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

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

SQL Server Release Services Blog and TechDays 2011- Places Worth Watching (Oh, & In Case You Missed it, SQL 2008 SP3 Was Already Released :)

Yes, SQL Server 2008 SP3 is out ...

TechDays 2011 SQL Server and Data Platform Track

SQL Tribal Knowledge

Calling all unpublished* SQL Server folk!
I’m now accepting abstracts for a new project we’re putting together – a community-written book of...

Document Your Day

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

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

Haunting a Database Near You

Today, we have a special Halloween edition.  For me, Halloween and computer geek go quite well together.  And thinking about...