SQL Server 2005 (Yukon)

MUST READ Granting permissions in SQL Server 2005 TIP - New security features in SQL Server 2005 make it easier to manage and grant permissions on a more granular basis. Get an overview of new features and functions in this tip. 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. New T-SQL features in SQL Server 2005 TIP - T-SQL features in SQL Server 2005 add flexibility to SQL development: error handling, ROW_NUMBER function, DDL triggers and CLR. 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. 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.

EXPERT TECHNICAL ADVICE: 1 - 3 of 201

SQL SERVER 2005 (YUKON) EXPERTS
			Adam Machanic Database Consultant ASK A QUESTION		Eric Johnson Database Technologies Consultant ASK A QUESTION

	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.

	Using DATEADD and DATEDIFF to calculate SQL Server datetime values Submitted By: SearchSQLServer.com | 07 Oct 2008 TIP - Here's how to use DATEADD and DATEDIFF in SQL Server to calculate datetime values in T-SQL queries, modify data and to use within your table definitions.

	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.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER 2005 (YUKON)

REFERENCE & LEARNING: 1 - 3 of 76

	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.

	Tutorial: SQL Server 2005 Analysis Services SearchSQLServer.com | 02 Jul 2008 TUTORIAL - Want to learn about Analysis Services 2005 in SQL Server? These tips outline helpful features and give examples of this BI tool's functionality.

	Export SQL Server data to an Excel file using SSIS and Visual Studio Jayaram Krishnaswamy | 08 Apr 2008 TUTORIAL - Here are seven steps for designing a SQL Server Integration Services package using Visual Studio and exporting data from your SQL Server table to Excel.

	VIEW ALL REFERENCE & LEARNING ON SQL SERVER 2005 (YUKON)

NEWS: 1 - 3 of 48

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

	Q&A: What's new in SQL Server 2005 SP1 SearchSQLServer.com | 04 May 2006 INTERVIEW - SQL Server 2005 Service Pack 1 provides production-ready Database Mirroring, SAP NetWeaver Business Intelligence support, Full-Text support and more.

	VIEW ALL NEWS ON SQL SERVER 2005 (YUKON)

WHITE PAPERS

	E-Guide - Best Practices for Sharepoint Server 2007 Backup and Disaster Recovery Published by: AvePoint, Inc. | 07 Jan 2009 EDITORIAL RESOURCE GUIDE - This informative E-Guide, brought to you by SearchWinIT.com and AvePoint, highlights best practices for SharePoint Server 2007 backup and disaster recovery.

	Is JD Edwards EnterpriseOne Right for Your Business? Published by: Oracle Corporation | 07 Jan 2009 IT BRIEFING - JD Edwards EnterpriseOne is a comprehensive and highly integrated suite of core business applications including things like financials, manufacturing, distribution, supply chain management, human capital management and so forth.

	E-Guide - How to Backup Sharepoint Server 2007 Published by: AvePoint, Inc. | 19 Dec 2008 EDITORIAL RESOURCE GUIDE - In this E-Guide, brought to you by SearchWinIT.com and AvePoint, explore an overview of the SharePoint backup and restore utility.

	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 SQL SERVER 2005 (YUKON)

DOWNLOADS: 1 - 1 of 1

	SQL Server backup and restore school Published by: SearchSQLServer.com | 16 Aug 2007 WEBCAST AND PODCAST SERIES - In this SQL Server backup and recovery school, you'll get best practices, basic restore commands and learn SQL Server 2005 features – all via webcasts and podcasts.

	VIEW ALL DOWNLOADS ON SQL SERVER 2005 (YUKON)

BEST WEB LINKS: 1 - 3 of 10

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

	Professional Association for SQL Server PASS | 01 Apr 2006 BEST WEB LINK - PASS is the definitive, global community for SQL Server professionals. It is the first independent, user-run, not-for-profit association committed to providing SQL Server professionals around the world with the resources and ...

	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 SQL SERVER 2005 (YUKON)

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 SQL SERVER 2005 (YUKON)

	SEE ALSO - Topics Related to SQL Server 2005 (Yukon):  SQL Server overview, SQL Server upgrade and migration, SQL Server 2008 (Katmai)