Installing / Configuring SQL Server 2005

Teaching the SQL SERVER SPECIALIST CERTIFICATE PROGRAM – Maintaining SQL Server 2005 Class Tonight.

Week1

Here is the slide deck for the class tonight.   DBA_Essentials_Class01_Installation

 

 

Determining the version of SQL server from TSQL

The question came up as to which version of sql server is being run, and how do you determine the exact version number of the SQL server. Here is what I have come up with. From TSQL if you are connected to the SQL Server, you can run the following command:

SELECT 'SQL Server ' + CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - ' + CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' (' + CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'

which should return something like the following:

SQL Server 9.00.4035.00 – SP3 (Standard Edition (64-bit))
or
SQL Server 10.0.2531.0 – SP1 (Enterprise Edition (64-bit))

Another way to do it is just

SELECT @@VERION;

Which will return something like this

Microsoft SQL Server 2008 (SP1) – 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Additionally if you are at the command prompt on the SQL server itself, you can run the following command:

osql -E -q”SELECT @@VERSION”

Questions and Answers Website.

Tonight I created the Questions and Answers website.  My wife was watching Mamma Mia (the movie), and that lost my interest quickly so I went and created the Questions and Answers site.  Total coding time was about 3 hours, and I was able to get questions asked and answered shortly after that.

This is an experiment for me in 2 areas… first database programming with the MySQL database, after so much SQL Server it was interesting to take a look at another database.  Second this site was created to take advantage of the Amazon Mechanical Turk system to pay people to generate content for a website.

Take a look at the Questions Site:

http://questions.civicvoice.com/

–Steve Stedman

Bellingham WA

On to a new adventure – Teaching SQL Server

I have just finished all of the paperwork. For spring quarter 2009, I will be teaching a SQL Server DBA class at Western Washington University.

The class is for the SQL Server 2005 Specialist Certificate program at WWU. It is part of the Extended Education program.