SQL Server

In-Memory OLTP

Free ebook: SQL Server Internals – In-Memory OLTP. In this book Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton…


SQL Operations Studio

Introducing Microsoft SQL Operations Studio, which is a free, light-weight tool for modern database development and operations for SQL Server on Windows, Linux and Docker, Azure…


Ignite – SQL 2017

This video is from Microsoft Ignite where Bob Ward demonstrated The Fast and Furious of SQL Server 2017. Also, check out this interview of Bob from…


SQL Server Certifications 2017

I will be in Atlanta this weekend to talk about SQL Server certifications. However, I know many of you will not be able to attend….


SQL Hall of Shame

The other day a twitter discussion between Adam Machanic, Brent Ozar, and Klaus Aschenbrenner arose about the most useless features is SQL Server. Which if you…


SQL MCSA Name Changes

 The Four new SQL MCSA certifications coming out this fall have had a last minute name change. http://bit.ly/2q8lWPj


Yooper PASS Session

Tonight, I will be speaking remotely for the Yooper SQL Server User Group. I am assuming that Yooper refers to Upper Michigan. You can watch…


24 Hours of PASS: Security

 24 Hours of PASS: Data Security and Data Quality starts in 20 minutes. My session is Hour 14. But don’t miss all the great Speakers…


Automatic Tuning in SQL 2017

 Automatic tuning in SQL Server 2017, notifies you whenever a potential performance issue is detected, and lets you apply corrective actions, or lets the Database…