Yukon

Learn more about Microsoft SQL Server Administration

	SQL Server virtualization pros and cons: Weigh the performance impact: Virtualizing SQL Server has pros and cons. Learn the performance impacts of virtualization on SQL Server I/O, RAM and memory to decide if it is a fit for your SQL Server system.
Hardening the network and OS for SQL Server security: To help prevent a major breach of your DBMS, it's important to secure all individual systems in an environment, including the network and operating system.
Performance implications of transaction log autogrowth in SQL Server: Take a closer look at the performance implications of shrinking transaction log files in SQL Server.
Working with sparse columns in SQL Server 2008: Sparse columns can provide significant storage benefits to those working with SQL Server 2008. Learn the proper way to implement sparse columns, column sets and filtered indexes.
Microsoft SQL Server Tools Guide: Whichever SQL Server hammer or nail you may be looking for, there's a good chance you'll find the tool or utility you need in this guide.
Consolidate SQL Servers: Decide why, when and how to consolidate SQL Servers. Navigate to key excerpts from our e-book, "Consolidate SQL Servers for availability, scalability and cost savings."
All-in-One Guide: SQL Server backup and recovery: Find out how to successfully back up and recover SQL Server data with this collection of tips and expert advice.
SQL Server Management Studio client tool enhancements: SQL Server MVP Adam Machanic advises DBAs to move out of the Query Analyzer and Enterprise Manager comfort zone to try out SQL Server Management Studio.

Do you have something to add to this definition? Let us know. Send your comments to techterms@whatis.com

More resources from around the web: - Microsoft describes SQL Server 2005's improvements over its predecessor. - The Microsoft SQL Server Developer Center provides additional information.

FILE EXTENSION AND FILE FORMAT LIST File Extension and File Format List: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

RELATED CONTENT Recovery Model Options in SQL Server In this podcast, SQL Server backup and recovery expert Greg Robidoux describes each of the three recovery models available for SQL Server including... Run SQL 2000 and SQL 2005 instances at the same time Can you run SQL 2000 and SQL 2005 instances on the same server? Are there any problems associated with the two instances running together? SQL Server backup and restore fundamentals In this webcast, industry expert and Edgewood Solutions' Greg Robidoux helps you ensure your backup and restore procedures are properly established...

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