Welcome to TechNet Blogs Sign in | Join | Help

Post Event Follow Up (RSS)

Follow up on XPs and SQLiMail question from SQL Server™ 2005 Management and Admin TechNet evening 28/7/05

Sorry for the delay in getting these answers posted but my trip to the US and some hols have got in the way. I was asked if SQL Express could handle Extended Stored Procedures unlike msde.  The answer is msde can handle XPs and so can SQL Express. 

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

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

Follow up on Replication Columns question in my TechNet SQL 2005 presentation (14/6/05)

Question:  How many columns does SQL Server 2005 allow in a published article (SQL Server 2000 was linited to 254)? Answer: The column limit for transactional replication, I'm informed, is now in excess of 1000. 

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

Database Mirroring: How many witness can you have in quorum? - One How many witnesses can you have on one box? - Many

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

Peer to Peer replication demo code from SQL Server 2005 TechNet evening on the 14th June at our Reading office

You can find all the code @ http://blogs.technet.com/mat_stephen/articles/406459.aspx

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