Automate Your SQL Notebooks with Two New Options
There are two new options for automating your SQL Notebooks with your SQL Servers. Earlier this month, the Insiders build of Azure Data Studio received
2019.09.23
Category: Code
Read More »
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
2019.05.06
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.
2019.05.01
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
2019.04.30
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 (
2019.04.27
Quick Blog: Foreach Result by Day
My friend Reza Rad ( blog | twitter ) reached out to me this morning because he was running into some issues with a PowerShell
2019.02.22
Demo Scrips for Idera Live Session
As promised, here are the scripts I used in my Idera Live session today. (also available via this direct link )
2017.05.17
Finding Free Space Per Drive & Mount Point in PowerShell
Back in 2010 I was inspired by a twitter conversation between Nicolas Cain (blog | twitter) and Dave Levy (blog | twitter) about checking Disk
2017.05.02
Up Next, SQL PowerShell for SSAS!
I’ve been wanting to demo cool-easy ways to do things in SSAS with PowerShell for a long time but haven’t gotten around to working on
2016.12.12
Follow:
Subcribe to Blog Via Email
Enter your email address to subscribe to this blog and receive notifications of new posts by email.