Technical RollUp

Premier Field Engineering - Technical Rollup Mails

October 2008 - Technical Rollup Mail - SQL

October 2008 - Technical Rollup Mail - SQL

  • Comments 1
  • Likes

Downloads

Microsoft SQL Server 2008 Feature Pack, August 2008

Download the 2008 Feature Pack for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide additional value for SQL Server 2008.

http://www.microsoft.com/downloads/info.aspx?na=22&p=1&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dc6c3e9ef-ba29-4a43-8d69-a2bed18fe73c%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=2&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=3&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d4fd1f86a-94a2-43d8-9b0a-774c81426d9e%26displaylang%3den

System Center Operations Manager 2007 SP1 Documentation

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

http://www.microsoft.com/downloads/info.aspx?na=22&p=4&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dd826b836-59e5-4628-939e-2b852ed79859%26displaylang%3den

ILM 2007 Getting Started

The Getting Started Collection introduces users to various features and functionality of ILM 2007.

http://www.microsoft.com/downloads/info.aspx?na=22&p=5&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d11fb01bc-94a9-4404-bb90-ceca1a206e32%26displaylang%3den

Microsoft SQL Server 2008 Enterprise Evaluation: Trial Experience for Developers

Download SQL Server 2008 180-day Trial Software. Microsoft SQL Server 2008 is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data analysis and reporting solutions.

http://www.microsoft.com/downloads/info.aspx?na=22&p=6&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d6b10c7c1-4f97-42c4-9362-58d4d088cd38%26displaylang%3den

Microsoft SQL Server 2008 Enterprise Evaluation: Trial Experience for IT Professionals

Download SQL Server 2008 180-day Trial Software. Microsoft SQL Server 2008 is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data analysis and reporting solutions.

http://www.microsoft.com/downloads/info.aspx?na=22&p=7&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d265f08bc-1874-4c81-83d8-0d48dbce6297%26displaylang%3den

Update for Windows XP (KB954920)

In some instances, applications using WDAC may return errors and lose connections to SQL Server 2008 servers if they try to access data in the new collations.

http://www.microsoft.com/downloads/info.aspx?na=22&p=8&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d16332629-da01-4763-8abc-5243286db3b3%26displaylang%3den

Update for Windows Vista for x64-based Systems (KB954920)

In some instances, applications using WDAC may return errors and lose connections to SQL Server 2008 servers if they try to access data in the new collations.

http://www.microsoft.com/downloads/info.aspx?na=22&p=9&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3da8a0d9c2-3c41-47c4-8706-3b18806dcf25%26displaylang%3den

Update for Windows Server 2008 (KB954920)

In some instances, applications using WDAC may return errors and lose connections to SQL Server 2008 servers if they try to access data in the new collations.

http://www.microsoft.com/downloads/info.aspx?na=22&p=10&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d0fad9615-cfd2-4b30-aa90-e4cbe7a63200%26displaylang%3den

Update for Windows Server 2003 x64 Edition (KB954920)

In some instances, applications using WDAC may return errors and lose connections to SQL Server 2008 servers if they try to access data in the new collations.

http://www.microsoft.com/downloads/info.aspx?na=22&p=11&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3de3ccccb2-67cd-4082-bbb7-9ac71da8ca6e%26displaylang%3den

Update for Windows Server 2008 x64 Edition (KB954920)

In some instances, applications using WDAC may return errors and lose connections to SQL Server 2008 servers if they try to access data in the new collations.

http://www.microsoft.com/downloads/info.aspx?na=22&p=12&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d6ad20990-5c8c-4fc3-a884-2a8e70cb892f%26displaylang%3den

Update for Windows Server 2008 for Itanium-based Systems (KB954920)

In some instances, applications using WDAC may return errors and lose connections to SQL Server 2008 servers if they try to access data in the new collations.

http://www.microsoft.com/downloads/info.aspx?na=22&p=13&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dae45c84a-7331-4bd4-9999-1f9c2464b1e1%26displaylang%3den

Update for Windows Vista (KB954920)

In some instances, applications using WDAC may return errors and lose connections to SQL Server 2008 servers if they try to access data in the new collations.

http://www.microsoft.com/downloads/info.aspx?na=22&p=14&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d2be8e665-77e1-46db-971c-17258595a37a%26displaylang%3den

Update for Windows Server 2003 for Itanium-based Systems (KB954920)

In some instances, applications using WDAC may return errors and lose connections to SQL Server 2008 servers if they try to access data in the new collations.

http://www.microsoft.com/downloads/info.aspx?na=22&p=15&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3ddd233b5d-0a8f-4c20-b524-2522546a6f5c%26displaylang%3den

Update for Windows Server 2003 (KB954920)

http://www.microsoft.com/downloads/info.aspx?na=22&p=16&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d32d4e3a7-8cc1-4975-94f4-2b04603d0208%26displaylang%3den

EMEA Case Study Resources

Case Study Resources

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

SQL Server 2005 VHD

This download comes as a pre-configured VHD. Microsoft SQL Server 2005 is a comprehensive, integrated, end-to-end data solution that empowers your people by providing a more secure, reliable, and productive platform for enterprise data and BI applications.

http://www.microsoft.com/downloads/info.aspx?na=22&p=18&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d7b243252-acb7-451b-822b-df639443aeaf%26displaylang%3den

.NET Rocks! - Thiago Silva on Reporting Services for SQL 2008

Carl and Richard talk to Thiago Silva about the new features of Reporting Services for SQL Server 2008.

http://www.microsoft.com/downloads/info.aspx?na=22&p=19&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d76620ac2-01f2-4e48-a230-a4817ca1b99a%26displaylang%3den

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

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%3d5148b887-f323-4adb-9721-61e1c0cfd213%26displaylang%3den

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

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=21&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d4603c722-2468-4adb-b945-2ed0458b8f47%26displaylang%3den

Security Update for SQL Server Reporting Services 2000 Service Pack 2 (KB954609)

A security issue has been identified in the SQL Server Reporting Services 2000 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=22&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d5f9e7f78-7439-414b-a9dc-a779b89427db%26displaylang%3den

SQL 2005 NS Components RC1

The SQL Server 2005 Notification Services components package made available in the February 2007 release of the Feature Pack for SQL Server 2005 is being updated to include server components and work with both SQL Server 2005 and SQL Server 2008 databases.

http://www.microsoft.com/downloads/info.aspx?na=22&p=23&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d614ffdf3-c608-4bd3-9061-ae37dcc81e2b%26displaylang%3den

Microsoft Application Compatibility Toolkit

The Microsoft Application Compatibility Toolkit (ACT) version 5.0 contains the necessary tools and documentation to evaluate and mitigate application compatibility issues before deploying Microsoft® Windows Vista, a Windows Update, or a new version of Windows® Internet Explorer® in your environment.

http://www.microsoft.com/downloads/info.aspx?na=22&p=24&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d24da89e9-b581-47b0-b45e-492dd6da2971%26displaylang%3den

Microsoft® Visual Studio Team System 2008 Database Edition GDR August 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=25&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dbb3ad767-5f69-4db9-b1c9-8f55759846ed%26displaylang%3den

Documents

Performance Optimizations for the XML Data Type in SQL Server 2005

This paper explores several ideas to improve the query and data modification performance of the XML data type in Microsoft SQL Server 2005. To get the most value from this paper, you need to be familiar with the XML features in SQL Server 2005. For background material, see XML Support in Microsoft SQL Server 2005 and XML Best Practices for Microsoft SQL Server 2005 on the Microsoft Development Network (MSDN). (26 printed pages)

http://msdn.microsoft.com/en-us/library/ms345118(SQL.90).aspx

Reducing Database Size by Using Vardecimal Storage Format

Learn about the new storage format for storing decimal and numeric data in SQL Server 2005 SP2. Details include when and how to enable vardecimal storage format, restrictions, space savings, and its impact on the performance of your workload.

http://msdn.microsoft.com/en-us/library/bb508963(SQL.90).aspx

Connectivity and SQL Server 2005 Integration Services

This white paper enumerates the connectivity options for databases with Microsoft SQL Server 2005 Integration Services and mentions special considerations that are required when using some database sources with some of the more complex transformations. (21 printed pages)

http://msdn.microsoft.com/en-us/library/bb332055(SQL.90).aspx

Multiple Active Result Sets (MARS) in SQL Server 2005

All Microsoft SQL Server data access application programming interfaces (APIs) provide an abstraction to represent sessions and requests within those sessions. SQL Server 2000 and earlier restricted the programming model such that at any point in time there would be at most one pending request on a given session. SQL Server 2005 implements Multiple Active Result Sets (MARS), which removes this constraint. This document explains the design, architecture, and semantic changes in MARS and what considerations must be taken into account by applications to get the maximum benefit out of these improvements. (15 printed pages)

http://msdn.microsoft.com/en-us/library/ms345109(SQL.90).aspx

Comparing Tables Organized with Clustered Indexes versus Heaps

In SQL Server 2005, any table can have either clustered indexes or be organized as a heap (without a clustered index.) This white paper summarizes the advantages and disadvantages, the difference in performance characteristics, and other behaviors of tables that are ordered as lists (clustered indexes) or heaps. The performance for six distinct scenarios where DML operations are performed on these tables are measured and detailed observations presented. This white paper provides best practice recommendations on the merits of the two types of table organization, along with examples of when you might want to use one or the other.

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/clusivsh.mspx

Database Encryption in SQL Server 2008 Enterprise Edition

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.

http://msdn.microsoft.com/en-us/library/cc278098.aspx

Events/Webcasts

Upgrade and Migration to SQL Server 2008 Webcast 

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032384669&EventCategory=3&culture=en-US&CountryCode=US

Lunch and Learn Webcast – All About SQL 2008

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032387909&EventCategory=2&culture=en-US&CountryCode=US

Comments
  • With the offical announcements of Windows 7 and Windows Azure Services Platform, and with some other

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