|
|
September 2005 - Posts
-
As I said earlier , Ryan Clay talked about a new feature to enable covering indexes in SQL Serve 2005. I didn't know about it beforehand so perhaps other people don't either. I'll try and elaborate here. So what is a covering index? Put simply...if you Read More...
|
-
Here's yet more for my wish list for the next version of SSIS. This came out of a conversation with Jason Workman at PASS yesterday. It would be really useful to distribute workload to different machines so as to take advantage of more resources. For Read More...
|
-
The first session today was "Real-time OLAP" as delivered by Aaron Solomon from Hitachi Consulting. A really great session - I learned alot about pro-active caching, SSIS tasks & components that integrate with Analysis Services, AS partitions and Read More...
|
-
I'm sitting here in the Thursday morning keynote which is basicaly an HP sales pitch - a real yawnathon- so I'm taking the opportunity to write this post instead. In my opinion the really great thing about PASS isn't the opportunity to learn stuff in Read More...
|
-
Nick Barclay has begun writing his own blog at http://nickbarclay.blogspot.com/ . Why am I telling you this? Well firstly its going to be about SSIS - nothing new there. Secondly, I know Nick has got some really useful stuff to share. Earlier this year Read More...
|
-
Here's something I picked up from Bob Beachemin's pre-conf today that I never knew about. You can capture the data that is inserted/updated into a table using the INSERTED table that often gets used in triggers. Why is this useful? One reason...identity Read More...
|
-
So day 2 really started out when we hit the bar last night. It was a good night for meet and greets. I finally met Allan Mitchell from SQLIS.com whom I've been talking to for ages without ever actually being in the same room. I also met some rather well Read More...
|
-
We're here! Only a 10-hour flight but Jon, Christian and myself touched down at Dallas Fort Worth almost on time, to baking hot sunshine and stifling humidity! Well I shouldn't complain, it beats the cold of Aberdeen which is where I've been the last Read More...
|
-
A short one this. I've just been attempting to install SQL Server September CTP. I uninstalled the previous version and also the the previous version of Visual Studio. When I tried re-installing Visual Studio I got a message saying that Microsoft Device Read More...
|
-
PASS 2005 kicks off in 3 days time and the Conchango powers that be have decreed that, Rita permitting, I'm gonna be there!! I'm looking forward to meeting god knows how many people that I've "virtually" met over the past year or so. Please come and say Read More...
|
-
I have just been asked by someone, " what is the recommanded way to implement the splitter patterne with an SSIS DataFlow ", asked in the context of this article: http://www.enterpriseintegrationpatterns.com/Sequencer.html which talks about splitting Read More...
|
-
Greg Foder of Parature emailed me recently with a method for processing different data sources using just one data-flow. In his very specific scenario there were common columns across all of the source tables that he wanted to process however they were Read More...
|
-
According to the good Mr Haselden Microsoft are going to be bring out a tool called "SQL Documenter" that will traverse SQL Server objects and servers and then build operational metadata reports (RS reports one would hope) based on what it finds. And, Read More...
|
-
Raul Villaronga posed a question on the SSIS forum today regarding the FileSystem task at http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=85827 The FileSystem task can move and rename files but Raul wanted to do both of those operations at the same Read More...
|
-
The SSIS script component rocks, don't you think? I think I might have made this point before on 4 or 5, possibly a few hundred, occasions. The ability it gives you to incorporate the power of the .Net framework and your own assemblies into the SSIS pipeline Read More...
|
-
I thought this was pretty cool. If ever you needed reminding about just how insignificant we are in the grand scheme of things, take a look at this: http://www.molecularexpressions.com/primer/java/scienceopticsu/powersof10/index.html Thanks to Mac for Read More...
|
-
It is generally accepted that a synchronous script component outputs the same number of rows as are input. Well I have news for you, this doesn't have to be the case. If you have a synchronous script component with multiple outputs then you can choose Read More...
|
-
Hello, I've had a few people contact me lately either by adding comments to one of my blog posts or by using the "Contact Me" link on my blog homepage. Some people have been asking me direct questions, which is great, but I feel bad cos due to problems Read More...
|
-
In SQL Server Integration Services (SSIS) variables have scope (this was not the case in the forerunner DTS). A variable can be accessed from any container that is an ancestor of the container to which the variable is scoped. This means that, for example, Read More...
|
|
|
|