Suggestions (RSS)

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

posted Monday, July 02, 2007 9:36 PM by SimonSabin with 0 Comments

Time dimension - What should the key be?

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Time dimension - What should the key be?
The new RSS feed is here

We are currently implementing a data warehouse and the design of the time dimension was recently being done.

Firstly it was agreed that day and time should be split out. Combining the two into one dimension is nuts your dimension would be huge and unworkable.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Time dimension - What should the key be?

posted Tuesday, June 26, 2007 9:04 AM by SimonSabin with 0 Comments

Maintenance plan warning for SP2

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Maintenance plan warning for SP2
The new RSS feed is here

Due to a regression bug introduced in SP2 some of the maintenance plan tasks that can operate on multiple databases may not perform as expected.

If a maintenance plan component uses TSQL of this nature

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Maintenance plan warning for SP2

posted Thursday, March 08, 2007 7:54 AM by SimonSabin with 0 Comments

Team Foundation Server Support for Keyword Expansion

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Team Foundation Server Support for Keyword Expansion
The new RSS feed is here

I remember coming across this last year when looking at TFS and was shocked.

I thought I heard it was going to be added in an service pack but can't find anything to support it.

If you feel that Keyword expansion is needed then please vote on the suggestion at connect

"Vote here Support for TFS keyword expansion"

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Team Foundation Server Support for Keyword Expansion

posted Thursday, November 30, 2006 6:44 PM by SimonSabin with 0 Comments

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

posted Thursday, October 19, 2006 12:59 AM by SimonSabin with 0 Comments

TSQL turning into C#

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/TSQL turning into C#
The new RSS feed is here

Following my previous post about the requirement of semi-colons when using service broker statements, I have raised a suggestion to improve the "Incorrect syntax near ..." error message.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/TSQL turning into C#

posted Friday, October 06, 2006 10:45 AM by SimonSabin with 0 Comments

SQL Server sucks - Stop complaining and do something about it

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 sucks - Stop complaining and do something about it
The new RSS feed is here

Further to my last post about the BULK UPDATE suggestion I have made, if you have any suggestions or bugs of your own then please put them into connect.

Please also support the bugs and suggestions that others have raised. The list of non-closed bugs and suggestions can be found here.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server sucks - Stop complaining and do something about it

posted Wednesday, October 04, 2006 8:58 PM by SimonSabin with 2 Comments

SQL Engine - BULK UPDATE command

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 Engine - BULK UPDATE command
The new RSS feed is here

You can achieve very high performance with the BULK INSERT interfaces in SQL Server 2005, from SSIS, ADO, TSQL or plain old bcp.

Many times you would like to be able to perform bulk updates with the same performance, however there is no command to support this.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Engine - BULK UPDATE command

posted Wednesday, October 04, 2006 8:43 PM by SimonSabin with 0 Comments

SSIS - Feature requests for annotations

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 - Feature requests for annotations
The new RSS feed is here

I was looking through the feedback in connect and saw a suggestion about wrapping text in annotations. If you've tried to be a good citzen of developer land you will have come across the fact that annotations don't word wrap. If you find that annoying then please vote.

In addition I have added another suggestion that annotations are tied to transforms and tasks

Finally I have requested that annotations can be formatted i.e. make them bold, italic etc. some packages are complicated so annotations are key to understanding the package.

Please support these suggestions

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS - Feature requests for annotations

posted Monday, October 02, 2006 10:47 PM by SimonSabin with 1 Comments

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?

posted Wednesday, September 20, 2006 6:41 PM by SimonSabin with 1 Comments