Author Archives: Robert

Get-AzDataFactoryPipeline: a misleading error

A few weeks back, I wanted to start an Azure Data Factory pipeline using PowerShell. It was the first time I tried that, and I thought it would be pretty simple: get the correct pipeline using Get-AzDataFactoryPipeline, supply all the … Continue reading

Posted in Azure Data Factory, Powershell | Leave a comment

Code samples for my book on Querying data with Transact-SQL (MCSA 70-761), chapter 3

Posted in Code samples, MCSA SQL 2016 70-761 | Leave a comment

Slow delete with immediate output

Posted in T-SQL | Leave a comment

How I passed the exam AZ-900 Microsoft Azure Fundamentals

This week, I passed my first Azure exam: AZ-900 Microsoft Azure Fundamentals. As the name suggests, this is the most basic Azure exam, and therefore a nice place to start if you want to get certified in one of the … Continue reading

Posted in Uncategorized | Leave a comment

Dynamic PIVOT statement

My attempt to make a dynamic PIVOT statement. The table used is the same as the example in my 70-761 book. First, the @list_of_columns parameter is filled to create a list of columns, using COALESCE. Next a common table expression is … Continue reading

Posted in Uncategorized | Leave a comment

Convert MSDB job history to datetime

This script will get the job history for a particular job. The start time will be converted from integer to datetime. Works for job duration under 1000 hours. Since I’ve still got clients on SQL 2008, I can’t use the … Continue reading

Posted in Uncategorized | Leave a comment

Bonus questions for MCSA 70-761

The practice questions have been moved to a free course on my Teachable site: https://consigno.teachable.com

Posted in Books, MCSA SQL 2016 70-761 | Leave a comment

Code samples for my book on Querying data with Transact-SQL (MCSA 70-761), chapter 2

 

Posted in Code samples, MCSA SQL 2016 70-761 | Leave a comment

Code samples for my book on Querying data with Transact-SQL (MCSA 70-761), chapter 1