Category: SQL Server
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…
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…
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…
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…
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…
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…
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…
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…
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…
SQL Server 2016, Database Mail and .Net 3.5 Framework
I came across this post in the SQL Server Slack chats and wanted to make sure that this information was shared so others don’t fall…