Welcome to blogs.conchango.com

This is a Public Service Announcement.  Attunity makers of all things connect-y for SSIS are putting on a webinar for their latest product Oracle CDC for SSIS. It’s an enabling solution that accelerates the development of real time data integration with Oracle systems. The event is to be held online on Monday, June 22, 2009 10:00 AM - ...

A couple of years ago I worked on an issue with my colleague Steve Wright about an issue with merge replication.  You can read Steve’s original post here.  However, in summary, the issue boiled down to a security check that merge replication was performing in a generated view called ...

[I had to call this out because I think its a cool example of what can be done with SSDS.] Mike Amundsen is a guy that really grasped the SSDS nettle. First he built the SSDS provisioning client (http://amundsen.com/examples/ssds/data-client/) and now he's built a simple application that is basically a Twitter clone, see it at ...

AAAaaaaah...Yesterday was just one of those days.  I was trying to do something very simple in a script task - assign the current datetime value to one of my variables - and was pulling my stubbly hair out trying to do it. I am happy to confess to not being the strongest .netter in the world but we do also in SSIS get a pretty pony script ...

So as suspected when I installed the new Security patch released by Microsoft for SQL 2005 sp2 that I mentioned this morning my build number has indeed shot up to 3233.  This places me somewhere between CU6 and CU7. Build 9.00.3228 was CU6 and 9.00.3239 is CU7. So just bear in mind that when you plop on your patch you are actually taking a ...

And so the great run comes to an end... For the full details of this incident please click here. N.B. This also affects Windows. However this is released under a different KB article. For the SQL 2005 sp2 KB article look at this link http://support.microsoft.com/kb/948108 For SQL 2000 GDR and MSDE 2000 KB article look at this one ...

  This issue caught me out today whilst putting together some build scripts for reference data. So I thought I’d share it. USE [tempdb] GO CREATE TABLE [dbo].[Table_1](       [Col1] [int] IDENTITY(1,1) NOT NULL,       [Col2] [char](1) NOT NULL ) ON [PRIMARY] GO delete from ...

Monday 30th June 2008. On Monday evening we were very fortunate to have Michael Rys present to the UK SQL Server User Group hosted at Conchango's offices here in London.  Michael has one of the longest job titles I have ever seen.  He's the "Principal Program Manager Lead for SQL Server's Beyond Relational Team".  I take ...

Not a lot more to say about this other than... HURRY.  You only have till the 4th July to get those abstracts written and your sessions submitted. SQLBits is a really great community event and this one is going to be the biggest ever.  We are aiming for 450 delegates this time and expect those sessions to be as wide and varied as ...

This one is a bit surprising. Assume you have a cold SQL Server which you have just re-booted.  The buffer cache is empty and lots of I/O requests are going to be physical. Boo! Hiss!  Down with physical I/O. Well help is at hand (if you are using SQL Server Enterprise Edition). Ramp-up is the process of converting your I/O's from page ...