Strategy and planning

MUST READ Optimize disk configuration in SQL Server TIP - Proper disk configuration can result in a lifetime of high performance for SQL Server databases. Go beyond storage capacity requirements and consider drive performance. Designing SQL Server non-clustered indexes for query optimization TIP - Optimize SQL Server non-clustered indexes and queries by considering index fields, compound indexes and SQL Server statistics' impact on non-clustered indexes. SQL Server consolidation: Why, when and how to consolidate SQL Servers E-BOOK - This e-book will introduce you to the worlds of server and storage consolidation, helping you ease into the process and work your way toward an efficient SQL Server environment. SQL Server 2000 to 2005 upgrade checklist CHECKLIST - Upgrading from SQL Server 2000 to 2005 involves key planning considerations. Before you upgrade to SQL Server 2005, review this checklist. Top 10 SQL Server indexing tips to improve performance TOP 10 TIPS - We've tallied our most popular tips on the topic of indexes. Weed out valueless indexes, design high performing indexes and query your existing SQL Server indexes.

EXPERT TECHNICAL ADVICE: 1 - 3 of 48

STRATEGY AND PLANNING EXPERTS
			Mark Kromer Technical Product Manager ASK A QUESTION		Eric Brown Senior Consultant ASK A QUESTION

	SQL Server database design disasters: How it all starts Submitted By: SearchSQLServer.com | 24 Sep 2008 TIP - SQL Server database design and high performance are tied to filling the role of both production DBA and development DBA for SQL Server.

	Can you shrink your SQL Server database to death? Submitted By: SearchSQLServer.com | 23 Sep 2008 TIP - To increase SQL Server disk space, 'shrink the database' task is used. But the tests in this tip using autogrowth prove that 'shrink database' poorly impacts SQL performance.

	Tuning SQL Server performance via memory and CPU processing Submitted By: SearchSQLServer.com | 09 Sep 2008 TIP - In this tip, learn how memory allocation and CPU processing impact SQL Server performance and get tips for tuning these areas.

	VIEW ALL EXPERT TECHNICAL ADVICE ON STRATEGY AND PLANNING

REFERENCE & LEARNING: 1 - 3 of 28

	SQL Server PerfMon counters for access methods and buffer manager Kevin Kline, SQL Server MVP | 28 Apr 2008 SCREENCAST - SQL Server MVP Kevin Kline focuses on PerfMon counters for SQL Server and shares best practices for tracking IO intensive access methods and buffer manager activity.

	Monitor SQL Server disk I/O with PerfMon counters Kevin Kline | 02 Apr 2008 SCREENCAST - In part 3 the SQL Server PerfMon counters screencast series, get the optimal values when monitoring performance counters for physical disk reads and writes and disk queue length.

	SQL Server PerfMon counters for tracking Windows memory Kevin Kline | 05 Mar 2008 SCREENCAST - Learn how to use SQL Server PerfMon counters to track Windows memory. SQL Server MVP Kevin Kline explains the maximum numbers to watch for when using PerfMon memory counters.

	VIEW ALL REFERENCE & LEARNING ON STRATEGY AND PLANNING

NEWS: 1 - 3 of 12

	Best practices for improved database management SearchDataManagement.com | 14 Jul 2006 ARTICLE - The best practices for improved database management include a combination of the right people, processes and products.

	Letters to the editor: Educating database end users SearchSQLServer.com | 11 Jan 2006 LETTERS TO THE EDITOR - As a SQL Server DBA or developer, what knowledge would you pass along to end users to help ease your burdens in the new year? Read what your peers have to say.

	BI better bought than built, study says SearchDataManagement.com | 05 Jan 2006 ARTICLE - A study finds that many companies prefer to buy business intelligence applications rather than build them. Have IT and business users finally found one thing they agree on?

	VIEW ALL NEWS ON STRATEGY AND PLANNING

WEBCASTS: 1 - 1 of 1

Avoiding SQL Server Sprawl with the PolyServe Database Utility - Vendor Webcast VIEW WEBCAST PREMIERED:   26 SEP 2006, 09:00 EDT (13:00, GMT) SUMMARY:   As your IT infrastructure grows, managing uncoordinated SQL Servers quickly becomes impossible. Attend this Webcast to learn about the problems this type of setup inevitably causes and how you can mitigate this risk by implementing various clustering and consolidation technologies.

	VIEW ALL WEBCASTS ON STRATEGY AND PLANNING

BEST WEB LINKS: 1 - 2 of 2

	The Detroit SQL Server User Group The Detroit SQL Server User Group | 05 Apr 2006 BEST WEB LINK - The Detroit Area SQL Server Special Interest Group consists of professionals interested in getting the most out of SQL Server and related technologies. Meetings are held on the second Thursday of every month at 6:00 PM at the ...

	SQL Server World Wide User Group Help Center http://www.sswug.org/ | 22 Jul 2005 BEST WEB LINK - This Web site allows subscribers access to educational webcasts, discussion forums, database news, script manager and e-mail discussion lists

	VIEW ALL BEST WEB LINKS ON STRATEGY AND PLANNING

	SEE ALSO - Topics Related to Strategy and planning:  SQL Server ROI and TCO, SQL Server career advice, SQL Server competitors, SQL Server licensing