- SQL Server Principals ̵… by Jason Brimhall
A fundamental component of SQL Server is the security layer. A principle player in security in SQL Server comes via principals.
- All about the Change by Jason Brimhall
The use of SQL Audit can be viable to track the changes that may be occurring within your SQL Server – from a settings point of view
- Alter Event Session by Jason Brimhall
Altering an Extended Event session is not necessarily a difficult task, but it is a very useful ability. Having this basic skill in your wheelhouse can be very positive and useful for you!
- Waiting, is it a Bad Thing? by Jason Brimhall
One of the more useful troubleshooting tools (granted when used properly and not with a knee jerk approach) is waits. There are waits in SQL Server that are very specific to Extended Events.
- A day in the Stream by Jason Brimhall
Explore the little function called sys.fn_MSxe_read_event_stream and discover just a little bit more of what Extended Events may be doing behind the scenes with the live data viewer.
- Hidden GUI Gems by Jason Brimhall
I have a few gems that are available to you in the GUI. These gems should help solidify your understanding of the tools available through the GUI to help work with Extended Events
- Filtering Logged Data by Jason Brimhall
Explore how to customize the view of the GUI for working with XEvent Log files or XEL files. This further customization does include working with filters.
- Customize the XEvent Log Display by Jason Brimhall
Explore how to configure the XEvents GUI with specific views to suit your needs and tastes for data display by adding, removing or changing the column orders.
- Log Files from Different Sources by Jason Brimhall
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 data from a source server on a different server.
- Tricks and Treats with XE by Jason Brimhall
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 as I share some treats and a trick to use with Extended Events.
- David about A day in the StreamThanks for the pointer. Not sure where you got the comment but it looks authoritative. Would…
- Jason Brimhall about A day in the Stream/* To Read Session Data from the other functions or files requires VIEW SERVER STATE To create/alter/delete XE Session requires…
- David about A day in the StreamAny ideas about the security requirements for fn_MSxe_read_event_stream? Based on my investigation you need "VIEW SERVER STATE". I…
- Jason Brimhall about Histograms and EventsLet me see if I can whip a post together to show that.
- Mark Freeman about Histograms and EventsHow could I extend the histogram output and the query to read from it if I wanted to get the…
- Robert L Davis about All about the ChangeThanks for participating in T-SQL Tuesday. Good article on some auditing basics which isn't spelled out very well in Books…
- Patrick Krapf about Reading Session Data from MemoryJason, Very nice article, it has me thinking on how I can put it to use in…
- Jason Brimhall about Security AuditThanks for the feedback. I will go test some more. I hadn't run into the bcp not working.
- MAgnus about Security AuditVery nice report, good work! fyi, I needed to add "database.dbo." before TBLHTML to get the bcp…
- kin about Missing Indexes Script v2Hello Jason, Excellent script. The only thing that would imporve its usefulness, if you can…