Monday, April 30, 2018

PowerShell PSSecurityException: UnauthorizedAccess

›
I just fought with this for close to an hour and the solution was REALLY simple so I thought I'd try and save someone else an hour of th...
Thursday, April 26, 2018

Continuous Integration (CI) with Azure DevOps, SSIS, and SQL Server Database Projects

›
What are we doing here? This is the first part of a two-part series covering 1) CI (continuous integration/build) and 2) CD (continuous de...
Sunday, March 11, 2018

Estimated Number of Rows = 1 Query Very Slow or Not Returning Data

›
A query that is slow that should be fast (e.g. underlying tables are not enormous, has been fast in the past, etc. - I'll let you dete...
Thursday, March 8, 2018

Visual Studio SQL Server Project (SSDT) OPENQUERY Warning

›
Using OPENQUERY in a stored procedure in a Visual Studio SQL Server project will result in the following warning. SQL70558: The column de...
Tuesday, July 12, 2016

Script to Copy Data Between Two SQL Server Databases

›
I recently had a requirement to "copy" the data between two identical database schemas. Actually the requirement was to "reb...
Tuesday, June 21, 2016

Visual Studio, TFS, Git, & GitHub

›
For those unfamiliar with TFVC it is one of the two version control engines shipped with Team Foundation Server, available with Visual Studi...
Wednesday, June 1, 2016

SQL Server 2016 Release Date

›
And...it's here! Looks like it was made available 12pm Eastern on June 1st, 2016.