New Microsoft SQL Server 2005 Upgrade Advisor - CTP June Refresh

Last night at the TechNet evening in Reading I was asked if we are planning an upgrade event.  I couldn’t say last night, but now I’m glad to say yes we are.  In the week starting 5th Decemer we are planning a SQL focus day – during which we will cover this topic. However in…

2

Follow up on Database snapshot performance question from SQL Server™ 2005 High Availability TechNet evening 21/6/05

Follow up on Database snapshot performance question from SQL Server™ 2005 High Availability TechNet evening 21/6/05   Question; how does a snapshot database perform compared to the original database when it comes to querying – can it make use of the indexes on the original database?   Thanks to my colleague in the States, Lewis…

0

More follow up from my TechNet SQL 2005 presentation (14/6/05) - SMP boxes and database files

During my TechNet presentation on Tuesday evening (14/6/05 in Reading), I got a little side tracked and, while talking about partitioning in SQL 2005, found myself drawing my audiences’ attention to the fact that only one thread can access a database file at any one time.  This fact being the foundation to my post http://blogs.technet.com/mat_stephen/archive/2005/02/02/365325.aspx…

2

London roadshow follow up: Selective execution of SQL Server Integration Service Tasks and Transforms

I had a question, at the London roadshow (8th June), which I wasn’t sure if I could answer reliably, so I promised to blog the answer. The question: “Can I run selected (with mouse) tasks and transforms from inside the SQL Server Integration Services package designer?” The answer I have is, for transforms, no you can’t. …

1