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,403 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
390 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
767 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
355 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,164 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
133 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
188 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
229 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
280 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
276 reads
Blogs
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Stop Being Surprised by Your Azure Bill: Use Budgets
By John
When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
Forums
The Max PK Length
Comments posted to this topic are about the item The Max PK Length
My experience using the GitHub Copilot in SSMS 22
Comments posted to this topic are about the item My experience using the GitHub...
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
Question of the Day
The Max PK Length
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers