Email Alerts
-
Introduction to SQL Server 2005 Management Studio
Get started understanding and working with SQL Server 2005 Management Studio in this excerpt, from the book SQL Server 2005: A Beginner's Guide. Book Excerpt
-
Using Management Studio with the SQL Server Database Engine
Learn how SQL Server Management Studio works in this excerpt from the book SQL Server 2005: A Beginner's Guide. Book Excerpt
-
Management Studio Exercises
Wrap up your lesson on SQL Server 2005 Management Studio with a few exercises to test what you learned, excerpted from SQL Server 2005: A Beginner's Guide. Book Excerpt
-
Authoring Activities Using SQL Server Management Studio
SQL Server Management Studio gives you an authoring environment for all types of queries. Read more in this excerpt from SQL Server 2005: A Beginner's Guide. Book Excerpt
-
Managing Tables Using Object Explorer
Learn how to create tables belonging to your new database in this excerpt from the book SQL Server 2005: A Beginner's Guide. Book Excerpt
-
Standard routines for each table in a surrogate key architecture
Use these standard stored procedures, user-defined function and triggers when building Brian Walker's proposed surrogate key architecture. Feature
-
Dealing with concurrent access
Methods for avoiding performance problems when more than one user is accessing the same data at the same time in a surrogate key architecture. Feature
-
Overview of proposed surrogate key architecture
Find out which columns and objects you need for a proposed surrogate key architecture. Feature
-
Columns and objects to support a surrogate key architecture
Ask a group of database administrators if they prefer surrogate keys over natural data keys to implement relationships between tables, and chances are you'll get some very different opinions. In the second part of this special feature, contributor Br... Feature
-
Connecting to SQL Server using Visual Studio
SQL Server expert Eric Brown provides some helpful information on connecting to SQL Server using Visual Studio. Ask the Expert