September 2008 SQL Technical Roll Up

Full Technical Roll Up here: https://blogs.technet.com/trm/default.aspx

Resources

SQL – The Next Great Gaming Platform

Presentation from GameFest 2008

https://www.microsoft.com/downloads/info.aspx?na=22&p=1&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d8b2a9674-13c4-42e3-8270-76813ab2a507%26displaylang%3den

SQL Server 2008 Report Builder 2.0 RC1

Microsoft SQL Server 2008 Report Builder 2.0 provides an intuitive report authoring environment for business and power users. It supports the full capabilities of SQL Server 2008 Reporting Services. The download provides a standalone installer for Report Builder 2.0.

https://www.microsoft.com/downloads/info.aspx?na=22&p=2&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dcc9acbbd-570c-4712-b74d-85f537a5a75f%26displaylang%3den

Microsoft SQL Server 2008 Express with Tools

Microsoft SQL Server 2008 Express with Tools 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 the web or local desktop.

https://www.microsoft.com/downloads/info.aspx?na=22&p=3&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d7522a683-4cb2-454e-b908-e805e9bd4e28%26displaylang%3den

Microsoft SQL Server 2008 Express with Advanced Services

https://www.microsoft.com/downloads/info.aspx?na=22&p=4&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3db5d1b8c3-fda5-4508-b0d0-1311d670e336%26displaylang%3den

Microsoft® Visual Studio Team System 2008 Database Edition GDR August CTP

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=5&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dbb3ad767-5f69-4db9-b1c9-8f55759846ed%26displaylang%3den

SQL Server 2008 Release Notes

This Release Notes document contains information for Microsoft SQL Server 2008 that supplements the SQL Server 2008 Readme and Books Online documentation.

https://www.microsoft.com/downloads/info.aspx?na=22&p=6&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3ddaf00920-7214-418a-a4b0-727f4ce08f81%26displaylang%3den

SQL Server Management Pack for MOM 2005

The SQL Server Management Pack monitors SQL Server services and features and their availability.

https://www.microsoft.com/downloads/info.aspx?na=22&p=7&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d79f151c7-4d98-4c2b-bf72-ec2b4ae69191%26displaylang%3den

SQL Server Data Services (SSDS) SDK (Beta)

This is a beta version of the Software Development Kit for SSDS including tools and client side components useful to developers building applications against SSDS.

https://www.microsoft.com/downloads/info.aspx?na=22&p=8&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d0b1fa5c6-ec9d-440b-939e-481dd05f2627%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=9&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d91ef5106-944a-41e1-b3a0-5bd3f2356f32%26displaylang%3den

SQL Server 2005 Best Practices Analyzer

This download is the August 2008 release of SQL Server 2005 Best Practices Analyzer.

https://www.microsoft.com/downloads/info.aspx?na=22&p=10&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dda0531e4-e94c-4991-82fa-f0e3fbd05e63%26displaylang%3den

Visual Studio 2008 Team Foundation Server SP1

This Service Pack contains bug fixes and new features that address feedback from customers and provide support for recent operating system and database releases. This service pack applies to Team Foundation Server 2008, Team Foundation 2008 Proxy, and Team Foundation Server 2008 Build.

https://www.microsoft.com/downloads/info.aspx?na=22&p=11&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d9e40a5b6-da41-43a2-a06d-3cee196bfe3d%26displaylang%3den

SQL Server Compact 3.5 SP1 Books Online and Samples

SQL Server Compact 3.5 SP1 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the Books Online and samples for SQL Server Compact 3.5 SP1

https://www.microsoft.com/downloads/info.aspx?na=22&p=12&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d07829770-73a7-41e4-880d-e74b1a353623%26displaylang%3den

SQL Server Compact 3.5 SP1 for Windows Mobile

SQL Server Compact 3.5 SP1 for devices Windows Installer (MSI) file contains the CAB files and the DLLs for installing SQL Server Compact 3.5 SP1 on the Windows mobile devices.

https://www.microsoft.com/downloads/info.aspx?na=22&p=13&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dfce9abbf-f807-45d6-a457-ab5615001c8f%26displaylang%3den

SQL Server Compact 3.5 SP1 and Synchronization Services for ADO.NET v1.0 SP1 for Windows Desktop

SQL Server Compact 3.5 SP1 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP1 and Synchronization Services for ADO.NET version 1.0 SP1 on Windows desktop.

https://www.microsoft.com/downloads/info.aspx?na=22&p=14&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3ddc614aee-7e1c-4881-9c32-3a6ce53384d9%26displaylang%3den

SQL Server Compact 3.5 SP1 Server Tools

SQL Server Compact 3.5 SP1 Server Tools Windows Installer (MSI) file installs replication components on the computer running the Internet Information Services (IIS) for synchronizing data with SQL Server 2005 and SQL Server 2008.

https://www.microsoft.com/downloads/info.aspx?na=22&p=15&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dfa751db3-7685-471b-ac31-f1b150422462%26displaylang%3den

SQL Server 2008 Analysis Services Datasheet

Microsoft® SQL Server™ 2008 helps enable organizations to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar tools.

https://www.microsoft.com/downloads/info.aspx?na=22&p=16&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d1ad953e6-2ca9-4d8b-95ff-d5242c4c627a%26displaylang%3den

SQL Server 2008 Predictive Analysis Datasheet

Microsoft® SQL Server™ 2008 empowers informed decisions with predictive analysis through intuitive data mining; seamlessly integrated within the Microsoft Business Intelligence platform and extensible into business applications.

https://www.microsoft.com/downloads/info.aspx?na=22&p=17&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dbfcc3ded-9a3d-4a32-85e2-e71fd90ee645%26displaylang%3den

Microsoft SQL Server 2008 Upgrade Advisor

Download the Microsoft SQL Server 2008 Upgrade Advisor. Upgrade Advisor analyzes instances of SQL Server 2000 and SQL Server 2005 to help you prepare for upgrades to SQL Server 2008.

https://www.microsoft.com/downloads/info.aspx?na=22&p=18&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3df5a6c5e9-4cd9-4e42-a21c-7291e7f0f852%26displaylang%3den

SQL Server Data Mining Add-ins for Office 2007

Download SQL Server 2008 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=19&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d896a493a-2502-4795-94ae-e00632ba6de7%26displaylang%3den

Microsoft SQL Server 2008 Feature Pack, August 2008

Download the 2008 Feature Pack for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide additional value for SQL Server 2008.

https://www.microsoft.com/downloads/info.aspx?na=22&p=20&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dc6c3e9ef-ba29-4a43-8d69-a2bed18fe73c%26displaylang%3den

SQL Server Reporting Services Add-in for SharePoint Technologies

The Microsoft SQL Server 2008 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=21&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d200fd7b5-db7c-4b8c-a7dc-5efee6e19005%26displaylang%3den

SQL Server 2008 Privacy Statement

Read the Privacy Statement document for Microsoft SQL Server 2008.

https://www.microsoft.com/downloads/info.aspx?na=22&p=22&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3de7f89bf5-d80c-46b5-a12f-fade6d41330d%26displaylang%3den

SQL Server Data Services

SQL Server Data Services

https://www.microsoft.com/downloads/info.aspx?na=22&p=23&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d2539d851-1e68-42fd-bee0-d36806a732fb%26displaylang%3den

Microsoft SQL Server 2008 Books Online

Download the documentation and tutorials for Microsoft SQL Server 2008.

https://www.microsoft.com/downloads/info.aspx?na=22&p=24&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d765433f7-0983-4d7a-b628-0a98145bcb97%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=25&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=26&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d6b10c7c1-4f97-42c4-9362-58d4d088cd38%26displaylang%3den

Microsoft SQL Server 2008 Express

SQL Server 2008 Express is a free edition of SQL Server that is ideal for learning and building desktop and small server applications, and for redistribution by ISVs.

https://www.microsoft.com/downloads/info.aspx?na=22&p=27&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d58ce885d-508b-45c8-9fd3-118edd8e6fff%26displaylang%3den

Install_cc_triggers

https://www.microsoft.com/downloads/info.aspx?na=22&p=29&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d0f30eb82-0ca2-40cd-b6dc-1ce637dd7838%26displaylang%3den

SQL Server 2000 Service Pack 4 and MSDE 2000 (KB948110)

Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000 (KB948110)

https://www.microsoft.com/downloads/info.aspx?na=22&p=30&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d4fd1f86a-94a2-43d8-9b0a-774c81426d9e%26displaylang%3den

Documents

SQL Server 2008 Licensing Overview

This document explains key licensing considerations for SQL Server 2008 customers.

SQL Server 2008 Pricing and Licensing

https://www.microsoft.com/downloads/info.aspx?na=22&p=28&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d7b133660-36b9-4a02-b0d8-dd7f7f19aa4f%26displaylang%3den

XML Best Practices for Microsoft SQL Server 2005

https://technet.microsoft.com/en-gb/library/ms345115.aspx

SQL Server 2005 Full-Text Queries on Large Catalogs: Lessons Learned

https://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ftslesld.mspx

Events/Webcasts

TechNet Webcast: SQL Server 2008 (Part 3 of 3): Integrate Growing Data Volumes (Level 300)

Attend this session to learn how to integrate growing volumes of data with the new enhancements in Microsoft SQL Server 2008. We cover new technologies, like Change Data Capture and MERGE SQL statement, in addition to scalability improvements in SQL Server Integration Services, like lookup enhancements and data profiling.

https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032365552&EventCategory=5&culture=en-US&CountryCode=US

TechNet Webcast: Mastering Time Series Prediction with SQL Server 2008 Data Mining (Level 300)

Time series data is one of the most useful sources for data mining. Whether it be estimating future gasoline prices or understanding the relationship between the weather and sales, there is a role for time series analysis. In the new release of Microsoft SQL Server 2008 Data Mining, Microsoft has introduced some important enhancements to our support in this area, making powerful analysis both more effective and easier to use. In this webcast, we not only introduce these new features, but we also cover many of the business scenarios for which time series prediction is invaluable.

https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032359362&EventCategory=5&culture=en-US&CountryCode=US

MSDN Webcast: Introducing SQL Server Compact 3.5 (Level 200)

With Microsoft SQL Server Compact 3.5 and Microsoft Visual Studio 2008, developers have an easy-to-deploy solution for local data. Ranging from caching reference data to full offline scenarios, developers can use a single engine for their Windows Mobile-powered devices, or their full desktop clients–benefiting from the power of SQL Server in a compact footprint. Using Visual Studio 2008, we show how SQL Server Compact can be transparently deployed with unique features including updatable result sets and a custom document format, and how to manage the creation and maintenance of your local data. This session is packed with demonstrations that can get you started today.

https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032364883&EventCategory=5&culture=en-US&CountryCode=US