November Question: What is your favorite, and not so favorite hardware to run SQL Server on?

Selecting which hardware to run SQL Server on is often discussed among DBAs. So, for this month’s question, “What is...

Quick and Dirty Index Info

From time to time, somebody needs to find some information about the indexes in the database.  As DBA’s, there are a few tools at your disposal to look up...

Quick and Dirty Index Info

From time to time, somebody needs to find some information about the indexes in the database.  As DBA’s, there are...

BI Pyramid (read categories of users in a BI solution)

Purpose of any business intelligence solution is to provide users information and enable them to make intelligent decisions that benefit their...

Fatal Error Emails This Morning…

So every morning I check my email on my phone.  Normally, I don’t see any error emails from SQL Server...

Backup/restore/checkdb/shrinkfile progress

Have you ever wonderet how long you need to wait for a backup or restore command to complete? If you...

Being an Effective DBA Remotely

Do not let the phrase “out of sight, out of mind” apply to you.
As Data Professionals a lot of us...

Log file size after backup and restore

Quick summary of the post:

A restoration of a full database backup retains the log file size before restoration.

Now...

Four faces of an Employee

Whoever starts their career in any domain/technology, initially they will have two faces.

First face of an employee is to take...

Document Your Day

You should be documenting your day, your week, your month, on a regular basis. Take a few minutes when you...