SQL Server with Mr. Denny:

December, 2008

December 31, 2008  11:00 AM

Happy New Year!!

Posted by: Denny Cherry

Have a happy New Year. Go spend the night with family.

That's what I'm doing tonight.


December 30, 2008  7:39 PM

New Years Resolutions for 2009

Posted by: Denny Cherry
Denis Gobo, Jason Massie, Tom LaRock

I've been tagged by Denis Gobo for a New Years Resolution post.  I've only got a couple of things to put, since I'm not a big fan of New Years resolutions. Upgrade our production...

December 30, 2008  9:07 AM

Managing Multiple Databases on a Single Server

Posted by: Denny Cherry
Consolidation, enterpriseitplanet.com

Back in November I wrote an article for Enterprise IT Planet entitled "Managing Multiple Databases on a Single Server" in which I...

December 29, 2008  11:00 AM

Order To Restore Database Backups In

Posted by: Denny Cherry
Backup & recovery, Restore Database, RESTORE LOG

I'm often asked (both online and offline) once you have all your database backups, in what order to they need to be restored in? I've actually asked this very question to senior level DBAs as an interview question before, and gotten some very interesting answers. When restoring your database...

December 25, 2008  11:00 AM

What should I do when my Windows Admin wants to put an anti-virus on the SQL Servers?

Posted by: Denny Cherry
Anti-Virus, SQL

My answer to that one is pretty easy.  Let him / her.  I'm a firm believer that every machine on the network should have anti-virus software installed.  Most anti-virus software is pretty lightweight (especially compared to the amount of hardware that your SQL Server has), and if a virus did get...

December 24, 2008  3:07 AM

VMware 3.5 won’t start any VMs if the Licensing server is down

Posted by: Denny Cherry
Licensing Server, Patching, Virtual Center, VMware

So tonight I finely got around to patching the fourth VMware ESX 3.0.2 server to 3.5 Update 3. The other 3 servers went just fine, quick reboot when done and back up and running in no time. So experience said that the fourth one would be no problem...

December 23, 2008  11:30 PM

sp_replwritetovarbin Heap Overflow Code Exploit Code In The Wild, Works By Using Our Good Friend SQL Injection

Posted by: Denny Cherry
Denis Gobo, Exploit

For those living under a rock there is a new SQL exploit in the wild. Dennis did an excellent write up of it already so I'll refer you do <. for his entry and save myself the time of writing what has already been...

December 22, 2008  11:00 AM

Development of SQL 2008 SSIS Packages Requires SSIS Service

Posted by: Denny Cherry
BIDS, SQL Server 2008, SSIS

Unlike in SQL 2005, when developing SSIS packages in SQL Server 2008 BIDS you must have the SSIS service installed on your workstation.  This is a change from SQL Server 2005 where you did not have to have the actual SSIS service installed on your workstation. It doesn't appear that you...

December 18, 2008  11:00 AM

Its time for a code freeze again

Posted by: Denny Cherry

Its the holidays again, and that means its time for a code freeze. Code freeze's are handy for a few reasons.

  1. People like to take vacations this time of year for some reasons. With a code freeze in place everyone can spend the holidays with family rather than with the...

December 15, 2008  8:03 PM

SQLServerPedia.com Webcast Archived

Posted by: Denny Cherry
Quest Software, SQLServerPedia.com, Webcast

I've been informed that the webcast I did last week with some of the other editors for SQLServerPedia.com has been archived for offline...

Bookmark and Share     0 Comments     RSS Feed     Email a friend

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: