File Group Backups - Intro

What is File Group backup?

Backing up a portion of a database, say a File Group is termed as Filegroup...

Friday SQL Nugget #1

Gee thanks Jes (blog|twitter). Just what I wanted, a little extra work on a Friday afternoon. I used to like...

HP DL980…now this is a server!

I have been fortunate the past few months to be working on a HP ProLiant DL980 G7 Server.  This is...

Moving Database Files and Replication

Today’s post is a quick one as I am a bit under the cosh.
There are many ways to move database...

Re-blog – January 6 – January 12

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

Bloopers from Dec 2012

The raw ones from podcasts in late Nov and Dec 2011.
Dec 2011 Bloopers
Filed under: Blog Tagged: Humor, syndicated

Database Mirroring From SQL Server 2005 to SQL Server 2008 R2 SP1 CU3

I recently ran into a production instance of SQL Server 2005 SP2 (Build 3042) that is running in a two...

DBAs@Midnight 6 week roundup

We’ve been awfully busy these last few weeks, what with holidays and work and whatnot. But that hasn’t stopped us...

Fragmented Index – Rebuild or Reorganize ?

Introduction
In past, many times I have written on Fragmentation of Indexes and how to Defrag them. You can find some...

Missing Indexes

SQL Server has means built into it to track possible missing indexes.  This used to be found through the use of the Index Tuning Wizard.  The process has improved...