June 2008 - Technical Rollup Mail - SQL


Technical RollUp


Is the World Ready for SQL Server 2008 ?

SQL Server 2008, the latest version of the Microsoft database platform, is due for release in second quarter 2008. Microsoft Corporate Vice President of the Data and Platform Storage Division, Ted Kummert, talks with Karen Forster, editorial strategy director of SQL Server Magazine, about key features of SQL Server 2008.



Microsoft Is Positioned in Leaders Quadrant of Latest Magic Quadrant for Data Warehousing


Cumulative update package 7 for SQL Server 2005 Service Pack 2



SQL Server Compact 3.5 SP1 Beta and Synchronization Services for ADO.Net v1.0 SP1 Beta

SQL Server Compact 3.5 SP1 Beta 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 SP1 Beta and Synchronization Services for ADO.Net v1.0 SP1 Beta


Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks

The Windows Live Security team shares best practices - from platform and network security to incident management - in providing security for web applications and infrastructure.


Barrington Captial CS

BCM decided to deploy Windows Server 2008 Standard on one server. The deployment would create a terminal server to provide remote access to a key line-of-business (LOB) application for the existing three users, in addition to remote users that will be added over time—including business partners. The solution would provide a platform for the LOB application, for a Web service, and for a portal. The


The Menninger Clinic CS

The Menninger Clinic needed a safe and simple upgrade of its application and Web service platforms. Interoperability and the availability of third-party administration skills were more important considerations than implementation cost as these ultimately provided continuing savings during day-to-day operations.


Trinity Valley School CS

Trinity Valley School hired Microsoft Certified Partner and Small Business Specialist, and HP Microsoft Frontline Partner, NetVision Consulting to design and deploy a presentation virtualization solution, and terminal services to access the school’s infrastructure.


NetVision Consulting, Inc. CS

NetVision deployed the new solution on an HP ML350 G5 server in a single day using Windows Deployment Services. The company’s new server immediately improved its virtualization scenarios, and provided the company with a greater cache capacity.


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.


Beacon Technologies, Inc. CS

Beacon Technologies, a Microsoft Gold Certified Partner, had its own network issue to address: The company’s technicians would be at customer sites with only limited access to customer history records. Beacon resolved this by deploying the Windows Server® 2008 Terminal Services features, which provided its technicians with real-time access to existing line-of-business (LOB) software.


Stevens, Foster Financial Advisors Inc. CS

To remedy this situation, Stevens Foster partnered with Success Computer Consulting to upgrade from Microsoft Windows® 2000 Server to Windows Server® 2008 per their recommendation. Success Computer Consulting planned and conducted the deployment, conducted testing, and provided ongoing support.


System Center Operations Manager 2007 SP1 Documentation

This download contains documentation for System Center Operations Manager 2007 SP1.


How Microsoft IT Implemented New Storage Designs for Exchange Server 2007

How does Exchange Server 2007 enable a large enterprise to increase mailbox quotas globally by a factor of ten and still lower storage costs, reduce maintenance complexities, and simplify data recovery processes? Microsoft IT was able to take advantage of Cluster Continuous Replication (CCR) in new mailbox server designs based on direct attached storage (DAS).


Microsoft Dynamics CRM 4.0 Performance and Scalability

Microsoft, together with Unisys Corporation, completed benchmark testing of Microsoft Dynamics CRM 4.0 running on Microsoft® Windows Server® 2008 operating system and Microsoft SQL Server® 2008 database software. Benchmark results demonstrate that Microsoft Dynamics CRM can scale to meet the needs of an enterprise.


MSDN Library for VS SP1 (April 2007 Edition)

The MSDN® Library is an essential resource of information for developers using Microsoft® tools, products, and technologies.



White Paper: Security Overview for Database Administrators 2008.  


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.

White Paper: SQL Server 2008 Compared to Oracle Database 11g


Microsoft SQL Server has steadily gained ground on other database systems and now surpasses the competition in terms of performance, scalability, security, developer productivity, business intelligence (BI), and compatibility with the 2007 Microsoft Office System. It achieves this at a considerably lower cost than does Oracle Database 11g.

White Paper: 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.


TechNet Webcast: 24 Hours of SQL Server 2008: Reporting Services Architecture Improvements (Level 200)


Contoso plans to provide employees with access to standard reports using Microsoft SQL Server 2008 Reporting Services. In this webcast, we review the new features in Reporting Services that enable organizations to easily configure and manage a scalable, high-performance reporting infrastructure, including the new physical architecture of Reporting Services, authentication configuration, the new processing and rendering architecture, and memory management. We also provide demonstrations on configuring Reporting Services, using the Configuration Manager, configuring authentication alternatives, and configuring memory settings.

MSDN Webcast: 24 Hours of SQL Server 2008: Reach Users with the 2007 Office System (Level 200)


Throughout this series, we use Contoso as our scenario customer as we explore the features that make up the Microsoft SQL Server 2008 platform. Contoso is a shipping company that delivers all kinds of items around the globe, from small individual items to large manufactured items. Contoso has seen growth in its business over the past years, especially in the movement of goods from China around the world. While Contoso is happy with their in-house applications and believe they provide a significant advantage over competitors, Contoso wants to ensure that these applications are running on the most productive platform to maintain this advantage, especially as their business grows worldwide. The recent growth at Contoso has been mirrored with the growth of its data, from client voice mails to scanned and e-mail documents. These documents are now common as part of insurance claims or parts of quotes. This growth in unstructured data has led Contoso to look at options for its storage, access, security, and searching needs.

MSDN Webcast: geekSpeak: T-SQL Tips and Tricks in SQL Server 2008 with Andrew Karcher (Level 200)


geekSpeak is a new kind of webcast series, hosted by developer evangelists from Microsoft. Dispensing with slide decks and scripted demos, geekSpeak webcasts bring you industry experts in a sort of "talk-radio" format. These experts share their knowledge and experience around a particular developer technology, and they are ready to answer your questions in real time during the webcast. Learn about industry trends, new technology, real-world experiences, and more. During the webcast, you hear lively discussion and debate, and you can even add your comments to the fray. Who knows, you might even see a whiteboard sketch or an off-the-cuff demo.

MSDN Webcast: geekSpeak: Spatial Data in SQL Server 2008 with Denny Cherry (Level 200)


geekSpeak is a new kind of webcast series, hosted by developer evangelists from Microsoft. Dispensing with slide decks and scripted demos, geekSpeak webcasts bring you industry experts in a sort of "talk-radio" format. These experts share their knowledge and experience around a particular developer technology, and they are ready to answer your questions in real time during the webcast. Learn about industry trends, new technology, real-world experiences, and more. During the webcasts, you hear lively discussion and debate, and you can even add your comments to the fray. Who knows, you might even see a whiteboard sketch or an off-the-cuff demo.

TechNet Webcast: SQL Server 2008 for SAP Customers (Level 200)


In this webcast, we talk about what will be delivered to SAP customers in Microsoft SQL Server 2008 including compression, minimal logging, parallelism improvements, and query handling enhancements. Join us to learn how upgrading or migrating to SQL Server 2008 can result in multiple improvements for your SAP implementations.

New KB's

When you use Business Intelligence Development Studio to create a report model project in SQL Server 2005 Reporting Services, the isolation mode that you click in the Isolation list is not used


FIX: Error message when you create a subscription in SQL Server 2005 Compact Edition to a merge publication on SQL Server 2000: "The table name is not valid. [Token line number (if known) = 1,Token line offset (if known) = 22,Table name = <TableName>]"


The identity column of the destination table does not contain the same identity values as the source table after you use SQL Server Management Studio to import data or to export data in Microsoft SQL Server 2005


A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server 2000


FIX: Internet Explorer crashes when you try to print or to preview a report that you view by using SQL Server Reporting Services


When you use dynamic security, SQL Server 2005 Analysis Services does not reevaluate the permissions of the user after the permissions change


How the impersonation information option of a SQL Server 2005 Analysis Services database affects deployment and synchronization


Support WebCast: Microsoft SQL Server 2005 Failover Clustering on Windows Server 2008