Quick 6 month check – how are those learning goals going…?

So in January I wrote a blog post on some goals I had this year: Some of my goals for 2019 It’s now July – how are things going?...

Join a List of Values

There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
Related Posts:

Correlate Trace...

Powershell script to get list of databases on a server

At one of my clients I received an email from one of the IT Project Managers asking a simple question:"Can you please let us know which databases reside on...

All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT

This is the first in a series of posts about gatekeeping in Information Technology and other fields. I am not the first — nor will I be the last...

Investigating Azure Databricks

At SQL Saturday #884 – Pensacola, I dropped into Rodney Ladrum’s session on Azure Databricks (ADB) and the Traditional DBA. I had heard a bit about Databricks, and read...

Life Support 2008 – Audit Logons

Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...

New Security Update for SQL Server in July 2019 Patches

It doesn’t look like this would affect SQL Server 2008 or SQL Server 2008 R2 since the earliest reported platform is SQL Server 2014, but in Microsoft’s release of...

None of the IP addresses configured for the availability group listener can be hosted by the server Either configure a public cluster network 19456

Requirement: Remove a node from one of...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

sp_drivespace – See How Much Space You Have On Your Disks, Including Mount Points

We love xp_fixeddrives here, it’s a quick and simple way to see how much space you’ve got available on your drives. But there are just a couple of things...

SQL Server 2019 Query Store And SSMS

While not specific to SQL Server 2019 (I was using this version to do some testing) I was struggling to find how to change the time period of analysis...