SQL Server 2000 is one of the most popular RDBMS's for the Windows platform. Never worked with SQL Server 2000 before but dying to know how? In this article Mitchell looks at how to create your first database, and also shows you how to manipulate this database through both Enterprise Manager and Query Analyzer.
Building Your First SQL Server 2000 Database (Page 1 of 5 )
Try surfing around the Internet and finding me a popular site that isn't using some sort of database to store its content. I bet you'll have a tough time trying to find just one popular site (i.e. a site with over 5,000 unique visitors a day) that doesn't use some sort of DBMS, such as SQL Server 2000, MySQL, or Oracle.
As I'm sure you're aware, it's extremely difficult to build a dynamic web site without a way to access and manipulate your content dynamically. Back in 1995 when the majority of web sites were still serving static content (i.e. plain HTML files), database driven sites were nowhere near as popular as they are today. Why do you think this is? Are databases easier to setup today? Is web server software more user friendly? Or was it just a natural progression that we as web developers went through to "evolve" from the way we developed "back then"?
I would like to think it's all of these things. Today we have databases such as MySQL and SQL Server that can be setup on a development machine with very little expertise: you simply run the setup program, change a couple of options and you're up and running in 20 minutes or so. It also seems that databases are "the way to go" these days, which makes sense when you think about it: they're readily available (some such as MySQL are free), some are supported cross platform, and others are supported with native providers or pure source code libraries.
In this article we're going to take a beginners look at Microsoft SQL Server 2000. We will look at how to create our first database, and also how to manipulate this database through both Enterprise Manager and Query Analyzer. If you've never worked with SQL Server 2000 before but have always been curious, then this article's guaranteed to get you up and running in no time.
Before we proceed however, you should have SQL Server 2000 installed on your machine. I'm running Windows 2000 Advanced Server, but SQL Server 2000 can also be installed on Windows 2000 Server, Windows 2000 Datacenter Server, and Windows NT 4.0 with service pack 5. If you'd just like to fiddle around with SQL Server 2000 for the span of this article, then you'll be glad to know that you can download a free 120-day trial version of it by clicking here.
If you have any trouble with your installation then check MSDN or consult the reference material that was included with your copy of SQL Server 2000.