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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=1&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d1e53f882-0c16-4847-b331-132274ae8c84%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=2&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3de7f89bf5-d80c-46b5-a12f-fade6d41330d%26displaylang%3den

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=3&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d228de03f-3b5a-428a-923f-58a033d316e1%26displaylang%3den

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.

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

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

https://www.microsoft.com/downloads/info.aspx?na=22&p=5&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d9f783224-9871-4eea-b1d5-f3140a253db6%26displaylang%3den

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=6&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d61bf87e0-d031-466b-b09a-6597c21a2e2a%26displaylang%3den

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=7&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d34f2e52d-6cde-40ad-b253-fee924662df7%26displaylang%3den

System Center Operations Manager 2007 SP1 Documentation

This download contains documentation for System Center Operations Manager 2007 SP1.

https://www.microsoft.com/downloads/info.aspx?na=22&p=8&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dd826b836-59e5-4628-939e-2b852ed79859%26displaylang%3den

SQL Server 2005 Privacy Statement

Read the Privacy Statement document for Microsoft SQL Server 2005.

https://www.microsoft.com/downloads/info.aspx?na=22&p=9&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d0623907e-6939-4251-a6e7-90142590ed43%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=10&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d91ef5106-944a-41e1-b3a0-5bd3f2356f32%26displaylang%3den

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.

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

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=12&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dd9cb21fe-32e9-4d34-a381-6f9231d84f1e%26displaylang%3den

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.

https://www.microsoft.com/downloads/info.aspx?na=22&p=13&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dc4abd726-71cd-4f9b-b10a-f2189c79cd46%26displaylang%3den

SLM Datasheet

This is Microsoft Services SQL: Service Level Management (SLM) datasheet.

https://www.microsoft.com/downloads/info.aspx?na=22&p=14&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3de37c709d-48c3-4ba0-afa2-aab2b93cda2b%26displaylang%3den

DCM for SQL Datasheet

This is Microsoft Services for SQL: Desired Configuration Monitoring (DCM) datasheet.

https://www.microsoft.com/downloads/info.aspx?na=22&p=15&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dfcda8b1c-6634-47a5-8601-e21773fe2a7b%26displaylang%3den

SQL Server 2005: for Administrators Datasheet

This four-day WorkshopPLUS course is available exclusively for Microsoft Premier Support customers and contains Level 300+ content.

https://www.microsoft.com/downloads/info.aspx?na=22&p=16&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d1cfb760c-a3fa-4e50-9fc3-0e7c9819d51f%26displaylang%3den

Microsoft SQL Server 2008 Books Online (August 2008)

Download the documentation and tutorials for Microsoft SQL Server 2008.

https://www.microsoft.com/downloads/info.aspx?na=22&p=17&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d765433f7-0983-4d7a-b628-0a98145bcb97%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=18&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dc6c3e9ef-ba29-4a43-8d69-a2bed18fe73c%26displaylang%3den

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

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

https://www.microsoft.com/downloads/info.aspx?na=22&p=19&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d8316bc5e-8c2d-4710-8acc-b815ccc81cd4%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=20&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d4fd1f86a-94a2-43d8-9b0a-774c81426d9e%26displaylang%3den

Documents

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

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.

https://download.microsoft.com/download/1/e/6/1e68f92c-f334-4517-b610-e4dee946ef91/2008%20SQL%20Licensing%20Overview%20final.docx

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.

https://msdn.microsoft.com/en-us/library/cc671628.aspx

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

https://msdn.microsoft.com/en-us/library/cc949109.aspx

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.

https://msdn.microsoft.com/en-us/library/cc952922.aspx

Comments