Microsoft SQL Server 2005

MUST READ Disaster recovery features in SQL Server 2005 TIP - New backup and restore features in SQL Server 2005 include log shipping, replication and database mirroring. Know your best option for disaster recovery. Upgrading to SQL Server 2005: Six migration tips TIP - Upgrading to SQL Server 2005 takes preparation. Hands-on experience and testing the new SQL Server database optimizes SQL Server upgrade processes. Top 10 new features in SQL Server 2005 TIP - From programming to administrative capabilities, SQL Server 2005 enhances many existing SQL Server 2000 features and goes well beyond.

EXPERT TECHNICAL ADVICE: 1 - 3 of 200

	Tips for tuning SQL Server 2005 to improve reporting performance 02 Oct 2008 EXPERT ANSWER - There are a few things you can do to tune SQL Server for improved reporting performance. Here are some generic and Reporting Services-specific techniques.

	SQL Server consolidation: Why it's an optimization technique Submitted By: SearchSQLServer.com | 30 Sep 2008 TIP - SQL Server consolidation benefits are high availability and lower licensing costs. Here's what to expect for hardware needs, system monitoring and SQL licensing.

	Parent-child dimensions in SQL Server 2005 with Analysis Services MDX Submitted By: SearchSQLServer.com | 23 Sep 2008 TIP - Retrieving a hierarchy with recursive relationships can be difficult in SQL. Easily implement these relationships with a parent-child dimension using Analysis Services MDX.

	VIEW ALL EXPERT TECHNICAL ADVICE ON MICROSOFT SQL SERVER 2005

REFERENCE & LEARNING: 1 - 3 of 71

	SQL Server Reporting Services Fast Guide SearchSQLServer.com | 20 Feb 2009 LEARNING CENTER - Check out this collection of best practices, troubleshooting advice and perfomance tips for working with SSRS in SQL Server 2005.

	SQL Server Service Broker Tutorial and Reference Guide SearchSQLServer.com | 01 Dec 2008 LEARNING GUIDE - Discover the major objects of the SQL Server Service Broker, including message types, contracts, queues, services and commands such as SEND and RECEIVE.

	Enforcing data integrity in a SQL Server database SearchSQLServer.com | 16 Sep 2008 BOOK EXCERPT - Find out how primary keys, foreign keys and constraints can keep your SQL Server data consistent in this book excerpt.

	VIEW ALL REFERENCE & LEARNING ON MICROSOFT SQL SERVER 2005

NEWS: 1 - 3 of 45

	End of life comes for SQL Server 2005 SP2, 2008 SearchSQLServer.com | 08 Oct 2009 ARTICLE - Mainstream support for at least two versions of Microsoft SQL Server is set to expire next year.

	Microsoft reiterates promise of SQL Server 2005 SP3 SearchWinIT.com | 21 Oct 2008 ARTICLE - SQL Server 2005 database administrators and managers will be happy to know that a third service pack will be here shortly.

	SQL Server DBMS' growing popularity is no coincidence SearchSQLServer.com | 05.26.2006 OPINION - SQL Server offers more robust features at a lower price point than competing database management systems, making its growing popularity no surprise to contributor Adam Machanic. In this column, he details the advantages of ...

	VIEW ALL NEWS ON MICROSOFT SQL SERVER 2005

WHITE PAPERS

Protecting and Enhancing SQL Server With Double-Take Availability Published by: Double-Take Software | 16 Nov 2009 WHITE PAPER - Double-Take Software provides organizations with a solution that offers distinct recovery and protection advantages over manual Microsoft SQL built-in replication capabilities: Double-Take Availability saves more data real-time and restores that data in a much faster manner.

	The IT Manager’s Guide to SQL Server 2008 Migration Published by: SHI | 03 Nov 2009 EGUIDE - While SQL Server 2008 is now considered stable and beneficial, many businesses are still hesitant to migrate. In this expert E-Guide, brought to you by SearchSQLServer.com and SHI, you will discover the unique advantages offered by a SQL Server 2008 migration.

Dell and Microsoft solutions help ServiceU deliver reliable system performance and create a virtualized environment that reduces power consumption by 50 percent Published by: Dell and Microsoft | 28 Oct 2009 CASE STUDY - ServiceU Corporation was challenged to deploy reliable hardware to support its Microsoft® SQL Server® 2008 environment and virtualize other applications to enhance business flexibility. Read this case study to learn about the benefits that ServiceU achieved through by implementing Dell hardware and Microsoft Hyper-V technology.

	VIEW ALL WHITE PAPERS IN THIS TOPIC

WEBCASTS: 1 - 3 of 3

	SQL Server performance monitoring and tuning how-tos - Vendor Podcast DOWNLOAD PODCAST PREMIERED:   22 AUG 2006, 09:00 EDT (13:00, GMT) SUMMARY:   Learn how to develop a systematic approach to SQL Server database performance tuning. Buck Woody will detail how to define performance tuning components, collect and interpret monitoring metrics, and put a performance tuning action plan in place.

Weighing your SQL Server 2005 migration options - Expert Webcast VIEW WEBCAST PREMIERED:   11 MAY 2006, 09:00 EDT (13:00, GMT) SUMMARY:   SQL Server 2005 is packed with new features that may be tempting you to make the move to the new DBMS sooner than later. But you must first determine what to migrate and steps to take to get there. Edgewood Solutions' Jeremy Kadlec reviews your migration options in this webcast.

Consolidating SQL Servers on 64-bit for reliability and scalability - Expert Webcast VIEW WEBCAST PREMIERED:   30 NOV 2005, 09:00 EST (14:00, GMT) SUMMARY:   This webcast explains how to consolidate SQL Servers under a single 64-bit platform. It will focus on server consolidation methodologies, capacity planning and implementation, as well as ways to achieve greater SQL Server reliability, scalability and ROI without compromising performance.

	VIEW ALL WEBCASTS ON MICROSOFT SQL SERVER 2005

DEFINITIONS: 1 - 2 of 2

	Yukon 25 Oct 2004 WORD - Yukon is the code name used for the beta version of Microsoft's SQL Server 2005. SQL Server 2005 is said to provide enhanced flexibility, scalability, reliability, and security to database applications, and to make them ...

	application server 30 Apr 2003 WORD - An application server is a server program in a computer in a distributed network that provides the business logic for an application program. The application server is frequently viewed as part of a three-tier application, ...

	VIEW ALL DEFINITIONS ON MICROSOFT SQL SERVER 2005

	SEE ALSO - Topics Related to Microsoft SQL Server 2005:  Microsoft SQL Server 2008, Microsoft SQL Server 2000, Microsoft SQL Server 2008 R2