Execute Multiple Files Using SQLCMD/SQLClient – Which Is Faster?

• by Richie Lee

• Richie Lee's SQL Stuff

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,301 reads

Deploy Dacpacs with dbatools – The Script!

• by Richie Lee

• Richie Lee's SQL Stuff

Hello!
Not so long ago, I wrote about how dbatools now has functions that can be used to deploy dacpacs. What...

2018-01-16

282 reads

salt Release 1.1.2562 – With Bug Fix!

• by Richie Lee

• Richie Lee's SQL Stuff

Hello!
Very recently a user of salt got in touch with me about a bug when setting the job schedules up...

2018-01-09

237 reads

The Mystery Of The Failing Azure Cmdlet

• by Richie Lee

• Richie Lee's SQL Stuff

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

391 reads

PoshSSDTBuildDeploy Update – Now With Dynamic SqlCmdVar Updates

• by Richie Lee

• Richie Lee's SQL Stuff

One of the big challenges in the whole “build once/deploy many” ideology is the need for environment configuration. And this...

2017-11-28

249 reads

PoshSSDTBuildDeploy Update – Now With LocalDB!

• by Richie Lee

• Richie Lee's SQL Stuff

Hello!
Late on Friday I published a PowerShell Module that gives working examples of using DataToolsMSBuild. All very interesting, go and...

2017-11-28

318 reads

Automate Parameterising SSIS Connection Managers

• by Richie Lee

• Richie Lee's SQL Stuff

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,014 reads

Kill a Connection, Session, or Command in Analysis Services

• by Richie Lee

• Richie Lee's SQL Stuff

One of the useful features of the SSAS Activity Monitor is the ability to cancel sessions and queries. Though there is...

2017-10-10

1,464 reads

Failed SSIS Build – DtsRuntimeException

• by Richie Lee

• Richie Lee's SQL Stuff

Hello!
I was helping a team debug a failed build today. Despite the fact that the build compiled on the devs...

2017-10-06

301 reads

What Do You Get if You Unpack an Ispac?

• by Richie Lee

• Richie Lee's SQL Stuff

I’ve spent what feels like a lifetime working on automating SSIS deployments, more specifically SSIS packages that have been created...

2017-10-04

809 reads