Building and Maintaining a High Availability Infrastructure. I am giving a hands on (code camp) presentation on setting up SQL 2008 Clustering.  If you are interested, click the link below and register. Will see you there. http://codecamp.phillydotnet.org/2008-3/Lists/Sessions/Dis... [More]

Let us take a performance snapshot on using Row Constructors in SQL 2008 Example table: create table Customer (customerID int primary key clustered identity(1,1) ,firstName varchar(30) ,lastname varchar(30) , age int ) -- SQL 2005 method begin transaction inser... [More]

Row Constructors in SQL 2008 Let us delve into using Row Constructors Two basic tables for test purposes -- Customer IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Customer]') AND type in (N'U')) DROP TABLE [dbo].[Customer] ... [More]

Developer centric SQL 2008 Features: I am giving a walk through on developer centric features in SQL 2008. If you are interested to learn more about the new SQL 2008 features available for developers like Row constructors, HierarchyID and more, you can register on the link shown below:  ... [More]