- Extended Events File Initia… by Jason Brimhall
One of the recommended methods to trap payload data in an XE session is via the use of the event_file target. Sending data to a file has numerous benefits such as being able to take the trace and evaluate the trace file from a different machine (locally to that machine).
- Profiler for Extended Event… by Jason Brimhall
As of SSMS 17.4 we have been given the ability to control XEvents Profiler just a tiny bit more. For what it is worth, we as Database Professionals love to be able to control our database environment. So this teeny tiny bit of new control ability is potentially a huge win, right?
- SQL Server User Already Exi… by Jason Brimhall
One of my all-time favorite things in SQL Server is security. No matter what, it always seems that there is a new way to abuse permissions. When people abuse their access level or abuse the way permissions should be set in a SQL Server environment, we get the pleasure of both fixing it and then trying to educate them on why what they did was wrong and how to do it the right way.
- Database Corruption and IO Errors by Jason Brimhall
A quick way to have your day turned upside down and rip your gut out with nerves and anxiety is to come in one day to find that users are panicked, applications are not working and the HelpDesk team is curled up in the fetal position in the corner. Why? The sky is falling and everybody thinks the database has blown up. You appear to have a corrupt database and nasty IO errors.
- Checking the Health of your CLR by Jason Brimhall
Having a tool to be able to monitor CLR health will be essential as you deploy more and more managed code within SQL Server. Extended Events offers a great lightweight means to do just that. This article shows how to deploy a session that will capture the various changes with CLR objects within our database environment. In addition, you will be able to capture various conditions related to performance or problems with the managed code. You may even recognize some of the CLR events from the system_health session.
- SQL Server Configurations &… by Jason Brimhall
One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would be called defaults. Having default settings is not a bad thing nor is it necessarily a good thing.
- Summiting that Technical Challenge by Jason Brimhall
The challenge at hand – conquering that technical problem and getting that high associated with the metaphorical high of summiting a tough task.
- Common Tempdb Trace Flags &… by Jason Brimhall
In this article I introduce you to some basics in regards to default behaviors and settings in tempdb along with some best practices. It is advisable to investigate from time to time some of these recommendations and confirm what we are really being told so we can avoid confusion and mis-interpretation.
- Changing Default Logs Direc… by Jason Brimhall
In this article I will explore altering the default logs directory location. Some may say this is no big deal and you can just use the default location used during install. Fair enough, there may not be massive need to change that location
- Sharepoint Diagnostics and XE by Jason Brimhall
In this article I have introduced you to a quick session setup that comes from using the SPDiag tool that could plausibly be useful in the troubleshooting of various different problems (most probably performance related) with Sharepoint.
- Jason Brimhall about Database Corruption and IO ErrorsThanks Robert.
- Robert L Davis about Database Corruption and IO ErrorsGreat article Jason. When I saw your initial list of things to do and #5 was "Restore", my initial thought…
- Jason Brimhall about Parse Dynamics AX Context Infothat is a very good question. AX 2009 did things a little differently. While minimal, at best, the online users…
- Tel about Parse Dynamics AX Context InfoInteresting. Do you know which versions of AX support this? I'm interested in AX 2009.
- Jason Brimhall about Sharepoint Diagnostics and XEBaris, will you please clarify for me a little bit? Details on what you are envisioning would be helpful.
- Baris Saydag about Sharepoint Diagnostics and XEHi Jason, I am impressed with your contributions to SQL world! Your books are amazing. You…
- Jason Brimhall about Audit Domain Group and User…i have and it would be a similar routine. The question with nested groups is what point do we stop…
- jeff_yao about Audit Domain Group and User…Have you considered a Domain group within another group?
- Gerald about Best New(ish) SSMS FeatureNice - never heard of this before. Seems to be a great feature - i'll give it a try!…
- Jason Brimhall about T-SQL Tuesday #096: Inspira…Thank you Brent. And thanks for reading too!