Make Sure Your SQL Servers are Running the Latest Cumulative Update (CU) with the New SQL Assessment cmdlets available in the SqlServer module.
2019-07-30
28 reads
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...
2019-05-21 (first published: 2019-05-06)
306 reads
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...
2019-05-10 (first published: 2019-05-01)
568 reads
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...
2019-05-09 (first published: 2019-04-30)
847 reads
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...
2019-04-27
29 reads
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,...
2019-04-18 (first published: 2019-04-05)
702 reads
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...
2019-04-02
86 reads
Have you ever wanted to export an entire SQL Server database to Excel file? Yeah, me neither. Until yesterday, when...
2019-03-28 (first published: 2019-03-14)
459 reads
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...
2019-03-14
11 reads
This is one of those things that doesn’t warrant a blog post; until you talk to three other well-versed data...
2019-03-12
398 reads
By Jen McCown
Download session materials and watch the recordings of my excellent sessions on Transact-SQL and...
By Steve Jones
This post continues looking at my process of learning more about Kubernetes. I’ve been...
By James-Serra
A brand new product by Microsoft called Azure Data Share was recently announced. It...
Hi all, first of all, I am new to Integration Services. I googled everything...
I am trying to write a query that generates an html report to be...
HI Team, please help to get the expected data. my Data like below: create...
Ask SSC