SSMS 2016 has new Scroll Bar settings tucked away under Tools, Options. I walk through each option, what it changes and which ones I find useful.
SQL SERVER – FIX: Setup Was Not Able to Access Domain
A DBA installing SQL Server 2012 on a virtual machine got ‘Setup was not able to access domain’. Here is what the message means and how to get past it.
Understanding Database Scalability – Vertical and Horizontal
One server with 64 cores or two with 32 cores? A customer asked me to help decide. Here is a simple look at Database Scalability, vertical and horizontal.
Hey DBAs – What Are You Assuming/Missing Today? – Notes from the Field #122
Hey DBAs, what are you assuming or missing today? Mike Walsh on why a good DBA watches every instance and is not afraid to say I do not know.
SQL SERVER – Computed Column and Conditions with Case Statement
How to write conditions with CASE statement in a computed column, using a simple AdventureWorks script you can adapt for any complicated logic.
SQL SERVER – What is WRK file in Log Shipping?
Even if you have used log shipping for years, you may never have noticed the WRK file in log shipping. Here is what I learned about it.
PowerShell Script – Backup Every Database In SQL Server
A client wanted to automate backups with a script instead of a GUI. Here is the PowerShell and SMO script I have used for years to backup every database.