SQL Server with Mr. Denny


January 2, 2009  7:12 AM

Standalone SQL Agent Project Kickoff Announement

Denny Cherry Denny Cherry Profile: Denny Cherry

If you have used SQL Server 2005 Express Edition (or SQL Server 2008 Express Edition) then you know that the SQL Agent has been removed from the product.  I have from time to time found this to be annoying as I want to do things like backup my database on a regular basis, or do other basic things.  The normal solution is to either use another SQL Server to do the scheduling, or use the Windows Task Scheduler to do the scheduling. Continued »

December 31, 2008  11:00 AM

Happy New Year!!

Denny Cherry Denny Cherry Profile: Denny Cherry

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

That’s what I’m doing tonight.

Denny


December 30, 2008  7:39 PM

New Years Resolutions for 2009

Denny Cherry Denny Cherry Profile: Denny Cherry

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 systems to SQL Server 2008
I’ve been speaking about SQL Server 2008 since before it was released.  It would probably be nice if I actually upgraded our production systems at the office.  It’s just a matter of time to actually get it done.

Get started writing a SQL book of my own
In 2008 I wrote a few chapters for a couple of books for other people.  In 2009 I’ll attempt to write my own.

I’ll tag Jason Massie and Tom Larock.

Denny


December 30, 2008  9:07 AM

Managing Multiple Databases on a Single Server

Denny Cherry Denny Cherry Profile: Denny Cherry

Back in November I wrote an article for Enterprise IT Planet entitled “Managing Multiple Databases on a Single Server” in which I go over the potential problems you can face when consolidating instances of SQL Server.

Denny


December 29, 2008  11:00 AM

Order To Restore Database Backups In

Denny Cherry Denny Cherry Profile: Denny Cherry

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 you start with your full backup, then restore your diffential backup (if you have taken one) then restore all the transaction log backups begining with the backup taken after the full (or differential) and going until the last transaction log backup available (or until you reach the point in time you want to stop the restore at).

Denny


December 25, 2008  11:00 AM

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

Denny Cherry Denny Cherry Profile: Denny Cherry

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 onto the SQL Server the results could be awful.

Continued »


December 24, 2008  3:07 AM

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

Denny Cherry Denny Cherry Profile: Denny Cherry

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…

Continued »


December 23, 2008  11:30 PM

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

Denny Cherry Denny Cherry Profile: Denny Cherry

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 written.

Denny


December 22, 2008  11:00 AM

Development of SQL 2008 SSIS Packages Requires SSIS Service

Denny Cherry Denny Cherry Profile: Denny Cherry

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 actually need to have the service running.  I have stopped the SSIS service on my workstation and I am still able to run my SQL 2008 SSIS packages, however I would recommend setting it to manual rather then disabled just in case BIDS needs it running for some reason.

If you try and edit an existing package without the SSIS service installed an error message will be displayed saying that the service needs to be installed.

Denny


December 18, 2008  11:00 AM

Its time for a code freeze again

Denny Cherry Denny Cherry Profile: 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 servers.
  2. With everyone taking time off, if new code has a problem finding the people who actually wrote the code may be an issue.
  3. It boosts staff moral to not have to worry about pushing new features into production on a skeleton staff.
  4. It keeps the families of the staff happy to have them home around this time of year.

While it doesn’t help make the company and money to freeze code, it simply makes everyone happy, and isn’t that what this time of year is really all about.

Denny


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: