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...
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.
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.
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...
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...
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...
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...
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...
Have you ever wanted to export an entire SQL Server database to Excel file? Yeah, me neither. Until yesterday, when I was trying to build a Power BI demo with sample data (that needed...
SQL PASS PowerShell
Virtual User Group
Available from dbatools.io and github
SQLvariations: SQL Server, a little PowerShell, maybe some Power BI
