Katmai - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » Katmai (RSS)
24 April 2008 09:46

SQL Server 2008 UK Usergroup London Launch event

SQL Server 2008 UK Usergroup London Launch event As part of the SQL Server Launch wave we are holding a usergroup meeting to celebrate the launch (not RTM). We're going to run this as an open session so you'll be able to ask us to cover the areas...
Posted by simonsabin | with no comments
Filed under: , , ,
11 April 2008 16:27

SQL Server 2008 - Breaking bug

If you are using CTP6 of SQL Server 2008 and want to use Integrated Full Text and find it is not working. You might get timeouts or other general errors. It could be due to an account that iFTS uses. iFTS does some stuff out of process for security and...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
31 March 2008 10:13

SQL Server 2008 - HierarchyId - How do you move nodes/subtrees around

In a recent post SQL Server 2008 - HierarchyId whats the point? I talk about the scenarios that the new hieararchyId can be applied to. Here we expand on this further and also provide a solution for moving hierarchies around. The limitation is that you...
Posted by simonsabin | 2 comment(s)
Filed under: , , ,
29 March 2008 23:40

SQL Server 2008 - HierarchyId whats the point?

I've recently been deliverying training sessions on SQL Server 2008 and doing launch events. The training covers all aspects of SQL Server development. For most features I can provide a strong argument for the feature with the exception of one. HierarchyId...
Posted by simonsabin | 1 comment(s)
Filed under: ,
19 December 2007 16:19

SQL Server 2008 Spatial - Got a question?

If you got a question about the spatial stuff in SQL Server 2008 make sure you visit the msd Spatial forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1629&SiteID=1 The guys from the team that developed it hang out there so you should...
Posted by simonsabin | 1 comment(s)
Filed under: , ,
17 December 2007 23:24

SQL Server 2008 Filestream : Why?

Why would you want to use filestream in SQL Server 2008? The files you store using filestream in SQL Server 2008 are not accessible directly using the normal io methods.Instead you have to make a SQL call to get a pointer which you can then use with normal...
Posted by simonsabin | with no comments
Filed under: , ,
12 December 2007 15:06

Katmai Spatial - Whats a dimension?

When you read the specs for the spatial stuff (BOL has some incorrect links) some of the methods talk about min and maximum geometry dimensions. I must have been doing too much analysis services stuff and for the life of me I couldn't figure out what...
Posted by simonsabin | with no comments
Filed under: , , ,
09 December 2007 22:50

Katmai Spatial - What's a geometry

Following on my previous post on discovering the spatial types I mention that one of the aspects to understand is the different types of geometries. Point Fairly this is obvious its a single spot that has an X and a Y co-ordinate. Multi Point A group...
Posted by simonsabin | with no comments
Filed under: , , , , ,
09 December 2007 21:43

Katmai Spatial - First thoughts

I've been doing some work with the Spatial types in Katmai and these are my first thoughts. The first thing is that the data type is the same used by SQL as used in your .Net code. So what does that mean, · You use the same methods, which is great from...
Posted by simonsabin | 5 comment(s)
Filed under: , , , , , ,
18 October 2007 23:38

Katmai Features I Love Part 1

I've seen it and I love it. If you've ever used Visual studio you would know that you can expand and collapse blocks of code to make your code readable. Well in Katmai you will be able to do this in management studio. So if you've got big sps then you...
Posted by simonsabin | 1 comment(s)
Filed under: , ,
29 August 2007 18:18

Katmai - Connecting from SQL2005

UNfortunately you canot connect from SQL2005 to SQL 2008 (Katmai) from management studio, or can you. It appears the validation code is in the main connection dialog. However if you use SQLCMD mode you will be fine. So connect to you SQL2005 server and...
Posted by simonsabin | with no comments
Filed under: , ,
16 August 2007 22:44

Whats in a BOL link?

In using BOLyou will have noticed that the links in BOL contain some lovely guids. I often want to reference BOL in documents, forum posts etc but was concerned that the guids might change. So I asked Alan Brewer whether they change or not. He gave me...
Posted by simonsabin | 1 comment(s)
Filed under: , , , ,
01 August 2007 07:48

Katmai - July CTP is now available

Contrary to the home page of Connect which says June CTP. The July CTP is now available. Some of the features in this CTP are · Large User defined types o Need more that 4000 bytes here you go · Date and time data types o You can now store just the date...
Posted by simonsabin | 2 comment(s)
Filed under:
02 July 2007 21:36

SSIS : Web Service task doesn't cut it but who cares

18 months ago I was trying to use the SSIS web service task for a number of purposes. The first was to integrate with SalesForce, the second was to manage reporting services. Unfortunately the Integration Services (SSIS) web service task doesn't work...
Posted by simonsabin | with no comments
Filed under: , , , ,
04 June 2007 22:02

SSIS - Sweet sight - Visual Studio 2005 Tools For Applications

I've metioned it before but the proof is in the pudding. On doing an install of Sql Server 2008 (Katmai) I was very pleased to see a step installing Visual Studio 2005 Tools for Applications So why am I so excited, because it allows you to write in C#...
Posted by simonsabin | 3 comment(s)
Filed under: , ,
More Posts Next page »