November 2008 SQL Technical Roll Up
The TRM blog can be found here https://blogs.technet.com/trm/
Downloads
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.
SQL Server 2008 Privacy Statement
Read the Privacy Statement document for Microsoft SQL Server 2008.
Microsoft SQL Server 2008 Feature Pack, October 2008
Download the Microsoft SQL Server 2008 Feature Pack, a collection of stand-alone install packages that provide additional value for SQL Server 2008.
Web Platform Installer Beta
The Microsoft Web Platform Installer (beta) is a free tool that makes it simple to download and install the latest components of the Microsoft Web Platform, including the IIS7, SQL Server Express, .NET Framework and Visual Web Developer.
SQL Server 2008 Report Builder 2.0
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 stand-alone installer for Report Builder 2.0
SQL Server 2005 Driver for PHP Cumulative Update - October 2008
Download the SQL Server 2005 Driver for PHP Cumulative Update - October 2008. This update contains bug fixes reported by the community.
Direct Marketing Microsoft Office SharePoint Server Case Study
One of this agency’s clients has 14 subsidiary organizations whose independently developed collateral needed greater brand creative man¬agement and consistency. Using Microsoft Office SharePoint Server (MOSS) 2007 and technologies from Adobe and Equilibrium, the agency developed a template-based collateral development and brand management solution.
System Center Operations Manager 2007 SP1 Documentation
This download contains documentation for System Center Operations Manager 2007 SP1.
SQL Server 2005 Privacy Statement
Read the Privacy Statement document for Microsoft 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.
Microsoft® Visual Studio Team System 2008 Database Edition GDR September CTP
Microsoft® Visual Studio Team System 2008 Database Edition GDR implements support for SQL Server 2008.
Microsoft Connectors for Oracle and Teradata
Download the SSIS Connectors for Oracle and Teradata that provide additional value for SQL Server Integration Services (SSIS) 2008.
Western Extrusions CS
According to Mojica, the aging Windows Server 2003 platform had worn thin. The new operating system would need to work smoothly with Western’s SQL Server® 2000 and Windows® SharePoint® Services 3.0 solutions.
SLM Datasheet
This is Microsoft Services SQL: Service Level Management (SLM) datasheet.
DCM for SQL Datasheet
This is Microsoft Services for SQL: Desired Configuration Monitoring (DCM) datasheet.
SQL Server 2005: for Administrators Datasheet
This four-day WorkshopPLUS course is available exclusively for Microsoft Premier Support customers and contains Level 300+ content.
Microsoft SQL Server 2008 Books Online (August 2008)
Download the documentation and tutorials for Microsoft SQL Server 2008.
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.
SQL Server 2000 Service Pack 4 and MSDE 2000 (KB948111)
Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000 (KB948111)
SQL Server 2000 Service Pack 4 and MSDE 2000 (KB948110)
Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000 (KB948110)
Documents
Running SQL Server 2008 in a Hyper-V Environment - Best Practices and Performance Recommendations
SQL Server Replication: Providing High Availability using Database Mirroring
Running SQL Server 2008 on Windows Server 2008
The combination of SQL Server 2008 and Windows Server 2008 offers enterprise IT administrators and professional developers a superlative platform for mission-critical applications together with enhanced end-to-end security, management, and development capabilities.
https://www.microsoft.com/sqlserver/2008/en/us/wp-run-sql-2008-on-windows-server-2008.aspx
SQL Server 2008 Licensing Overview
This document explains key licensing considerations for SQL Server 2008 customers.
Best Practices for Integration Services Configurations
This article explains what SQL Server Integration Services configurations are used for, why you should use Integration Services configurations, and what options you have for leveraging configurations. It will also make some simple recommendations that are based on my experiences of building Integration Services packages in a real-world environment. An understanding of the terms “package”, “Business Intelligence Development Studio”, and “dtexec.exe” in the context of Integration Services is assumed.
FILESTREAM Storage in SQL Server 2008
In today’s society, data is generated at incredible rates and often needs to be stored and accessed in a controlled and efficient way. There are various technologies to do this and the choice of technology often depends on the nature of the data being stored – structured, semistructured, or unstructured
Events/Webcasts
Creating an Analysis Services Project (SQL Server Video)
This video demonstrates how to create an Analysis Services project, define a data source, and define a data source view. You will also learn how to change the value of the FriendlyName property for objects in the data source view to increase the user-friendliness of their names.
https://msdn.microsoft.com/en-us/library/cc952925.aspx
Defining and Deploying a Cube (SQL Server Video)
This video demonstrates how to define and deploy an OLAP cube using Analysis Services.
https://msdn.microsoft.com/en-us/library/cc952924.aspx
Modifying Measures, Attributes and Hierarchies (SQL Server Video)
This video demonstrates how to modify the measures, attributes and hierarchies in a cube.
https://msdn.microsoft.com/en-us/library/cc952926.aspx
Creating a Basic Package (SQL Server Video)
This video demonstrates how to create a basic package by using the SSIS Designer in Business Intelligence Development Studio.
https://msdn.microsoft.com/en-us/library/cc952921.aspx
Exporting SQL Server Data to Excel (SQL Server Video)
This video demonstrates how to use the SQL Server Import and Export Wizard to create a package that exports data from a SQL Server database to a Microsoft Excel spreadsheet.