Featured Article(s)
SQL Server 2005 Temporary Tables Optimization Tips
Here are some helpful tips to optimize using SQL Server 2005 temporary tables.
SQL Server Consolidation – Have You Completed a Project or Two?
More and more I’m getting requests from people about best experiences/practices for SQL Server consolidation. Many are consolidating because they have a better understanding of the server requirements, application needs and of course because SQL Server and the hardware available to run it have advanced and present very compelling approaches to running your environment.
I thought I’d put this out for discussion – what types of things have you done that have worked, or haven’t worked, when you work through consolidation projects?
In my own work, we’ve tended toward combining consolidation projects with upgrade projects. I have to really fight (myself) to keep from doing "upgrades" to the logic and such as well – it’s enough to do the consolidation and/or update to the new release of SQL Server, let alone having to recode to use new features. We’ve learned that, whenever possible, breaking apart the consolidation/version update and programming update projects usually results in better successes.
This isn’t to say that you may not be forced to do the upgrade to your applications during this – but if you can break apart the processes, rather than doing one big migration, you’ll walk away with fewer gray hairs.
What’s your approach to consolidation? Any horror stories? Great successes? Inquiring minds, as they say, want to know.
Featured White Paper(s)
Understanding Business Intelligence: ETL Best Practices
This paper is about building powerful data marts that require minimal administration and are simple to change. This may seem … (read more)
Improving Data Protection and Storage Reliability for Critical Databases
Discover how a healthcare management company met the challenge of improving data protection and storage reliability for criti… (read more)