Microsoft SQL Server 2005 (Yukon)
Home > SQL Server Topics > Microsoft SQL Server Platforms > Microsoft SQL Server 2005 (Yukon)
SQL Server Topics:
EMAIL THIS
 TOPICS HOME   BROWSE ALL SQL SERVER TOPICS     RSS FEEDS 

Microsoft SQL Server 2005 (Yukon)


Microsoft released SQL Server 2005 more than five years after SQL Server 2000 replaced SQL Server 7.0. The release features a multitude of improvements over its predecessor, including new better error recovery systems, indexing algorithms and native support for managing both relational and XML data. This Microsoft SQL Server 2005 topic page features resources dealing with the upgrade, migration and installation of Microsoft's SQL Server database management system. Do you want to learn about the new features and enhancements in SQL Server 2005? Take a look at these tips that go inside SQL Server 2005 on topics of development and database administration.
IN THIS TOPIC:  EXPERT TECHNICAL ADVICE (196) , REFERENCE & LEARNING (71) , NEWS (45) , WHITE PAPERS , WEBCASTS (3) , DEFINITIONS (2)

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 196
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 (YUKON)

  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 (YUKON)

  NEWS: 1 - 3 of 45
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 MICROSOFT SQL SERVER 2005 (YUKON)

  WHITE PAPERS
Databases and ERP Selection: Oracle vs SQL Server
Published by: IFS | 19 Jun 2009
WHITE PAPER - How do Oracle and Microsoft SQL Server database platforms compare on reliability, scalability and cost when run under enterprise software? Download this white paper for details.
Leveraging Virtualization for Application Assurance
Published by: AppAssure Software | 09 Jun 2009
WHITE PAPER - Business continuity. Application assurance. Virtualization. Consider that a mission-critical progression. Virtualization answers the need for business continuity and challenge of application assurance enabling companies to quickly and seamlessly recover from e-mail outages and keep business on track.
SQL Server Database Backup and Restore Planning
Published by: AppAssure Software | 09 Jun 2009
WHITE PAPER - Whether a business is small, medium or large business, it must have a well-written plan for backing up the servers. Planning a backup strategy up-front and documenting not only the backup process but also the restore process, will save you a ton of time in the end. Read this paper for backup tips.
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 (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 MICROSOFT SQL SERVER 2005 (YUKON)

SEE ALSO - Topics Related to Microsoft SQL Server 2005 (Yukon): 
Microsoft SQL Server 2008 (Katmai), Microsoft SQL Server 2000



Microsoft SQL Server 2005 (Yukon) Solutions - SQL Server Topics

HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts