Just seen this new KB article; may be worth considering if you are using /PAE to support more than 4GB RAM.
Data is corrupted when PAE is enabled on a Windows Server 2003-based computer http://support.microsoft.com/kb/834628 "...When you run Microsoft SQL Server on a Microsoft Windows Server 2003-based computer, data that is saved to the SQL Server database may be corrupted. This problem may occur if you use the Intel Physical Addressing Extension (PAE) specification to support more than 4 gigabytes (GB) of installed memory in your computer".
Although work is still in progress, I am impressed by the screenshots of the new version of Web Data Administrator for SQL Server http://microsoftsqltools.com/photos/screen_shots/images/17/original.aspx. Go here for more http://microsoftsqltools.com/. This looks like a big improvement on the original release http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en.
I'm on a roll...
Good article on SQL Server 2005 64-bit http://www.microsoft.com/sql/techinfo/whitepapers/advantages-64bit-environment.mspx
Ok, I know I haven't posted for a while... but as it is a new year I thought I'd try and post more frequently.
Some new (and really good) SQL Server 2005 downloads have appeared recently on the microsoft.com. I've listed these below:
SQL Server 2005 Samples and Sample Databases (December 2005) http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en
Troubleshooting Performance Problems in SQL Server 2005http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx
SQL Server 2005 Business Intelligence Metadata Whitepaper http://www.microsoft.com/downloads/details.aspx?FamilyId=182BD330-0189-450C-A2FE-DF5C132D9DA9&displaylang=en
This white paper covers several interesting and unique methods for managing metadata in SQL Server Integration Services, Analysis Services and Reporting Services using built-in features including data lineage, business and technical metadata and impact analysis.
SQL Server 2005 Business Intelligence Metadata Samples Toolkithttp://www.microsoft.com/downloads/details.aspx?FamilyId=11DAA4D1-196D-4F2A-B18F-891579C364F4&displaylang=enMicrosoft
SQL Server 2005 BI Metadata Samples provides tools and samples for analysing dependencies within and across SSIS and SSAS.The source code for the tools is provided. The following are the components of this pack:DependencyAnalyzer: a utility that scans SSIS packages and SSAS databases for enumerating metadata (objects, properties and dependencies).DependencyViewer: a utility to view metadata organization & inter-dependencies (lineage/impact analysis).Analysis Services Samples : sample SSAS packages that can be analyzedIntegration Services Samples: sample SSIS packages that can be analyzedReport Model Samples (Report Builder): report builder modelReports: sample reports built from metadata storeSQL: SQL script for creating metadata store
Yes, its here... The new JDBC driver for SQL Server 2000/2005 http://www.microsoft.com/downloads/details.aspx?FamilyID=e22bc83b-32ff-4474-a44a-22b6ae2c4e17&displaylang=en
I've been keeping my eye on the TechNet Briefings and there are some good SQL Server specific events appearing over the next few months. This one in particular looks useful https://msevents-eu.microsoft.com/cui/EventDetail.aspx?culture=en-GB&eventid=118768584 Upgrading to SQL 2005 – How do I migrate from my existing SQL Server and what are my options? This is scheduled for 28th Feb at the Microsoft UK campus. I'll also be helping out so please come along if you're interesting in migrating to SQL Server 2005.
Thanks to Euan http://blogs.msdn.com/euanga for pointing this out - There is a good post here on ADO.NET 2.0 data access methods from PDC 05 http://blogs.msdn.com/dataaccess/archive/2006/01/09/510083.aspx (includes code samples, slide deck and also the recorded session!)
Just seen this http://www.windowsitpro.com/roadshows/sqlservereurope/.
"Get the facts about deploying SQL Server 2005 in one information-packed day. SQL Server experts will present practical, real-world information in three tracks--administration, development, and business intelligence. You'll come away from the SQL Server 2005 Up & Running Roadshow with a clear understanding of how to put SQL Server 2005 into practice and how to use its new capabilities to improve your database computing environment.
The SQL Server Roadshow has already visited Lisbon, Prague, Reykjavik, Rome, Milan, Istanbul, the Hague, Helsinki, and Dubai and will soon be visiting London and Stockholm"
If you are interested in how our internal IT department deployed SQL Server 2005, then this is a good read http://www.microsoft.com/technet/itsolutions/msit/deploy/movingtosql2005.mspx
If you're in the UK and near the Microsoft office in Reading on 24th January, please come along to the TechNet Briefing Whats NEW in SQL 2005 - Integration Services https://msevents-eu.microsoft.com/cui/EventDetail.aspx?culture=en-GB&eventid=118761630. I will be there along with Matthew Stephen, SQL Server Product Specialist http://blogs.technet.com/mat_stephen/.