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.
SQLvariations: SQL Server, a little PowerShell, maybe some Power BI Blog
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...
What Chocolatey Packages Does a Business Intelligence Developer Need?
I’m getting a new work laptop next week: Hooray!! 😃 I’m going to have to install A LOT of software: Opportunity! 👍 Problem: I have a lot of meetings next week, and I don’t...
Group By Conference is Back April 11th!
I have joined forces with Blyther Morrow & Daniel Hutmacher to keep the GroupBy Virtual Conference going. We’re aiming to host the conference at least twice this year, and the next one is just...
