Enterprise Challenges and Business Rules Course Resources

Numerous resources are offered with this course that will help you complete it successfully.
The greatest resource is the Sql Configuration Sitemap which you should visit now.
In addition to the orientation, several other resources are available to you.

Throughout this course, you will have the opportunity to review definitions of key terms. These terms are defined in the course glossary. The terms appear as italicized in the lesson text and will normally have the corresponding footnote at the bottom of the page. Clicking a glossary term opens a pop-up window with the definition.

The optional text for this course can be obtained by visiting the following site.
SQL Server. This book is recommended for anyone that wants to know the latest with respect to SQL Server.

SQL Server Configuration Manager is a tool to manage the services associated with SQL Server and to configure the network protocols used by SQL Server. SQL Server Configuration Manager is a Microsoft Management Console snap-in that is available from the Start menu or can be added to any other Microsoft Management Console display. Microsoft Management Console (mmc.exe) uses the SQLServerManager10.msc file in the Windows System32 folder to open SQL Server Configuration Manager.

When you first load SQL Server, you start with at least four system databases:

1. master
2. model
3. msdb
4. tempdb

All of these need to be installed for your server to run properly. Indeed, without some of them, it will not run at all. From there, things vary depending on which installation choices you made. Examples of some of the databases you may see include the following:

1. ReportServer: The database that serves Reporting Server confi guration and model storage needs
2. ReportServerTempDB: The working database for Reporting Server
3. AdventureWorks: The sample database
4. AdventureWorksDW: Sample for use with Analysis Services

In addition to the system-installed examples, you may, when searching the web or using other tutorials, fi nd reference to a couple of older samples:

1. pubs
2. Northwind

I mention them mostly because they carry fond memories from simpler times, and partly because you might find them out there somewhere.

After completing some exercises, you will be required to cut and paste your source code into a text submission box.
In the next lesson, the learning community will be discussed.