December 2007 - Technical Rollup Mail - SQL
News
Try SQL Server 2008 Today – Your Data, Any Place, Any Time
SQL Server 2008, the next release of Microsoft SQL Server, will provide a comprehensive data platform that is more secure, reliable, manageable and scalable for your mission critical applications, while enabling developers to create new applications that can store and consume any type of data on any device, and enabling all your users to make informed decisions with relevant insights. Download the latest SQL Server 2008 Community Technology Preview (CTP) and try out the latest features of SQL Server 2008 for 180 days! The SQL Server development team uses your feedback to help refine and enhance product features. Download the newest CTP today and share your feedback.
https://www.microsoft.com/sql/2008/prodinfo/newfeatures.mspx
https://www.microsoft.com/sql/2008/prodinfo/download.mspx
Try Visual Studio 2008
Microsoft Visual Studio 2008 provides an industry-leading developer experience for Windows Vista, the 2007 Microsoft Office system, and the Web. In addition, it continues in the Microsoft tradition of development language innovation. To enable evaluation of Visual Studio 2008, this page provides links to trial versions of Visual Studio 2008.
https://msdn2.microsoft.com/en-us/vstudio/products/aa700831.aspx
Documents
Reporting Services in SQL Server 2008
Microsoft SQL Server 2008 Reporting Services provides a complete server-based platform that is designed to support a wide variety of reporting needs including managed enterprise reporting, ad-hoc reporting, embedded reporting, and web based reporting to enable organizations to deliver relevant information where needed across the entire enterprise. Reporting Services 2008 provides the tools and features necessary to author a variety of richly formatted reports from a wide range of data sources and provides a comprehensive set of familiar tools used to manage and secure an enterprise reporting solution. Reports are processed and delivered quickly and effectively, enabling users to either receive reports automatically through subscriptions, to access reports from a central report repository on an ad-hoc basis, or to consume reports in context of their business processes through reports directly embedded into their business or web applications.
https://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_ssrs.mspx
What's New for XML in SQL Server 2008
Microsoft introduced XML-related capabilities in Microsoft SQL Server 2000 with the FOR XML and OPENXML Transact-SQL keywords, which enabled developers to write Transact-SQL code to retrieve a query result as a stream of XML, and to shred an XML document into a rowset. SQL Server 2005 extended these XML capabilities significantly with the introduction of a native xml data type that supports XSD schema validation, XQuery-based operations, and XML indexing. SQL Server 2008 builds on the XML capabilities of previous releases and provides enhancements to meet the challenges that customers have faced when storing and manipulating XML data in the database.
https://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_xml.mspx
Managing Unstructured Data with SQL Server 2008
The proliferation of digital content has significant implications for the way in which organizations store and access business data. Increasingly, databases that are at the core of business applications must be integrated with unstructured data in the form of documents, images, video content, and other multimedia formats. Organizations increasingly need to be able to store and manage digital data of all formats in order to manage the information lifecycle, meet compliance requirements, and implement content management solutions. Microsoft SQL Server™ 2008 provides a flexible solution for storing unstructured data and combining it with relational data to build comprehensive solutions that encompass the full range of data across an organization.
https://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_unstructured.mspx
Delivering Location Intelligence with Spatial Data
The growing ability of businesses and consumers to quickly absorb large volumes of data, together with the increased availability of digital maps and spatially-enabled applications has created an unprecedented opportunity to incorporate geographic factors into decision making processes and analysis. The new spatial support in Microsoft SQL Server™ 2008 can help you to make better decisions through visual analysis of location data that can be stored and manipulated in a SQL Server database.
https://www.microsoft.com/sql/techinfo/whitepapers/spatialdata.mspx
SQL Server 2008 Security Overview for Database Administrators
SQL Server 2008 is secure by design, default, and deployment. Microsoft is committed to communicating information about threats, countermeasures, and security enhancements as necessary to keep your data as secure as possible. This paper covers some of the most important security features in SQL Server 2008. It tells you how, as an administrator, you can install SQL Server securely and keep it that way even as applications and users make use of the data stored within.
https://www.microsoft.com/sql/techinfo/whitepapers/SQL2008_Sec_Overview.mspx
Server Consolidation with SQL Server 2008
Microsoft SQL Server 2008 supports multiple options for server consolidation, which provides organizations with the flexibility to choose the consolidation approach that best meets their requirements to centralize data services management and reduce hardware and maintenance costs. By providing centralized management, auditing, and monitoring capabilities, SQL Server 2008 makes it easy to manage multiple databases and data services, which significantly reduces administrative overheads in large enterprises. Finally, SQL Server 2008 provides the reassurance of industry-leading performance and scalability, and unprecedented control over server resource to maximize the performance of consolidated data services.
https://www.microsoft.com/sql/techinfo/whitepapers/sql_srv_consol.mspx
SQL Server 2005 Powers Global Forensic Data Security Tool
The Information Security team at Microsoft uses an internal tool called Information Security Consolidated Event Management (ICE 3.0) to gather forensic data from more than 85 proxy servers around the world. Powered by SQL Server 2005, the 27 TB data management system collects different types of global evidence, such as inbound and outbound e-mail traffic, Login events, and Web browsing, into a single database. ICE 3.0 provides rapid security analysis and queries, robust proxy performance analysis, and extensive troubleshooting functionality. Table level partitions allow event processing and database loading, without affecting the ongoing query activities and analysis work of security forensics engineers. Storage Area Networking (SANs) manage enterprise storage for ICE 3.0, and the service maintains an uptime of 99.9%. A controller application dynamically launches multiple instances of SQL Server Integration Services (SSIS), which seamlessly respond to changes in the volume of incoming evidence. The tool was redesigned in 2006 using SQL Server 2005. The SQL upgrade enhanced the data feed process, query response time, expanded the data retention period, and reduced manual data loading and data validations.
Microsoft Synchronization Services for ADO.NET Books Online
Synchronization Services lets you synchronize data from disparate sources over two-tier, N-tier, and service-based architectures. Instead of only replicating a database and its schema, the Synchronization Services application programming interface (API) provides a set of components to synchronize data between data services and a local store. Applications are increasingly used on mobile clients, such as portable computers and devices, that do not have a consistent or reliable network connection to a central server. It is important for these applications to work against a local copy of data on the client. Equally important is the need to synchronize the local copy of the data with a central server when a network connection is available. The Synchronization Services API is modeled after the ADO.NET data access APIs and gives you an intuitive way to synchronize data. It makes building applications for occasionally connected environments a logical extension of building applications where you can depend on a consistent network connection.
Microsoft SQL Server Compact 3.5 Books Online and Samples
SQL Server Compact 3.5 Books Online provides in-depth information about the features of the product. In addition to the Books Online, the sample applications helps to ramp up quickly on SQL Server Compact technology and an easy way to build applications rapidly. For information about Microsoft Synchronization Services for ADO.Net v1.0 download the Books Online
Scale-Out Querying with Analysis Services Using SAN Snapshots
This SQL Server Best Practices white paper describes the use of virtual copy SAN snapshots in a load-balanced scalable querying environment for Microsoft SQL Server 2005 Analysis Services to increase the number of concurrent queries to Analysis Services servers with a rapid response time per query. Load-balanced querying distributes the load of all queries among the available servers. The use of the virtual copy SAN snapshots eliminates the need to copy data between an Analysis Services processing server and one or more dedicated Analysis Services query servers. This paper supplements the Scale-Out Querying with Analysis Services white paper.
Downloads
Microsoft Synchronization Services for ADO.NET v2.0 CTP1
Microsoft Synchronization Services for ADO.NET provides the ability to synchronize data from disparate sources over two-tier, N-tier, and service-based architectures. Rather than simply replicating a database and its schema, the Synchronization Services application programming interface (API) provides a set of components to synchronize data between data services and a local store. Applications are increasingly used on mobile clients, such as laptops and devices, that do not have a consistent or reliable network connection to a central server. It is crucial for these applications to work against a local copy of data on the client. Equally important is the need to synchronize the local copy of the data with a central server when a network connection is available. The Synchronization Services API, which is modeled after the ADO.NET data access APIs, gives you an intuitive way to synchronize data. It makes building applications for occasionally connected environments a logical extension of building applications where you can count on a consistent network connection.
Visual Studio 2005 Support for SQL Server 2008, Community Technology Preview
This CTP resolves a problem that when you try to open a database connection to SQL Server 2008 by using Visual Studio 2005 design tools, you may receive the following error message:
“This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.”
This CTP addresses this issue, and enables the following Visual Studio functionality for SQL Server 2008 CTP5 :
- Server Explorer successfully connects to SQL Server 2008, and database objects such as stored procedures and table data can be viewed and edited. Note that table schemas still cannot be viewed or edited in this release.
- SQL CLR projects that target SQL Server 2008 CTP5 can be created and deployed to the server.
- T-SQL and SQL CLR debugging are now enabled for SQL Server 2008 CTP5.
- Data binding features in Client and Web Projects are enabled.
Microsoft SQL Server 2005 MSIT Comprehensive Configuration Pack for Configuration Manager 2007
The Microsoft SQL Server 2005 MSIT Comprehensive Configuration Pack is designed to be used for managing the configuration of SQL 2005 servers. This configuration pack defines recommended configurations based on an extensive number of settings affecting the configuration of SQL 2005 servers in the Microsoft IT environment. A partial list of the included configuration items and settings can be obtained by downloading the Microsoft SQL Server 2005 MSIT Basic Configuration Pack and/or the Microsoft SQL Server 2005 MSIT Intermediate Configuration Pack. It is recommended that users begin by evaluating their configuration against the Basic configuration pack, and then progress to the Intermediate and Comprehensive configuration packs as desired configurations are verified.
Microsoft SQL Server 2005 MSIT Intermediate Configuration Pack for Configuration Manager 2007
The Microsoft SQL Server 2005 MSIT Intermediate Configuration Pack is designed to be used for managing the configuration of SQL 2005 servers. This configuration pack defines recommended configurations based on a substantial number of settings affecting the configuration of SQL 2005 servers in the Microsoft IT environment. A partial list of the included configuration items and settings can be obtained by downloading the Microsoft SQL Server 2005 MSIT Basic Configuration Pack; more extensive configuration items and settings can be obtained by downloading the Microsoft SQL Server 2005 MSIT Comprehensive Configuration Pack. It is recommended that users begin by evaluating their configuration against the Basic configuration pack, and ten progress to the Intermediate and Comprehensive configuration packs as desired configurations are verified.
Microsoft SQL Server 2005 MSIT Basic Configuration Pack for Configuration Manager 2007
The Microsoft SQL Server 2005 MSIT Basic Configuration Pack is designed to be used for managing the configuration of SQL 2005 servers. This configuration pack defines recommended configurations based on a limited number of settings affecting the configuration of SQL 2005 servers in the Microsoft IT environment. More extensive configuration items and settings can be obtained by downloading the Microsoft SQL Server 2005 MSIT Intermediate and Comprehensive Configuration Packs. It is recommended that users begin by evaluating their configuration against the Basic configuration pack, and then progress to the Intermediate and Comprehensive configuration packs as desired configurations are verified. Once imported into SCCM 2007, this configuration pack and its included configuration items can be targeted to collections of systems which are then audited for compliance with the recommended configurations. When settings are detected to be out of compliance, events will be generated and sent to the Configuration Manager server where the data is available for reporting.
SQL Server 2008 Books Online Community Technology Preview (November 2007)
SQL Server 2008, the next release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. Download a pre-release preview of Books Online for SQL Server 2008. If you were looking for the latest released version of Books Online, visit the SQL Server 2005 Books Online page on the Microsoft Download Center. Note: This pre-release version of the SQL Server 2008 Books Online may contain topics that are empty, incomplete, or not up to date. Topics for new features may be missing and not all new or updated content has been reviewed for technical accuracy.
Microsoft SQL Server 2005 Assessment Configuration Pack for Health Insurance Portability and Accountability Act (HIPAA)
The Microsoft SQL Server 2005 Assessment Configuration Pack for Health Insurance Portability and Accountability Act was developed in conjunction with Brabeion Software, and contains suggested system configurations that map best practices and standards to the requirements of the Health Insurance Portability and Accountability Act. This configuration pack defines recommended configurations based on a number of settings-based configuration items, and assesses your system against the desired configuration. Once imported into SCCM 2007, this configuration pack and its included configuration items can be targeted to collections of systems which are then audited for compliance with the recommended configurations. When settings are detected to be out of compliance, events will be generated and sent to the Configuration Manager server where the data is available for reporting.
Microsoft SQL Server 2005 Assessment Configuration Pack for European Union Data Protection Directive (EUDPD)
The Microsoft SQL Server 2005 Assessment Configuration Pack for European Union Data Protection Directive was developed in conjunction with Brabeion Software, and contains suggested system configurations that map best practices and standards to the requirements of the European Union Data Protection Directive. This configuration pack defines recommended configurations based on a number of settings-based configuration items, and assesses your system against the desired configuration. Once imported into SCCM 2007, this configuration pack and its included configuration items can be targeted to collections of systems which are then audited for compliance with the recommended configurations. When settings are detected to be out of compliance, events will be generated and sent to the Configuration Manager server where the data is available for reporting.
Microsoft SQL Server 2005 Assessment Configuration Pack for Federal Information Security Management Act (FISMA)
The Microsoft SQL Server 2005 Assessment Configuration Pack for Federal Information Security Management Act was developed in conjunction with Brabeion Software, and contains suggested system configurations that map best practices and standards to the requirements of the Federal Information Security Management Act. This configuration pack defines recommended configurations based on a number of settings-based configuration items, and assesses your system against the desired configuration. Once imported into SCCM 2007, this configuration pack and its included configuration items can be targeted to collections of systems which are then audited for compliance with the recommended configurations. When settings are detected to be out of compliance, events will be generated and sent to the Configuration Manager server where the data is available for reporting.
Microsoft SQL Server 2005 Assessment Configuration Pack for Sarbanes-Oxley Act (SOX)
The Microsoft SQL Server 2005 Assessment Configuration Pack for Sarbanes-Oxley Act was developed in conjunction with Brabeion Software, and contains suggested system configurations that map best practices and standards to the requirements of the Sarbanes-Oxley Act. This configuration pack defines recommended configurations based on a number of settings-based configuration items, and assesses your system against the desired configuration. Once imported into SCCM 2007, this configuration pack and its included configuration items can be targeted to collections of systems which are then audited for compliance with the recommended configurations. When settings are detected to be out of compliance, events will be generated and sent to the Configuration Manager server where the data is available for reporting.
Microsoft SQL Server 2005 Assessment Configuration Pack for Gramm-Leach Bliley Act (GLBA)
The Microsoft SQL Server 2005 Assessment Configuration Pack for Gramm-Leach Bliley Act was developed in conjunction with Brabeion Software, and contains suggested system configurations that map best practices and standards to the requirements of the Gramm-Leach Bliley Act. This configuration pack defines recommended configurations based on a number of settings-based configuration items, and assesses your system against the desired configuration. Once imported into SCCM 2007, this configuration pack and its included configuration items can be targeted to collections of systems which are then audited for compliance with the recommended configurations. When settings are detected to be out of compliance, events will be generated and sent to the Configuration Manager server where the data is available for reporting.
Microsoft SQL Server 2008 CTP, November 2007
Microsoft SQL Server 2008, the next release of Microsoft SQL Server, provides a comprehensive data platform that is more secure, reliable, manageable and scalable for your mission critical applications, while enabling developers to create new applications that can store and consume any type of data on any device, and enabling all your users to make informed decisions with relevant insights.
Microsoft SQL Server Compact 3.5 and Microsoft Synchronization Services for ADO.Net v1.0 for Windows Desktop
SQL Server Compact 3.5 is a small footprint in-process database engine that allows developers to build robust applications for Windows Desktops and Mobile Devices. This download contains the files for SQL Server Compact 3.5 and Synchronization Services for ADO.Net v1.0 for Windows Desktop platform.
Microsoft SQL Server Compact 3.5 for Windows Mobile
SQL Server Compact 3.5 for Devices Windows Installer contains the CAB files and DLL’s for installation on the Windows Mobile platform. When compared to its previous release, SQL Server Compact 3.5 includes a host of new features including the following:
- Side-by-side installation together with SQL Server 2005 Compact Edition (version 3.1)
- Support for newer and more secure encryption algorithms
- Additional timestamp (rowversion) data type
ReportViewer Samples for Microsoft Visual Studio 2008
Visual Studio 2008 includes ReportViewer controls that you can use to add rich data reporting to Windows forms and ASP.NET applications. This download provides two complete samples so that you can view the control and sample reports in a finished application.
- The RSSNewsReader sample is a Windows form application written in Visual C#. It retrieves data from live news feeds and presents that data in a report. The report demonstrates how to use parameters to filter the dataset.
- The Web Log Analyzer is a Windows form application written in Visual Basic. It analyzes log files created by Web servers, such as Microsoft Internet Information Services (IIS). It includes reports that show statistics on page hits, server activity, and referrals from other sites.
Microsoft SQL Server Compact 3.5 Server Tools
SQL Server Compact 3.5 Server Tools installs replication components on the IIS server enabling merge replication and remote data access (RDA) between SQL Server Compact 3.5 database on a Windows Desktop & Mobile devices and database servers running SQL Server 2005 and later versions of SQL Server 2005. This install is not required for Synchronization Services for ADO.NET
SQL Server Compact 3.5 Server Tools cannot be installed Side-by-Side on the same IIS server with previous versions of SQL Server 2005 Compact Edition Server Tools or with SQL Server 2005 Mobile Edition Server Tools. Using SQL Server Compact 3.5 Server Tools you can synchronize between SQL Server Compact 3.5 or SQL Server 2005 Compact Edition or SQL Server 2005 Mobile Edition versions of the client database and SQL Server 2005 and later versions of SQL Server 2005.
Search Server 2008 Sample: Federated Search Connector Sample
Microsoft Search Server 2008 provides you with the ability to include items from content repositories that are not indexed by the search server’s crawler through federated locations. Search Server 2008 supports federating search from the local search index, as well as sites that support the OpenSearch 1.0 or 1.1 standard and returns search results in a structured XML format (for example, RSS or Atom results). To include federated search results from other types of content repositories, you must create a federated connector. When the repository does not expose a searchable XML feed, this federated connector must include an interface to expose results from the repository. The interface must support querying via OpenSearch and return XML formatted results.
Events / WebCasts
SQL 2005 Webcasts and Virtual Labs
SQL Server 2005 is data management and analysis software that delivers enhanced security, availability, and scalability to mission-critical data applications—while making them easier to develop, deploy, and manage. Choose from a wide range of live and on-demand webcasts. Or take part in a virtual lab, which allows you to cut your teeth on the new platform by experimenting with its different capabilities.
TechNet Webcast: Prepare Yourself for Windows Server 2008 (Part 1 of 8): Product Workload Scenarios (Level 300) – Monday, December 03, 2007 9:30 AM Pacific Time (US & Canada)
In this first session of our series, we discuss how Windows Server 2008 addresses key deployment scenarios for customers. We start with an overview of the key product workload scenarios for Windows Server 2008. We cover as many as 10 different scenarios, and we discuss how each scenario can be categorized into one of three different design pillars. While examining the scenarios, we take a closer look at the specific technologies used within the scenario, describe how they are used, and explain why they are needed. We show which technologies comprise each scenario and the value propositions they deliver. Finally, we see how the scenario adds value to Windows Server 2008 and, in some cases, we provide real-world examples of usages for the scenario.
MSDN Webcast: New T-SQL Programmability Features in SQL Server 2008 (Level 300) – Tuesday, December 04, 2007 1:00 PM Pacific Time (US & Canada)
Join this webcast on new T-SQL programmability features in Microsoft SQL Server 2008, an extension from last year's presentation on top Microsoft SQL Server 2005 T-SQL features. We cover exciting new features such as:
New data types (i.e. date/time, filestream, HierarchyID, large UDT, sparse columns)
Dependency management for database objects
Procedure programming (i.e. table value parameter)
Data warehousing enhancements (i.e. Merge data manipulation language (DML) statement, grouping set, filtered indexing)
Supportability (i.e. Data Definition Language (DDL) trigger)
MSDN Webcast: New T-SQL Programmability Features in SQL Server 2008 (Level 300)
Momentum Webcast: Migrating from Access to SQL Server (Level 100) – Wednesday, December 05, 2007 11:00 AM Pacific Time (US & Canada)
Technical audiences currently using Microsoft Office Access will benefit from this tutorial on how to easily migrate databases from Microsoft Office Access 97 through Microsoft Office Access 2003 to Microsoft SQL Server 2005 using Microsoft SQL Server Migration Assistant (SSMA). In this webcast, Dmitry Balin, director of SQL Server marketing, explains different methods of upsizing Access applications to SQL Server (linked tables, Access projects , rewriting to the Microsoft .NET Framework) and shows how SQL Server Migration Assistant automates, streamlines, and simplifies this process. SSMA for Access converts Access database objects to SQL Server database objects, loads those objects into SQL Server, and then migrates data from Access to SQL Server. Dmitry also shares experiences from other customers who have benefited from using SSMA and SQL Server to improve their business processes.
Momentum Webcast: Migrating from Access to SQL Server (Level 100)
TechNet Webcast: Using the New Policy-Based Management Framework in SQL Server 2008 (Level 300) – Thursday, December 06, 2007 11:30 AM Pacific Time (US & Canada)
Microsoft SQL Server 2008 introduces a new policy-based framework for database administrators, which can significantly improve administrative productivity and reliability. Database administrators declare their administrative intent through policies that are then applied by the system. This approach reduces the potential for administrative error and enables the framework to monitor or enforce the policies in an automated fashion. Not only can policies be applied to individual databases or tables on a single server, but they can also seamlessly be scaled to include large collections of objects spanning many server instances.
TechNet Webcast: Using the New Policy-Based Management Framework in SQL Server 2008 (Level 300)
Momentum Webcast: SQL Server 2008 (Part 2 of 3): Expanding Business Intelligence Capabilities (Level 100) – Thursday, December 06, 2007 1:00 PM Pacific Time (US & Canada)
Join us for this second webcast in our three-part series on Microsoft SQL Server 2008 to learn all about its new features. SQL Server 2008 builds on the strong momentum in the business intelligence (BI) market by providing a scalable infrastructure that enables IT to drive BI throughout your organization and deliver intelligence where users want it. SQL Server 2008 makes great strides in data warehousing, providing a comprehensive and scalable platform that lets organizations integrate data into the data warehouse faster and to scale and manage that data while delivering insight to all users. With the more scalable BI infrastructure provided by SQL Server 2008, you can easily manage reports and analysis of any size or complexity, and at the same time, empower users through the deeper integration with Microsoft Office programs. SQL Server 2008 also delivers improved performance in many areas, including data warehousing, reporting, and analytics. Join us to learn how you can use SQL Server 2008 to get the right information to the right people in the right format on the right device.
MCP Live Meeting: SQL Server 2008 and Your Microsoft Certifications (Session 1) – Wednesday, December 12, 2007 7:30 AM Pacific Time (US & Canada)
Join the Microsoft Certification team for guidance on your certification path for SQL Server. In this meeting, we will introduce our plans for SQL Server 2008 training and certification, review the SQL Server 2005 certifications, and answer your individual questions about the path that is right for you, in Business Intelligence, Database Development, or Database Administration.
MCP Live Meeting: SQL Server 2008 and Your Microsoft Certifications (Session 1)
Momentum Webcast: SQL Server 2008 (Part 3 of 3): Reducing Hardware and Maintenance Costs with Server Consolidation (Level 100) – Wednesday, December 12, 2007 11:00 AM Pacific Time (US & Canada)
Join us for this final webcast in our three-part series on Microsoft SQL Server 2008 to learn all about its new features. SQL Server 2008 can help reduce hardware and maintenance costs by providing a flexible server consolidation solution. Organizations can centralize data services on fewer servers through server virtualization and support for multiple service instances on a single physical server, along with the tools and functionality to migrate distributed data to a consolidated data center. By providing a centralized data services management interface and declarative, policy-based configuration management, SQL Server can make it easy for organizations with multiple data stores to reduce management overhead. Finally, the enhanced performance in SQL Server 2008 and the ability to explicitly control how your server resources are used enable you to consolidate your data services while providing the scalability and performance your applications need. Join us to learn how you can use SQL Server 2008 to get the right information to the right people in the right format on the right device.
TechNet Webcast: Microsoft SQL Server and FileMaker Pro 9 Interoperability (Level 200) – Wednesday, December 12, 2007 1:00 PM Pacific Time (US & Canada)
Microsoft SQL Server works seamlessly with FileMaker Pro version 9. FileMaker is more than database software; it is a rapid-application development environment that anyone can use to quickly create solutions for collecting, managing, and reporting data. Join this webcast to understand how developers can benefit from connecting FileMaker Pro 9 and Microsoft SQL Server. We also show a technology demonstration of FileMaker Pro 9 connecting with Microsoft SQL Server.
TechNet Webcast: Microsoft SQL Server and FileMaker Pro 9 Interoperability (Level 200)
MCP Live Meeting: SQL Server 2008 and Your Microsoft Certifications (Session 2) – Wednesday, December 12, 2007 5:00 PM Pacific Time (US & Canada)
Join the Microsoft Certification team for guidance on your certification path for SQL Server. In this meeting, we will introduce our plans for SQL Server 2008 training and certification, review the SQL Server 2005 certifications, and answer your individual questions about the path that is right for you, in Business Intelligence, Database Development, or Database Administration.
MCP Live Meeting: SQL Server 2008 and Your Microsoft Certifications (Session 2)
Further on-demand webcasts are available here: https://www.microsoft.com/events/series/technetsqlserver2005.mspx
New KB’s
SQL Server 2000 Standard Edition
Error message when you insert data in an article that has automatic identity range handling enabled in a merge replication in SQL Server 2000: "The identity range managed by replication is full and must be updated by a replication agent"
https://support.microsoft.com/?kbid=939318
SQL Server 2005 Compact Edition
A file and some registry entries are missing when you upgrade SQL Server Compact 3.5 Beta to SQL Server Compact 3.5
https://support.microsoft.com/?kbid=945317
SQL Server 2005 Standard Edition
FIX: All later commands are ignored after the SQLDescribeParam function returns an error message in a SQL Server 2005-based application that uses the SQL Native Client ODBC provider
https://support.microsoft.com/?kbid=942704
FIX: You cannot bring the SQL Server group online in a cluster environment after you rename the virtual server name of the default instance of SQL Server 2005
https://support.microsoft.com/?kbid=934812
FIX: Error message on a Windows Vista-based computer when you try to query data from a column of the XML data type or from a variable of the XML data type in a SQL Server 2005: "Unexpected end of file has occurred"
https://support.microsoft.com/?kbid=941720
FIX: Error message when you create a WMI event alert by using the sp_add_alert stored procedure in SQL Server 2005: "The @wmi_query could not be executed in the @wmi_namespace provided"
https://support.microsoft.com/?kbid=944517
Error message when you connect to a named instance of SQL Server on a client computer that is running Windows Vista or Windows Server 2008: "Specified SQL server not found" or "Error Locating Server/Instance Specified"
https://support.microsoft.com/?kbid=944390
You cannot start the SQL Server Agent service of a failover cluster of SQL Server 2005 if the build of SQL Server build is 3179 or a later build
https://support.microsoft.com/?kbid=943525
FIX: A federated database server stops responding when you run parallel queries on a multiprocessor computer that uses NUMA architecture in SQL Server 2005
https://support.microsoft.com/?kbid=944902
Error message when an SSIS package runs that is scheduled to run as a SQL Server Agent job: "An OLE DB error has occurred. Error code: 0x80004005"
https://support.microsoft.com/?kbid=933835
SQL Server 2000 Analysis Services
Error message when you use the ADOMD.NET data provider in an application to connect to an instance of SQL Server 2000 Analysis Services: "The session, '<SessionID>', does not exist"
https://support.microsoft.com/?kbid=915837
SQL Server 2005 Analysis Services
FIX: The operation takes a long time to be completed when you process a partition that has proactive caching enabled in SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=935831
FIX: When you run an MDX query for the second time, the query does not run faster than the first time that you ran the query in SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=936262
You obtain no result set when you run an MDX query against an instance of SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=944527
FIX: SQL Server 2005 Analysis Services stops responding when you run an MDX query that references a measure of the double data type or a calculated member of the double data type
https://support.microsoft.com/?kbid=943526
SQL Server 2000 Reporting Services
FIX: The document map area of a SQL Server 2000 Reporting Services report may be blank when you view the report in Windows Internet Explorer 7
https://support.microsoft.com/?kbid=935227
FIX: You cannot open an Excel workbook that is exported from SQL Server 2000 Reporting Services on a Macintosh computer
https://support.microsoft.com/?kbid=944486
SQL Server 2005 Reporting Services
After you install Cumulative Update Package 4 for SQL Server 2005 SP2, time stamp information that is related to the RSPrintClient ActiveX control is logged in the report server log file
https://support.microsoft.com/?kbid=943285
FIX: Message when you click the Back button in Internet Explorer 7 to return to a SQL Server 2005 Reporting Services report that contains one or more DateTime parameters: "Report is being generated"