Home > SQL Server Learning Center
EMAIL THIS
 Learning Center:  SQL Server 2005 tools
Search our content and thousands of pre-screened sites.
Advanced Search  
Last Updated: May 19, 2006 
SQL Server 2005 was in production so long that its final release was jam packed with new tools and enhancements. Here we've compiled a list (by no means exhaustive) of features not to be missed.
>> Get more tips and tutorials on SQL Server 2005 in this learning guide.
>> Ask expert Adam Machanic your SQL Server 2005 questions.
Q&A: What's new in SQL Server 2005 SP1

(09 May 2006)

SQL Server 2005 Service Pack 1 provides production-ready database mirroring, SAP NetWeaver Business Intelligence support, Full-Text support and more.

Read Full Story
ADVICE:
>> 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 ...
>> SQL Server Management Studio client tool enhancements
TIP :SQL Server MVP Adam Machanic advises DBAs to move out of the Query Analyzer and Enterprise Manager comfort zone to try out ...
>> SQL Server 2005 Upgrade Advisor reduces unknowns
TIP :SQL Server 2005 Upgrade Advisor helps analyze your databases and server before upgrading and warns of potential problems. MVP ...
>> Using SQL Server 2005 Surface Area Configuration tool
TIP :How to use the Surface Area Configuration tool to manage and secure SQL Server 2005.
>> Tuning your SQL Server 2005 database engine
TIP :Installing SQL Server 2005 is not your greatest challenge; it's ensuring the new DBMS meets high-performance demands. Tune ...
>> SQL Server Integration Services to simplify database maintenance
TIP :SQL Server Integration Services (SSIS) eases your database maintenance workload in SQL Server 2005. Review SSIS benefits and ...
>> Load-balancing enhancements in SQL Server 2005
TIP :SQL Server 2005 still doesn't support load balancing out of the box, but it offers useful new features that help distribute ...
>> Top 10 security enhancements in SQL Server 2005
TIP :SQL Server 2005 offers many new features to help lock down the database and protect access to data. Adam Machanic identifies ...
>> SQL Server 2005 business intelligence features
TIP :SQL Server 2005 business intelligence features make reporting and Analysis Services applications user-friendly.
>> Backup and recovery enhancements in SQL Server 2005
TIP :SQL Server 2005 backup and restore has new features worthy of your attention. Backup and recovery expert Greg Robidoux talks ...
>> SQL Server 2005: When and how to use Database Snapshots
TIP :A new feature in SQL Server 2005 lets you easily create a read-only copy of your database. Edgewood Solutions' Greg Robidoux ...
>> Database mirroring in SQL Server 2005
ASK THE EXPERTS :Was database mirroring removed from SQL Server 2005?
>> SQL Server 2005 DMVs: Exposing the state of your server
TIP :It was never a simple task to determine which T-SQL connections were blocking others in SQL Server -- until SQL Server 2005 ...
>> Working with schemas in SQL Server 2005
TIP :If you're managing too many databases with too many objects, it may be time to take advantage of SQL Server 2005's ANSI SQL ...
>> What's new with T-SQL in SQL Server 2005
TIP :T-SQL enhancements are among the most significant new features in SQL Server 2005. SQL expert Jeremy Kadlec explains error ...
>> Exception handling best practices in SQL Server 2005
TIP :SQL Server 2005 brings you TRY/CATCH, a new T-SQL feature that helps find and address errors before they reach application ...
>> Writing SQL Server CLR routines
TIP :SQL CLR is a powerful developer tool in SQL Server 2005. Learn how to get the new programming paradigm working properly with ...
>> Sysindexes replacement in SQL Server 2005
ASK THE EXPERTS :SQL Server 2000 uses sysindexes to look for the IAM page. What view is used by SQL Server 2005 to perform the same ...
>> Index types in SQL Server 2005
ASK THE EXPERTS :Does SQL Server 2005 have any new index types?
>> SQL Service Broker and Microsoft Message Queuing
ASK THE EXPERTS :What is the relationship between SQL Service Broker (SSB) and Microsoft Message Queuing (MSMQ)?

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
SQL Server 2005 (Yukon)
How to use rank function in SQL Server 2005
Manage traces in SQL Server 2005 Analysis Services with XMLA commands
Tutorial: SQL Server 2005 Analysis Services
Create a computed column in SQL Server using XML data
Open SSIS packages without validation using these SQL properties
Using the OUTPUT clause for practical SQL Server applications
Create DDL table in SQL Server 2005 to audit DDL trigger activity
How to process SQL Server 2005 Analysis Services for data availability
Configure SQL Server Service Broker for sending stored procedure data
SQL Server 2005 log shipping setup using the wizard
SQL Server 2005 (Yukon) Research

SQL Server installation
Virtual database storage for SQL Server: Friend or foe?
Tutorial: Migrating to SANs from local SQL Server disk storage
How to restore SQL Server database to transition server during upgrade
Storage area network (SAN) basics every SQL Server DBA must know
Tips for moving from SQL Server local disk storage to SANs
SQL Server 2005 log shipping setup using the wizard
SQL Server tools don't appear in menu after SQL Server 2005 install
Troubleshoot SQL Server 2005 SP2 installation error
Configuring SQL Server memory settings
Optimize SAN setup for improved SQL Server performance
SQL Server installation Research

SQL Server upgrades and patches
Upgrade live applications to SQL Server 2005 for high availability
SQL Server high availability when upgrading to SQL Server 2005
How to restore SQL Server database to transition server during upgrade
Top 10 SQL Server Integration Services (SSIS) and DTS tips
Upgrade Active/Active cluster to SQL Server 2005 and Windows 2003
FAQ: SQL Server databases how-to
Upgrading to SQL Server 2008 advantages and hardware requirements
Create an upgrade plan for your move to SQL Server 2005
Table partitioning with SQL Server 2005
Change collation to SQL Server 2005 after upgrading databases

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
application server  (SearchSQLServer.com)
Yukon  (SearchSQLServer.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary

> SQL Server restore how-tos
> Learning Center: Top 10 SQL Server security tips
> SQL Server 2005 data mining
> SQL Server 2005 security
> Database design decisions
View All Topics

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

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




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