Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Planning
Tuesday, October 27, 2009 7:14 AM

Disaster Response and the Physical Plant

Near our home is a Dam about to break. It was built long ago, and even though millions were taxed and spent for it, little to none of that money ever got to the actual shoring up and maintaining the dam  over time (don’t get me started). Anyway,
Posted by Buck Woody | 0 Comments
Thursday, August 27, 2009 7:28 AM

Test your Restores, or, a Cautionary Tale

The other day I rebuilt a test system, and as a result I wanted to restore a few of my test databases. I've done a lot of customization in those, fuzzed some of the private data and so on, that they've moved dangerously close to a "production" database,
Posted by Buck Woody | 0 Comments
Tuesday, July 28, 2009 9:11 AM

Should I stay or Should I Go?

I'm writing this post on a bus headed towards the Seattle Convention Center, where the technical folks in the field meet once a year to hear from the product teams about all the new features coming in the future. I used to present at this conference (and
Posted by Buck Woody | 0 Comments
Monday, July 06, 2009 8:00 AM

Consolidation Strategies: Profiling Your Systems

Many shops are considering consolidating their SQL Server Instances onto fewer boxes, as I've blogged about before. There are lots of ways to think about consolidation, from placing more databases on one Instance (Database Stacking), putting multiple
Posted by Buck Woody | 0 Comments
Monday, June 29, 2009 8:08 AM

Grid Painting and Database Projects

I'm not very good at drawing. My drawings of people and objects with depth usually looks like what your 5th grader does, but not the talented 5th grader. But I found a trick that helps me draw not only depth, but complex things as well. It involves taking
Posted by Buck Woody | 0 Comments
Wednesday, February 04, 2009 7:29 AM

Server Consolidation Done Right

Consolidating your servers is all the rage, especially since you can save money by doing it. You can save not only on the hardware, but the licenses. To do that properly, you need a strategy. You start by detailing what you have, and then lay out the
Posted by Buck Woody | 1 Comments
Wednesday, January 28, 2009 7:54 AM

Data Retention Strategies and Server Consolidation

I deal with a lot of folks that are going through server consolidation exercises. These days everyone immediately thinks of Virtualization - which will consolidate servers onto a single instance. But in many cases it's actually smarter to evaluate the
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
Wednesday, January 07, 2009 7:36 AM

Are You Archiving Your Data?

Computer technology has been a fixture of business now for several decades - but I'm not sure it's a "mature" industry yet. Sure, we have a few standards, and some dominant vendors and a strong workforce - all earmarks of a mature industry -
Posted by Buck Woody | 1 Comments
Monday, January 05, 2009 7:40 AM

Another Reason to Use A Special Service Account

When I'm asked what the least-used feature of SQL Server is, I often have to reply that it is "good security". Many installations take all the default settings, and most use programmatic security rather than the features built in to SQL Server.
Posted by Buck Woody | 1 Comments
Monday, December 15, 2008 6:51 AM

SQL Server 2005 SP2 Gains CEC EAL4+

No, that's not a mis-print - it's SQL Server 2005 SP2 I'm talking about. This criteria is increadibly exacting, and takes a huge investment in time and money from a company (like us) to reach. If you're in an installation that requires this type of certification,
Posted by Buck Woody | 2 Comments
Friday, August 08, 2008 6:38 AM

Quick Ramp-Up on SQL Server 2008 for the DBA

Need to find out what's new in SQL Server 2008 for the DBA, even before you install it? We have a free on-line lab you can register for that will get you started quickly: http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032358030&EventCategory=3&culture=en-US&CountryCode=U
Posted by Buck Woody | 1 Comments
Tuesday, May 06, 2008 10:11 AM

Why you should upgrade to SQL Server 2008

One of the readers recently asked about the blog post I made regarding the performance of replication being so improved in SQL Server 2008. We don’t have a formal study posted on that particular result yet, but we do have others that talk about speed
Posted by Buck Woody | 1 Comments
Tuesday, April 08, 2008 9:01 AM

Support for SQL Server 2000 is ending - make your plans!

We're at the end of "Mainstream" support for SQL Server 2000, which is April 8th, 2008. If you're still using this version in your enterprise, you need to plan to move off of that version platform starting now. Many folks are planning to "jump" from SQL
Posted by Buck Woody | 1 Comments
 
Page view tracker