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.
Tagged: PowerShell
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...
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 cmdlet for gathering some log data. To make a...
I’m Speaking at Ignite in Orlando!
I’m excited to say that I will be speaking at Ignite this year in Orlando! I was at Ignite in Atlanta last year and it was an excellent experience. I’m really looking forward to...
DevOps or DataOps Either Way It’s Coming to SQL Server
For T-SQL Tuesday #91 the topic is databases and devops. Grant Fritchey asks us: How do we approach DevOps as developers, DBAs, report writers, analysts and database developers? How do we deal with data...
