Technical RollUp

Premier Field Engineering - Technical Rollup Mails

August 2008 - Technical Rollup Mail - SQL

August 2008 - Technical Rollup Mail - SQL

  • Comments 1
  • Likes

 

News

Technical RollUp

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

 

SQL Server 2008 RC0 Available for Everyone

http://blogs.technet.com/dataplatforminsider/archive/2008/06/10/sql-server-2008-rc0-available-for-everyone.aspx

 

 

Downloads

SQL Server 2005 Driver for PHP

Download the SQL Server 2005 Driver for PHP, a PHP 5 extension that allows for the reading and writing of SQL Server data from within PHP scripts.

http://www.microsoft.com/downloads/info.aspx?na=22&p=1&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d61bf87e0-d031-466b-b09a-6597c21a2e2a%26displaylang%3den

 

Microsoft® Visual Studio Team System 2008 Database Edition GDR July CTP

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

 

SSMA 2008 for Sybase V4.0

Automates database migration from Sybase ASE to SQL Server 2008.

http://www.microsoft.com/downloads/info.aspx?na=22&p=3&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d4fc68b67-149f-4237-8869-e70b68947f4f%26displaylang%3den

 

SSMA 2008 for Sybase PowerBuilder Applications v1.0

SQL Server Migration Assistant (SSMA) 2008 for Sybase PowerBuilder Applications is a tool that cuts the effort, cost, and risk of migrating PowerBuilder Applications designed for Sybase to SQL Server 2008.

http://www.microsoft.com/downloads/info.aspx?na=22&p=4&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dad09f718-7d6f-499b-8a6a-0ea98e0c0295%26displaylang%3den

 

SSMA 2008 for Oracle V4.0

SQL Server Migration Assistant (SSMA) 2008 for Oracle is a complete suite of tools that dramatically cuts the effort, cost, and risk of migrating from Oracle to SQL Server 2008.

http://www.microsoft.com/downloads/info.aspx?na=22&p=5&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d3e8722ae-77f3-4288-906d-f421e24d322f%26displaylang%3den

 

SSMA 2005 for Sybase V4.0

Automates database migration from Sybase ASE to SQL Server 2005.

http://www.microsoft.com/downloads/info.aspx?na=22&p=6&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d842b092d-c123-4c76-8051-30b16e45d554%26displaylang%3den

 

SSMA 2005 for Oracle V4.0

SQL Server Migration Assistant (SSMA) 2005 for Oracle is a complete suite of tools that dramatically cuts the effort, cost, and risk of migrating from Oracle to SQL Server 2005.

http://www.microsoft.com/downloads/info.aspx?na=22&p=7&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d6d9bc6a7-75da-493e-bee5-50f4a4352b91%26displaylang%3den

 

SSMA 2005 for Access V4.0

Automates database migration from Access to SQL Server 2005.

http://www.microsoft.com/downloads/info.aspx?na=22&p=8&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d4ecd1e67-c64e-49e6-821e-c4d83d9d5fed%26displaylang%3den

 

SSMA 2008 for Access V4.0

Automates database migration from Access to SQL Server 2008.

http://www.microsoft.com/downloads/info.aspx?na=22&p=9&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d133b59c2-c89c-4641-bebb-6d04476ec1ba%26displaylang%3den

 

System Center Data Protection Manager 2007 Feature Pack (x86)

This Update bundles the following features: Windows Server 2008 support, SQL Server 2008 support, enhanced support for sharing tape libraries and better tape utilization.

http://www.microsoft.com/downloads/info.aspx?na=22&p=10&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3de9e1fe35-b175-40a8-8378-2f306ccc9e28%26displaylang%3den

 

System Center Data Protection Manager 2007 Feature Pack (x64)

This Update bundles the following features: Windows Server 2008 support, SQL Server 2008 support, enhanced support for sharing tape libraries and better tape utilization.

http://www.microsoft.com/downloads/info.aspx?na=22&p=11&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dad5cd1a2-9b87-4a2c-90a2-9dbaf1024310%26displaylang%3den

 

Microsoft Dynamics GP 10.0 Benchmark Performance White Paper: 1,000 Concurrent Users with Microsoft SQL Server 2005

This white paper documents performance benchmark testing for running Microsoft Dynamics GP 10.0 with 1,000 constant concurrent users, all engaged in heavy transaction processing or analysis activity across various functional areas of the solution.

http://www.microsoft.com/downloads/info.aspx?na=22&p=12&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3de0e92459-f611-4957-85be-823f0b88cff5%26displaylang%3den

 

SQL Server 2008 Privacy Statement

Read the Privacy Statement document for Microsoft SQL Server 2008.

http://www.microsoft.com/downloads/info.aspx?na=22&p=13&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3de7f89bf5-d80c-46b5-a12f-fade6d41330d%26displaylang%3den

 

Source Code Analyzer for SQL Injection

Microsoft Source Code Analyzer for SQL Injection is a static code analysis tool for finding SQL Injection vulnerabilities in ASP code. Customers can run the tool on their ASP source code to help identify code paths that are vulnerable to SQL Injection attacks.

http://www.microsoft.com/downloads/info.aspx?na=22&p=14&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d58a7c46e-a599-4fcb-9ab4-a4334146b6ba%26displaylang%3den

 

Security Update for Windows Server 2003 (KB948110)

A security issue has been identified in the Microsoft SQL Server 2000 Desktop Engine (WMSDE) that could allow an attacker to compromise your Microsoft Windows-based system and gain control over it.

http://www.microsoft.com/downloads/info.aspx?na=22&p=15&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d1c0ae18b-1f17-44b3-a337-b36e7de437a7%26displaylang%3den

 

Security Update for SQL Server 2005 Service Pack 2 (KB948109)

A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your system and gain control over it.

http://www.microsoft.com/downloads/info.aspx?na=22&p=16&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d4c9851cc-2c4c-4190-872c-84993a7623b7%26displaylang%3den

 

SQL Server 2000 Service Pack 4 and MSDE 2000 (KB948111)

Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000 (KB948111)

http://www.microsoft.com/downloads/info.aspx?na=22&p=17&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d8316bc5e-8c2d-4710-8acc-b815ccc81cd4%26displaylang%3den

 

SQL Server 2000 Service Pack 4 and MSDE 2000 (KB948110)

Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000 (KB948110)

http://www.microsoft.com/downloads/info.aspx?na=22&p=18&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d4fd1f86a-94a2-43d8-9b0a-774c81426d9e%26displaylang%3den

 

SQL Server 7.0 and MSDE 1.0 Service Pack 4 (KB948113)

A security issue has been identified in the SQL Server 7.0 and MSDE 1.0 Service Pack 4

http://www.microsoft.com/downloads/info.aspx?na=22&p=19&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dc95b2cb3-51a4-44e4-b9f4-9416e9ce16a0%26displaylang%3den

 

Security Update for SQL Server 2005 Service Pack 2 (KB948108)

A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your system and gain control over it.

http://www.microsoft.com/downloads/info.aspx?na=22&p=20&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3da60bb7e7-ef4e-4cbd-b63a-0ad7bd1402b3%26displaylang%3den

 

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.

http://www.microsoft.com/downloads/info.aspx?na=22&p=21&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d91ef5106-944a-41e1-b3a0-5bd3f2356f32%26displaylang%3den

 

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.

http://www.microsoft.com/downloads/info.aspx?na=22&p=22&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3db8704100-0127-4d88-9b5d-896b9b388313%26displaylang%3den

 

SQL Server JDBC Driver 2.0 CTP (July 2008)

Download the SQL Server JDBC Driver 2.0 CTP, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5.

http://www.microsoft.com/downloads/info.aspx?na=22&p=23&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3df914793a-6fb4-475f-9537-b8fcb776befd%26displaylang%3den

 

SQL Server 2008 RC0 Release Notes

This Release Notes document contains information for Microsoft SQL Server 2008 Release Candidate 0 (RC0) that supplements the SQL Server 2008 RC0 Readme and Books Online documentation. This document describes behaviors that apply only to this release or that are not documented in this release of Books Onl

http://www.microsoft.com/downloads/info.aspx?na=22&p=24&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3ddaf00920-7214-418a-a4b0-727f4ce08f81%26displaylang%3den

 

Documents

White Paper: Microsoft Data Platform Development

http://www.microsoft.com/sqlserver/2008/en/us/wp-sql-2008-data-development.aspx

Microsoft SQL Server 2008 and the Microsoft data platform provide developers with a comprehensive programming framework in which to create data-centric solutions that target mobile devices, desktops, Web servers, and enterprise servers. This data programming environment improves developer productivity by integrating data access and management into the business logic of an application. It provides a comprehensive platform for data access and management from disparate data sources, and a scalable solution for data storage and applications.

 

Database Encryption in SQL Server 2008 Enterprise Edition

http://msdn.microsoft.com/en-us/library/cc278098(SQL.100).aspx

With the introduction of transparent data encryption (TDE) in SQL Server 2008, users now have the choice between cell-level encryption as in SQL Server 2005, full database-level encryption by using TDE, or the file-level encryption options provided by Windows. TDE is the optimal choice for bulk encryption to meet regulatory compliance or corporate data security standards. TDE works at the file level, which is similar to two Windows® features: the Encrypting File System (EFS) and BitLocker™ Drive Encryption, the new volume-level encryption introduced in Windows Vista®, both of which also encrypt data on the hard drive. TDE does not replace cell-level encryption, EFS, or BitLocker. This white paper compares TDE with these other encryption methods for application developers and database administrators. While this is not a technical, in-depth review of TDE, technical implementations are explored and a familiarity with concepts such as virtual log files and the buffer pool are assumed. The user is assumed to be familiar with cell-level encryption and cryptography in general. Implementing database encryption is covered, but not the rationale for encrypting a database.

 

Events/Webcasts

TechNet Webcast: Security Enhancements in SQL Server 2008 (Level 300)

https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032364703&EventCategory=5&culture=en-US&CountryCode=US

Microsoft SQL Server 2005 introduced many security enhancements, from data encryption to advanced context impersonation. Microsoft SQL Server 2008 further helps administrators protect their database with the introduction of new features such as Transparent Database Encryption, Extensible Key Management, and Auditing. In this session, we describe the new security enhancements in SQL Server 2008 and discuss how to best take advantage of them.

 

TechNet Webcast: SQL Server 2008 (Part 1 of 3): High-Performance Data Warehousing (Level 300) 

https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032365533&EventCategory=5&culture=en-US&CountryCode=US

Attend this session to learn how to incorporate the new features in Microsoft SQL Server 2008 to provide a high-performance data warehouse that can scale to larger number of users and growing volumes of data. In this session, we cover new technologies like partitioned table parallelism, star join query enhancements, and Grouping Sets.

 

TechNet Webcast: SQL Server 2008 Performance and Scalability Technologies (Level 300)

https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032354211&EventCategory=5&culture=en-US&CountryCode=US

Microsoft SQL Server 2008 supports very large databases, enterprise-scale reporting systems, and data warehouses. It provides growing database systems with tools and features to optimize performance, scale up individual servers, and scale out very large databases. SQL Server 2008 is designed to take advantage of the latest hardware technologies to support server consolidation. Throughout this presentation, we look into SQL Server 2008 performance and scalability technologies and show how you can use these technologies to provide optimal performance and responsiveness for your large data solutions.

 

New KB's

You obtain no result when you use an aggregate in a filter in Report Builder of SQL Server 2005 Reporting Services

http://support.microsoft.com/?kbid=954784

 

FIX: SQL Server 2005 Express Edition cannot pass the Windows logo certification when you install an ISV application on a Windows Vista-based computer or on a Windows Server 2008-based computer

http://support.microsoft.com/?kbid=953970

 

FIX: When you update more than one row in a table that is joined to another table in SQL Server 2005, some rows are not added

http://support.microsoft.com/?kbid=953627

 

FIX: CPU utilization may be high when you configure more than one transactional replication on a computer that has multiple processors in SQL Server 2005

http://support.microsoft.com/?kbid=953811

 

FIX: When you use SQL Native Client to retrieve data from a column of the sql_variant data type in SQL Server 2005, an incorrect data type is returned

http://support.microsoft.com/?kbid=953946

 

FIX: The size of a database keeps increasing when you perform many DELETE operations and many INSERT operations on the database in SQL Server 2005

http://support.microsoft.com/?kbid=953991

 

FIX: When you define an alert activity on a fractional performance counter of an instance of Microsoft SQL Server 2005 in System Monitor, the alert does not work

http://support.microsoft.com/?kbid=953850

 

FIX: Error message after you run the DBCC DBREINDEX Transact-SQL statement on a table that does not have a unique clustered index on a SQL Server 2005-based computer: "Msg 2511"

http://support.microsoft.com/?kbid=954734

 

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