New vCore Compute Levels for Azure SQL Database and Elastic Pools

Additional vCore-based elastic pools and single databases have been expanded for the general purpose, business critical, and hyperscale service tiers....

Power BI World Tour 2019 Tampa

In just a few weeks (Jan 21-22) I will be presenting on two topics at the Power BI World Tour...

#SQLCareer 4/4 January 2nd 2019

Last July (yes, it’s taken me 5+ months to finally finish this) Steve Jones (b/t) suggested that it might be...

SQL Server Transaction Log is full due to XTP Checkpoint Error 9002, Severity 17, State 16

I want to take some time and discuss my experiences with a certain SQL Server error, error 9002. Error 9002...

Why is the query hash so useful?

An example of how I use the query hash
I wrote a blog on what the query hash is, right here....

Donating Hair Again

There are several organizations which take hair donations, but the one I prefer to donate to is Wigs for Kids,...

Source Control using Azure Data Studio and GitHub

You can maintain and deploy code easily

Source control is a vital part of IT work, since it is used to track changes over software and documents, with two main...

Pro SQL Server on Linux–Install

As part of my learning goals for 2018, I wanted to work through various books. This is part of my...

TICK TOCK…6 MONTHS UNTIL SQL SERVER 2008/2008 R2 SUPPORT EXPIRES UNLESS YOU TAKE ACTION

If you are still running SQL Server 2008/2008 R2 you probably have heard by now that as of July 9,...

Back to the future

It’s January 2019 as I write this. I realized that I started on my journey with SQL Server in 1998,...