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 brevity, there’s all sorts of nastiness in trying to authenticate using Azure Active Directory when connecting to an Azure SQL Instance/Managed Instance. And the function what I wrote aimed to automate uninstalling and installing the “correct” version of the adalsql.dll required. Thing was I admitted it was a hack in the original post, and the worst thing about a hack is that they tend to be a bit….

PoshSSDTBuildDeploy 2.0.271.0 - Now With Better Exception Handling!

Hello!

Another quick bulletin about the changes I made to PoshSSDTBuildDeploy today -

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 that will make it easier to figure out which Operation is creating which Issue.

Let’s revisit the xml file that I running my tests with -

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 Report. Let’s take a look at a report that has warnings in it -

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 PoshSSDTBuildDeploy which is going to be the start of more changes. Intrigued? Well, read on…

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 spend a birthday…

Fix For Using Azure Active Directory and DacFX

Update:

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 trick. Thankfully Eugene Niemand came along and very kindly offered to update the tests into Pester tests, and also just generallytidy up the mess. It’s always great to have a second pair of eyes on any code, as it helps it from not being quite so auteured…

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. And there have been a few minor updates to the module over the past fortnight which I’ll go through now! As I type the latest version is 2.196.0. Return Path of MSBuildDataTools - Just so much easier to have location returned so that when you execute Invoke-MSBuildSSDT and Publish-DatabaseDeployment you can just pass the outputted variable in.