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 [...]
Archive | February, 2009
SQL Server 2008 System Views Map
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.
Best New Features of SQL 2008
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 [...]
Beating the Exam Jitters
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 [...]
- What is a Schema in SQL Server 2005?
- Oracle 11g New Features for Developers
- Introduction to Oracle 11g Cursors
- So you want to be a Data Modeler?
- Using Triggers and Compound Triggers in Oracle 11g
