SimonS' SQL Server Stuff

Katmai - Connecting from SQL2005

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Katmai - Connecting from SQL2005
The new RSS feed is here

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.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Katmai - Connecting from SQL2005

Whats in a BOL link?

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Whats in a BOL link?
The new RSS feed is here

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 to publish here.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Whats in a BOL link?

Katmai - July CTP is now available

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Katmai - July CTP is now available
The new RSS feed is here

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

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Katmai - July CTP is now available

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

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS : Web Service task doesn't cut it but who cares
The new RSS feed is here

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 I'm not sure what web services it does support.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS : Web Service task doesn't cut it but who cares

SSIS - Sweet sight - Visual Studio 2005 Tools For Applications

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS - Sweet sight - Visual Studio 2005 Tools For Applications
The new RSS feed is here

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

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS - Sweet sight - Visual Studio 2005 Tools For Applications

SQL Server 2008 (Katmai) June CTP available for download

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Server 2008 (Katmai) June CTP available for download
The new RSS feed is here

If you haven't heard the June CTP of SQL Server 2008 (Katmai) is available for download from connect.

When you go to the download if you are based in Europe I suggest that you select Europe as the download site, which for once provides a fantastic download rate. I'm currently getting 1.4Mb/s :)

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server 2008 (Katmai) June CTP available for download

Katmai - Group Policy for SQL Server

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Katmai - Group Policy for SQL Server
The new RSS feed is here

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.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Katmai - Group Policy for SQL Server

Katmai new features - Spatial indexing

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Katmai new features - Spatial indexing
The new RSS feed is here

A press release went out today about Katmai the next version of SQL Server.

There are some really exciting developments. Spatial indexing being one of them.

Yes spatial is going first class, no more need for writing your own CLR code, this stuff will be in the engine.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Katmai new features - Spatial indexing

OLAP or Relational? Its all irrelevant

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/OLAP or Relational? Its all irrelevant
The new RSS feed is here

Chris Webb has mentioned an article about Ralph Kimball that discusses the what tool you should be using at the end of your BI process to present back to users. Should it be OLAP based or Relational based.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/OLAP or Relational? Its all irrelevant

PASS 2006 - Shared disk is not a scale out solution

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/PASS 2006 - Shared disk is not a scale out solution
The new RSS feed is here

At the end of the keynote today, Paul Flessner joined Steve Balmer for a short Q&A. One of the questions was around SQL Servers response to the Oracle RACK solution to provide a scale out solution.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/PASS 2006 - Shared disk is not a scale out solution

CREATE or REPLACE feature request

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/CREATE or REPLACE feature request
The new RSS feed is here

I remember back when I moved from Oracle to 6.5 I found the lack of a create or replace really annoying. Whenever I create new sps I always curse at not being able to do "create or replace myproc..." having to do "if exists (select 1 information_schema...)" or "if object_id(...) is not null" or "if not exists(select 1 from sys.objects..)" is really annoying, especially as there are so many different options.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/CREATE or REPLACE feature request

Performance improvements for Katmai the next version of SQL Server

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Performance improvements for Katmai the next version of SQL Server
The new RSS feed is here

If you use SQL Server and have a great suggestion for performance improvements to the engine then post them at the sql tips blog because they want to know
http://blogs.msdn.com/sqltips/archive/2006/09/20/TOP_5_DW_PERF_IMP_NEXT_SQL.aspx

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Performance improvements for Katmai the next version of SQL Server

Full text suggestions for SQL Server 2007?

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Full text suggestions for SQL Server 2007?
The new RSS feed is here

Who knows when it will be out, but these are 2 of my suggestions for enhancing Full Text.

Allowing it to index documents outside of the database.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=208632

and incorporating it as a first class index or add the ability to include other non text columns in the full text index so when someone does a search for a common keyword performance doesn't hit the floor.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=208636

Its free to make suggestions, just go to the connect website and fire away.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Full text suggestions for SQL Server 2007?