SQL RNNR

Public Role Permissions – Back to Basics

• by Jason Brimhall

• SQL RNNR

If you are being serious in your role, then the amount of times you grant permissions to the public role should either be a) never, b) when you want...

2019-06-17

3 reads

Get the Source of PREEMPTIVE_OS_PIPEOPS Waits

• 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 capably monitor the server for any issue be it...

2019-06-13

20 reads

Note to Self

• by Jason Brimhall

• SQL RNNR

Not only should you pay respect to those giving of their time, but you should spend a little time to also give back to the community. I will say...

2019-06-11

9 reads

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

183 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

56 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

11 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-06-12 (first published: 2019-05-23)

171 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

88 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)

211 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

73 reads