Creative XE Sessions – Funky Data

Playing around with emojis in a database is a fun endeavor. Not only is it fun to play with for personal growth, but it does have some business advantages.
Related...

Checking SSIS Variable Values During Runtime

As anyone who reads my blog on a regular basis knows, I’m a big fan of using dynamic configurations, including SSIS parameters variables, to make my ETL architectures as...

Creative Extended Event Sessions

A picture is worth a thousand words, right? Sometimes, a picture for an event session just may be able to say it better than 50-60 letters used to try...

Creative Extended Event Sessions

A picture is worth a thousand words, right? Sometimes, a picture for an event session just may be able to say it better than 50-60 letters used to try...

Happy New Year!

Happy New Year!! Yes, I know it was two days ago but I’m still pseudo-on-vacation-not-really so just another simple blog post wishing you prosperity, health, and good tidings this...

SQLSaturday Orlando Notes – The Five Hats

I want to wrap up the notes on SQLSaturday by writing about my approach to managing events that I’ve evolved at SQLSaturday but definitely applies to most events and...

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,...