Do you know that your Server logs 300 million deprecation events a week? Do you know if code needs to be updated or how to find deprecated uses in SQL Server?
Finding Deprecated Uses in SQL Server
Category: Extended Events
Default Sessions – Back to Basics
With the evolution of SQL Server, there is an evolution in Extended Events. New features in SQL Server also means there may be some additional default sessions.
Events By Feature
Within the world of SQL Server there are a few things one can be certain of – things will change. This is true of the features in SQL Server. Additionally, Extended Events is constantly evolving which underscores this constant change.
Finding the Right Path
What is this gaping hole in the coverage of Extended Events? To be honest, it is not a very complicated topic or very difficult gap to fill. It’s just something that has been overlooked. The gap boils down to this: how does one consistently find the correct path to the Extended Event Log file (XEL file)?
Audit All Select Statements
Legislation and regulation sometimes dictates that certain activities must be tracked within a database. On occasion, it will be required that queries be audited and tracked to reach compliance with the legislation or regulation. To achieve this compliance, this article will demonstrate how to use Extended Events to audit statements being executed within the database.
Easily Shred Event Data
Parsing XML is the epitome of salt in a wound for a DBA. Parsing the XML from Extended Events need not be so painful. Read further to discover how to remove the pain from the task of XML parsing.
Another Query to Help Find the Right Event
Finding the right event or combination of events to monitor may seem like quite a daunting task with so many events to explore and (frequently) too little familiarity with Extended Events.
Extended Event Help Queries
When working with Extended Events, there are times when a little more information is, well, helpful. You know you want to use extended events to try and monitor for a specific thing to happen.
SQL Server Desired Enhancements
SQL Server 2016 has come with a ton of cool features, bells, whistles and well cool stuff (yes redundant). That aside, what are some of the really cool features that I would love to see in SQL Server?
Awesome SQL Server Feature
There are a lot of cool features in SQL Server that ROCK! It is really hard to pick just one with so many cool features that can make life much easier as a DBA.