Learning Guide: SQL Server basics
SQL Server is gaining ground in the database space. As more companies turn to the DBMS hyped as the low-cost big player, more DBAs will have to learn its intricacies. With that in mind, we created this learning guide, highlighting basic SQL Server information that can help Oracle and DB2 pros get up to speed on the system.
SQL Server is gaining ground in the database space. As more companies turn to the DBMS hyped as the low-cost big...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.

player, more DBAs will have to learn its intricacies. With that in mind, we created this learning guide, highlighting basic SQL Server information that can help Oracle and DB2 pros get up to speed on the system.
TABLE OF CONTENTS
Some SQL Server terms and acronyms
SQL Server basics
Detailed product information and manuals
SQL Server/Oracle comparisons
SQL Server/DB2 comparisons
Security
Some SQL Server terms and acronyms
- FAQs
- SQL Server administration dos and don'ts
- NVARCHAR vs VARCHAR in SQL Server 2000
- Changing SA passwords
- SQL Server backup and restore, part I: The basics
- SQL Server backup and restore, part II: Best practices
- Introduction to Transact-SQL
- T-SQL tutorial
- Finding the Nth maximal value: An extension of the MAX T-SQL function
- Implementing full text search in T-SQL stored procedures
- Hundreds of free SQL Server tips and scripts
- Ask the SearchDatabase.com SQL Server experts your question
Detailed product information and manuals
- Microsoft's SQL Server home page
- A high-level overview
- Key features in SQL Server 2000
- Getting started with Books Online (BOL)
- Surviving in a multi-database environment
- An Oracle/SQL Server comparison
- DBMS reviews and comparisons
- Migrating Oracle databases to SQL Server 2000
- Options for replicating Oracle data to SQL Server
- Replicating data from SQL Server 2000 to Oracle
- This Oracle query won't work in SQL Server
- The DESC equivalent
- The TO_CHAR equivalent
- The ROWNUM equivalent
- The DUAL equivalent
Dig Deeper on Microsoft SQL Server 2000
PRO+
Content
Find more PRO+ content and other member only offers, here.
0 comments
Oldest Newest