bzzzt! I Have No Idea What I'm Doing

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 no obvious way to do this through SSMS you can in fact write an xmla query to kill either the session, connection or command: If you specify the connection ID it will kill all sessions, if you kill a session it will cancel all SPIDs that pertain to that session, and if you kill the SPID it will kill that one command.

But wait! There's more!

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 box - something that’s become almost cliché to hear these days - it would fail using via cmdline. Annoyingly, there was no errors outputted. So i cloned the repo and took a look myself - This is helpful to approximately no one. But based on experience we figured out that the Azure Feature Pack for SSIS needed to be installed on the build agent.

But wait! There's more!

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 in Visual Studio that use the project deployment model. If your SSIS Project is using this model you’ll know that the output of a build is an .ispac file. But what is in an ispac? Funnily enough, someone forwarded me a link to a page that covers some details about the ispac file format on MSDN.

But wait! There's more!

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 had made a mistake on that post and had updated. But I also realised that the script itself is actually part of a PowerShell module. So wanting to make things as easy as possible, and being the helpful guy that I am, I have altered that example into a script which I am posting here.

But wait! There's more!

Some Notes on AssistDeploy

Hello! I’ve spent a large chunk of the past few months putting together a PowerShell Module that will automate the deployment of SSIS solutions. Recently it went open source, and because I have a poor sense of humour I called it AssistDeploy. Aside from the readme, each function has it’s own documentation in the header. I’ve also written a rather large post on it at my companies blog. All very detailed, go and have a read.

But wait! There's more!

How To Use MSBuild Arguments in Visual Studio Builds

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 it elsewhere in greater depth, but here are the headlines: It makes use of SSIS Scale Out, which was released as part of SQL Server 2017. Although it is based on SSIS Scale Out, you can’t actually configure SSIS Scale Out to run on the instance. If this confuses you then read my in-depth post.

But wait! There's more!

Restore BACPAC to SQL Azure


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 to restore to Azure. It’s actually incredibly easy: use SQLPackage! Setthe /SourceFile to your bacpac, and use the connection string published on Azure, and you’re done!

Only a short post yes, but the precursor to some much longer and more interesting posts…

Updating XML Using PowerShell

Hello! One of the patterns in Continuous Delivery is to “build once, deploy many”. Another is to “deploy the same way to each environment”. This is certainly easier said than done: The 3 biggest challenges in creating a Continuous Delivery pipeline can be summed up as follows: Configuration Configuration Configuration Obviously values of variables are going to change across environments. So how can we take something static that contains meta data of an environment, like say some xml, and update the values so that it is correct at runtime.

But wait! There's more!

Get Dll VersionInfo Using PowerShell


Let’s be brief and not mince words: PowerShell is great. And so recently I needed to get the VersionInfo of a given DLL, and so was able to write up a module that did exactly that.