So far, in this series, I have discussed the means to view the metadata associated with Extended Events. I also demonstrated some quick and simple means to retrieve some metadata via the catalog views and DMVs.
Beyond the metadata in the the catalog views and DMVs, there are a… Read more
In the previous article, I wrote about getting into some of the metadata to take a peek at session metadata relevant to deployed Extended Event sessions. Today, I will continue talking about metadata. One difference being that today I will focus on diving into the metadata of running sessions. Read more
Today will be the first of a few introductory level posts about Extended Events.
When dealing with Extended Events, there are a few ways to take a look some of the metadata. Not all metadata is created equal when dealing with Extended Events. Some of the metadata is pertinent to…
The other day I wrote about that torrid love/hate relationship DBAs tend to have with working with XML. In that same post, I promised I would have a follow up post about XML in Extended Events.
Well, today I present to you another opportunity for you to renew your love/hate… Read more
One of the biggest pains with Extended Events is the thing we love to hate – XML. XML is so foreign to many DBAs. It’s not relational and often brings nightmares of parsing and performance issues.
Despite that, Extended Events takes advantage of XML much like we have seen in… Read more
You find yourself cruising along, just doing your thing as a database administrator. Then the CIO plops down into a spare chair in your cubicle to talk about the weather.
Well, not entirely true there. The CIO dropped in because the alerts for disk space have been blowing up everybody’s… Read more
Picture this if you could. You inherit a new database either through the change of a job, or finding a black box database server, or maybe due to the acquisition of a new application.
No matter the cause, you are now responsible for maintaining that database and you also really… Read more
This was a knock for the early days of Transparent Data encryption (circa SQL Server 2012). If TDE were enabled,… Read more
I want you to think about that one for just a little bit. What comes to mind when you hear DBCC? Is it the default go-to used when talking about consistency checks? Is it something more involved? Maybe… Read more
How well do you know the health of your SQL Servers and databases? Ever wonder about the current health or even what the health was like a few months back? Sure, one could anecdotally say the databases and servers are healthy, but how do you quantify it?
Many have asked… Read more
As was recently promised, I have an update to an old tried and true script for calculating the size of an object.
Some of the beauty of SQL Server is the complexity that it holds. Some of that complexity is right before our eyes. And some of that requires a little bit of diving into the internals to figure out what is happening or even why it is complex.
I enjoy the… Read more
I have previously written about finding what the big space consumers are within the database. I even shared scripts in those articles on how to find those big consumers (read all about it here).
That is grand when it comes to quickly finding which objects happen to be… Read more
SQL Server 2016 is on the horizon. We have a few CTP versions already released for download, allowing people to become more and more familiar with the product.
At long last the wait is over. After much blood, sweat and more blood and sweat, the next edition of the SQL Server Recipes book is finished.
This edition brings several changes and quite a bit of re-write. It has been updated for many of the new SQL… Read more
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on continuing. You can read (in full) about previous whistle stops and why they are called whistle stops here.
Amazing this… Read more
What is that default setting?
SQL server does a fantastic job of having numerous settings at the server level and at the database level predefined for you. Additionally, the OS has a bunch of settings that are predefined. These are notoriously the default settings. Or as some would say: “Set… Read more
Quick run the other way!
PASS Summit will never be the same!
Well, because for the first time in the history of me, I have been selected to speak at such a prestigious event.
Isn’t that just crazy?
In some ways it seems crazy. When I received the email… Read more
One of my pet-peeves (and consequently frequent topic of discussion) is finding database settings (or any setting that has changed) without knowing about it. Worse yet is finding that the change has occurred and nobody claims to have any knowledge of it or having done the deed.
This happened again… Read more
As we begin to get a grasp of all that is available with SQL Server 2016 and all of the new features, it is a great idea to see what else has been made available to us in order to help support and troubleshoot these new features. With that, it… Read more