Step-by-step guides with code samples on how to perform database backup to Azure Blob Storage with T-SQL in SQL Server 2012 SP1 CU2 / SQL Server 2014 and SQL Server 2016 using Credentials.
A quick summary and the ultimate reference to Stretch Database in SQL Server 2016 CTP 2
SQL Sentry Plan Explorer - Anonymous Plan Diagram
SQL Sentry Plan Explorer has a number of views available to help you understand the rich information stored within Execution Plan files. It also can provide you with additional details when you run Get Actual Plan on the query directly.
SQL Prompt - Summarize Script
A #SQLCoop Review of Red Gate's SQL Prompt for Clean and Tidy code, promoting readability, high comprehension and ease of navigation.
Never Assume Anything
Some examples on minimising assumptions in T-SQL code
ABC Analysis on AdventureWorks Product Model
This blog post shows an example to perform ABC Classification using SUM and a SQL Server Window Function,
SSMS Tools Pack Tab Sessions History
This blog post visits my top 8 features of SSMS Tools Pack for developing / administering Windows Azure SQL Database (WASD) instances.
Reviewing SQL Search as one of must have SQL Tools for Database Developers / DBAs/ SQL Server consultants.
Creating Credential using SSMS
#InAJiffy: The CREATE CREDENTIAL statement for creating SQL Server database file on Windows Azure Storage
tf undo
Resolving ghost Pending Changes in Team Foundation Service (a cloud-powered source control management) using TF Command-Line Utility Commands.