SQL Server with Mr. Denny:

February, 2010


February 25, 2010  11:00 AM

Made2Mentor’s MacGyver Moment Meme



Posted by: Denny Cherry
Brent Ozar, EarthLink, Tom LaRock

David Stein (@Made2Mentor) started a neat new post My McGuyver Moment and tagged

February 22, 2010  10:14 PM

I must have had a great time at the MVP summit, I’m sick as hell



Posted by: Denny Cherry
MVP Summit, SQL Karaoke, SQL PASS

I'm not that kind of sick, any hangover would be long gone by now.  But the lack of sleep has caught up with me.  I've got exactly 5 days to get over it before my next trip, which will hopefully be much more tame. So last week was the MVP Summit (


February 22, 2010  11:00 AM

Heading to SQL Saturday 33 in Charlotte, NC



Posted by: Denny Cherry
In Person Events

In about a week I've got the pleasure of attending my first SQL Saturday.  Of course I've submitted some sessions to present at the event, because we'll I'm a sucker for a speaking event where I can meet SQL Server Professionals, and catch...


February 18, 2010  11:00 AM

Why I don’t buy big name laptops any more



Posted by: Denny Cherry
Laptop Cop

There are tons laptops out there which you can buy.  HP and Dell are the biggest sellers in laptops these days.  However for the last couple of laptops that I've purchased I've stayed away from the major brands. My last laptop was an


February 15, 2010  11:00 AM

Dealing with a digital “chicken or the egg” situation.



Posted by: Denny Cherry
Cisco VPN, Windows 7

Recently I had the opportunity to upgrade my computer desktop from 2 Gigs of RAM to 8 Gigs of RAM.  This required that I reinstall Windows 7 to replace by 32bit OS with a 64bit OS. This presented me with a problem as I work from home full time and I have to VPN in.  You see we use a Cisco VPN...


February 11, 2010  11:00 AM

Do what you love, love what you do, or let someone who does, do.



Posted by: Denny Cherry
Professional Development

Coming up soon the next group of college students will be graduating from school which means the annual "how do I get a job which pays a lot of money" job posting will being showing up shortly. The best way to get a good paying job is to pick a field which you like working in.  If you can be...


February 8, 2010  11:00 AM

Using XMLNAMESPACES within a function



Posted by: Denny Cherry
Functions, T/SQL, XML

Recently one of my developers asked me to begin returning data from a function as XML instead of a comma separated list.  My thoughts on this was awesome, another cursor getting removed from the system.  I'll write a quick FOR XML AUTO, ROOT('root') at the bottom of the SELECT statement being...


February 4, 2010  11:00 AM

It happens to be my birthday!



Posted by: Denny Cherry
Family

Today happens to be my Birthday and a regular blog posting day.  What are the odds... Actually about 1 in 7 or so, but anyway go have some cake for me. Denny


February 2, 2010  11:00 AM

Taking backups is good, but testing them is better.



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, Restore Database, Testing

I bet that if asked when the last time the database backup was taken and if it succeeded you would know off of the top of your head when that was.  But if I asked you when the last time your database was restored successfully would you know?


February 1, 2010  6:59 PM

January 2010 #SoCalCode links are fixed.



Posted by: Denny Cherry

If you tried to download the slide decks from last weekends SoCal Code Camp this morning the links where broken.  I've fixed (and tested) all three links and they are all working...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: