Exporting Custom Messages from Sys.Messages

Learn how to get your custom messages from an existing instance and add them to a new instance.

Always Use Roles–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Which of these is more complex? GRANT SELECT...

Burning Out

Burning out in an IT job is easier to do than it should be. Steve has a little advice today.

The SQL Change Automation in SSMS Beta

Give it a try, as the beta is out. I’ve been watching this product and getting updates for the last six months or so and lately I’ve been pushing...

Getting the Max

High Security Prices–Always Encrypted 2019 needs Datacenter Edition

I was recently doing some work on Always Encrypted in SQL Server 2019 and needed to set up an HGS server. I went through most of the setup, and...

Small Experiments in Data

Amsterdam is using data to try and improve their city.

Happy Hour at SQL in the City Austin

Tomorrow is SQL in the City 2019 – Austin. If you’ve registered, you’re going to want to come. From Kendra’s great opening keynote to Brian’s demo to a couple...

Keynotes in Australia and New Zealand

I get to do the SQL in the City Summit keynotes in Australia and New Zealand. I’m excited, following the footsteps of Kendra Little and Donovan Brown, who have...

No State Based Deployments

Today Steve Jones talks about deploying your database changes, and how you can't ever really depend on a state based approach.