A classic interview question: what happens when adding file to database in an AlwaysOn Availability Group? Here is the answer, with the basics first.
SQL SERVER – DevOps for the DBA – Notes from the Field #091
DevOps is a buzz word with real substance behind it. In Notes from the Field #091, Stuart Ainsworth explains what DevOps means for a DBA’s daily job.
How to Find Queries Running in Parallel in SQL Server
To find queries running in parallel, read max_dop and the CPU to elapsed ratio from the query stats view, then confirm with the plan XML. This post tests both on a two million row table. It also explains why the same query stays serial until its cost passes the threshold.
SQL SERVER – How to Change Server Name?
I renamed my VM and needed SQL Server to match. Here is a query that shows the host and server names from every source, and how to change server name.
SQL SERVER – Using Project Connections in SSIS – Notes from the Field #088
Connection managers are the gateway for most SSIS reads and writes. In Notes from the Field #088, Tim Mitchell explains how to use Project Connections in SSIS.
Pre-Flight Checks at the Top of a Script With THROW
Learn pre-flight checks with practical SQL Server examples, clear checks, and the limits you need before changing application data.
Interview Question of the Week #027 – Move TempDB from One Drive to Another Drive When Low Disk Space
Diagnose low disk pressure in tempdb before moving files, inspect transaction and allocation usage, and plan a verified Windows restart.