David Overton's Blog and Discussion Site
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  
SQL Server Downloads (CTPs - Synchronization Services for ADO.NET, VS 2005 Support for SQL Server 2008, Configuration Manager config packs, Assessment packs for HIPPA, European Union Data Protection Directive (EUDPD), SOX, GLBA, FSMA, ReportViewer samples,
From the TRM Blog at November 2007 - Technical Rollup Mail - SQL 
Microsoft Synchronization Services for ADO.NET v2.0 CTP1Microsoft 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.http://www.microsoft.com/downloads/details.aspx?FamilyID=147c41a9-69f0-496e-b095-dbc5cffd6285&DisplayLang=en Visual Studio 2005 Support for SQL Server 2008, Community Technology PreviewThis 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.
http://www.microsoft.com/downloads/details.aspx?FamilyID=e1109aef-1aa2-408d-aa0f-9df094f993bf&DisplayLang=en Microsoft SQL Server 2005 MSIT Comprehensive Configuration Pack for Configuration Manager 2007The 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.http://www.microsoft.com/downloads/details.aspx?FamilyID=daca4a14-abcf-4a25-81bd-196282bbdde0&DisplayLang=en Microsoft SQL Server 2005 MSIT Intermediate Configuration Pack for Configuration Manager 2007The 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.http://www.microsoft.com/downloads/details.aspx?FamilyID=daca4a14-abcf-4a25-81bd-196282bbdde0&DisplayLang=en Microsoft SQL Server 2005 MSIT Basic Configuration Pack for Configuration Manager 2007The 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.http://www.microsoft.com/downloads/details.aspx?FamilyID=3718598e-ba03-4984-b7c6-be78377ab024&DisplayLang=en 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.http://www.microsoft.com/downloads/details.aspx?FamilyID=19db0b42-a5b2-456f-9c5c-f295cdd58d7a&DisplayLang=en 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.http://www.microsoft.com/downloads/details.aspx?FamilyID=7050d56c-7e5a-479f-b94c-419ede535608&DisplayLang=en 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.http://www.microsoft.com/downloads/details.aspx?FamilyID=14862939-4bb0-4e26-b43a-a5953b484239&DisplayLang=en 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.http://www.microsoft.com/downloads/details.aspx?FamilyID=976df931-a3cf-40e3-802e-3281b1451835&DisplayLang=en 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.http://www.microsoft.com/downloads/details.aspx?FamilyID=fe3a2b70-4ac7-49ee-ba18-748133feead1&DisplayLang=en Microsoft SQL Server Compact 3.5 and Microsoft Synchronization Services for ADO.Net v1.0 for Windows DesktopSQL 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.http://www.microsoft.com/downloads/details.aspx?FamilyID=7849b34f-67ab-481f-a5a5-4990597b0297&DisplayLang=en Microsoft SQL Server Compact 3.5 for Windows MobileSQL 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
http://www.microsoft.com/downloads/details.aspx?FamilyID=38ed2670-a70a-43b3-87f3-7ab67b56cbf2&DisplayLang=en ReportViewer Samples for Microsoft Visual Studio 2008Visual 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.
http://www.microsoft.com/downloads/details.aspx?FamilyID=8af004bd-ee06-43fa-a5b6-955689a66c84&DisplayLang=en Microsoft SQL Server Compact 3.5 Server ToolsSQL 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.
http://www.microsoft.com/downloads/details.aspx?FamilyID=b18327f3-96e1-415d-b037-9e0c46d49956&DisplayLang=en Search Server 2008 Sample: Federated Search Connector SampleMicrosoft 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.http://www.microsoft.com/downloads/details.aspx?FamilyID=b59ea8c3-76e8-45df-947f-32a69c56b5cd&DisplayLang=en
 ttfnDavid

Posted Wed, Dec 5 2007 3:55 PM by David Overton

Add a Comment

(optional)  
(optional)
(required)  
Remember Me?

(c)David Overton 2006-18