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 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 37

STRATEGY AND PLANNING EXPERTS
			Eric Brown Senior Consultant ASK A QUESTION

	Tips for moving from SQL Server local disk storage to SANs Submitted By: SearchSQLServer.com | 14 May 2008 TIP - Move SQL Server storage to storage area networks (SANs) with network redundancy and storage multipathing tips. Learn about iSCSI databases and SQL failover.

	Sarbanes-Oxley compliance checklist: IT security and SQL audits Submitted By: SearchSQLServer.com | 07 May 2008 TIP - Get security practices, procedures and documentation to meet Sarbanes-Oxley (SOX) compliance. This tip includes checklists to guide SQL DBAs and developers to inspect systems.

	Find size of SQL Server tables and other objects with stored procedure Submitted By: Richard Ding | 09 Apr 2008 TIP - Check the size of SQL Server tables and other database objects with an original stored procedure, sp_SOS, that expands on sp_spaceused. Calculate space and perform more functions.

	VIEW ALL EXPERT TECHNICAL ADVICE ON STRATEGY AND PLANNING

REFERENCE & LEARNING: 1 - 3 of 24

	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

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 career advice, SQL Server competitors, SQL Server licensing, SQL Server ROI and TCO