Capture the Flag – The Trace Flag

Many people work in a tightly controlled environment. Every change requires a change control form and approval to make a...

How To: XEvents as Profiler

Despite the controls in place there always seems to be some change that is unknown or even some cowboy that makes changes as s/he sees fit and forgets to...

How To: XEvents as Profiler

A common excuse for not delving into extended events seems to be the jump from Profiler to extended events.  There...

2018 Advent of Code–Day 1

I enjoy when the Avent of Code comes around each year. I seem to make this a December (or sometimes...

How Much Volunteer Time Per Year is a Good Goal?

Yesterday I posted about journaling with my goal being to track the time I spend on SQLOrlando (I’ll exclude time...

Indexing In Memory OLTP Tables

Indexing on In Memory OLTP tables is a little different from your traditional on-disk rowstore tables…
In Memory Differences…
There is no...

Merry Christmas

Wish you all a Merry Christmas and may this festival bring abundant joy and happiness in your life!

From 
 Technology with Vivek Johari 

Merry Christmas

Wish you all a Merry Christmasand may this festival bring abundant joy and happiness in your life!

From  Technology with Vivek Johari 

Quick and Easy XE for Azure DB

This is a very simple introduction into the creation of an Extended Event session using a template for Azure SQL DB. I demonstrate the use of the GUI to...

Thread-safe PowerShell Logging with PSFramework

In my previous post, I mentioned that I wasn’t checking the status of my RSJobs because I had logging built into my function. I originally tried to log out...