Blog Posts

Database Offline – Redux

• 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…

Jason Brimhall

2019-04-15

13 reads

Making Databases Personal

• SQL RNNR

If you can use a database to create automation routines to help sustain your work life, you can certainly do the same to sustain your personal life. Databases are…

Jason Brimhall

2019-04-09

89 reads

Database In Recovery Redux

• SQL RNNR

One of the more gut-wrenching experiences of a DBA is to have a database get stuck in recovery. This typically happens when the server was rebooted unexpectedly and typically…

Jason Brimhall

2019-04-08

4 reads

Connect To SQL Server – Back to Basics

• SQL RNNR

The first critical task any data professional should ever learn how to do is how to connect to SQL Server. Without a connection to SQL Server, there is barely…

Jason Brimhall

2019-03-27

443 reads

An Experiment with Deadlocks

• SQL RNNR

There seems to be a myth out there that when deadlocks come a-knocking, then just throw this little directive (ROWLOCK) at it and all will be well. This is…

Jason Brimhall

2019-03-25

182 reads