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

T-SQL Tuesday #36 – Community

Chris Yates (@YatesSQL / blog) is hosting the T-SQL Tuesday blogging party this month, and he wants to know “What does...

T-SQL Tuesday #36 – SQL Community

T-SQL Tuesday #36 – SQL Community
T-SQL Tuesday #36 - SQL Community

This blog entry is participating in T-SQL Tuesday #36, hosted this month...