in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » Katmai » Tips and Tricks (RSS)

Browse by Tags

  • 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 can't do something like this to change the parent...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Mar 31 2008

  • 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 of points that are not connected. (if they were connected...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Sun, Dec 9 2007

  • 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 a familiarity perspective · When calling the...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Sun, Dec 9 2007

  • 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 can easily simplify the view by expanding...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Oct 18 2007

  • 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 then issue a :connect MyKatmaiServer Anything after...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Aug 29 2007

  • 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 a great response which I've got his permission...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Aug 16 2007

  • 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 for these web services. On further investigation...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Jul 2 2007

  • Katmai - Group Policy for SQL Server

    If you've worked in a large AD shop you will have come across Group Policy. A means by which you can make sure each component in a domain has the same settings, behaves the same way, has the same security. This is essential when managing a large server estate. Unfortunately Group Policy doesn't...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, May 9 2007
Page 1 of 1 (8 items)
Powered by Community Server (Commercial Edition), by Telligent Systems