SQL

SQL 2016 Stretch Database

SQL Server Stretch Database lets you dynamically stretch warm and cold transactional data from Microsoft SQL Server 2016 to Azure. Unlike typical cold data storage,…


Data Driven Virtual Event

Join Data Driven virtual event to hear Microsoft CEO Satya Nadella share why data is so critical in our world today, how customers are embracing…


SQL Saturday – Indianapolis

SQL Saturday – Indianapolis is now live. SQL Saturday is a free training event for SQL Server professionals and those wanting to learn about SQL Server….


Microsoft Azure Stack

Azure Stack extends the Azure vision by bringing the cloud model of computing to every datacenter. Azure Stack is a new hybrid cloud platform product…


Wait Statistics Guide

Wait a minute… How could I have a week of favorite performance tuning resources without including one of my favorites. That’s right we are visiting…


Data Storage Internals

Wrapping up my week of Query Optimization page recommendations and while SQLity.NET  does have a lot of information on Query Optimization, it is an older series…


Query Optimization Papers

When talking about SQL Performance and Optimization, I always like to point to this excellent post by Benjamin Nevarez where he discusses which sources he used to…


Working with Wait Statistics

A list of favorite blog posts would not be complete without a trip over to SQL Skills and Paul Randal where he asks,”How many times…


Query and Join Hints

Day two of my favorite posts on SQL Server Query Optimization takes us to Simple Talk and a 2009 blog post from Grant Fritchey and Controlling…