January 2009 - Technical Rollup Mail - SQL Server
News
Technical RollUp
https://blogs.technet.com/trm/default.aspx
Documents
Accessing External Data Sources with Microsoft SQL Server Analysis Services 2005
https://msdn.microsoft.com/en-us/library/aa964120(SQL.90).aspx
Accessing SQL Server Databases with PHP
https://msdn.microsoft.com/en-us/library/cc793139(SQL.90).aspx
Geo-Replication Performance Gains with Microsoft SQL Server 2008 Running on Windows Server 2008
Microsoft.com Engineering Operations (MSCOM Ops), the team responsible for architecting and managing many of the most heavily trafficked Microsoft Web sites, recently documented substantial replication performance improvements for both push and pull subscriptions in Microsoft® SQL Server® 2008 running on Windows Server® 2008—up to 100 times faster than Microsoft SQL Server 2005 running on Windows Server 2003. This paper provides IT pros with an in-depth look at the tests conducted by the MSCOM Ops team, insight into the results, and technical analysis of the enhancements to Windows Server 2008 and SQL Server 2008 that enable wide area network (WAN)–based geo-replication.
https://msdn.microsoft.com/en-us/library/dd263442.aspx
Running SQL Server 2008 in a Hyper-V Environment - Best Practices and Performance Recommendations
SQL Server Replication: Providing High Availability using Database Mirroring
Downloads
CAT.NET V1 CTP
CAT.NET is a binary code analysis tool that helps identify common variants of certain prevailing vulnerabilities that can give rise to common attack vectors such as Cross-Site Scripting (XSS), SQL Injection and XPath Injection.
SAP Documents
Technical documentation for SAP implementation on Microsoft Windows platform.
CAT.NET V1 CTP 64 bit
CAT.NET is a binary code analysis tool that helps identify common variants of certain prevailing vulnerabilities that can give rise to common attack vectors such as Cross-Site Scripting (XSS), SQL Injection and XPath Injection.
SQL Server 2005 Books Online (December 2008)
Download an updated version of the documentation and tutorials for Microsoft SQL Server 2005. See the "Additional Information" section for an update on SQL Server Express Books Online.
SQL Server 2005 SP3
Download Service Pack 3 for Microsoft SQL Server 2005.
Feature Pack for SQL Server 2005 December 2008
Download the December 2008 Feature Pack for Microsoft SQL Server 2005, a collection of standalone install packages that provide additional value for SQL Server 2005.
Microsoft SQL Server Protocol Documentation
The Microsoft SQL Server protocol documentation provides technical specifications for Microsoft proprietary protocols that are implemented and used in Microsoft SQL Server 2008.
SQL Server 2005 Express Edition with Advanced Services SP3
Microsoft SQL Server 2005 Express Edition with Advanced Services is a free, easy-to use version of SQL Server Express that includes more features and makes it easier than ever to start developing powerful data-driven applications for web or local desktop development.
SQL Server Management Studio Express SP3
Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services.
SQL Server 2005 Express Edition Toolkit SP3
Microsoft SQL Server 2005 Express Edition Toolkit provides additional tools and resources for SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services.
SQL Server 2005 Express Edition SP3
Microsoft SQL Server 2005 Express Edition is a free, easy-to-use, lightweight version of SQL Server 2005. It is fast and easy to learn, allowing you to quickly develop and deploy dynamic data-driven applications.
SQL Server Data Mining Add-ins for Office 2007
Download SQL Server 2005 Data Mining Add-ins for Office 2007. This package includes two add-ins for Microsoft Office Excel 2007 (Table Analysis Tools and Data Mining Client) and one add-in for Microsoft Office Visio 2007 (Data Mining Templates).
SQL Server Reporting Services Add-in for SharePoint Technologies
The Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.
Microsoft SQL Server 2005 SP3 Readme
Before you install Microsoft SQL Server 2005 Service Pack 3 (SP3), download, extract, and read the SP3 Setup documentation, and review the SP3 Readme files.
Web Platform Installer Release Candidate
The Microsoft Web Platform Installer (release candidate) is a free tool that makes it simple to download and install the latest components of the Microsoft Web Platform, including the IIS, SQL Server Express, .NET Framework and Visual Web Developer.
SQL Server 2008 Enterprise and Standard Feature Compare
SQL Server 2008 Enterprise and Standard Feature Compare
SQL Server MP for OpsMgr 2007
The Microsoft SQL Server Management Pack for Operations Manager 2007 provides discovery and monitoring of SQL Server 2000, 2005 and 2008.
Microsoft SQL Server 2008 Enterprise Evaluation: Trial Experience for IT Professionals
Download SQL Server 2008 180-day Trial Software. Microsoft SQL Server 2008 is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data analysis and reporting solutions.
Microsoft SQL Server 2008 Enterprise Evaluation: Trial Experience for Developers
Download SQL Server 2008 180-day Trial Software. Microsoft SQL Server 2008 is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data analysis and reporting solutions.
SQL Server 2008 RDL Spec
SQL Server 2008 RDL Spec
Microsoft® Visual Studio Team System 2008 Database Edition GDR
Microsoft® Visual Studio Team System 2008 Database Edition GDR implements support for SQL Server 2008.
SQL Server 2008 Upgrade Technical Reference Guide
This 490-page document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. It is intended to be a supplement to SQL Server 2008 Books Online.
Events/Webcasts
SQL Server 2005 Service Pack 3 Now Available
https://msdn.microsoft.com/en-gb/sqlserver/bb895958.aspx
High Performance Computing (HPC) Traditional computing takes the form of an application running on a server or workstation. All of the commands for the application are processed on the local system. High Performance Computing (HPC) instead uses the processing power of multiple systems to process the commands for an application. Distributing the processing load across multiple systems allows for faster processing of the data. https://msdn.microsoft.com/en-us/sqlserver/dd353223.aspx TechNet Webcast: Protect SQL Server 2008 with Data Protection Manager 2007 (Level 300) Are you deploying or migrating to Microsoft SQL Server 2008? Microsoft System Center Data Protection Manager 2007 is designed for the database administrator or the IT generalist. Data Protection Manager 2007 uses wizards and workflows to help ensure that you can protect your organization's data, and it doesn't require an advanced degree, training, or certification in storage and backup technologies. Attend this webcast to learn more. https://www.microsoft.com/events/series/detail/webcastdetails.aspx?seriesid=111&webcastid=5011 |
TechNet Webcast: 24 Hours of SQL Server 2008: Performance Troubleshooting (Level 200)
An area of concern for Contoso is the monitoring and troubleshooting of any performance issues it may encounter on Microsoft SQL Server 2008. In this session, we cover the tools available for IT departments as they troubleshoot performance. We look at Performance Studio, the features available, and how to use them to analyze performance. We also cover how to use the Best Practice Analyzer for SQL Server, and utilizing the results it provides.
https://www.microsoft.com/events/series/detail/webcastdetails.aspx?seriesid=111&webcastid=4731
TechNet Webcast: 24 Hours of SQL Server 2008: Streamlining Data Integration (Level 200)
To load data into the Contoso enterprise data warehouse, Contoso uses Microsoft SQL Server 2008 Integration Services. In this webcast, we review the new features in Integration Services that help Contoso streamline the development and execution of processes to extract, transform, and load data into the data warehouse: ADO.NET connectivity, persistent lookups, pipeline improvements, and data profiling. We also examine alternatives for managing changing data in the data warehouse using the Change Data Capture function and MERGE command. Demonstrations on using an ADO.NET data source, working with lookup caches, identifying dirty data with data profiling, and using Change Data Capture and MERGE for slowly changing dimensions are included in this webcast.
https://www.microsoft.com/events/series/detail/webcastdetails.aspx?seriesid=111&webcastid=4875
New KB's
SQL 2005
SQL Svr Standard Edtn 2005 EN: Microsoft SQL Server Service pack 3 (SP3)
SQL 2005
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you install Cumulative Update 10 or Cumulative Update 9 for SQL Server 2005 Service Pack 2 on a drive that uses the FAT32 file system: "Unexpected Error Occurred"
https://support.microsoft.com/kb/959132/EN-US
SQL Svr Standard Edtn 2005 EN: MDX: Calculated member without parent is treated as level 1 in DESCENDANTS function
https://support.microsoft.com/kb/960532/EN-US
SQL 2008
SQL Svr Standard 2008 EN: In a localized Microsoft Windows operating system, the English version of the context-sensitive Help for SQL Server 2008 Report Builder is displayed instead of the localized context-sensitive Help
https://support.microsoft.com/kb/960124/EN-US
SQL Svr Developer 2008 EN: Error message when you install the 64-bit version of SQL Server 2008 Business Intelligence Development Studio: "Upgrade Failed due to the following Error. The error code is: -2147467259.Message:Unspecified error"
https://support.microsoft.com/kb/960127/EN-US
SQL Svr Express Edition 2008 AL: Error message when you upgrade from MSDE 2000 to SQL Server 2008 Express: "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible."