SQL Clone
SQLServerCentral is supported by Redgate
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,652 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,440 reads
   Items 1 to 2 of 2