Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Ken Johnson

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

Not In v Not Equal

Is it better to use NOT IN() or <> in a T-SQL query? Ken Johnson had the question put to him and decided to investigate them both. Read about how these two functions perform.   Read more...
By Ken Johnson 2007/05/29 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 21,617 reads

Securing the SA Account in SQL Server 2005

SQL Server 2005 has greatly changed the security paradigm for SQL Server DBAs. The sa account still exists, but for many tasks you can now avoid using it. New author Ken Johnson brings us some ides for properly securing this highly privileged account.   Read more...
By Ken Johnson 2007/03/14 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 16,413 reads
   Items 1 to 2 of 2