Deploy Dacpacs with dbatools – The Script!
Hello!
Not so long ago, I wrote about how dbatools now has functions that can be used to deploy dacpacs. What...
2018-01-16
322 reads
Richie Lee's SQL Stuff
salt Release 1.1.2562 – With Bug Fix!
Hello!
Very recently a user of salt got in touch with me about a bug when setting the job schedules up...
2018-01-09
244 reads
The Mystery Of The Failing Azure Cmdlet
Hello!
I’ve been helping out a team with setting up a deployment pipeline that uses Azure Data lake Store, and so...
2017-12-14
397 reads
PoshSSDTBuildDeploy Update – Now With Dynamic SqlCmdVar Updates
One of the big challenges in the whole “build once/deploy many” ideology is the need for environment configuration. And this...
2017-11-28
260 reads
PoshSSDTBuildDeploy Update – Now With LocalDB!
Hello!
Late on Friday I published a PowerShell Module that gives working examples of using DataToolsMSBuild. All very interesting, go and...
2017-11-28
321 reads
Kill a Connection, Session, or Command in Analysis Services
One of the useful features of the SSAS Activity Monitor is the ability to cancel sessions and queries. Though there is...
2017-10-10
2,987 reads
Failed SSIS Build – DtsRuntimeException
Hello!
I was helping a team debug a failed build today. Despite the fact that the build compiled on the devs...
2017-10-06
311 reads
Automate Parameterising SSIS Connection Managers
Hello!
Back when SQL Server 2012 was known as Denali, one of the new and exciting features released was that all...
2017-10-11 (first published: 2017-10-06)
2,345 reads
What Do You Get if You Unpack an Ispac?
I’ve spent what feels like a lifetime working on automating SSIS deployments, more specifically SSIS packages that have been created...
2017-10-04
2,637 reads
Deploy SSAS Cubes With PowerShell
Hello!
Recently someone got in touch with me about one of my earliest posts on my old blog. I realised I...
2017-10-03
1,107 reads
Blogs
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...
A Six Week Break
By Steve Jones
Today is my last day of work for six weeks. I start my sabbatical...
Forums
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