Upgrading From SQL Server Profiler
How to correlate all of your favorite trace/profiler options into the shiny new XE equivalents.
As luck would have it, there is a means to correlate trace/profiler events to Extended...
2018-12-26
11 reads
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,...
2018-12-26
1,033 reads
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...
2018-12-25
20 reads
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-12-25
761 reads
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
2018-12-24
34 reads
Merry Christmas
Wish you all a Merry Christmasand may this festival bring abundant joy and happiness in your life!
From Technology with Vivek Johari
2018-12-24
176 reads
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...
2018-12-24
330 reads
Running Windows and Linux SQL Containers together
Just for fun I decided to spend Christmas Eve getting Windows and Linux SQL containers running together.
WARNING
This is NOT a...
2019-01-04 (first published: 2018-12-24)
1,891 reads
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...
2018-12-24
23 reads
Quick and Easy XE for Azure DB
The Cloud
It has been a minute since I gave much love or attention to Extended Events in Azure SQL DB....
2019-01-07 (first published: 2018-12-24)
1,499 reads
Blogs
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers