-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Richie Lee's SQL Stuff

Full time computer guy, part time runner. Full time Dad, part time blogger. Knows a thing or two about Pokémon. Knows too much about SQL Agent. Writer of fractured sentences. Maker of the best damn macaroni cheese you've ever tasted.

Archives: October 2017

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:

View the code on Gist Read more

0 comments, 172 reads

Posted in Richie Lee's SQL Stuff on 10 October 2017

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 devenv.com via cmdline. Annoyingly, there was no errors outputted. So i cloned the… Read more

0 comments, 181 reads

Posted in Richie Lee's SQL Stuff on 6 October 2017

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 properties of a connection manager in a SSIS project were parameterised. This even happened automatically when they got deployed to a SSIS Server. Great! The feature was also written… Read more

1 comments, 1,483 reads

Posted in Richie Lee's SQL Stuff on 6 October 2017

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…

Read more

0 comments, 198 reads

Posted in Richie Lee's SQL Stuff on 4 October 2017

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… Read more

0 comments, 146 reads

Posted in Richie Lee's SQL Stuff on 3 October 2017