Understand Developer Edition rights, identify the installed SQL Server edition, and keep shared test systems separate from production work.
SQL SERVER – Identifying Application vs Network Performance Issues
But what do you do? Let us learn in this blog about How to Identify Application vs Network Performance Issues and their solution.
SQL SERVER – SSMS Tip: How to Get Larger Fonts for Results in Grid Output
At GIDS I could not read a speaker’s SSMS output from the back row. Here is a quick SSMS tip to get larger fonts for results in grid output.
SQL SERVER – Configuration Manager – MMC could not create the snap-in. The snap-in might not have been installed correctly
Opening SQL Server Configuration Manager failed with: MMC could not create the snap-in. A reader on Facebook asked, and here is how to fix it.
What is NOT NULL Constraint? – Interview Question of the Week #073
A client table full of NULL values was hurting query plans. Here is what a NOT NULL constraint is, how to add one and why it helped performance.
SQL Server – InMemory OLTP Hash Collisions Performance Overhead
A customer’s InMemory OLTP tables ran slowly because of a very low hash bucket count. Here is the hash collisions performance overhead and how to avoid it.
SQL SERVER – FIX: Error 1807 Could not obtain exclusive lock on database ‘model’. Retry the operation later – Part 2
Msg 1807, could not obtain exclusive lock on database ‘model’, still shows up in SQL Server 2016. Here is another cause of Error 1807 and how to fix it.