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.
TABLE OF CONTENTS
Requires Free Membership to View






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
- Surviving in a multi-database environment
- A comparison of SQL Server 2000 and DB2 Version 8
- DBMS reviews and comparisons
- DB2 replication to SQL Server 2000
- Converting a DB2 date to SQL Server
- Top 10 SQL Server security blunders, part I
- Top 10 SQL Server security blunders, part II
- An enterprise-class plan for securing SQL Server
- SQL Server 2000 SP3 security features and best practices
- Webcast: SQL Server security best practices
- Webcast: Protecting against hack attacks
Email Alerts
This was first published in February 2005
Join the conversationComment
Share
Comments
Results
Contribute to the conversation