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,304 reads
Richie Lee
Deploy Dacpacs with dbatools – The Script!
Hello!
Not so long ago, I wrote about how dbatools now has functions that can be used to deploy dacpacs. What...
2018-01-16
284 reads
salt Release 1.1.2562 – With Bug Fix!
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
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
392 reads
PoshSSDTBuildDeploy Update – Now With Dynamic SqlCmdVar Updates
One of the big challenges in the whole “build once/deploy many” ideology is the need for environment configuration. And this...
2017-11-28
253 reads
PoshSSDTBuildDeploy Update – Now With LocalDB!
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
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,079 reads
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...
2017-10-10
1,659 reads
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...
2017-10-06
301 reads
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...
2017-10-04
1,179 reads
Blogs
Azure Platform Series “You have exceeded the maximum amount of scale changes within the past hour”
By HamishWatson
This blog post relates to where you might be doing scale operations of your...
Bash: “command not found” in IF statement
By HamishWatson
This blog post is about a situation where writing an IF THEN ELSE statement...
The First Data Saturday is Tomorrow
By Steve Jones
Data Saturday #2 – Guatemala is tomorrow. This is the first event on the...
Forums
Calling remote powershell script through SQL server agent
I have a powershell script in remote server. When I go to remote server...
Data Privacy Grows in California
Comments posted to this topic are about the item Data Privacy Grows in California
Grant user access to view database only
Hi I need to grant a user access to a DB on the server...
Ask SSC