Blog Archives
Sunday Funday
Today’s installment of Sunday Funday brings you a great little Tic-Tac-Toe game with T-SQL exercise by Adam Haines found on SQL Server Central. Enjoy!
Sunday Funday
Today’s installment of Sunday Funday brings you a great little drawing with T-SQL exercise by Roji P. Thomas. Enjoy!
Sunday Funday
Today’s installment of Sunday Funday is brought to you by the Code Project introducing the spatial datatypes available in SQL Server 2008: SQL Battleship 2008. Enjoy!
Sunday Funday Has Returned
Sunday Funday has returned! We took a hiatus from these series of posts because quite frankly it is hard to find people having fun with SQL Server these days. Let’s have some fun!
Today I bring you a maze game written in SQL, enjoy Lionel Clarke : A Sql Game.
Sunday Funday
Today has not been much fun for me as I’ve been working on a deployment all weekend for our enterprise content management system. This deployment was necessary for two reasons: we have a deadline and I will be busy for the rest of the weekends in May.
However I did miss sending my girls off to their high school prom, but it was unavoidable and it is the sacrifice I had to make. Instead this weekend I am living vicariously through my #SQLFamily and my physical family through Facebook and Twitter.
I hope you are enjoying a wonderful weekend. If not go out and have some fun, it’s not too late to spend some time with those you love. Enjoy!
PASS Summit 2012, Join Me!
With only a week before SQL Rally in Dallas, there has been quite a bit of excitement and commentary in the twitterverse and blogosphere. However, I cannot attend due to other commitments. With all the excitement in the air, I cannot contain my excitement for the PASS Summit in November. I have never been able to attend the Summit in the past and I am not 100% sure that I will be able to attend this year, but the planets are lining up and there is a glimmer of hope for my first Summit conference. Sitting by last year and watching all of the action from the sidelines just about drove me nuts. Here it is six months away and I have already scoped out the hotels in the area, looked around via Google’s man on the street, and my wife is even thinking about tagging along (I think just so she can see those flying fish at the market, no wait that is just me).
I have been to Seattle once before in my youth for the National Mu Alpha Theta math competition. It was there that my skills in advanced math were not as worldly as I thought, even though I placed (no I can’t remember but I think third place) in the state of Florida. But, many schools from Florida and Alabama dominated the competition awards, interesting as I am sure most of the world does not think of Alabama and Florida as math powerhouses but in the late 80s when those respective states were battling neck and neck for last place in education those two states were advanced math geniuses, but I digress.
I know I won’t be able to take another tour of the King Dome and I wonder what else has changed since grunge and coffee took over that beautiful and friendly city some 25 years ago. I wonder if I should ask someone at the hotel if I could walk to Mt. Ranier and have them laugh at me just for old times sake. I am also excited about riding the monorail on the awesome two block journey. Do they still have the theme park at the needle? Maybe I can cross another item off my bucket list: touring Forks and seeing all of the Twilight scenery in person (really just kidding on that one LOL).
Don’t get me wrong, I want to see SQLChicken do his gorilla impression and participate in SQLKaraoke. I want to soak up all that is SQLAwesomeness and bask in the MCM and MVP glory that is PASS Summit 2012. Won’t you join me?
Interview with the Resource Database
Recently I had a chance to catch up with the Resource Database, which is rare given his reclusive ways as of late. Today, I bring you the answers you demand.
Me: So mssqlsystemresource, can I call you Resource Database?
RD: Sure, just keep in mind I won’t return your queries.
Me: So Resource Database, what have you been doing with yourself lately? Where have you been? What have you been up to?
RD: Oh, just hanging out behind the scenes. I don’t like the limelight, I leave that to my friend, TempDB. Most administrators don’t even know I exist and I like it that way.
Me: Shouldn’t administrators know about you?
RD: NOOOOO! Next thing you know they will want to query me for data, try to change my settings, and next thing you know they will corrupt me! I’m not having that. This is all off the record, right?
Me: Ah, sure. So what secrets are you hiding?
RD: I mostly work by keeping all the secrets of the system objects, you know sys.objects, I keep all of that stored and sealed up.
Me: Wait a minute? We see those in the sys schema of every database. What gives?
RD: Logically you are correct but physically you are incorrect. They are mine. How else do you think you can upgrade SQL Server? By letting everyone mess with those objects? I don’t think so! This interview is over! I’m outta here!
Me: Well there you have it folks. The mysterious Resource Database remains mysterious. Enjoy!
Professing My Love For All Things Awesome!
With today being my anniversary to my lovely bride, Elizabeth aka @SumterGatorGirl aka the Princess Bride, I found it prophetic to wax lyrical about all the things I love. How does a SQL geek, go about doing such a thing? With a table of course!
Thought you should’ve been higher on the list? I can be bought, especially with SWAG! Enjoy!
Change of Plans
After long consideration, I have decided to change my career path. After several meetings with out Oracle team, I have decided that their product is much more robust and the career possibilities are endless. It also appears that their product is much easier to use and requires very little work so that I may sit in my cubicle playing angry birds or plumber crack all day long. This is the career path for me. Enjoy!
SQL Server, Oh How I Love Thee!
Oh SQL Server How I Love Thee, Let Me Count The Ways!
Over the years I’ve had commitment issues with SQL Server as I was a Progress RDBMS Consultant as well as being a developer and a systems administrator. In the past, SQL Server was just one of my many duties and essentially I was an accidental DBA. However, I did consider myself a Progress DBA for the five years that I specialized in Progress 4GL. But during that time, I still administered SQL Server 6.5 and 7 databases, I just didn’t feel that it would be where my career path would go. I fancied myself a database developer who could also administer servers and perform other duties as assigned. That was my life calling, or so I thought.
Over the last couple of years, I’ve grown to love SQL Server more and more so much so that during the last year I proposed to SQL Server committing myself totally. Obviously, I still have numerous other administrative duties with my windows servers, SharePoint servers, OpenText ECM servers and VMWare infrastructure, however I have dedicated myself to the SQL Server community and my career to being the best SQL Server DBA that I can be. Are you willing to commit to SQL Server?
Enjoy!
SQL Swampland 