An audit row blamed the wrong machine because a label was treated as proof. Here is which connection values you can trust, and which you cannot.
SQL SERVER – Connecting to Azure Storage with SSMS
Connecting to Azure Storage from SSMS takes a few simple steps from Object Explorer. I also show where to find your storage account name and key.
SQL SERVER – SSMS: Index Usage Statistics, Physical Statistics & User Statistics
Creating indexes is a science, not rules of thumb. I look at the SSMS reports for Index Usage Statistics, Physical Statistics and User Statistics.
SQL SERVER – Using the SSIS Term Extraction for Data Exploration – Notes from the Field #046
Tim Mitchell shows how SSIS Term Extraction helps with data exploration, so you understand the source data better before you build an ETL process.
SQL SERVER – SSMS: Resource Locking and Object Execution Statistics Report
How many times did a procedure run, and how much CPU and IO did it use? The SSMS Resource Locking and Object Execution Statistics reports answer exactly that.
SQL SERVER – Location of Natively Compiled Stored Procedure and Naming Convention
Why is it called a natively compiled stored procedure when the code is T-SQL? I explain, and show a DMV query that finds where its DLL is loaded from.
SQL SERVER – Beginning In-Memory OLTP with Sample Example
Beginning In-Memory OLTP in SQL Server 2014 is easier than it looks. I explain why we need it in simple words, with a sample example to get you started.