A DBAs List of Little Things

Today is Meme Monday.  Today we get to talk about all of the little things a DBA does.  Thomas LaRock started things off with his list – here. I...

Are my Linked Servers Being Used?

This is a follow up to an article published on 3/1/2012.  That article showed how to find what linked servers...

Are my Linked Servers Being Used?

This is a follow up to an article published on 3/1/2012.  That article showed how to find what linked servers were created on your instance of SQL Server.  You...

Database Mirroring

Introduction

This blog covers the High Availability Solutions provided by SQL Server i.e. Database Mirroring.
Database mirroring is a solution in SQL...

Find the latest databse backup SQL server

AdvertisementsUse the simplest script to find the latest database backup and the location.
 
-- To get the backup history
SELECT top 100...

How to use Change Data Capture (CDC)

With SQL Server 2008 Microsoft added the CDC feature to SQL Server enterprise edition. I haven’t come to play around...

Register for SQL Server 2012 Virtual Launch

`As we all are aware SQL Server 2012 virtual launch is scheduled after 60 hours roughly. Earlier I have discussed...

Reporting Services 2008–Books

I have had a few people ask me recently about books that I would recommend to help further develop your...

Restoring a Certificate

I have written about creating a certificate and backing up a certificate, and the next step is the restoration of...

RYO Maintenance Plan – Index Maintenance

It’s been a couple of weeks since my last post, but I swear I have a good excuse. I’ve been...