November 1, 2012 6:17 PM
Posted by: Denny Cherry
AlwaysOn,
Data Loss,
DataCenter,
Distaster Recovery,
Recovery,
SQL ServerWhile I applaud the hard work and ingenuity of the sysadmins who works through the days after hurricane Sandy to keep the generators running, one thing kept coming to my mind. Why...
September 5, 2012 2:00 PM
Posted by: Denny Cherry
Database,
DataCenter,
Development,
Social Commentary,
SQL ServerBack on August 28th another ITKE poster wrote a blog post titled "The elephant not in the room" in which they talk about how if you want to work in IT in the future you better plan on working at one of...
December 27, 2011 2:00 PM
Posted by: Denny Cherry
Back To Basics,
Backup & recovery,
Recovery,
SQL ServerOne of the questions which I see pop up from time to time (especially when I used to work for a VAR that wrote software for small businesses) is why doesn't SQL Server do the maintenance automatically? Things like checking for corruption (DBCC CHECKDB), index defragmentation, backups, etc.
The...
October 20, 2011 2:00 PM
Posted by: Denny Cherry
Recovery,
vCenter,
VMwareApparently one of the things that VMware's support department will often recommend that people do is to change the recovery mode of the vCenter database within SQL Server from FULL to SIMPLE recovery because it will magically make a lot of disk problems go away. While this is true, your disk...
December 10, 2009 11:00 AM
Posted by: Denny Cherry
Recovery,
SQLAll to often I see people online saying that they detach a database then delete the log file to shrink it. This is a very dangerous operation which can leave you with a corrupt database that you can't do anything with.
October 26, 2009 11:00 AM
Posted by: Denny Cherry
RAM,
Server Hardware,
SQLSo you are going along your normal day, and your boss comes up to you and tells you "We've got a few thousand bucks left in this years budget, what would you like to upgrade?" Assuming that new 26" monitors for your workstation are out of the question, the boss is probably talking about a server...
July 23, 2009 11:00 AM
Posted by: Denny Cherry
Server Hardware,
System DesignI am so sick and tired of people posting questions on various forums along the lines of "We just bought a Some brand and model of server and it has n hard drives in it. How should I setup the database on these drives?"
August 25, 2008 11:00 AM
Posted by: Denny Cherry
Backup & recovery,
KILL,
Log Shipping,
Recovery,
RESTORE LOG,
SQL Server 2005,
xp_delete_file,
xp_dirtreeSo you've been tasked with setting up a quick and dirty reporting server. The goal is to restore the log files from the production server to the reporting server nightly.
The backups are simple, use the SQL Maintenance plan to backup the logs, and then copy them to the remote machine. But...