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.

Read more about SQL Server: - 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.

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

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Solve SQL Server errors and more from the DBA trenches -- part 2 Solve SQL Server errors and other problems including primary filegroup out of space, failed SQL Server logins and trouble bringing a SQL database... Tutorial: Learn SQL Server basics from A-Z If you're new to SQL Server of simply want a refresher on some fundamentals, check out this tutorial on topics from security and performance to SSIS... FAQ: Troubleshooting SQL Server Reporting Services Troubleshoot SQL Server Reporting Services (SSRS) issues such as configuration, report designs and importing and exporting report data using Excel.

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