Author: paschott
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…
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…
Putting The PowerShell Window Title To Better Use | xkln.net
I’ll admit that I typically use VSCode for most of my scripting, but Milosh Djuric put together some neat PS to make the console window…
How SQL Server Professionals can benefit from using version control – Kevin Chant
Kevin has a great read on why Database people should use version control. It’s really easy to just keep files in e-mails, random folders, and…
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….
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…
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…
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…
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…