Technical RollUp

Premier Field Engineering - Technical Rollup Mails

December 2008 - Technical Rollup Mail - SQL Server

December 2008 - Technical Rollup Mail - SQL Server

  • Comments 1
  • Likes

NEWS

Technical RollUp

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

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

Database Snapshot Performance Considerations under I/O-Intensive Workloads

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

Best Practices for Semantic Data Modeling for Performance and Scalability

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

DOWNLOADS

SQL Server 2008 RDL Spec

SQL Server 2008 RDL Spec

http://www.microsoft.com/downloads/info.aspx?na=22&p=1&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d2a20c7af-52e8-4882-bd24-9479b3c7517d%26displaylang%3den

Microsoft® Visual Studio Team System 2008 Database Edition GDR

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

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.

http://www.microsoft.com/downloads/info.aspx?na=22&p=3&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d66d3e6f5-6902-4fdd-af75-9975aea5bea7%26displaylang%3den

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.

http://www.microsoft.com/downloads/info.aspx?na=22&p=4&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d8c0f970e-c653-4c15-9e51-6a6cadfca363%26displaylang%3den

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.

http://www.microsoft.com/downloads/info.aspx?na=22&p=5&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d6e1021dd-65b9-41c2-8385-438028f5acc2%26displaylang%3den

Azure Services Training Kit

Azure Services Training Kit

http://www.microsoft.com/downloads/info.aspx?na=22&p=6&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d413e88f8-5966-4a83-b309-53b7b77edf78%26displaylang%3den

EMEA Case Study Resources

Case Study Resources

http://www.microsoft.com/downloads/info.aspx?na=22&p=7&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d7cbc1d01-bdfb-46af-acc1-8ce17ff50bcb%26displaylang%3den

RML Utilities for SQL Server (x64)

Tools to help database administrators manage the performance of Microsoft SQL Server.

http://www.microsoft.com/downloads/info.aspx?na=22&p=8&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3db60cdfa3-732e-4347-9c06-2d1f1f84c342%26displaylang%3den

RML Utilities for SQL Server (x86)

Tools to help database administrators manage the performance of Microsoft SQL Server.

http://www.microsoft.com/downloads/info.aspx?na=22&p=9&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d7edfa95a-a32f-440f-a3a8-5160c8dbe926%26displaylang%3den

SQL Server Data Services

SQL Server Data Services

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

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.

http://www.microsoft.com/downloads/info.aspx?na=22&p=11&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dd9af2c25-989c-45c4-8008-1f15722190ed%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.

http://www.microsoft.com/downloads/info.aspx?na=22&p=12&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dbfcc3ded-9a3d-4a32-85e2-e71fd90ee645%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.

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

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.

http://www.microsoft.com/downloads/info.aspx?na=22&p=14&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d3be0488d-e7aa-4078-a050-ae39912d2e43%26displaylang%3den

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.

http://www.microsoft.com/downloads/info.aspx?na=22&p=15&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3de1109aef-1aa2-408d-aa0f-9df094f993bf%26displaylang%3den

SQL Server 2008 Security DataSheet

SQL Server 2008 Security DataSheet

http://www.microsoft.com/downloads/info.aspx?na=22&p=16&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d65c2a014-5cbc-424e-ad5d-8d1da0bf6f58%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=17&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d9f783224-9871-4eea-b1d5-f3140a253db6%26displaylang%3den

Virtualizing SQL Server 2008 with Windows Server 2008 Hyper-V

Virtualizing SQL Server 2008 with Windows Server 2008 Hyper-V

http://www.microsoft.com/downloads/info.aspx?na=22&p=18&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d5b72bd51-df66-43a0-aca6-d23bf0d7f44d%26displaylang%3den

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.

http://www.microsoft.com/downloads/info.aspx?na=22&p=19&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d87bbe64e-5439-4fc8-becc-deb372a40f4a%26displaylang%3den

Intergraph

Intergraph® GeoMedia® to Support Microsoft SQL Server 2008

http://www.microsoft.com/downloads/info.aspx?na=22&p=20&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dac45a8bf-a152-431b-bb79-04afa66ddfe0%26displaylang%3den

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.

http://coeo.com/sql-server-events/sql-server-conferences.html

TechNet Webcast: SQL Server 2008 for SAP Customers

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

http://www.microsoft.com/events/series/detail/webcastdetails.aspx?seriesid=111&webcastid=5011

TechNet Webcast: 24 Hours of SQL Server 2008: Performance Troubleshooting (Level 200)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

http://support.microsoft.com/kb/958758/EN-US

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment