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 186

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

	Create DDL table in SQL Server 2005 to audit DDL trigger activity Submitted By: SearchSQLServer.com | 05 May 2008 TIP - Create DDL table in SQL Server 2005 to audit Data Definition Language (DDL) trigger events when DML statements run. Define DDL trigger to track SQL changes.

	How to process SQL Server 2005 Analysis Services for data availability Submitted By: SearchSQLServer.com | 01 May 2008 TIP - SQL Server 2005 Analysis Services offers data availability options for processing cube partitions. Learn how to decrease SQL memory, CPU and disk use for availability.

	Configure SQL Server Service Broker for sending stored procedure data Submitted By: Denny Cherry | 16 Apr 2008 TIP - Set up SQL Server 2005 Service Broker for a messaging platform to queue data of stored procedures and functions. Configure Service Broker with these steps.

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

REFERENCE & LEARNING: 1 - 3 of 72

	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.

	Top 7 SQL Server backup and restore tips of 2007 SearchSQLServer.com | 02 Jan 2008 THE YEAR IN REVIEW - Optimize SQL Server backup and restore methods natively with these best practices. Check out the top seven most viewed tips of 2007 on the topic of backup and recovery.

	Upgrading to SQL Server 2005 FAQs SearchSQLServer.com | 17 Sep 2007 FAQ - Here's a list of frequently asked questions that address your SQL Server 2005 upgrade issues, including DTS packages, copying databases and creating passwords.

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

NEWS: 1 - 3 of 47

	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.

	SQL Server 2005 SP1 ships SearchWinIT.com | 19 Apr 2006 ARTICLE - SQL Server 2005's database mirroring functionality is finally here with the release of SQL Server SP1.

	VIEW ALL NEWS ON SQL SERVER 2005 (YUKON)

WHITE PAPERS

	Microsoft Dynamics™ CRM Integration into the Contact Center Published by: AMC Technology | 09 May 2008 WHITE PAPER - This technical integration brief explains how the Microsoft Dynamics CRM application can be integrated into a contact center, including both general technical details of call center integration, as well as how to use vendor certified software f...

	100+ Year Old Wholesale Grocer Uses CONNX to save Millions on Enterprise Systems Replacement Costs Published by: CONNX Solutions | 08 May 2008 CASE STUDY - Explore how a data access and integration solution saved one of North America's oldest wholesale grocers from replacing its ten year old distribution system and spending up to five million dollars on a brand new enterprise solution.

	Real World SQL Implementations Published by: Hewlett-Packard Company | 10 Apr 2008 WHITE PAPER - Homeplans, part of Move, is a leading provider of pre-drawn home designs. This case study explains how Homeplans used HP PolyServe Software for Microsoft SQL Server to improve availability, decrease risk, and simplify administration.

	VIEW ALL WHITE PAPERS IN THIS TOPIC

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 upgrades and patches, SQL Server 2008 (Katmai)