Sorting Values in a Column

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Watch: Can This Team Succeed at DevOps? Panel discussion

I recently participated in a panel discussion for the SQL PASS DevOps virtual chapter. If you didn’t make the meeting, you can catch our 90 minute discussion here about...

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...