- Database Dropped by Jason Brimhall
What do you do when a developer comes to you and asks, “Where did the database go? The database was there one minute, and the next it was not.”
- Default Sessions – Ba… by Jason Brimhall
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 by Jason Brimhall
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 by Jason Brimhall
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)?
- T-SQL Tuesday #081: Recap by Jason Brimhall
August 2016 TSQL Tuesday Recap
- T-SQL Tuesday #081: Getting Sharper by Jason Brimhall
Getting sharper at JSON through a little experimentation.
- Audit All Select Statements by Jason Brimhall
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.
- BIT9 PathNames by Jason Brimhall
We live in a day and age when security (data, network, server, etc) is seemingly at the forefront of the daily news.
- T-SQL Tuesday #081: Sharpen… by Jason Brimhall
This month I am asking you to not only write a post but to do a little homework – first. In other words, plan to do something, carry out that plan, and then write about the experience.
- Easily Shred Event Data by Jason Brimhall
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.
- Jason Brimhall about Database DroppedI would agree with you there. In addition, I have the follow-up to audit for dropped databases via Extended Events…
- Curt Summers about Database DroppedGreat post! This is an excellent addition to my toolbox. For accidental drops this script does the trick. It is…
- Jason Brimhall about T-SQL Tuesday #081: RecapSorry. I don't test firefox. They work in IE and chrome. I will update to include links in the paras…
- Robert L Davis about T-SQL Tuesday #081: RecapImage links are not working in FireFox. They work in IE. The only link that works in FF is Rob…
- Jason Brimhall about T-SQL Tuesday #081: RecapThanks
- Rob Farley about T-SQL Tuesday #081: RecapNicely done. I love a creative round-up.
- Jason Brimhall about Table Hierarchy updatedThanks. I agree that is a fatal flaw. I will update.
- Clayton Groom about Table Hierarchy updatedThanks for a great script. It has a fatal flaw that needs to be addressed though. You've ignored object schemas,…
- Jason Brimhall about Audit All Select StatementsSQL Audit would be an appropriate mechanism for auditing statements run by specific people. The complication with sql audit comes…
- Peter about Audit All Select StatementsCuriosity - would SQL Audit be a reasonable choice if I wanted to audit all SQL Statements run by accounts…