Archives: November 2011
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
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
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 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