Mustafa EL-Masry General topics

New Permission in SQL Server 2014


Hi Dears as we know SQL Server 2014 come with more new features and more improvements in the Performance today we will take about the new Feature in SQL Server 2014 in particular in SQL Server security SQL Server 2014 come with three new permission really amazing permission it will help any DBA in his work to can grant simple permission in All Databases in the server in the minimum time this operation it will not take from him one second lets go for the scenario and for the DEMO.

in SQL 2012 and we can see 31 permission whereas SQL 2014 has 34 permissions. These permissions are listed under Server properties >  permissions tab.

New Permission in SQL Server 2014:

  1. CONNECT ANY DATABASE Permission.
  2. SELECT ALL USER Securables Permission.
  3. IMPERSONATE ANY LOGIN Permission.

New permisions

 

Continue reading “New Permission in SQL Server 2014” →

Mustafa EL-Masry General topics

SQL Gulf #1 event at Riyadh on 30/8/2014 http://www.asysg.com.sa/sql/


After long waiting time and eager passion of our audience and followers to see a real series of SQL Server events in the middle east to resurrect SQL Server love in the Gulf region we are much glad to unveiled about this new brand name of events “SQL Gulf “ which is indeed the power house of SQL Server Administration , development and BI for every .net developers , Database administrator and Analysts to fancy their knowledge capitals about SQL Server through a variety of 10 interesting sessions leaded by Top notch experts from different countries worldwide Canada , UK, Jordan , India and Saudi Arabia..etc , SQL Gulf is coming first at Riyadh on Saturday 30/8/2014 at Al –Faisal University to be the first SQL Server 2014 in the middle east that will unveiled about SQL Server 2014 myths and legends and performance dreams of 10x-30x, your esteemed presence is really a pride for us so don’t wait more and go directly now to register at http://www.asysg.com.sa/sql/ (There are separate areas for females)

http://sqlserver-performance-tuning.net/?p=4657
Event-logo_final

 

 

Please have a moment to share it with your friends and  managers and add it over your social & technical hubs , thanks for all speakers who shared us some of their quite busy schedules

Mustafa EL-Masry General topics

Check the status of SQL Server Setting


When we need to Work in SQL Server we Must know What the Status of SQL Server Setting is Enabled or Disabled  this Setting like

  • QUOTED_IDENTIFIER
  • ARITHABORT
  • ANSI_NULL_DFLT_ON
  • ANSI_WARNINGS
  • ANSI_PADDING
  • CONCAT_NULL_YIELDS_NULL
  • ANSI_NULLS

Now How i Can Know if (QUOTED_IDENTIFIER) is Enabled or Disabled in My SQL Server Session before i Run my Query we Can use System Function SESSIONPROPERTY to know if (QUOTED_IDENTIFIER)  is ON or OFF .

Example :


SELECT SESSIONPROPERTY('QUOTED_IDENTIFIER')

1

If the Statement Return 1 that’s meaning is QUOTED_IDENTIFIER Setting is ON  in This Session otherwise is OFF that’s meaning  The QUOTED_IDENTIFIER Setting is OFF

Mustafa EL-Masry General topics

Difference between Count() and Count_Big() Funiction


In our Query Life when we need to get the Count of any Record in our Database Mostly we Use the COUNT() Aggregate Function the

Question Now SQL Server Have another  Aggregate Function COUNT_BIG() i asked my Self SQL Server Team Created this Function Whiteout any bin fits ……….. The answer is No . COUNT() and COUNT_BIG() it’s the Same Aggregate Function in the Use The Main Different between the two Aggregate Function it :

Count  Aggregate Function Return Int data type value .

COUNT_BIG()  Aggregate Function Return BigInt data type value .

So if you Have Millions Record in your table and you need to Return the Count of this Record when you use the Count() Function it will Return Error but the Count_Big() Function it will Work with you Simply in this Case .

Count() Aggregate Function :

Select Count(Column_Name) from Table_Name

Count_Big Aggregate Function :

Select Count_Big (Column_Name) From Table Name