Deciding between COALESCE and ISNULL in SQL Server
Tip : Deciding between COALESCE and ISNULL in SQL Server
Monthly Archive: April 2012
A cautionary tale about CAL licenses in SQL Server 2012 Enterprise
UPDATE 2020-01-28 – Microsoft has addressed my primary concern here in the SQL Server 2019 License Terms dialog: This is a great change, but I suspect a lot of people will still just check-check-next....
Minimize SQL Server plan cache bloat
Tip : Minimize SQL Server plan cache bloat
Seacoast SQL Users Group : What's New in SQL Server 2012
Tonight I presented my "What's New in SQL Server 2012" deck to the folks up in Portsmouth, NH. The deck can be downloaded here. File Attachment: AB_NH_SQL2012.pptx.zip
New cumulative updates for SQL Server 2008 R2 (RTM & SP1) are available!
This morning the SQL Server Release Services Team has pushed out new cumulative updates for SQL Server 2008 R2. Cumulative Update #13 for SQL Server 2008 R2 RTM Knowledge Base article: http://support.microsoft.com/kb/2679366 Build number:...
SQL Server 2012 Cumulative Update #1 is available!
While I joked earlier this month that SQL Server 2012 Service Pack 1 was released on the same day as General Availability (hey, it's Microsoft's fault since they decided to GA on April 1),...
Storing E-mail addresses more efficiently in SQL Server – Part 2
Tip : Storing E-mail addresses more efficiently in SQL Server – Part 2
Participating in 3 SQL events in 8 days
This one time, I traveled over 18,000 miles and had 26 net time zone changes, all to give a couple of sessions.