Thursday, May 21, 2009

That’s A Rap?

You may have noticed a lot of DBA's trying to go around rapping this week. For example, Steve Jones posted DBA's Delight earlier this week with no explanation (braver than me). If I am going to make the world read my sad attempt at writing a rap, I figure I at least owe them an explanation. So here's the scoop. Michelle Ufford and Ward Pond started a SQL Rap Contest the prize is an iPod touch.


Now that you know the motivation behind what you are about to read. Here is my submission...


WARNING! You may notice a yellow tint on your monitor due to the amount of cheese contained in the following post.


Vanilla Ice Parody


All right, DROP the Database and Listen
The Cube is back with a whole new Dimension


Caffeine has a hold on me tightly
I'm gettin paged now daily and nightly


Will it ever stop, yo I don't know
I work all night, its no joke


To the extreme I kill your process like a vandal
Cause I got SQL Skills, (oops that's Paul Randal)


If there is a problem, yo I'll solve it
Haven't run CHECKDB with Data Loss yet


This job is kind of crazy (dun, dun, dun, duh-na-na-nah)
Haven't seen the Sunlight lately (dun, dun, dun, duh-na-na-nah)


Rollin, out version 10.0
With my files sized right so my logs won't grow


Oh yeah, I've got Enterprise Edition
I'm using Resource Governor, with a mission


Putting, all the databases on Standby
For the logs, that I should apply


Installs, I've got down to a science
Service Packs, I know how to apply it


If I learn something yo, I blog it
Check out my site when your browser resolves it (cybersql.blogspot.com)


This job is kind of crazy (dun, dun, dun, duh-na-na-nah)
Haven't seen the Sunlight lately (dun, dun, dun, duh-na-na-nah)




(Word to your Mutha)

Here are a few other submissions I tracked down.


http://benchmarkitconsulting.com/colin-stasiuk/2009/05/01/sqlfool-sql-server-rap-contest/


http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-rap-i-am-the-dbcc-yeah-u-know-me


http://sqlchicken.blogspot.com/2009/04/sql-rap-by-dj-majik-poultry.html

SQL 2008 Data Collection Woes

I finally got around to playing around with the SQL 2008 Data Collector. I got the database set up, ran some tests, and everything seemed to be going great.  Well, there are a few jobs that get created when you set up the Data Collector.  Since I use this machine for presentations, I wanted to go ahead and clean up the jobs so I could have a clean Instance for my demos.  Easier said than done. Turns out that once you set up the Data Collector, the jobs are there for good.  I did some searching and found this Connect entry (Here). Hopefully the capability will be added to remove these jobs in a future release, but for now, just be aware that if you set up the Data Collector, you may be stuck with some unwanted jobs on your system.

Monday, May 18, 2009

Columbus GA SQL Server Users Group

I’ve got the Users Group up and running in Columbus GA (http://columbusga.sqlpass.org).  Our first meeting was a big success.  I was expecting about 12 people and over 40 people showed up. You can read about the first meeting on the SQL Pass website (Here).

Here is the info for the next meeting.  If you are in the area feel free to attend.  I have booked a bigger room this time that holds 70 people, since the other room was only supposed to hold 35.  Also, send me an email if you are interested in speaking or sponsoring on of the upcoming meetings.

Michael McClellan, a Lead Client Server Software Analyst at TSYS will be providing a real world example of creating an SSIS Package to load a DataMart using the AdventureWorks database.  He will provide a document containing step by step instructions to recreate the package along with the completed package file for you to download following the presentation.

May 27, From 4:00 - 7:00
At the Columbus Public Library.

4:00 P.M.-4:15 P.M.  Registration, networking
4:15 P.M.-4:30 P.M.  Announcements and business
4:30 P.M.-5:30 P.M.  Main Presentation
5:30 P.M.-6:00 P.M.  Question-and-answer period
6:00 P.M.-7:00 P.M.  Informal meetings, raffle drawings, etc.

We will giving away some shirts provided by Edgewood Solutions, a few books from Apress and Microsoft, and the complete set of DVDs covering every session from the 2008 PASS conference currently going for $595. The food for this months meeting will be provided courtesy of Confio Software.