Upgrading From SQL Server Profiler

I just shared an article describing how to use Extended Events to perform your SQL Server Profiler duties. If not,...

Useful T-SQL queries and scripts to work in SQL Server

This post is about some queries and scripts that I use in my daily work on SQL Server. Some of...

Advent of Code 2018 – Day 4 (Repose Record)

Advent of Code 2018 – Day 4
As I explained in a recent post, I’m participating in this year’s Advent of Code...

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 Christmasand may this festival bring abundant joy and happiness in your life!

From  Technology with Vivek Johari