Partager via


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

https://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SQL2008inHyperV2008.docx

 

SQL Server Replication: Providing High Availability using Database Mirroring

https://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/ReplicationAndDBM.docx

 

 

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=1&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d0178e2ef-9da8-445e-9348-c93f24cc9f9d%26displaylang%3den  

 

SAP Documents

Technical documentation for SAP implementation on Microsoft Windows platform.

https://www.microsoft.com/downloads/info.aspx?na=22&p=2&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d63d54a72-bc62-43cf-8eae-444935e08b40%26displaylang%3den  

 

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=3&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3de0052bba-2d50-4214-b65b-37e5ef44f146%26displaylang%3den  

 

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=4&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dbe6a2c5d-00df-4220-b133-29c1e0b6585f%26displaylang%3den  

 

SQL Server 2005 SP3

Download Service Pack 3 for Microsoft SQL Server 2005.

https://www.microsoft.com/downloads/info.aspx?na=22&p=5&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dae7387c3-348c-4faa-8ae5-949fdfbe59c4%26displaylang%3den  

 

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=6&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d536fd7d5-013f-49bc-9fc7-77dede4bb075%26displaylang%3den  

 

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=7&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d91ef5106-944a-41e1-b3a0-5bd3f2356f32%26displaylang%3den  

 

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=8&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3db448b0d0-ee79-48f6-b50a-7c4f028c2e3d%26displaylang%3den  

 

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=9&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d5d76230d-580d-4874-8c7d-93491a29db15%26displaylang%3den  

 

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=10&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dd434dc36-a24d-44ee-937e-553c382557e3%26displaylang%3den  

 

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=11&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d3181842a-4090-4431-acdd-9a1c832e65a6%26displaylang%3den  

 

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).

https://www.microsoft.com/downloads/info.aspx?na=22&p=12&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d8c873841-61a1-444c-a40b-ab62cf136be8%26displaylang%3den  

 

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=13&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d0acb75a6-7c1d-4e2b-af69-7e5f9ecad299%26displaylang%3den  

 

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=14&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d851c39ee-6f9d-47d9-8ecc-44ac1e9dc182%26displaylang%3den  

 

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=15&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d3a41fac1-ed06-4944-a24d-76c8da31cf7d%26displaylang%3den  

 

SQL Server 2008 Enterprise and Standard Feature Compare

SQL Server 2008 Enterprise and Standard Feature Compare

https://www.microsoft.com/downloads/info.aspx?na=22&p=16&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d31e71958-0004-4230-803a-ebf0e3e1b25c%26displaylang%3den  

 

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=17&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d8c0f970e-c653-4c15-9e51-6a6cadfca363%26displaylang%3den  

 

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=18&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d265f08bc-1874-4c81-83d8-0d48dbce6297%26displaylang%3den  

 

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=19&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d6b10c7c1-4f97-42c4-9362-58d4d088cd38%26displaylang%3den  

 

SQL Server 2008 RDL Spec

SQL Server 2008 RDL Spec

https://www.microsoft.com/downloads/info.aspx?na=22&p=20&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d2a20c7af-52e8-4882-bd24-9479b3c7517d%26displaylang%3den  

 

Microsoft® Visual Studio Team System 2008 Database Edition GDR

Microsoft® Visual Studio Team System 2008 Database Edition GDR implements support for SQL Server 2008.

https://www.microsoft.com/downloads/info.aspx?na=22&p=21&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dbb3ad767-5f69-4db9-b1c9-8f55759846ed%26displaylang%3den  

 

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=22&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d66d3e6f5-6902-4fdd-af75-9975aea5bea7%26displaylang%3den  

 

 

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)

https://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en

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."

https://support.microsoft.com/kb/960126/EN-US

Comments

  • Anonymous
    January 01, 2003
    The comment has been removed