Olympia Area SQL Server Users Group

Serving the Olympia Community with exposure to SQL Server Technologies

 

Home About OASSUG Chair's Corner Meeting Location Resources Sponsors Forum
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.

Download Presentation


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.

Download Presentation

 


March 19th, 2008

SQL Server 2008 a Value Rich Version

by Greg Larsen, MCTS

Lead Database Administrator, Washington State Dept of Health

Download Presentation

 


February 20, 2008

Visual Studio 2005 Database Professional Edition

by Rick Villamil

DSHS/Children’s Administration FamLink project

Download solution