Knowledge is the power and you will gain by sharing it;
SQL Server MVP and Subject Matter Expert with consulting & technical expertise for Databases, Business Intelligence & Architecture solutions with over 19+ years of experience. My work experience inclduesa wide range of industries, including the stock exchange, insurance, tele-communications, financial, retail, and manufacturing sectors, among others.
A regular Speaker and SME volunteer at major technology conferences such as Microsoft Tech-Ed (Europe, India and North America), SQL PASS (Europe and North America), SQL Bits – UK and manages Scottish Area SQL Server user group based in Scotland. A moderator in majority of web based SQL Server forums (Microsoft Technet & www.sql-server-performance.com), writer, contributing editor & blogs at www.sqlserver-qa.net, www.sql-server-performance.com and www.beyondrelational.com websites.
Author of Microsoft SQL Server 2008 R2 Administration cookbook (released May 2011) - www.packtpub.com
Co-Author of MVP Deep Dives SQL Server Volume II from Manning Publications.
SQL Server upgrade is no easy job, as DBA must go through upgrade methodology with options and considerations. Take help of freely available Upgrade tools from Microsoft and plan your database upgrade with a coverage of
Pre-upgrade tasks, during upgrade and Post upgrade tasks.
Storage of large volumes of unstructured data - build a strategy by following best practices.
Achieving application uptime of 99.99% is not an impossible task, can be accomplished if you apply right procedures at right time!
A typical day of DBA and new features of SQL Server 2008 can help - save a minute.
Database or SQL Server instance upgrade will need thorough planning and implementaiton.