Happy Diwali………….

Wishing You a Very Happy Diwali…………….
KAHI TIMTIMAHAT HAIN DIYO KI, KAHI SHOR HAAN ATHISBAZI KA
CHAMAK HAAN DIL MAIN, UMEEDO KI...

How to obtain the version and license for a Red Gate SQL BACKUP install

/*
here is a little script I've hobbled together that I use to get version and license info for a Red...

How to Use xp_dirtree to List All Files in a Folder

UPDATED -- Dec 31, 2012 -- Be sure to read Part 2 of this post discussing xp_dirtree.

Last week I blogged about how...

Instant File Initialization with TDE

If you are using Transparent Data Encryption TDE and have Instant File Initialization turned on, you are not getting the...

Mirrored Database as SSRS Data Source

Recently one of our report started to fail with error like Unable to Connect to Database error. Then only we...

PASS Summit 2012 Wrap Up

Wow, what a week. Once again, PASS put on a great event that provided much in the way of events...

Rules of Holes #2: You Are Still in a Hole

OK. So you followed the First Rule of Holes -you stopped digging yourself in deeper. But now what? You are...

SharePoint 2010 Setup Error

Sometimes in life things happen when you least expect them.  This was my experience some few weeks ago when I...

Site Update – Performance Tuning

Here at gethynellis.com we offer a range of consulting services to help you manage and maintain your SQL Server environment,...

TSQL Tuesday - What SQL Community Means To Me

Today is Tuesday, and its time for another edition of TSQL Tuesday #36, as we continue the eternal blog party...