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...

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...

Fame and Social Media

Reading this post about Alton Brown from Good Eats triggered me to think on the topic. It looks like initially...

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...

Free Business Intelligence Workshop

If you are in and around Dallas next week drop by my FREE half-day Business Intelligence workshop.  The details are...

Get Inspired – SQL Inspire 2011 New York

Coming up next week is the SQL Inspire 2011 event in New York City. It’s an event with a number...

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...

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...

Presenting on SQL Internals, Recovery Models, & Backups! OH MY Today

 Today I’m presenting “SQL Internals, Recovery Model’s, and Backups. OH MY!”, for Pragmatic Works.  I did this presentation once before...

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...