May 2010 - Technical Rollup Mail - SQL
News
SQL 2008
Day 2 at Collaborate 2010
https://blogs.technet.com/dataplatforminsider/archive/2010/04/20/day-2-at-collaborate-2010.aspx
SQL 2008 R2
SQL Server 2008 R2 Released to Manufacturing!
Unisys Releases the First Pre-Packaged Data Warehouse Solution
Other
Technical RollUp
https://blogs.technet.com/trm/default.aspx
Documents
SQL 2005
Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
This best practices white paper discusses three many-to-many query performance optimization techniques, including how to implement them, and the performance testing results for each technique.
SQL 2008
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.
SQL 2008 R2
SQL Server 2008 R2 Books Online
Download the release version of the documentation and tutorials for Microsoft SQL Server 2008 R2.
Downloads
Other
SQL Server Compact 3.5 SP2 Server Tools
SQL Server Compact 3.5 SP2 Server Tools Windows Installer (MSI) file installs replication components on the computer running the Internet Information Services (IIS) for synchronizing data with SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 November CTP.
SQL Server Compact 3.5 SP2 for Windows Mobile
SQL Server Compact 3.5 SP2 for devices Windows Installer (MSI) file contains the CAB files and the DLLs for installing SQL Server Compact 3.5 SP2 on the Windows mobile devices.
SQL Server Compact 3.5 SP2 for Windows Desktop
SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP2 and Synchronization Services for ADO.NET version 1.0 SP1 on Windows desktop.
SQL Server Compact 3.5 SP2 for Windows Mobile
SQL Server Compact 3.5 SP2 for devices Windows Installer (MSI) file contains the CAB files and the DLLs for installing SQL Server Compact 3.5 SP2 on the Windows mobile devices.
SQL Server Compact 3.5 SP2 for Windows Desktop
SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP2 and Synchronization Services for ADO.NET version 1.0 SP1 on Windows desktop.
SQL Server Compact 3.5 SP2 for Windows Mobile
SQL Server Compact 3.5 SP2 for devices Windows Installer (MSI) file contains the CAB files and the DLLs for installing SQL Server Compact 3.5 SP2 on the Windows mobile devices.
SQL Server Compact 3.5 SP2 for Windows Desktop
SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP2 and Synchronization Services for ADO.NET version 1.0 SP1 on Windows desktop.
SQL 2000
SQL Server Compact 3.5 SP2 for Windows Mobile
SQL Server Compact 3.5 SP2 for devices Windows Installer (MSI) file contains the CAB files and the DLLs for installing SQL Server Compact 3.5 SP2 on the Windows mobile devices.
SQL Server Compact 3.5 SP2 for Windows Desktop
SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP2 and Synchronization Services for ADO.NET version 1.0 SP1 on Windows desktop.
SQL Server 2000 Best Practices Analyzer
SQL Server 2000 Best Practices Analyzer is a database management tool that lets you verify the implementation of common Best Practices on your servers.
SQL 2005
SQL Server Compact 3.5 SP2 for Windows Mobile
SQL Server Compact 3.5 SP2 for devices Windows Installer (MSI) file contains the CAB files and the DLLs for installing SQL Server Compact 3.5 SP2 on the Windows mobile devices.
SQL Server Compact 3.5 SP2 for Windows Desktop
SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP2 and Synchronization Services for ADO.NET version 1.0 SP1 on Windows desktop.
Events/Webcasts
Live Meeting Webcast: SQL Server 2008 Performance Tuning
Wednesday, May 05, 2010 12:15 PM Eastern Time (US & Canada)
There are a number of tools available on the market that can assist you in performance tuning and troubleshooting your SQL Server 2008 database engine.
But fortunately for us, Microsoft has included several internal SQL Server tools that can assist in trouble shooting difficult performance problems. In this session Pragmatic Works will demonstrate how to use Dynamic Management Views, SQL Profiler and Execution plans to detect, diagnose and solve tricky SQL Server Performance Problems.
Live Meeting Link for webcast attendees:
https://www.livemeeting.com/cc/pragmaticworksweb/join?id=C39JFT&role=attend&pw=wt%3D8%29fkjC
Meeting ID: C39JFT
Call-in number: 712-432-0075
Participant code: 501383
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032445578&culture=en-US
Live Meeting Webcast: New T-SQL programmability features in SQL
Wednesday, May 19, 2010 12:15 PM Eastern Time (US & Canada)
With the advent of SQL Server 2008, Microsoft introduced several new T-SQL programming features, which included the Hierarchical date type, Geospatial data type, declaring and initializing variables, new date and time data types and functions, the MERGE statement, and table-valued parameters to mention a few. In this session Pragmatic Works will introduce these new technologies and provide demonstrations on how to design and implement the new T-SQL features.
Live Meeting Attendee URL:
https://www.livemeeting.com/cc/pragmaticworksweb/join?id=K82HZF&role=attend&pw=t%2F%5D%7C72g%5EN
Meeting ID: K82HZF
Call-in number: 712-432-0075
Participant code: 501383
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032445581&culture=en-US
MSDN Webcast: geekSpeak: Powershell for Data Professionals (Level 200)
Wednesday, May 05, 2010 12:00 PM Pacific Time (US & Canada)
In this episode of geekSpeak, Microsoft SQL Server guru Aaron Nelson shows you how to take control of your SQL Server with PowerShell. Aaron demonstrates how to perform everyday database administrator tasks like backing up user databases, scripting table objects, and evaluating disk space usage, and he shows what a timesaver PowerShell scripts can be for automating SQL Server activities. This geekSpeak is hosted by Glen Gordon.
The geekSpeak webcast series brings you industry experts in a "talk-radio" format hosted by developer evangelists from Microsoft. These experts share their knowledge and experience about a particular developer technology and are ready to answer your questions in real time during the webcast.
Presenter: Aaron Nelson, Senior SQL Server Architect
Aaron Nelson is a senior Microsoft SQL Server architect with more than 10 years of experience in architecture, business intelligence, development, and performance tuning of SQL Server data management software. He has experience managing enterprise-wide data needs in both transactional and data warehouse environments. Aaron also holds certifications for MCITP: Business Intelligence Developer, Database Administrator, Database Developer; and MCTS: Windows Server Virtualization, Configuration (meaning Hyper-V).
View other sessions from geekSpeak: Join a Discussion Like No Other
If you have questions or feedback, contact us.
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032449694&culture=en-US
TechNet Webcast: SQL Server 2008 R2: Data Mining (Level 300)
Tuesday, May 04, 2010 11:00 AM Pacific Time (US & Canada)
In this webcast, we examine the architecture and configuration of PowerPivot for SharePoint and explain how to properly install and configure PowerPivot for SharePoint on Microsoft SharePoint Server and in a SharePoint Server farm. We also explain how PowerPivot for SharePoint is used in the management of PowerPivot workbooks created in Microsoft Excel 2010 and describe some of the tools available for managing and monitoring PowerPivot for SharePoint.
Presenter: Dmitri Tchikatilov, Database Technology Specialist, Microsoft Corporation
View other sessions from SQL Server 2008: Access Your Data Any Place, Any Time
If you have questions or feedback, contact us.
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032450031&culture=en-US
TechNet Webcast: SQL Server 2008 R2: Performance Troubleshooting (Level 300)
Thursday, May 06, 2010 11:00 AM Pacific Time (US & Canada)
In this webcast, we explore two performance-related tools, Performance Studio and Best Practice Analyzer, that ship with Microsoft SQL Server 2008 R2. Performance Studio helps you monitor, collect, and analyze performance diagnostic data, and Best Practice Analyzer helps you to ensure peak performance with the enforcement of certain best practices.
Presenter: Kartik Tamhane, Database Technology Specialist, Microsoft Corporation
View other sessions from SQL Server 2008: Access Your Data Any Place, Any Time
If you have questions or feedback, contact us.
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032450036&culture=en-US
TechNet Webcast: SQL Server 2008 R2: Ensuring Your Data Is Secure (Level 300)
Thursday, May 06, 2010 8:00 AM Pacific Time (US & Canada)
Security is becoming increasingly important as more networks are connected together. Organizations' assets must be protected, particularly databases, which contain valuable information. Security is one of the critical features of a database engine, because it helps to protect the enterprise IT environment against threats. Attend this webcast to learn how the security features of Microsoft SQL Server 2008 R2 database software are designed to make it more secure and to make security more approachable and understandable to those who are responsible for data protection.
Presenter: Andrew Fryer, IT Pro Evangelist, Microsoft Corporation
View other sessions from SQL Server 2008: Access Your Data Any Place, Any Time
If you have questions or feedback, contact us.
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032450124&culture=en-US
TechNet Webcast: SQL Server 2008 R2: Data Warehouse Scaling and Performance (Level 300)
Tuesday, May 11, 2010 11:00 AM Pacific Time (US & Canada)
In this webcast, we explain how Microsoft SQL Server 2008 R2 data management software can improve the performance of data warehouse systems. Performance and scalability go somewhat hand in hand. The better that your data warehouses perform the more scalable they tend to be. We look at the optimizations that were made to data warehousing, including improved parallelism and star join optimizations. We then look at the new features that target the performance of data warehouse systems and help you achieve better scalability, including data compression and a new query feature called Grouping Sets.
Presenter: Kartik Tamhane, Database Technology Specialist, Microsoft Corporation
View other sessions from SQL Server 2008: Access Your Data Any Place, Any Time
If you have questions or feedback, contact us.
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032450033&culture=en-US
TechNet Webcast: SQL Server 2008 R2: Securing Your System (Level 300)
Thursday, May 13, 2010 8:00 AM Pacific Time (US & Canada)
While it is extremely important to secure data, it is also vital to secure the operating system too. In this webcast, we focus on features available in the Windows Server 2008 R2 operating system, when used in combination with Microsoft SQL Server 2008 R2 database software, that make a higher level of protection possible and help you create a complete security solution. When SQL Server 2008 R2 is installed on Windows Server 2008 R2, you can use SQL Server 2008 R2 tools to increase security by decreasing the surface area and storing encrypted keys safely. Join us to learn how Windows Server 2008 R2 features such as Network Access Protection (NAP) and BitLocker can increase security on your servers.
Presenter: Andrew Fryer, IT Pro Evangelist, Microsoft Corporation
View other sessions from SQL Server 2008: Access Your Data Any Place, Any Time
If you have questions or feedback, contact us.
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032450232&culture=en-US
TechNet Webcast: SQL Server 2008 R2: Ensuring Business Continuity (Level 300)
Tuesday, May 18, 2010 8:00 AM Pacific Time (US & Canada)
Microsoft SQL Server 2008 R2 database software provides a wide range of solutions to improve availability and decrease downtime, which helps increase productivity and ensure business continuity. Attend this webcast to discover that the availability solutions provided in SQL Server R2 are at least as good—in terms of performance and variety—as anything available from any of the major database software vendors and SQL Server 2008 R2 continues to lead the way in terms of manageability and value for money. We also explain how SQL Server Always On technologies can help you recover quickly from an unplanned downtime event.
Presenter: Andrew Fryer, IT Pro Evangelist, Microsoft Corporation
View other sessions from SQL Server 2008: Access Your Data Any Place, Any Time
If you have questions or feedback, contact us.
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032450234&culture=en-US
TechNet Webcast: SQL Server 2008 R2: Improvements for Business Intelligence Designers (Level 300)
Thursday, May 20, 2010 11:00 AM Pacific Time (US & Canada)
In this webcast, we look at some of the improvements that have been made to Microsoft SQL Server 2008 R2 to help you design business intelligence (BI) solutions more effectively and to increase the reporting capabilities of people who develop reporting solutions. SQL Server Reporting Services (SSRS) gives users new ways to share reports and data among coworkers across organizations, and SSRS provides the ability to create and reuse report content in a variety of ways. There are also several new ways to visualize data to help your reports convey a great deal of information at a glance. Topics we cover include some of the new features available to report designers, SQL Server Analysis Services, improvements in designing aggregations of cube data, improvements in cube design, and improvements in dimension design.
Presenter: Dmitri Tchikatilov, Database Technology Specialist, Microsoft Corporation
View other sessions from SQL Server 2008: Access Your Data Any Place, Any Time
If you have questions or feedback, contact us.
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032450029&culture=en-US
New KB's
SQL 2005
SQL Svr 2005 Analysis Svcs EN: Naming schema for Microsoft SQL Server software update packages (Updated)
https://support.microsoft.com/kb/822499/EN-US
SQL Svr 2005 Analysis Svcs EN: FIX: A calculated member that uses filtered dimension members returns an incorrect result in SSAS 2005
https://support.microsoft.com/kb/981867/EN-US
SQL Svr Standard Edtn 2005 EN: You may receive an error message when you try to run an existing CLR object or create an assembly that has the external_access or unsafe permission set on a database that is attached or restored from a different server (Updated)
https://support.microsoft.com/kb/918040/EN-US
SQL Svr Standard Edtn 2005 EN: The user is not assigned to a default schema when you use Windows authentication to connect the user to SQL Server 2005 or to SQL Server 2008 (Updated)
https://support.microsoft.com/kb/918346/EN-US
SQL Svr Standard Edtn 2005 EN: On a computer that has a multicore processor, you may be unable to install SQL Server 2005 (Updated)
https://support.microsoft.com/kb/954835/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The Wmiprvse.exe host process stops responding when you run a SQL Server 2005-based application that sends a Windows Management Instrumentation (WMI) query to the SQL Server WMI provider (Updated)
https://support.microsoft.com/kb/967199/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: You cannot create a maintenance plan or perform a DatabaseMail operation after you install a service pack or hotfix on a SQL Server 2005 failover cluster
https://support.microsoft.com/kb/978308/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A DateTime value is replaced by a NULL value when a conflict is resolved by using a custom resolver in a SQL Server 2005 merge replication
https://support.microsoft.com/kb/979212/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: You receive a "Provider Load Failure" error message or the WMIPRVSE.EXE process stops responding when you use a SQL Server 2005 WMI provider to obtain information about SQL Server 2005 services
https://support.microsoft.com/kb/980142/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The content index is corrupted when the master merge process is paused in SQL Server 2005
https://support.microsoft.com/kb/980290/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: You experience high latency for peer-to-peer distribution agents in SQL Server 2005
https://support.microsoft.com/kb/980849/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Proactive caching starts unexpectedly when you insert data in SQL Server 2005
https://support.microsoft.com/kb/980883/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Metadata is corrupted when you move SSAS 2005 data folders from one computer to another computer
https://support.microsoft.com/kb/980948/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The DownloadGenerationsPerBatch parameter is not applied correctly in a SQL Server 2005 merge replication
https://support.microsoft.com/kb/981074/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: An access violation occurs when you run an SSIS 2005 package that uses Lookup transformations
https://support.microsoft.com/kb/981106/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A query returns an incorrect result if it uses an index that is being rebuilt online in SQL Server 2005
https://support.microsoft.com/kb/981713/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: "Internal Query Processor Error” error message when you run a query that joins multiple tables in SQL Server 2005
https://support.microsoft.com/kb/981755/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: "Deadlock monitor failed to resolve this deadlock. Server may require restart to recover from this condition" error message when a database is being recovered in SQL Server 2005
https://support.microsoft.com/kb/981888/EN-US
SQL 2008
SQL Svr Standard 2008 EN: FIX: You cannot start the Data Profile Viewer (DataProfileViewer.exe) in SQL Server 2008 (Updated)
https://support.microsoft.com/kb/957803/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you run a query in SQL Server 2008 or in SQL Server 2005: "SqlDumpExceptionHandler: Process <spid> generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process." (Updated)
https://support.microsoft.com/kb/972936/EN-US
SQL Svr Standard 2008 EN: You receive an error message when you set up a SQL Server 2008 failover cluster on a subnet that contains only IPv6 addresses (Updated)