What is your Favorite Database? I asked SQLAuthority.com readers in a quick poll. The poll is now closed, and SQL Server came out as the clear winner.
SQLAuthority News – Author Visit – MVP Global Summit 2009 – Seattle and Redmond
I am all set for my first MVP Global Summit 2009 in Seattle and Redmond, March 1 to 4, to meet other MVPs and the Microsoft product teams.
SQL SERVER – Disable Windows Authentication – Remove Windows Authentication Login Account
A reader asked how to disable Windows Authentication in SQL Server. The short answer: it can not be disabled, and it is the most secure way to log in.
SQLAuthority News – Ahmedabad User Group Meeting February 21 2009 – Meeting Report
My review of our Ahmedabad user group meeting February 21, 2009: a growing crowd, two sessions on index usage and IDENTITY, and great feedback.
When SSMS and Your Application Return Different Results
Investigate SSMS different results by comparing connections, parameters, session options, transactions, and plans against the application.
SQL SERVER – My Observation – Effect of Clustered Index over Nonclustered Index
A simpler rewrite of my observation on the effect of clustered index over nonclustered index, with a sample script and execution plans to compare in SSMS.
Checking IDENTITY Columns Before They Run Out of Numbers
Check IDENTITY columns for their current value, type limit and remaining range, including descending increments, before inserts fail.