From the monthly archives:

February 2009

What is a Schema in SQL Server 2005?

February 21, 2009

What is a Schema?
In Microsoft SQL Server 2005, a schema is a collection of objects adhering to the ANSI SQL-92 standard.
The ANSI SQL-92 standard defines a schema as a collection of database objects that are owned by a single principle and form a single namespace.
All objects within a schema must be uniquely named and a [...]

Read the full article →

SQL Server 2008 System Views Map

February 3, 2009

Download the SQL 2008 System View Map
The Microsoft SQL Server 2008 System Views Map shows the key system views included in SQL Server 2008, and the relationships between them.

Read the full article →

Best New Features of SQL 2008

February 3, 2009

I am getting ready to upgrade an existing SQL 2005 application and have found the following SQL 2008 features worth more exploration:

INSERT (Transact-SQL Row Constructors) – Allows the ability to add one or more new rows to a table or a view. Seems novel but not sure how useful in practice.
MERGE Statement. This new Transact-SQL statement performs [...]

Read the full article →

Beating the Exam Jitters

February 3, 2009

How to Prepare for Certification Exams

Most people find it essential to establish some special time for learning. Be sure to set it for when you learn best … in the morning, early evening, etc., and stick to your schedule.
Use an effective method of study. Your own plan, if effective, is good. If yours didn’t work, [...]

Read the full article →