I'm looking for a free tutorial, white paper or reference about SQL Server 2000. I've already used Microsoft Access and MySQL, so I don't need to learn SQL. I'd like an introduction to SQL Server 2000 that shows how to create a database, grant permissions, create tables, etc.
There is a plethora of information now available on the Web about SQL Server 2000. I assume that you actually want a good all-encompassing overview of SQL Server, but you don't want to fork over the dollars to buy a good book? If this is the case, then you should absolutely start with the
SQL Server Books On-Line (BOL)
. The next stop is Microsoft TechNet, where there are a multitude of great
resources for SQL Server DBAs
. My favorite is the
Microsoft SQL Server Operations Guide
. If you've already mastered the BOL then it's time to start looking around the Internet. I'd start at
to see which topics you're most interested in. Other great sites include
and SQL Server Magazine. When you're ready to start tuning the performance of your SQL Server, then
is a must-have for your toolbox.
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on Microsoft SQL Server Installation
Monitoring and Administration expert Kevin Kline discusses the obstacles of database administration when a publisher resides on a different domain.
A common SQL Mail error is addressed by monitoring and administration expert Kevin Kline.
Monitoring and Administration expert Kevin Kline discusses the installation of SQL Server client tools on Windows XP Pro.