Easy Open Event Log Files

• by Jason Brimhall

• SQL RNNR

Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to better service the needs of the developers when the...

2019-06-07

1 reads

Implicit Conversion Insights with XE

• by Jason Brimhall

• SQL RNNR

Seldom does a DBA have the opportunity to get out in front of infrequent or random errors such as implicit conversions. More often than not, it is the privilege...

2019-06-05

1 reads

Implicit Conversion Fail

• by Jason Brimhall

• SQL RNNR

Implicit conversions are not uncommon in the computing world and can be viewed as kind of a fail-safe for when we don't quite follow decent practices when designing the...

2019-05-31

2 reads

Puzzles and Daily Trivia

• by Jason Brimhall

• SQL RNNR

One of my favorite database automations is to send trivia style questions daily. This helps me to mentor and assess other dba talent within an organization without being too...

2019-05-31 (first published: 2019-05-14)

222 reads

Mass Backup All Sessions

• by Jason Brimhall

• SQL RNNR

Migrating Extended Event Sessions from one server to another should be a simple task. So simple, one would think there was no need to give it a second thought,...

2019-05-23

Event Log File Paths

• by Jason Brimhall

• SQL RNNR

How does one consistently find the correct path to the Extended Event Log file (XEL file)? This article shows a thorough method to capture that information for all sessions...

2019-05-20

98 reads

Event Log File Paths

• by Jason Brimhall

• SQL RNNR

How does one consistently find the correct path to the Extended Event Log file (XEL file)? This article shows a thorough method to capture that information for all sessions...

2019-05-20

Puzzles and Daily Trivia

• by Jason Brimhall

• SQL RNNR

One of my favorite database automations is to send trivia style questions daily. This helps me to mentor and assess other dba talent within an organization without being too...

2019-05-14

Database Recovery Monitoring with XE

• by Jason Brimhall

• SQL RNNR

Database recovery (crash recovery) is a nerve wrenching situation under the wrong conditions. It can be as bad as a root canal and just as necessary to endure that...

2019-04-22 (first published: 2019-04-10)

528 reads

Database Offline – Redux

• by Jason Brimhall

• SQL RNNR

A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help...

2019-04-15

74 reads