Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Maintenance
Monday, April 20, 2009 7:54 AM

Listing the Central Management Servers Programmatically

I don't normally advocate hitting the system tables in any database with direct queries, preferring instead to use views or functions that the vendor provides. But so far I haven't been able to find the view or function that would return the list of servers
Posted by Buck Woody | 1 Comments
Monday, March 30, 2009 7:39 AM

Security Patches and the Conficker Worm

Well, the media has done their usual stellar job on computer technology subjects, so after this weekend you may have gotten some questions about the Conficker worm. Here's a few pointers to hand out to the relatives and associates: Microsoft released
Posted by Buck Woody | 1 Comments
Monday, February 02, 2009 9:50 AM

Check that database before you restore it...

I'm on my way to the city of Seattle this morning on the train and I ran across an issue with a database restore. I've been working with Service Broker and then put it out of my mind. I then backed up said database and restored it the same instance as
Posted by Buck Woody | 1 Comments
Tuesday, January 27, 2009 9:13 AM

Versioning the Database

If you write apps that hit a database that you own, then you probably want version control on the database itself. I always script out the initial database, and version that script. I also script the changes, and version those, and then script the entire
Posted by Buck Woody | 1 Comments
Tuesday, January 06, 2009 7:33 AM

Have You Backed Up Your Database Master Key?

If you have encrypted columns in a database or certificates used to create them, you need to make sure that you back up the Database Master Key as part of your maintenance, and then protect that backup file. Here's the short version of the command: BACKUP
Posted by Buck Woody | 1 Comments
Tuesday, December 16, 2008 7:48 AM

SQL Server 2005 Service Pack Three is Available

Load this after you thoroughly read the release notes - no, seriously, take a little time and do that. And as always, test, test, test! SP3 (Std, Dev, Ent) SP3 Express SP3 Express Advanced SP3 express Toolkit SQL 2005 Feature Pack Refresh December 2008
Posted by Buck Woody | 0 Comments
Friday, November 14, 2008 4:35 AM

The Great American Shakeout

Yesterday here in the U.S. the state of California had a "Shakeout", which was a practice for what to do in case of an earthquake. Although not everyone was involved, many government agencies were, and some companies also joined in. Japan also
Posted by Buck Woody | 1 Comments
Tuesday, September 23, 2008 6:38 AM

CU1 for SQL Server 2008 is now Available!

Many people wait for the “first” service pack of a product to work with it. Well, the CU#1 for SQL Server 2008 is now available. This is a new service model where we get out fixes far faster than a full Service Pack. You should read the article
Posted by Buck Woody | 1 Comments
Wednesday, July 30, 2008 9:05 AM

A Friendly Reminder to Check Those Backups

As I rode home on the bus yestereday a young lady sitting next to me noticed me typing on my laptop, and asked me a question about, of all things, backups! She worked in a medical facility, and wondered why their backups took longer by the end of the
Posted by Buck Woody | 1 Comments
Wednesday, July 02, 2008 9:22 AM

SQL Server 2008 Feature Pack RC0

The SQL Server 2008 Feature Pack for RC0 is now live - if you haven't downloaded this and played with it yet, shame on you! :) OK - just kidding - it's not like you don't have a day job. However, if you'll take a few moments and look this download over
Posted by Buck Woody | 3 Comments
Friday, May 30, 2008 3:12 PM

SQL Injection Attacks

You might have read recently that there have been ongoing SQL injection attacks against vulnerable web applications occurring over the last few months. These attacks have received recurring attention in the press as they pop up in various geographies
Posted by Buck Woody | 5 Comments
Thursday, April 17, 2008 6:42 AM

SQL Server Management Studio Standard Reports – The Full List

I've completed documenting all of the Standard Reports in SQL Server Management Studio. You can get to them from the tags, but I thought I would post a list of them all here with the links. I hope that you've been able to put some of this information
Posted by Buck Woody | 1 Comments
Monday, April 14, 2008 9:51 AM

SQL Server Management Studio Standard Reports – Top Jobs

I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the SQL Server Agent node. From the menu
Posted by Buck Woody | 1 Comments
Monday, March 31, 2008 8:40 AM

SQL Server Management Studio Standard Reports – Job Steps Execution History

I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the SQL Server Agent node. From the menu
Posted by Buck Woody | 0 Comments
Tuesday, March 25, 2008 9:19 AM

The Enterprise DBA

In a couple of other posts, I’ve covered some of the challenges and strategies for dealing with those challenges that DBAs face. I mentioned that in my experience, the answers depend on the “kind” of DBA you are. I've covered the “single-seat” DBA and
Posted by Buck Woody | 1 Comments
More Posts Next page »
 
Page view tracker