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)
489 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)
573 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-06
34 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
21 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)
684 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
85 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)
443 reads
Invoke-Sqlcmd is Now Available for MacOS & Linux in the SqlServer module. The module has been posted as v21.1.18095-preview which means...
2019-03-19 (first published: 2019-03-05)
2,049 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
7 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 Steve Bolton …………In the last two installments of this series of amateur self-tutorials...
This year PASS is trying something new at PASS Summit. There are going to...
One of the most significant and hardest challenges we face as data professionals (or...
I have a table "Mytable" containing a list of IDs. There is a web...
So I have a DW with a table with some pre-aggregated scores (not my...
HI all, About to start this project and would be grateful for any good...
Ask SSC