SQL Server basics

With that in mind, we created this SearchSQLServer.com Learning Guide highlighting basic SQL Server information on which to build your foundation. This Learning Guide will also help orient you to key sections of our new site, SearchSQLServer.com. Drop me an e-mail to let me know what other learning guides you'd like to see on SearchSQLServer.com. Beth Rosenberg, Assistant Editor.

TABLE OF CONTENTS    SQL Server terms and acronyms    Getting started with SQL Server    Migration and upgrades    SQL Server Administration    SQL Server Development    SQL Server 2005

SQL: "Structured Query Language is a standard interactive and programming language for getting information from and updating a database. Although SQL is both an ANSI and an ISO standard, many database products support SQL with proprietary extensions to the standard language. Queries take the form of a command language that lets you select, insert, update, find out the location of data, and so forth."

SQL Server terms and acronyms

Return to Table of Contents

• Browse through our SQL Server Glossary and find all of the SQL Server-related terms you need to know. (SearchSQLServer.com)


• ActiveX Data Objects (SearchSQLServer.com)


• Availability (SearchSQLServer.com)


• Cluster (SearchSQLServer.com)


• C# (SearchSQLServer.com)


• Data warehouse (SearchSQLServer.com)


• .NET (SearchSQLServer.com)


• OLTP (SearchSQLServer.com)


• Relational database management system (SearchSQLServer.com)


• Replication (SearchSQLServer.com)


• SQL (SearchSQLServer.com)


• Stored procedure (SearchSQLServer.com)


• T-SQL (SearchSQLServer.com)


• Yukon (SearchSQLServer.com)

Getting started with SQL Server

Return to Table of Contents

• Browse through this collection of SQL Server tips, tricks and expert advice. (SearchSQLServer.com)


• SQL Server: Getting Started with SQL Server (Microsoft)


• SQL Server: Top 10 SQL Server issues (SearchSQLServer.com)


• SQL Server: The Guru's guide to SQL Server architecture and internals (SearchSQLServer.com)
• SQL Server: SQL Server frequently asked questions (Microsoft)
• SQL Server: SQL Server connection basics (Microsoft)
• SQL Server: Beyond the basics with SQL (DevGuru)

Migration and upgrades

Return to Table of Contents

• Installation: Creating a SQL Server database (SearchSQLServer.com)


• Installation: Installing SQL Server 7.0 objects into SQL Server 2000 (SearchSQLServer.com)


• Upgrades: Upgrading SQL Server: Overview and project planning (SearchSQLServer.com)


• Upgrades: Upgrading SQL Server: Critical upgrade decisions (SearchSQLServer.com)


• Upgrades: In-place versus side-by-side upgrade (SearchSQLServer.com)


• Upgrades: Upgrading & migrating SQL Server (Microsoft)

SQL Server Administration

Return to Table of Contents

• Browse through this collection of SQL Server Administration tips, tricks and expert advice. (SearchSQLServer.com)


• Administration: SQL Server administration dos and don'ts (SearchSQLServer.com)


• Availability: Hardening SQL Server hardware (SearchSQLServer.com)


• Availability: High availability resources (Microsoft)


• Availability: Achieving high availability (MS SQLServer.com)


• Backup and recovery: Selecting a SQL Server recovery model (SearchSQLServer.com)


• Backup and recovery: Selecting a SQL Server backup model part 2 (SearchSQLServer.com)


• Backup and recovery: Backup and recovery best practices (SearchSQLServer.com)


• Performance and tuning: SQL Server performance-tuning worst practices (SearchSQLServer.com)
• Performance and tuning: Reach the SQL Server performance tuning pinnacle (SearchSQLServer.com)


• Performance and tuning: Checklist: Load testing -- the magic bullet for SQL Server performance tuning (SearchSQLServer.com)


• Security: How to improve SQL Server security (SearchSQLServer.com)


• Security: Top 10 SQL Server security blunders, part 1 (SearchSQLServer.com)


• Security: Top 10 SQL Server security blunders, part II (SearchSQLServer.com)


• Security: How to patch SQL Server (SearchSQLServer.com)


• Security: Building security into SQL Server solutions (Microsoft)


• Security: Security features and best practices (Microsoft)


• Security: SQL Server 2000 Security (Microsoft)

SQL Server Development

Return to Table of Contents

• Browse through this collection of SQL Server Development tips, tricks and expert advice. (SearchSQLServer.com)


• ADO.NET: ADO.NET and SQL Server 2005 (SearchSQLServer.com)


• ADO.NET: Introducing ADO.Net (SearchSQLServer.com)


• ADO.NET: ADO.NET primer (SearchSQLServer.com)


• CLR: An introduction to SQL Server 2005's CLR functions (SearchSQLServer.com)


• Transact-SQL: Adding T-SQL functions to SQL Server system schema (SearchSQLServer.com)


• Transact-SQL: Semantics and compatibility of Transact-SQL outer joins (SearchSQLServer.com)


• Transact-SQL: T-SQL tutorial (DevGuru)


• Transact-SQL: Introduction to Transact-SQL (O'Reilly Online Catalog)

SQL Server 2005

Return to Table of Contents

• Browse through this collection of SQL Server 2005 tips, tricks and expert advice. (SearchSQLServer.com)


• SQL Server 2005: SQL Server 2005: Resources for learning (SearchSQLServer.com)


• SQL Server 2005: What's new in SQL Server 2005 (SearchSQLServer.com)


• SQL Server 2005: SQL Server 2005 New Features (SearchSQLServer.com)


• SQL Server 2005: An Overview of SQL Server 2005 Beta 2 for the Database Administrator (Microsoft)


• SQL Server 2005: An Overview of SQL Server 2005 for the Database Developer (Microsoft)

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT SQL Server 2005 (Yukon) SQL Server consolidation: Why it's an optimization technique Parent-child dimensions in SQL Server 2005 with Analysis Services MDX Using SQL Server datetime functions GETDATE, DATENAME and DATEPART SSIS error message due to installation problem on SQL Server 2005 SQL Server data conversions from date/time values to character types Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005 How to configure Database Mail in SQL Server 2005 to send mail 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 SQL Server 2005 (Yukon) Research SQL Server upgrades and patches SQL Server consolidation: Why it's an optimization technique Should you upgrade to SQL Server 2005 or SQL Server 2008? Monitor database mirroring and replication after a SQL Server upgrade 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 SQL Server installation SQL Server consolidation: Why it's an optimization technique SSIS error message due to installation problem on SQL Server 2005 Get SQL Server log shipping functionality without Enterprise Edition How to create a SQL Server linked server to DB2 Tuning SQL Server performance via disk arrays and disk partitioning 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 installation Research

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