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.
SQL SERVER – Why Haven’t You Disabled CPU Power Saving Yet?! – Notes from the Field #087
Notes from the Field #087: why you should disable CPU power saving on your SQL Server, and how this one setting can quietly slow queries.