July 2005 - Posts
June CTP Refresh of the SQL Server 2005 Upgrade Advisor can be downloaded from here http://www.microsoft.com/downloads/details.aspx?FamilyID=cf28daf9-182e-4ac2-8e88-f2e936558bf2&DisplayLang=en .
Read More...
I've been hitting quite a few bugs in the Integration Services June CTP recently; some are minor and others not so. Hopefully we won't have to wait too long until the final CTP in August/September. I'm finding many uses for package configurations and
Read More...
Please take some time to look at the SQL Server TechCenter http://www.microsoft.com/technet/prodtechnol/sql/default.mspx , particularly the SQL Server 2005 Business Intelligence section http://www.microsoft.com/technet/prodtechnol/sql/2005/BI/default.mspx
Read More...
I've just read a good article which discusses using SQL Server in a hyper-threaded environment http://support.microsoft.com/kb/322385 . To cut a long story short, we recommend that the maxdop (maximum degree of parallelism) setting should remain equal
Read More...
I've just discovered a new 3rd party add-on for Integration Services by Ivolva.com. There is a SSIS wizard http://www.ivolva.com/ssis_wizards.html which simplifies the process of creating a custom task or data flow component. There is also the Extra Sort
Read More...
Go here for free online learning for SQL Server 2005: https://www.microsoftelearning.com/sqlserver2005/ - not bad as a starting point...
Read More...
We've had some interesting questions during the first day on the ATE stand at Tech-Ed in Amsterdam. These have ranged from: 1. How does the optimiser work? to 2. Where can I download SQL Server 2005 from? There was also quite a lot of interest around
Read More...
I have seen enough black Tech-Ed bags to send me blind..... Pre-conf was good, I decided to attend the VB6 to VB.NET session and it was surprisingly very good - I thought I'd 'keep in touch' with the developer platforms since the CLR is going to be a
Read More...
