Posted in DBA ETL PowerShell 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…

Continue Reading... BCP and PowerShell
Posted in Azure PowerShell SQL Server

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…

Continue Reading... Azure SQL Database – Get users and role members for all databases
Posted in DBA PowerShell Scripting SQL Server

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…

Continue Reading... Quickly execute a folder of SQL scripts using dbatools and PowerShell
Posted in PowerShell Scripting

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…

Continue Reading... Putting The PowerShell Window Title To Better Use | xkln.net
Posted in PowerShell SQL Server

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…

Continue Reading... Importing Registered Servers from SSMS into Azure Data Studio – Port 1433
Posted in PowerBI

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…

Continue Reading... Analyzing Slack Traffic with PowerBI