Browsing All Posts published on »January, 2008«

Krypton Command

January 31, 2008

0

A new control has been added to the excellent Krypton Toolkit, the Krypton Command. This allows you to group settings together and assign the group to a control. For instance, you could have the Text property set to Katmai then assign the command to a number of controls, each control’s Text property will be shown […]

Katmai release date

January 28, 2008

0

According to numerous blog posts, SQL Server 2008 should now be out Q3 2008. I agree with the majority on this that I am happy for this to be delayed as long as we get a stable product. Of course , if this slips any further it could be renamed to SQL Server 2009 however […]

Office 2007 Ribbon

January 25, 2008

0

Ok, not exactly SQL Server related but if any SQL Dev’s out there are interested in GUI development as well and do not know about this fantastic product then I thought it was worth letting you all know. The product is Krypton Ribbon. It mimics the Office 2007 ribbon almost perfectly, getting better on each release.  […]

iFTS

January 25, 2008

0

As SQL Server 2008 CTP6 is now with us I will be doing a post on the new integrated full text search (iFTS) shortly. iFTS includes a number of key changes including support for STOPLIST, mixed query performance, thesaurus improvements and of course full text indexes are stored and maintained inside SQL Server now. There […]

LINQ in Action

January 25, 2008

2

Just a quick post to promote an excellent book on LINQ.  I downloaded early editions of this as it was being written and it is an excellent reference on LINQ. It is now available to buy in printed form so if anyone has the slightest interest in LINQ they should buy this book now. The […]

More TVP..

January 21, 2008

0

I found this screencast on MSDN’s Channel9, its a great addition to Simon’s post especially if you are a more visual person. Table Valued Parameters

Table Valued Parameters

January 21, 2008

0

Simon Sabin posted an excellent article on SQL Server 2008’s Table Valued Parameters today. This saves me writing about it. To read his post, follow the link below: Table Valued Parameters If you have any particular feature you would like me to report on , please leave a comment.

All Change

January 21, 2008

0

I will putting together a piece on Change Tracking over the next couple of days. This is a new feature that will be available in all editions of SQL Server 2008.

A Date with Dates

January 20, 2008

0

There are some interesting changes in the upcoming release of SQL Server 2008, some of which are powerful and sexy (“Spatial data” anyone?) and some have a less of a wow factor but never less are extremely useful. As a start, I wanted to write a special introductory post about the new date and time […]

Sparse Columns

January 20, 2008

0

SQL Server 2008 (“Katmai”) introduces something called Sparse Columns. What this allows you to do is to define a column that rarely contains data. When this is defined the column does not take up any space until it is used. An example of the code required to define the column is shown below. CREATE TABLE […]