December 2008 - Technical Rollup Mail - SQL Server
NEWS
Technical RollUp
https://blogs.technet.com/trm/default.aspx
DOCUMENTS
Running SQL Server 2008 in a Hyper-V Environment - Best Practices and Performance Recommendations
SQL Server Replication: Providing High Availability using Database Mirroring
Database Snapshot Performance Considerations under I/O-Intensive Workloads
Best Practices for Semantic Data Modeling for Performance and Scalability
DOWNLOADS
SQL Server 2008 RDL Spec
SQL Server 2008 RDL Spec
Microsoft® Visual Studio Team System 2008 Database Edition GDR
Microsoft® Visual Studio Team System 2008 Database Edition GDR implements support for SQL Server 2008.
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.
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.
SQL Server 2008 Compliance Guide
This paper provides an overview of how to approach compliance for the management of the SQL Server database. It describes the compliance-related features of SQL Server 2008 and how to apply them to IT controls. This paper includes tips and scripts to help jump-start compliance solution development.
Azure Services Training Kit
Azure Services Training Kit
EMEA Case Study Resources
Case Study Resources
RML Utilities for SQL Server (x64)
Tools to help database administrators manage the performance of Microsoft SQL Server.
RML Utilities for SQL Server (x86)
Tools to help database administrators manage the performance of Microsoft SQL Server.
SQL Server Data Services
SQL Server Data Services
External Collaboration Toolkit for SharePoint
This solution accelerator is a collection of software and guidance that you can use to easily deploy a SharePoint-based environment for collaboration with people outside your firewall. The accelerator allows users to create collaboration environments that use the familiar SharePoint interface. Because the solution is easy to use, end users are more likely to use it rather than revert to e mail.
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.
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.
SQL Server 2008 Analysis Services Performance Guide
This white paper describes how application developers can apply query and processing performance-tuning techniques to their SQL Server 2008 Analysis Services OLAP solutions.
Visual Studio 2005 Update for SQL Server 2008 Support
This update enables developers to use Microsoft Visual Studio 2005 Service Pack 1 with Microsoft SQL Server 2008.
SQL Server 2008 Security DataSheet
SQL Server 2008 Security DataSheet
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
Virtualizing SQL Server 2008 with Windows Server 2008 Hyper-V
Virtualizing SQL Server 2008 with Windows Server 2008 Hyper-V
Creating Custom Reports by Using Configuration Manager 2007 SQL Views
This documentation provides the information to help you create custom reports, determine which Configuration Manager 2007 SQL views contain the information you need for your reports, and identify the path between the necessary SQL views and determine what columns can be used to join them.
Intergraph
Intergraph® GeoMedia® to Support Microsoft SQL Server 2008
EVENTS/WEBCASTS
A walk down memory lane - SQLBits Video
An in-depth look at SQL Server and Windows memory configuration and usage covering x86, x64, /PAE, /3GB, AWE, MemToLeave, Virtual Address Space, DBCC MemoryStatus, and Workspace/Query Memory.
https://coeo.com/sql-server-events/sql-server-conferences.html
TechNet Webcast: SQL Server 2008 for SAP Customers
https://www.microsoft.com/events/series/detail/webcastdetails.aspx?seriesid=111&webcastid=1032353311
TechNet Webcast: Protect SQL Server 2008 with Data Protection Manager 2007 (Level 300)
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)
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)
https://www.microsoft.com/events/series/detail/webcastdetails.aspx?seriesid=111&webcastid=4875
NEW KB's
SQL 2008
SQL Svr Standard 2008 EN: FIX: You may receive incorrect results when you run a query that references three or more tables in the FROM clause in SQL Server 2008
https://support.microsoft.com/kb/958611/EN-US
SQL Svr Enterprise 2008 EN: How to upgrade SQL Server 2008 Setup by running a newer version of the SQL Server 2008 Setup support files
https://support.microsoft.com/kb/955392/EN-US
SQL Svr Standard 2008 EN: Some Dundas Chart features are missing after you convert a SQL Server 2005 Reporting Services report to SQL Server 2008 Reporting Services
https://support.microsoft.com/kb/956027/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you use a SQL Server 2008 Integration Services package to query a table in an Oracle database: "SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR"
https://support.microsoft.com/kb/959794/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you rebuild indexes for a table that contains sparse columns in SQL Server 2008: "Cannot alter table '<TableName>' because the table either contains sparse columns or a column set column which are incompatible with compression"
https://support.microsoft.com/kb/958792/EN-US
SQL Svr Standard 2008 EN: FIX: Some screens in the Cumulative Update 1 for Microsoft SQL Server 2008 setup contain incorrect information
https://support.microsoft.com/kb/959792/EN-US
SQL Svr Standard 2008 EN: FIX: When an AMO object is used in the SQL Server 2008 CLR stored procedure to create or update Analysis Services objects, the stored procedure may fail
https://support.microsoft.com/kb/959780/EN-US
SQL Svr Standard 2008 EN: FIX: When you try to install a failover instance on a computer that is running a 64-bit version of Windows, the x86 option is available on the options landing page in SQL Server 2008
https://support.microsoft.com/kb/959889/EN-US
SQL Svr Standard 2008 EN: FIX: A deadlock occurs when you implement DDL statements against the partitions that are defined in a partitioned table in SQL Server 2008
https://support.microsoft.com/kb/959783/EN-US
SQL Svr Standard 2008 EN: Error message when an application uses ODBC to bind a TVP and a subtype as DAE in SQL Server 2008: "HY010, [Microsoft][SQL Server Native Client 10.0]Function sequence error"
https://support.microsoft.com/kb/959796/EN-US
SQL Svr Standard 2008 EN: FIX: A query that uses a DMV to query the sys.dm_os_performance_counters object seems to stop responding in SQL Server 2008
https://support.microsoft.com/kb/959798/EN-US
SQL Svr Standard 2008 EN: FIX: The installation is not successful when you try to install BIDS in SQL Server 2008
https://support.microsoft.com/kb/959800/EN-US
SQL Svr Standard 2008 EN: FIX: When you try to update SQL Server 2008 in attended mode, the update for SQL Support is not successful
https://support.microsoft.com/kb/959801/EN-US
SQL Svr Standard 2008 EN: FIX: Dr. Watson error information is not posted in the Problem Reports and Solutions window if SQL Server 2008 Setup fails
https://support.microsoft.com/kb/959788/EN-US
SQL Svr Standard 2008 EN: FIX: SQL Server Setup may be unsuccessful when you try to install SQL Server 2008
https://support.microsoft.com/kb/958918/EN-US
SQL Svr Standard 2008 EN: FIX: A DMX prediction query returns incorrect results when you query a logistic regression model in SQL Server 2008 Analysis Services
https://support.microsoft.com/kb/959769/EN-US
SQL Svr Standard 2008 EN: FIX: Visual Studio 2008 stops responding when you leave a SQL Server 2008 Analysis Services-based database project idle for some time
https://support.microsoft.com/kb/959776/EN-US
SQL Svr Standard 2008 EN: FIX: A database contains jumbled column data after you use the SSIS Fuzzy Grouping transformation in SQL Server 2008
https://support.microsoft.com/kb/959770/EN-US
SQL Svr Standard 2008 EN: FIX: The results of a writeback operation to a measure group are not reflected in a linked measure group in SQL Server 2008
https://support.microsoft.com/kb/959768/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you try to export a SQL Server 2008 Reporting Services report by using Report Manager: "Internet Explorer cannot download <ReportName>.xls from <URL>"
https://support.microsoft.com/kb/958479/EN-US
SQL Svr Standard 2008 EN: FIX: The output from the DBCC MEMORYSTATUS command indicates that the Schema Manager cache uses more buffer space than expected in SQL Server 2008
https://support.microsoft.com/kb/958599/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you synchronize data for a transactional publication in SQL Server 2008: "Procedure or function 'sp_MSins_dbo<TableName>_msrepl_ccs' expects parameter '@c7', which was not supplied"
https://support.microsoft.com/kb/959784/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you try to add articles to a publication that uses an Oracle Database 11g database as the publisher in SQL Server 2008: "Constraint column '<ColumnName>' not found in table '<TableName>'"
https://support.microsoft.com/kb/959785/EN-US
SQL Svr Standard 2008 EN: FIX: When Excel 2007 tries to connect to an OLAP cube on a server that is running SQL Server 2005, the connection fails
https://support.microsoft.com/kb/959771/EN-US
SQL Svr Standard 2008 EN: FIX: Calculated members in a SQL Server 2008 database are not evaluated, and the advanced filters return unexpected results when you run the Filter function in an Excel 2007 PivotTable report
https://support.microsoft.com/kb/959774/EN-US
SQL Svr Standard 2008 EN: FIX: When you try to use a subselect query that has calculated members in Excel 2007, the query returns an unexpected error
https://support.microsoft.com/kb/959773/EN-US
SQL Svr Standard 2008 EN: FIX: A query returns incorrect results if a passthrough predicate is used with a filter in the query plan
https://support.microsoft.com/kb/958214/EN-US
SQL Svr Standard 2008 EN: FIX: The script that the Generate Scripts wizard generates does not include some source database tables
https://support.microsoft.com/kb/958793/EN-US
SQL Svr Standard 2008 EN: FIX: In SQL Server 2008, SQL Server Management Studio generates a CREATE TABLE script instead of creating a DROP TABLE script
https://support.microsoft.com/kb/958790/EN-US
SQL Svr Standard 2008 EN: FIX: You cannot use the SQL Server 2008 version of SMO to manage certificates in SQL Server 2005 and in SQL Server 2000
https://support.microsoft.com/kb/958757/EN-US
SQL Svr Standard 2008 EN: FIX: SQL Server Management Studio uses the simple recovery model to create a new database when you click "New Database" in SQL Server 2008
https://support.microsoft.com/kb/958759/EN-US
SQL Svr Enterprise 2008 EN: FIX: The database name or the database ID number does not appear in the "Most Expensive Queries" chart in the Activity Monitor when you run a query on a server running SQL Server 2008
https://support.microsoft.com/kb/958941/EN-US
SQL Svr Enterprise 2008 EN: FIX: Activity Monitor shows the high wait times when the FSAGENT wait type is enabled on a server that is running SQL Server 2008
https://support.microsoft.com/kb/958942/EN-US
SQL Svr Enterprise 2008 EN: FIX: The Database column or the Task State column may be blank for some processes in the Process chart of Activity Monitor on a server that is running SQL Server 2008
https://support.microsoft.com/kb/958943/EN-US
SQL Svr Enterprise 2008 EN: FIX: Database Engine Tuning Advisor in SQL Server 2008 does not recommend any index to analyze a query
https://support.microsoft.com/kb/959790/EN-US
SQL Svr Enterprise 2008 EN: FIX: The License Terms screen of the Setup program for Cumulative Update 1 for SQL Server 2008 incorrectly states "To install Service Pack"
https://support.microsoft.com/kb/959795/EN-US
SQL Svr Enterprise 2008 EN: FIX: You cannot access Books Online help from the Activity Monitor feature in SQL Server 2008 by pressing the F1
https://support.microsoft.com/kb/959782/EN-US
SQL Svr Enterprise 2008 EN: FIX: Error message when you run the DBCC SHRINKFILE command or the DBCC SHRINKDATABASE command on a server that contains a SQL Server 2008 database: "5205 : DBCC SHRINKFILE: Moving Page <FileId>:<PageId> failed"
https://support.microsoft.com/kb/959376/EN-US
SQL Svr Enterprise 2008 EN: FIX: Memory consumption in MEMORYCLERK_SOSNODE and in USERSTORE_SCHEMAMANAGER may cause a performance slowdown of a SQL Server 2008 database
https://support.microsoft.com/kb/959767/EN-US
SQL Svr Express Edition 2008 AL: FIX: Full-text search functionality does not work in SQL Server 2008 Express Edition