More online operations available now – or soon
I show DDL commands in Azure SQL Database that can now run as online operations instead of blocking, size-of-data operations.
Monthly Archive: February 2015
Should I use NOLOCK against #temp tables?
I address a popular theory that NOLOCK can substantially reduce locking overhead against #temp tables.
Give SQL Server users access to Extended Events
Tip : Give SQL Server users access to Extended Events
Developers need to know "DBA stuff" – and vice-versa
I discuss why developers and DBAs should work together.
SQL Server 2014 Cumulative Update #6 is available!
Microsoft has released Cumulative Update #6 for SQL Server 2014. This update fixes a few important issues exposed in Cumulative Update #5; see this blog post for some more information about those issues. KB...
Fun with THROW: Avoid % and use semi-colons!
I talk about a couple of subtleties of THROW, and how to avoid frustrating bouts of troubleshooting.
Out-of-band hotfix releases for SQL Server 2008 SP4 and 2008 R2 SP3
Back in September, I blogged about the availability of SQL Server 2008 R2 Service Pack 3 and SQL Server 2008 Service Pack 4. I made it clear that there would be no cumulative updates after...
Learning from kids
I share one of the most insightful pieces of feedback I have ever received from a session attendee – who happens to be a 6th grader.
Out-of-band AG hotfix for SQL Server 2012 SP2 and SQL Server 2014
A hotfix has been released for an issue that causes Availability Groups to show as NOT SYNCHRONIZING. The original issue is described in KB #3033492 and in this SQL Server Release Services Team blog...