What Does a Database Administrator Actually Do?

Most people in your organisation, never mind everyone else, have no real clue as to what it is you do.
It’s...

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

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

SQL Server 2012 (“Denali”): Details on the next version of SSRS

SQL Server 2012 contains six new features for SSRS:
Excel Renderer for Microsoft Excel 2003, 2007 & 2010 - Excel renderer will support the Excel...

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

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

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

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

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

Reporting Services 2008–Books

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