November 2008 – Technical Rollup Mail – SQL






 


News


Technical RollUp


http://blogs.technet.com/trm/default.aspx


 


 


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.


http://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.


http://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.


http://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.


http://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


http://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.


http://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.


http://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.


http://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.


http://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.


http://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.


http://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.


http://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.


http://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.


http://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.


http://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.


http://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.


http://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.


http://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)


http://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)


http://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


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


 


SQL Server Replication: Providing High Availability using Database Mirroring


http://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.


http://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.


http://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.


http://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


http://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.


http://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.


http://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.


http://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.


http://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.


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