Welcome to the first edition of the Coeo quarterly news or 'novus' to Latin speakers everywhere.
Our aim is to keep Coeo customers up-to-date with the latest thoughts, articles and interesting titbits from the world of SQL Server, bringing them together with our insight and knowledge into one publication.
This issue is focused on the second release of SQL Server 2008 but we would welcome your input and suggestions for future issues. One way of feeding back is to respond to our poll, which this time asks you about your production SQL Server environment. The poll results and comments will help us shape future articles.
Thank you for reading, we hope you enjoy it.
The Coeo Team
News in brief
Coeo are leading authors on SQL Server. Christian Bolton and Justin Langford, directors and co-founders of Coeo, are both ex-Microsoft engineers with exceptional qualifications and experience in the field. See reader reviews and buy their books from Amazon.
Coeo Announce Partnership with Fusion-IO
For some of our customers, milliseconds matter. That's why we recommend Fusion IO NAND server cards to customers with mission critical systems that demand lightning fast performance.
Should we wait for service pack 1 before deploying SQL Server 2008 R2? When a new version of any product is released, there is naturally some scepticism around the reliability and robustness of the product. This caution may be well founded - problems with early releases of new products aren't limited to software products; concerns around the electronic braking system on the Prius were estimated to cost Toyota $2bn in repairs and lost sales, and the recent Apple iPhone 4 launched to negative publicity - suffering low signal strength and dropped calls when held in certain positions.
SQL Server 2008 R2 was referred to as a "BI refresh" or "SQL10.5" (SQL Server 2008 is SQL10) prior to its release which gives you a good indicator of how Microsoft intended to position the product. However, it's not quite as black and white as only considering the BI features when choosing which version of the SQL Server to use.
SQL Bits is a conference for the SQL Server community organised by the SQL Server community - it's not a Microsoft event. Registration is now open for the October session taking place at York University. Coeo are speaking at the event and have a stand in the exhibition area with a prize draw to win a Fusion-IO Card. Feel free to stop by for a chat!
Q: What is the best way to run database consistency checks(DBCC CHECKDB) on a Very Large Database(VLDB) greater than 500GB in size?
A: Running database consistency checks on VLDBS's is a challenge and can overshoot the maintenance period due to the time it takes to complete DBCC CHECKDB. The trick lies in identifying what the business requirements are with regards to database consistency and the likely effect a database corruption will have on the business.
