Import Excel Data into SQL Server with PowerShell

In this article we look at PowerShell code you can use to import Excel data into SQL Server.

PowerShell Day By Day: The Pipeline

In this article, I wanted to discuss the PowerShell (PoSh) pipeline, which was confusing to me at first and took some time to get used to working with. I had used one in Linux before, but the PoSh one is more powerful, but also slightly different. Hopefully I can demystify some of the concepts for […]

Deploy Database Objects to Multiple SQL Server Instances Using PowerShell

In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.

Deploy Database Objects to Multiple SQL Server Instances Using PowerShell

In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.

Manage Power BI Dataset with PowerShell

Learn how to manage Power BI datasets with PowerShell with examples to give Developers and DBAs the flexibility have real time data stored in the Power BI service for reporting.

Monitoring SQL Server Instance Version and Builds with PowerShell

In this article we continue our PowerShell monitoring series with scripts that check the current version and build for all SQL Server instances in your environment.

Testing the Effects of PoSh

Finding the Free Space Difference Between Availability Groups Replicas

When was last time you have checked your Always On Availability Groups' replicas storage distribution?

Managing Power BI Workspaces with PowerShell

In this article we look at how to manage Power BI workspaces using PowerShell cmdlets.

Execute SSIS Package from PowerShell - Part 1

In this article we look at how you can execute SSIS package using PowerShell both with and without SSIS package parameters.