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 – 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 Domain Controller – Interview Question of the Week #072
SQL domain controller questions: can SQL Server run on one? Five interview answers, checked against Microsoft’s current guidance, one corrected.
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.