The Holidays are upon us.  It is time to take a break from the hustle and bustle and come out to participate in the local User Group for SQL Server.

This month, Jason Brimhall will be presenting a new topic:

REPORTING SERVICES FOR MERE DBAS

As a DBA in the… Read more

Back in August, I published a post on exporting SSRS report files en masse.  That article (which can be read here) detailed an SSIS package I created to export the files.  As it is published, it is only good for exporting the actual report files and not the data… Read more

Since Deep Dives 2 came out, I had been putting off getting my copy of the e-book until I wanted the book for travel purposes.  I decided I really needed to have it loaded on the kindle and quickly started running into a few roadblocks.

First roadblock was easy to… Read more

Finally, I have completed another book.  I took the opportunity while traveling to catch up on some reading.  Better yet, I was able to do this while testing out my Kindle.

The book I just finished is “Throne of Fire” by Rick Riordan.  This is the second book in the… Read more

At the beginning of the month, we had a Meme Monday on the topic of SQL Family.  I had a few things to say about the SQL community back then.  And now, I want to give a bit of an update on the topic that supports what I have… Read more

Another script, another day.  And as promised, I am providing an update to the Table Space script that followed the sp_MStableSpace script.  Not a lot more to be said about this one, since much was said already.

I updated the script for those CS collations.  I also provided the update… Read more

Since I am in the Collation Sensitive mood, I am finally getting around to updating this script.  This is the Table Space script that I have had out there for a while.  In the last release of this script, a request (by Remi) was made to update it so it… Read more

At the urging of a friend, this script is being updated for those that are dealing with Case Sensitivity.  The first few rounds, I neglected Case Sensitivity and never tested for that.  It makes sense to have this script updated for that if anybody out there is using it.

The… Read more

I have talked about tools for SQL server a few times in the past.  You can read some of what I wrote here and here.

Since writing those last articles, I have come across more tools here and there.  Over the past few weeks, I came across three that… Read more

If you recall, I like Sudoku.  I even posted a script for solving it via TSQL.  I went so far as to enter my script into a TSQL Challenge.  That all started way back in August.  Today, I have an update!!

I was notified this morning from BeyondRelational.com that… Read more

I sit here in a hotel room as I reminisce on this past weekend.  This last weekend began with a red-eye trip from Salt Lake to New York.  The reason for taking that trip was merely to attend SQLInspire – oh and to support the community.

This event was organized… Read more

I find myself just now sitting down to write this as the deadline for TSQL Tuesday 24 fast approaches.  Fortunately I started planning out what I wanted to cover several days ago.

I could have tried writing this last night – but I ended up falling asleep at the keyboard.… Read more

Another month, another meeting.  Time really is flying.  And now with more Holidays fast approaching, I am sure that time will warp on us.

The Las Vegas user group is happy to announce that we have a new topic and new presenter (new to us anyway) for the month of… Read more

It has been a while since I last wrote something for a meme monday.  This month is a perfect time to jump back in the deep end.

If you don’t know what a meme monday is, then here is a little recap.  Thomas LaRock started this to assist in getting… Read more

Some time ago, I had the opportunity to work on a problem involving the color wheel.  The requirements for that problem lent themselves to a solution involving bitwise operations (which you can read here).

I recently came across a new problem involving the color wheel.  This time the requirements… Read more

From time to time, somebody needs to find some information about the indexes in the database.  As DBA’s, there are a few tools at your disposal to look up that information.  The required/requested information is not always the same.  That said, you can usually adapt a query quickly to find… Read more