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
329 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
250 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
404 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
268 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
326 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
3,115 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
317 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,402 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,792 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,119 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers