T-SQL Tuesday #028 - I'm a Jack of All Trades, and Proud of It

If I wasn't, would I have proposed the following topic for several speaking chances, including SQLRally?
 
Being a specialist means you're...

Views in Use?

Today, I am following up on a topic I mentioned in an earlier post.  In case you haven’t read the...

Views in Use?

Today, I am following up on a topic I mentioned in an earlier post.  In case you haven’t read the post on finding your linked servers, you can read...

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

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