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,257 reads
Richie Lee's SQL Stuff
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
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
352 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
761 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,159 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
125 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
183 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
215 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
271 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
271 reads
Blogs
Quick Wins with GenAI
By Steve Jones
The more I look to GenAI to save me minutes, short periods of time,...
Speaking at the 2025 PASS Data Community Summit
By Brian Kelley
I will be back in Seattle this year attending the 2025 PASS Data Community...
The Book of Redgate: Motivation
By Steve Jones
Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight...
Forums
Batchmode execution in SQL 2019
Is there a way to force a query to use Batchmode execution, my database...
How to Work with RStudio and SQL Server
Comments posted to this topic are about the item How to Work with RStudio...
Finding Heaps
Comments posted to this topic are about the item Finding Heaps
Question of the Day
Finding Heaps
If I am querying DMVs for a heap, what do I look for?
See possible answers