Quick Blog: Making the Power BI PowerShell cmdlets easier to use
One of the top reasons I love PowerShell so much is that from the beginning, it was designed to let you, yes you, make it run better for the way you work. In fact,...
SQLvariations: SQL Server, a little PowerShell, maybe some Power BI Blog
Quick Blog: Clone Power BI Workspace Permissions
However, one detail they left out of that post is how to clone the users & groups, and their respective permissions from one Workspace to another. It’s a pretty simple thing to do, with one not-completely-obvious quirk to it.
Make Sure Your SQL Servers are Running the Latest CU with the New SQL Assessment cmdlets
Make Sure Your SQL Servers are Running the Latest Cumulative Update (CU) with the New SQL Assessment cmdlets available in the SqlServer module.
Exporting an .ISPAC from the SSIS Catalog via the SSIS PowerShell Provider
In my last blog post I showed that using the SSIS Provider could be an easier option for deploying an .ISPAC file, vs. the PowerShell script method shown in the official documentation. I very...
Webcast – Install & Configure SQL Server with PowerShell DSC
On Tuesday May 7th at 7 AM EDT (GMT -4) the PowerShell Virtual Group of PASS will host Jess Pomfret as she presents her session: Install & Configure SQL Server with PowerShell DSC.
Deploy SSIS Packages with PowerShell .ISPAC Deployment, using the SSIS Provider
In today’s world, people expect to be able to commit one change, then have the entire project re-deployed and automated tests run against it. Using the SSIS PowerShell Provider to deploy your code can help you accomplish that.
Execute SSIS Package from PowerShell
My friend Andy Leonard has written an excellent blog series on getting SSIS up & running in a Docker container. I would never have even tried to go down this road if not for...
My Ignite 2018 SQL PowerShell Scripts now available in GitHub
It appears that I forgot to post my SQL PowerShell Scripts from my talk at Ignite 2018 (video here). Big thanks to Tony Green ( t ) for bringing this to my attention. I...
Quick Programming Note: Thoughts Expressed Here are Mine
Just a quick Programming Note abut this blog: The thoughts expressed here are my own, but I may share the same view of dozens, hundreds or even thousands of other data professionals. Thoughts expressed...
