Fix For Using Azure Active Directory to Connect to SQL
Hello! The other day someone was kind enough to get in touch with me to thank me for some post I wrote back last year. For the sake of...
2019-03-12
10 reads
Richie Lee
PoshSSDTBuildDeploy 2.0.271.0 - Now With Better Exception Handling!
Hello!
Another quick bulletin about the changes I made to PoshSSDTBuildDeploy today -
2018-06-22
6 reads
PoshSSDTBuildDeploy 2.0.268.0 - Now With Issue Management!
Hello!
Concluding this weeks work on PoshSSDTBuildDeploy is adding one of the features I spoke about yesterday, which was joining the OperationSummary and Alerts objects to produce a new table...
2018-06-15
4 reads
PoshSSDTBuildDeploy 2.0.262.0 - Now With Warnings!
Hello!
Continuing on with my efforts to make the SSDT Deployment Report more useful, I’m pleased to say that I’ve added reporting on any alerts that appear in the Deployment...
2018-06-14
5 reads
More Changes to PoshSSDTBuildDeploy - DeployReport Information
Hello!
This is going to be a short one because I’ve been working hard all evening on this, and frankly I’m a little tired. But I’ve made a change to...
2018-06-12
7 reads
Birthday Musings and Deploy Using PoshSSDTBuildDeploy
Hello!
It is my birthday: another year older, another year not necessarily wiser. I’m planning on spending the evening watching the BBC and eating pizza. There are worse ways to...
2018-05-31
7 reads
Fix For Using Azure Active Directory and DacFX
Update:
Refer to this post instead
Hello!
One of the things I feel strongly about is that a build/release pipeline needs to be as complete as possible - that is all configuration...
2018-05-25
5 reads
PoshSSDTBuildDeploy Updated - Now With Pester Tests
Hello!
Some weeks ago I got the tests working on the CI build for PoshSSDTBuildDeploy. The tests were a bit of a mish mash, however they sort of did the...
2018-05-23
6 reads
PoshSSDTBuildDeploy Updated - Now With Install .NET!
Hello!
I’m currently working on a project that requires building and deploying SSDT-based projects. So it’s been a great opportunity of making use of PoshSSDTBuildDeploy and work through any issues....
2018-05-01
6 reads
Execute Multiple Files Using SQLCMD/SQLClient – Which Is Faster?
Hello!
I’ve been working on a PowerShell module that will migrate the schema of an Azure Data Warehouse from one database...
2018-02-26 (first published: 2018-02-15)
2,351 reads
Blogs
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Forums
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Upgrading Admin Queries
Comments posted to this topic are about the item Upgrading Admin Queries
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers