This week on SQLCrunch ... Using Emergency Mode to access a suspect/recovery pending database A great post from Paul that walks through the process of simulating a corrupt transaction log, and the available options for accessing the database ... Source : Paul Randal - SQLSkills.com - Blog Post
Using the Management Studio T-SQL Debugger
In this screencast, SQL Server MVP Paul Nielsen walks us through the new T-SQL Management Studio debugger ... Source : Paul Nielsen - screencast.com
What is (and what causes) corruption?
Depending on who you talk to, "Corruption" can mean anything from orphaned records due to an application bug through to a trashed hard drive. In this post, Paul categorizes corruptions, and dispels a few myths along the way ... Source : Paul Randal - SQLSkills.com - Blog Post
Windows Groups; Management Challenges for SQL Server Logins
The Windows Authentication mode allows logins to be defined for both Windows users and groups. As Laurentiu points out in this blog post, whilst adding Windows Groups can simplify management, they come with some additional considerations, particularly around object ownership and default databases/schemas ... Source : Laurentiu Cristofor - MSDN.com - Blog Post
Windows Server 2008 Failover Clustering
A great overview of the clustering enhancements in Windows Server 2008 including the new Management Interface, Quorum Models, Storage Interaction and Migration features ... Source : TechNet Magazine - Article
Written by Brad McGehee, this 283 page pdf covers just about everything there is to know about Profiler. Includes coverage of trace templates, deadlocks, blocks, slow running queries, statistics operations, auditing & perfmon integration. Thanks to Tom Gniadek for the heads up on the link ... Source : Brad McGehee - Red-Gate.com
Physical Database Storage Design
One of the classics. This downloadable whitepaper covers the all important process of designing storage for SQL Server. As well as an overview of the differences in OLTP/OLAP workloads, it includes details of sizing a system for performance and throughput, RAID levels and the different types of storage systems available today ... Source : Microsoft.com - Whitepaper
Using the new Xevent model, the system_health session can be used to look back on the detail of a variety of system problems including sev 20+ errors, non yielding problems, deadlocks and blocking issues ... Source : CSS SQL Server Engineers - Blog Post
A fantastic powerpoint presentation from Christian that covers all of the important memory configuration tasks including the limits of 32 bit systems, the memtoleave area, considerations for 64 bit systems, AWE on 32/64 bit systems and setting mix/max memory values ... Source : Christian Bolton - Coeo.com - pdf presentation
There are many articles that list partition alignment as an important configuration step, but few that go to this level of detail explaining why this is important. In this post, Jimmy also links to a downloadable powerpoint deck that walks through the process and supporting information. Great stuff. ... Source : Jimmy May - msdn.com - Blog Post
Sizing Storage for Performance Requirements
A good article that describes a method to calculate the number of spindles/disks in a storage system required to meet a given workload ... Source : SQLJunkies.com - Article
Cheers
Subscribe to this blog!
Comments