Deploy Dacpacs With PowerShell
Final Addendum – use dbatools!
Addendum – There is a repo on GitHub which I wrote and recommend using for build/deployment of DACPACs....
2017-09-26
7,169 reads
Richie Lee
SSIS Package Execution in Azure is Out Now
It’s been a long time coming, but now SQL Server Integration Services is in Public Preview on Azure!
I’ve written about...
2017-09-25
386 reads
How To Update Visual Studio 2017
(AKA how I lost a morning)
Hello!
This morning I needed to update my version of SSDT, but before I could do...
2017-09-22
760 reads
Restore BACPAC to SQL Azure
Hello!
2 posts in 1 day? When you’re hot, you’re hot!
I’m actually writing this one whilst I’m waiting for a BACPAC...
2017-09-22
351 reads
Truncate vs Delete in SQL Server: What’s the Difference?
I’ve been using TRUNCATE TABLE to clear out some temporary tables in a database. It’s a very simple statement to...
2017-09-04
1,158 reads
New Baby Musings (AKA Things I’ve Thought Upon On Sleepless Nights)
Hello!
One month ago I became a dad for the 3rd time. And so my spare time, which has always been...
2017-09-02
123 reads
Sample Databases For SQL Server
As a blogger, one thing that I appreciate greatly is examples of technical features. This is mainly because
technical features can...
2017-09-01
182 reads
My Evening With SQL Tool Service
Hello!
I’ve been writing a PowerShell Module that will handle deploying SQL Server Agent Jobs by using the Agent namespace in...
2017-07-13
209 reads
LocalDB DSC Script
Hello!
So, there are many different product SKUs of SQL Server available, and generally when developing it’s probably best to use...
2017-07-12
264 reads
Do Not Trust My GitHub Projects
Aloha!
Recently I’ve revisited one of my GitHub projects, TurboLogShip. I’ve been wanted to write a presentation around what it does...
2017-04-23
270 reads
Blogs
Mistakes IT Shops Without a DBA Make
By Kevin3NF
We get it. There’s no budget for a DBA on staff, or even a...
A New Word: Waldosia
By Steve Jones
waldosia– n. a condition in which you keep scanning faces in a crowd looking...
Deploy at Low Priority
By Zikato
Learn how to deploy schema changes in an always-online SQL Server environment without a...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Shadow AI Data Leak Risk or “From the Desk of I saw that Coming”
Comments posted to this topic are about the item Shadow AI Data Leak Risk...
Alternatives to Junk Dimensions in Data warehousing
Hello SSC, I am not sure if I posted this in the right spot,...
Question of the Day
Counting Bits IV
What does this code return in SQL Server 2022+?
select bit_count(2.4)See possible answers