Patching Error: No room is available to display rows
I show a workaround for an obscure error you might receive while patching SQL Server: "No room is available to display rows."
Monthly Archive: April 2015
SQL Server 2014 Cumulative Update #7 is available!
Microsoft has released Cumulative Update #7 for SQL Server 2014. See this blog post for more information. KB Article: KB #3046038 41 fixes listed publicly at time of publication (47 total) Build number is...
Convert Existing SQL Server Traces to Extended Events Sessions
Tip : Convert Existing SQL Server Traces to Extended Events Sessions
Please help me fix a big security loophole
I try to raise awareness of a significant security issue when creating or altering logins using a password hash. Please vote!
Information about the SQL Server 2014 Service Pack 1 snafu
Updated April 17, 2015: SQL Server 2014 Service Pack 1 has been released, but was quickly pulled. This post explains why and shows how to fix any affected instances.
SQL Server 2014 Service Pack 1 was available – but there's a catch!
Stop me if you've heard this one before. Microsoft has released Service Pack 1 for SQL Server 2014. However, do not install it if you use the SSIS catalog (SSISDB). From the Release Services...
T-SQL Tuesday #65 : Teach Something New
For T-SQL Tuesday< #65, I give a little detail on something I learned this week about altering a column from NOT NULL to NULL.
Bad Habits: Using MDF/LDF Files as "Backups"
A little advice on the use of MDF/LDF files for backups.
Prevent and Log Certain SQL Server Login Attempts
Tip : Prevent and Log Certain SQL Server Login Attempts
On-Demand Hotfix for Parallel Batch-Mode Deadlocks in SQL Server 2014
Today Microsoft released a critical, on-demand hotfix for customers using Columnstore indexes in SQL Server 2014. The hotfix addresses a scenario where a batch-mode scan that has gone parallel can deadlock, and the deadlock...