- 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.
- Dynamics AX Event Session by Jason Brimhall
There are many many uses for Extended Events. In this article I show a quick session setup that can be useful in the troubleshooting of various different problems (most probably performance related) with Dynamics AX.
- Correlate SQL Trace and Actions by Jason Brimhall
In the world of profiler and SQL Trace, these actions were an actual part of the payload for the Trace event. In XE, these actions are more like add-ons. I go into further depth about what an action in XE is – here. I recommend reading that article. Due to that, I won’t be diving into great detail here about what an Action is.
- Failed to Create the Audit File by Jason Brimhall
One day while checking things for clients, I happened across a fun little error message – “SQL Server Audit failed to create the audit file”. It just so happens that the audit had been working and then suddenly stopped and started flooding the error logs with this message.
Why would it suddenly stop working? Well, it says in the error that the disk might be full or that there may be a permissions issue. So, at least there are some possibilities provided by the message. Granted – neither of these options is very settling for a DBA.
- 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!