SimonS Blog on SQL Server Stuff - All Comments

The Technology Post for June 30th, 2009 | I love .NET!

The Technology Post for June 30th, 2009 | I love .NET! — Wed, 01 Jul 2009 06:01:47 GMT

Pingback from The Technology Post for June 30th, 2009 | I love .NET!

The Technology Post for June 30th, 2009 | Nexo IT - Information Technology News

The Technology Post for June 30th, 2009 | Nexo IT - Information Technology News — Wed, 01 Jul 2009 04:07:50 GMT

Pingback from The Technology Post for June 30th, 2009 | Nexo IT - Information Technology News

Disabling the beep

Rob Farley — Tue, 30 Jun 2009 10:30:33 GMT

I thought I’d blogged about this before, but when talking about with Simon Sabin just now, I couldn’t

Morning C# news – and more « C# Hacker – The Rambling Coder

Morning C# news – and more « C# Hacker – The Rambling Coder — Mon, 29 Jun 2009 13:07:53 GMT

Pingback from Morning C# news – and more « C# Hacker – The Rambling Coder

Twitted by MVPAwardProgram

Twitted by MVPAwardProgram — Mon, 29 Jun 2009 09:12:36 GMT

Pingback from Twitted by MVPAwardProgram

Hyperlinks in custom reports

SimonS Blog on SQL Server Stuff — Mon, 29 Jun 2009 07:49:27 GMT

One feature introduced SQL Server 2005 is the reporting. You have a set of standard reports that allow

Migracja id-parentid do hiererchyid | itsouldiers.com/blog

Migracja id-parentid do hiererchyid | itsouldiers.com/blog — Thu, 25 Jun 2009 13:56:17 GMT

Pingback from Migracja id-parentid do hiererchyid | itsouldiers.com/blog

re: Exporting XML data from SSIS - nugget

simonsabin — Tue, 23 Jun 2009 20:34:13 GMT

That is a unsupported custom component though.

The other option is to resort to a script task, but the use of the export column removes the need to do that.

It is also able to do multiple files.

As for transforming, you could do that in SQL

re: Exporting XML data from SSIS - nugget

jwelch — Tue, 23 Jun 2009 15:18:46 GMT

There's a pre-built XML destination at www.codeplex.com/SQLSrvIntegrationSrv.

Useful if your XML output needs to go through significant transformation before being saved.

Cambridge user group correction

SimonS Blog on SQL Server Stuff — Tue, 23 Jun 2009 09:53:54 GMT

I incorrectly said in my last blog post sqlblogcasts.com/.../Cambridge

SQL Server 2008 R2 CTP

Charley Hanania — Sun, 21 Jun 2009 13:25:42 GMT

You may have read my post on the next version of SQL Server coming out called SQL Server 2008 R2, which

SSIS Rawfile viewer

Charley Hanania — Sun, 21 Jun 2009 13:15:14 GMT

One of my colleagues griped about SSIS Raw files recently, so I thought I'd quickly post the link

Long Distance Router

Long Distance Router — Fri, 19 Jun 2009 19:46:11 GMT

Routers have come a long time in the last few years it's amazing how much they've changed.

re: When a query plan goes wrong

simonsabin — Wed, 17 Jun 2009 19:39:56 GMT

Allan Mitchell of SQLIS.com fame and fellow SQL MVP pointed me to a post from the sqlperf blog that highlighted exactly this issue.

re: SQL Server 2005 Performance analysis whitepaper

shaleah — Mon, 15 Jun 2009 14:06:37 GMT

thanks