Author Archive
Checking and Configuring File Autogrowth for SQL Server
One thing that I seem to come across often enough is the old auto-growth settings from SQL Server. 1MB for data files, 10% for logs. This was a horrible default and is now adjusted to be 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
Analyzing Slack Traffic with PowerBI
The other day in the SQL Community Slack channels, we started chatting about general usage of Slack – which channels saw the most activity, what topics were discussed, and so on. One thing led to another and
Automating File Processing with Python and SQL Server
Garry Bargsley ( b | t ) asks us this month what does “Automate all the things” mean to you. After all, if we have to do something over and over, it only makes sense to automate
Send Meaningful Errors for SSIS Packages
Recently, Kevin Hill (b | t ) posted on getting package errors from the SSIS catalog in a single query as opposed to clicking through the SSIS Reports and digging through pages. I took that and ran
A Speaker’s Workshop in 35 Minutes
Posted by paschott in SQL Server On November 28, 2018
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.