Archive | SQL Server RSS feed for this section

What is a Database?

By on January 1, 2012 in Database Administration, Database Development, Oracle Database, SQL Server

For the technical purpose of database developers and administrators, a database is simply a collection of operating system files. Database files are normally stored in a proprietary binary format that can only be mounted by an instance of the relational database software that created them. The purpose of the database instance is to to manage and [...]

Read full story • Comments { 0 }

Looking forward to SQL Server 2012

By on January 1, 2012 in SQL Server

I finally got around to installing SQL Server 2012 RC 0 on VMware Fusion 4 yesterday. Like a kid on Christmas, I started looking for the enhancements that do not get much marketing attention, but will improve my development workflow or put an end to some administration pains. This is what I found so far: [...]

Read full story • Comments { 0 }

What is a Schema in SQL Server 2005?

By on February 21, 2009 in SQL Server

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 [...]

Read full story • Comments { 22 }

SQL Server 2008 System Views Map

By on February 3, 2009 in SQL Server

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 full story • Comments { 0 }

Best New Features of SQL 2008

By on February 3, 2009 in SQL Server

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 [...]

Read full story • Comments { 0 }

SQL Server 2005 Data Types

By on December 27, 2008 in SQL Server

SQL Server 2005 has the following data types available: Exact Numerics BIGINT INT SMALLINT TINYINT BIT bit DECIMAL NUMERIC MONEY SMALLMONEY Approximate Numerics FLOAT REAL Date and Time DATETIME SMALLDATETIME Character CHAR VARCHAR TEXT Unicode Character NCHAR NVARCHAR NTEXT Binary BINARY VARBINARY IMAGE Other CURSOR SQL_VARIANT TABLE TIMESTAMP UNIQUEIDENTIFIER XML

Read full story • Comments { 0 }

All about SQL Server

By on December 25, 2008 in SQL Server

SQL Server is not yet Oracle but it does provide a key piece of the Microsoft developer platform. It must be judged for what it is, and that is a great database if designed within its limitations.

Read full story • Comments { 1 }