SQL Server Archive

Calendar / Date Tables – An Introduction

What is a Calendar or Date table? Maybe you’ve worked with data warehouses before, in which case the concept of a “Date Dimension” is going to be familiar. If not, the general idea behind a Calendar or

Creating and Setting SQL Server Certificates with PowerShell

I recently had a need to add certificates to SQL Servers throughout an organization. There were quite a few servers to update and the certificates would need to be generated using a given format. This would include

Using PowerShell to restore Missing Windows Installer cache items

This seems oddly specific, but someone or something had cleared out many files from the Windows\Installer folder, probably to save space. (Sidenote, you can actually create a mount point for these that go on another drive as

SSIS Catalog (SSISDB) Cleanup – Revisited

I wrote about cleaning up the SSIS Catalog a while back, but needed to revisit this recently for a different use and needed something that can run in an ongoing manner. My earlier post still works, but

Quickly execute a folder of SQL scripts using dbatools and PowerShell

I have often run into a situation where it’s been necessary to execute a bunch of scripts handed to me by developers or others. When there are only a couple of scripts to run, it’s not a

Importing Registered Servers from SSMS into Azure Data Studio – Port 1433

Drew Furgiuele came up with a PS script to import your SSMS Registered Servers into Azure Data Studio. He wrote it up in much more detail here: Importing Registered Servers from SSMS into Azure Data Studio –

Sharing: Feature Restrictions in SQL Server 2019 – a warning

Solomon Rutzky posted some thoughts on the new “Feature Restrictions” in SQL Server 2019, which some have said might help with SQL Injection. He writes up a lot of details about what Feature Restrictions were intended to

SQL Login Failures and Azure SQL

We ran into an issue recently with a large number of SQL Login failures triggering an alert for our sysadmins. This was in one of our Azure SQL databases so the usual tools to troubleshoot alerts don’t

A Speaker’s Workshop in 35 Minutes

Buck Woody shares a much abbreviated video of his speaking workshop to help others become a better speaker and present more effective sessions. Well, not the *whole* workshop. That’s a full-day long, with individualized attention and exercises.

TSQL: OUTPUT Columns Not In Target Table

One of the challenges I’ve run into regularly throughout my years trying to convert data from one system to another is that we have a set of old data, often with its own key values. That data