T-SQL Basics: using OUTPUT

You are working on a database development project, and you need to obtain the records before/after an INSERT, DELETE, UPGRADE or MERGE Statement to present it to the user...

Upcoming Speaking Engagements

I presented a few times in 2019, and I’m starting off 2020 with several as well. Here’s what’s on the schedule for Q1.
2020-01-06 Yep, ISO8601 format. That’s how I...

Why I’m Learning Git via the Command Line Interface

I’ve learned a bit about Git in the last year: I’m now quite comfortable creating and managing Git Repos in Azure DevOps. I frequently do demos with SQL Change...

Ad Hoc Queries Disabled

This article takes a look at an error that may occur depending on your use of linked servers and the use of openrowset.
Related Posts:

Linked Servers and Stats October 17,...

CPU custom module available for Inspector V2

If you need to keep track of CPU and are not fortunate enough to have a monitoring tool to keep hold of historical CPU usage then this module may...

Creative Database Naming

Every now and again, we as DBAs need to get away from the daily grind of the hum drum tasks. We need to find a way to have a...

Creative Database Naming

Every now and again, we as DBAs need to get away from the daily grind of the hum drum tasks. We need to find a way to have a...

Powershell : Desire State Configuration -DSC

Powershell in 2012, Powershell 4.x onwards introduced Desire State Configuration(DSC) which help to build the standard configuration/ process /template for your system state and can be use or maintain...

Prompt in ADS

Ever since VS Code and Azure Data Studio came out, people have been asking for SQL Prompt to port over. I’ve been right there with you, though unsure of...

2019 in Review

What an incredible year it’s been.  I kept thinking that I was busy, but I had no idea until I looked at the final numbers (I have a Power...