SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: November 2011

December 2011 LV UG Meeting

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:


As a DBA in the… Read more

0 comments, 1,597 reads

Posted in SQL RNNR on 30 November 2011

SSRS Export part 2 (Export Data Source)

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

0 comments, 1,605 reads

Posted in SQL RNNR on 29 November 2011

SQL Deep Dives 2 on the Kindle

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

1 comments, 776 reads

Posted in SQL RNNR on 23 November 2011

Throne of Fire

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

0 comments, 622 reads

Posted in SQL RNNR on 22 November 2011

SQL Family – an Update

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

1 comments, 645 reads

Posted in SQL RNNR on 21 November 2011

Table Space – CS Part Deux

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

0 comments, 643 reads

Posted in SQL RNNR on 21 November 2011

Table Space revised Again

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

0 comments, 993 reads

Posted in SQL RNNR on 17 November 2011

Table Hierarchy goes CS

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

0 comments, 581 reads

Posted in SQL RNNR on 16 November 2011

A Trio of Tools

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

2 comments, 823 reads

Posted in SQL RNNR on 15 November 2011

TSQL Challenge 63 – Update

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

5 comments, 1,016 reads

Posted in SQL RNNR on 14 November 2011

SQLInspire NYC 2011

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

2 comments, 530 reads

Posted in SQL RNNR on 14 November 2011

T-SQL Tuesday #024: Prox ‘n’ Funx

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

2 comments, 649 reads

Posted in SQL RNNR on 8 November 2011

SSSOLV November 2011 Meeting

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

0 comments, 564 reads

Posted in SQL RNNR on 7 November 2011

We are Family

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

4 comments, 661 reads

Posted in SQL RNNR on 7 November 2011

Another Color Wheel

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

4 comments, 1,245 reads

Posted in SQL RNNR on 3 November 2011

Quick and Dirty Index Info

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

1 comments, 715 reads

Posted in SQL RNNR on 1 November 2011