Browsing All Posts published on »March, 2008«

Virtual PC and SQL Server 2008

March 10, 2008

0

I found this great article on conserving space and making life a little easier by using differencing disks in Virtual PC 2007. For those of you who don’t use Virtual PC, it is a good (but not the only) way of testing SQL Server (any version) without breaking your main development machine. Always a good […]

Insert multiple rows

March 10, 2008

0

How many times have we had to write multiple INSERT INTO statements? Well, SQL Server 2008 comes to the rescue. Its a small feature but still very useful. You can now insert multiple rows into a table in a single statement. INSERT INTO T1 (Col1,Col2,Col3) VALUES (‘Row1’, ‘Value’,‘Test’), (‘Row2’, ‘Value’,‘Test’), (‘Row3’, ‘Value’,‘Test’) This inserts 3 […]

LINQ from a SQL Dev’s perspective

March 5, 2008

4

I attended the SQLBits conference on the 1st March and at this event a “developer” (not a SQL Developer I will add) did a quick overview presentation of LINQ; this wasn’t the full session on LINQ that was also presented that day but one of the open mic sessions. He was a very animated chap […]