Log Files from Different Sources
While working with Extended Events, or with any sort of logging or tracing utility, it becomes critical to consume the data from disparate sources or even to consume the...
2015-12-30
3 reads
Jason Brimhall
Histograms and Events
The last few articles covered the pair_matching target and some uses and details that go along with it. For a...
2015-11-03 (first published: 2015-10-22)
1,840 reads
Tricks and Treats with XE
With the proximity to Halloween, it's not hard (knowing me) to figure out why I originally decided to terminate this series on the Eve of Halloween day. Join me...
2015-10-30
Tricks and Treats with XE
Halloween is a great time of year. It is unfortunate that it is just one day of the year. That...
2015-10-30
1,017 reads
Default Sessions
So I have blasted through a lot of technical articles about Extended Events. There is a lot of groundwork that...
2015-10-29
1,089 reads
Default Sessions
The focus of this article will be to introduce the default sessions deployed with SQL Server. Some of these are internal and "private" while others are more "public" and...
2015-10-29
31 reads
Azure SQL Database
What hasn't received any TLC is Extended Events from the Azure SQL Database perspective. You may be wondering why it matters since I just said that Extended Events is...
2015-10-28
4 reads
Azure SQL Database
So far I have strictly focused on Extended Events for SQL Server installations. This means I have been looking at Extended...
2015-10-28
747 reads
Exposure to Internals
The premise of the article today is to get a little exposure to some of the internals that may cause a bit of curiosity for you. I will share...
2015-10-27
Exposure to Internals
For me, some of the most fun stuff with SQL Server is diving deep into the internals. Diving into the...
2015-10-27
586 reads
Blogs
New Pluralsight Course - Certified Kubernetes Administrator - Working With Your Cluster
We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...
Friday Basics: the CIA Triad
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
A New Word: the standard blues
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
Forums
One more reason to use foreign key constraints
Comments posted to this topic are about the item One more reason to use...
client_app_name is empty in Extended Events output but present in sp_who2
I'm tracing activity on one database and would like to include the client_app_name in...
How to compare data in customer table with other customers to find related cust
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
Question of the Day
The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers