We are nearing the max numbers we can afford for the
Saturday of SQLBits V. So if you are thinking of coming then make sure you
register soon.
More importantly, if you have said you are coming to the Saturday (most of
you) and you can no longer make it, please update your registration
accordingly. We have to cater for all the number registered and so if you
don't come we will still be paying the venue for you. So please keep your
registration updated.
Luke Hayler's been talking about going to SQLBits, Network
and logistics of getting there
http://www.lukehayler.com/2009/09/sqlbits-here-i-come/
-
We are going to an evening of SQL Server Query tuning on
the 29th October in Cambridge
Its going to be at the Bango offices.
Keep posted for more details.
If you want to notified of the event, then use the contact form
above.
-
Call me picky but it bugs me when things aren't in
order. The SQL team seem to be really bad at this particular annoyance. They
seem unable to put things in a nice order.
If you are loking at packages in Management Studio then you will find the
packages in totally random order, why is that you. Well they haven't put an
ORDER BY on the query that lists the packages, and we all know that without and
ORDER BY there is not guarantee of the order of the results.
To fix this you can hack one of the system stored procs. sp_dts_listpackages
This package is found in msdb it is classed as a system procedure and so is
in the system procedures folder (if looking in object explorer).
If you change it to
ALTER PROCEDURE [dbo].[sp_dts_listpackages]
@folderid uniqueidentifier
AS
SELECT
name,
id,
description,
createdate,
folderid,
datalength(packagedata),
vermajor,
verminor,
verbuild,
vercomments,
verid
FROM
sysdtspackages90
WHERE
[folderid] = @folderid
ORDER BY name
You will get your packages ordered nicely by name.
-