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.
SQL SERVER – Why DBAs Need to Know about Kerberos – Notes from the Field #126
Not everyone knows about Kerberos. Many think it is a two headed dog from mythology, well that is true but when we talk about database,
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.
PowerShell – Querying SQL Server From Command Line
A client’s deployment scripts got me curious about PowerShell. Here is how to start querying SQL Server from the command line with a PowerShell script.
SQL SERVER – What is Trace Flag – An Introduction
What is a trace flag, how do you turn one on, and how do you keep it after a restart? A beginner’s introduction, including the startup parameter option.
SQL Server 2016 – Introducing AutoGrow and Mixed_Page_Allocations Options – TraceFlags
A reader asked if trace flags 1117 and 1118 work for user databases. SQL Server 2016 turns them into the AutoGrow and Mixed_Page_Allocations options.