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

I'm presenting at 24 Hours of Pass!!

Woohoo!  I have been selected to present my SSIS Tips & Tricks presentation at this year's 24 Hours of Pass.  I am...

Oracle Tips for MSBI Devs #1: Executing an Oracle Stored Proc with No Parameters in SSIS Execute SQL Task

Originally posted: 3-4-2012 Welcome to a new blog series of tips related to Oracle with a focus on helping those...

CPU-Z 1.60 Released

Pretty much right on schedule, Frank Delattre has released CPU-Z 1.60, which has support for some new and upcoming processors...

Resource Governor Configuration

Resource Governor(RG) is a technology which introduced in SQL server 2008 to manage the CPU and Memory resource that a incoming session can...