Category: SQL Server
BCP and PowerShell
Sometimes you need to extract a large number of tables into some other format. I’ve written about BCP earlier as a quick option to move…
BCP for Flat File ETL
Brent Ozar is hosting today’s #TSQL2sday about the most recent issue you closed. Working with a consulting firm for a variety of clients, I tend…
SQL Shades for SQL Management Studio – Review
For those of us who’ve worked with SQL Server for some time, we’ve regularly used SQL Server Management Studio (SSMS). In recent years, we’ve seen…
Azure SQL Database – Get users and role members for all databases
I ran into a concern to quickly audit all current users and role members for a set of Azure SQL databases, spread across multiple resource…
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…
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…
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…
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…
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…