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

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

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

Happy Diwali

Wish you all a very happy and blessed festive season. May this festival of lights brings more brightness in your...

Migrating SQL Server Databases that use Database Master Keys

There’s a lot of things to consider when migrating databases between SQL Server instances. I want to provide some tips...

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

T-SQL Tuesday #36 SQL Community

Community – What is it? Community is something that is improperly defined with words alone.  Community is best defined through first person experience.  Community is a feeling and a...

T-SQL Tuesday #36 SQL Community

Community – What is it?
Community is something that is improperly defined with words alone.  Community is best defined through first person...

Time Trial sys.dm_exec_query_plan vs sys.dm_exec_sql_text

I’ve been working on a way to test performance usage on a server by database. I started out using sys.dm_exec_query_stats...

Rules of Holes #1: Stop Digging

You may have heard of the 'First Rule of Holes'. It goes something like this: " When you suspect you might be in a hole, stop digging. " That...