SQLLawman

I received a e-mail a few days ago from one of our developers informing me that he is unable to create views on one of our SQL Server 2005 databases.  He also told me he had another developer try and she also could not create views.  Interesting, I thought, so out to my favorite co-worker [...]

I enjoy testing things on my computer at home.  I have two machines at my complete disposal to test and play around.  First is my Toshiba Laptop, dual core processor, 4 GB Ram, 2×200 GB hard drives, Windows Vista HOme Premium 64 bit, not provided by my employer.  Number 2 is an old desktop.  Single [...]

After being tagged to blog my Professional New Years Resolutions late last year, I made getting certified as my first one.  Today I bit the bullet and took the 70-431 test.  I took about an hour to complete the 35 trivia (multiple choice) and 12 simulations.  I was a little shocked when the screen displayed [...]

After seeing a few of the other Wordles beginning to pop up on blogs, I had to add my own.  I think it will be fun to do this again in a few months to see how the words change.  So enjoy.

I had plopped onto my recliner over the weekend and looked around at my family.  I noticed that there seemed to be more of us than I had remembered.  Since the summer/fall ended we had begun become sedentary.  A family that swam, biked, and ran all summer and fall, were turning into couch blobs.  I [...]

As I am beginning our journey into SQL 2008, I am taking this time to go through all our scripts and try to resolve some of the issues I get alerted on that are due to how we do things.  One of the things we do is programatically list all the databases, determine which are [...]