Ethics and Power

Power corrupts.
A famous quote, and it’s one of the the most true quotes I’ve seen in my life. When someone...

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

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

How to let non-admin business users run replication agent jobs

This blog post is basic in nature but highlights a very real requirement that may arise when administering replication.  Occasionally...

File Group Backups - Intro

What is File Group backup?

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

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

Bloopers from Dec 2012

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

Scaling SQL Server Presentation from SQLSaturday #104 Precon

On Friday, January 6, 2012, I got the opportunity to present an expanded version of my “Scaling SQL Server” presentation...

SQL Server 2012 FileTable – Part 2

In this weeks blog post we will have a look at how easy it is to combine FileTables and FullText...