SQL Server

Ask your SQL Server questions at ITKnowledgeExchange.com

Codenamed Yukon in development, SQL Server 2005 was released in November 2005. The 2005 product is said to provide enhanced flexibility, scalability, reliability, and security to database applications, and to make them easier to create and deploy, thus reducing the complexity and tedium involved in database management. SQL Server 2005 also includes more administrative support.

The original SQL Server code was developed by Sybase; in the late 1980s, Microsoft, Sybase and Ashton-Tate collaborated to produce the first version of the product, SQL Server 4.2 for OS/2. Subsequently, both Sybase and Microsoft offered SQL Server products. Sybase has since renamed their product Adaptive Server Enterprise.

Getting started with SQL Servers

To explore how the SQL Server is used in the enterprise, here are some additional resources:

Learning Guide: SQL Server basics: This tutorial offers basic SQL Server resources to help Oracle and DB2 pros get up to speed on Microsoft's DBMS.

SQL Server consolidation: Why, when and how to consolidate SQL Servers: Get introduced you to the worlds of server and storage consolidation and work your way toward a much more efficient and easy-to-manage SQL Server environment.

Learning Guide: SQL Server performance tuning A to Z: From testing and monitoring to indexing and troubleshooting, you're sure to find a resource to help resolve your SQL Server performance dilemmas in this guide.

How to prevent SQL Server and Internet Explorer hack attacks: SQL server and Internet Explorer have been among hackers' favorite targets for some time. Get advice on how to secure these Microsoft technologies and how to prevent attacks.

Learn more about Microsoft SQL Server 2000

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 has more information on their SQL Server pages. - SearchSQLServer.com features webcasts and white papers about SQL server in this resource center. - eWeek Labs reviews SQL Server 2005.

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 Track changes to SQL Server 2000 and 2005 with one simple utility SQL Server triggers have limits when tracking changes. Use scripts in this utility to monitor SQL Server 2000 and 2005 for new objects, logins and... Is it possible to find disabled indexes in SQL Server 2000? If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know. SQL Server 2000 indexing Q&A to create and tune indexes Know how to choose proper indexes for your business situation. In part one of this two-part indexing series, Edgewood Solutions' Jeremy Kadlec answers...

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary application server  (SearchSQLServer.com) comma-separated values file  (SearchSQLServer.com)