SQL Server Archive

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

TSQL Tuesday: “Disabling” Triggers Without ALTERs

I’ve worked with my share of Triggers over the years. Most of the time, they were relatively simple affairs – do a simple update to a date if a row changed or track some basic audits somewhere.

ER Diagram Software Options for SQL Server

I’ve seen this come up several times recently in the SQL Server Community. There are diagrams built in to SSMS, but they’re a bit limited in their usefulness. You can’t easily break them down into sub-models or

SSIS Catalog (SSISDB) Cleanup

I really appreciate what MS has done w/ the SSIS Catalog. We have built-in logging at a level that wasn’t possible in prior releases, but that comes at a cost. The default retention is pretty high (365

Troubleshooting Database Mail on SQL Server 2016

tl/dr – Install the .NET Framework 3.5 feature on your server I was setting up a new SQL Server 2016 machine today and going through the normal configurations – setting permissions, setting backup/data locations, configuring database mail

Long-Running Queries and Extended Events

This has been something I’ve wanted to investigate for a while now. I’ve know you could use Profiler and set up server-side traces to capture long-running events, but was curious how to do the same with Extended