![]() |
Olympia Area SQL Server Users Group Serving the Olympia Community with exposure to SQL Server Technologies
|
| Resources |
![]() |
June 19th, 2008
How to Conduct a SQL Server Performance Audit "Surviving Corruption - From Detection to Resolution"
by Paul Randal and Kimberly Tripp of SQLSkills.com
How can you tell whether your data is corrupt? If you have corruption, how do you work out what’s wrong with the database? How do you ensure you have a valid backup? If you don’t have a valid backup, how and what do you repair? If you do have a backup, how do you work out whether you should restore or repair? And at what granularity? How do you go about determining what went wrong in the first place? It’s all about limiting downtime and data-loss when a corruption occurs - from knowing the tools to understanding the choices to planning a successful strategy. Some of the features discussed: torn-page detection and page checksums, IO read-retry, backup checksums, consistency checks (DBCC CHECKDB and related commands), and database repairs. Facing database corruption is almost inevitable in every DBAs career - make sure you're prepared when it happens to you.
Idera SQL admin toolset
The product is currently in public beta with 13 of the 24 tools available. Idera is looking for your feedback! They have had thousands of downloads in the past few weeks and have received an overwhelming number of compliments and requests, but they'd like to get more!
Here is a summary of the what’s in Idera's new SQL admin toolset:
View Idera's PowerPoint slides on this new product. Click here
Download a free copy of the SQL admin toolset, give Idera your feedback and you'll be given the chance to purchase the final product with all 24 tools at $195. That's $300 off the list price.
To learn more or to download a free copy of the Idera SQL admin toolset go to: www.idera.com/toolset
April 8th, 2008
How to Conduct a SQL Server Performance Audit
by Brad McGehee, MCSE+I, MCSD
Director of DBA Education, RedGate Software Hawaii Div.
March 19th, 2008
SQL Server 2008 a Value Rich Version
by Greg Larsen, MCTS
Lead Database Administrator, Washington State Dept of Health
February 20, 2008
Visual Studio 2005 Database Professional Edition
by Rick Villamil
DSHS/Children’s Administration FamLink project