Buenas,
recién llegado a Barcelona (sumando puntos aéreos como la selección) y mientras sigo son poder instalar el SP2 de SQL Server 2005, por algunos errores en la creación/modificación de Perfomance Counters en Vista; de nuevo la gente de Microsoft me tienta con algunas Features Packs adicionales para Microsoft SQL Server 2005.
Las mismas se pueden descargar desde Feature Pack for Microsoft SQL Server 2005 - February 2007 y contienen los siguientes items:
- Microsoft ADOMD.NET
- Microsoft Core XML Services (MSXML) 6.0
- Microsoft OLEDB Provider for DB2
- Microsoft SQL Server Management Pack for MOM 2005
- Microsoft SQL Server 2000 PivotTable Services
- Microsoft SQL Server 2000 DTS Designer Components
- Microsoft SQL Server Native Client
- Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider
- Microsoft SQL Server 2005 Backward Compatibility Components
- Microsoft SQL Server 2005 Command Line Query Utility
- Microsoft SQL Server 2005 Datamining Viewer Controls
- Microsoft SQL Server 2005 JDBC Driver
- Microsoft SQL Server 2005 Management Objects Collection
- Microsoft SQL Server 2005 Compact Edition
- Microsoft SQL Server 2005 Notification Services Client Components
- Microsoft SQL Server 2005 Upgrade Advisor
- Microsoft .NET Data Provider for mySAP Business Suite, Preview Version
- Reporting Add-In for Microsoft Visual Web Developer 2005 Express
- Microsoft Exception Message Box
- Data Mining Managed Plug-in Algorithm API for SQL Server 2005
- Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies
- Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007
- SQL Server 2005 Performance Dashboard Reports
- SQL Server 2005 Best Practices Analyzer
Sobre algunos ya escribí, como por ejemplo los SQL Server 2005 Data Mining Add-In for Office 2007, pero hay otros que realmente me intrigan como son el Microsoft SQL Server 2005 Best Practices Analyzer y el Microsoft Exception Message Box. Cuando tenga un tiempo y los pruebe, postearé al respecto claro, si no me llego/suicido cervezas y bacalao en los dias siguientes en Lisboa.
Mas detalle como siempre:
Instructions
Download the appropriate file by clicking one of the links below, then run the downloaded file to install that package.
Each package indicates the audience(s) for which it was intended, as follows: Customer: An individual may want to install this for additional licensed functionality such as interoperability.
Partner: An ISV may want to ship this as a redistributable component as part of their application.
Developer: A programmer may want to install this to support application development.
Microsoft ADOMD.NET ADOMD.NET is a Microsoft .NET Framework object model that enables software developers to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2005 Analysis Services. ADOMD.NET is a Microsoft ADO.NET provider with enhancements for online analytical processing (OLAP) and data mining.
Note: The English ADOMD.Net setup package installs support for all SQL Server 2005 languages.
Audience(s): Customer, Partner, Developer
Microsoft Core XML Services (MSXML) 6.0 Microsoft Core XML Services (MSXML) 6.0 is the latest version of the native XML processing stack. MSXML 6.0 provides standards-conformant implementations of XML 1.0, XML Schema (XSD) 1.0, XPath 1.0, and XSLT 1.0. In addition, it offers 64-bit support, increased security for working with untrusted XML data, and improved reliability over previous versions of MSXML.
Audience(s): Partner, Developer
Microsoft OLEDB Provider for DB2 The Microsoft OLE DB Provider for DB2 is a COM component for integrating vital data stored in IBM DB2 databases with new solutions based on Microsoft SQL Server 2005 Enterprise Edition and Developer Edition. SQL Server developers and administrators can use the provider with Integration Services, Analysis Services, Replication, Reporting Services, and Distributed Query Processor. Run the self-extracting download package to create an installation folder. The single setup program will install the provider and tools on x86, x64, and IA64 computers. The package includes product updates in the form of an integrated Service Pack 1. Read the installation guide and Readme for more information.
Audience(s): Customer, Developer
Microsoft SQL Server Management Pack for MOM 2005 The Microsoft SQL Server Management Pack enables you to monitor SQL Server 2005 and SQL Server 2000 in an enterprise environment. Included are enterprise-level capabilities to monitor resource availability and configuration, collect performance data, and test default thresholds. Local and remote connectivity checks help ensure database availability.
With the embedded expertise in the SQL Server Management Pack, you can identify issues and manage issues before they become critical. This Management Pack increases the security, availability, and performance of your SQL Server infrastructure.
The Microsoft SQL Server Management Pack Guide that is included describes the content of the management pack and how to deploy it.
Audience(s): Customer
Microsoft SQL Server 2000 PivotTable Services PivotTable Services 8.0 is the OLE DB provider for SQL Server 2000 Analysis Services and is used to connect with an Analysis Services 2000 server. PivotTable Services does not work with SQL Server 2005 Analysis Services. Therefore, client applications that need connect to Analysis Services in both SQL Server 2000 and SQL Sever 2005 will need to install both PivotTable Services 8.0 and Analysis Services 9.0 OLE DB Provider in a side-by-side configuration.
Audience(s): Customer, Partner, Developer
Microsoft SQL Server 2000 DTS Designer Components The Microsoft SQL Server 2000 Data Transformation Services (DTS) package designer is a design tool used by developers and administrators of SQL Server 2005 servers to edit and maintain existing DTS packages until they can be upgraded or recreated in the SQL Server 2005 Integration Services package format. After installing this download, SQL Server 2005 users can continue to edit and maintain existing DTS packages from the Object Explorer in SQL Server 2005 Management Studio and from the Execute DTS 2000 Package Task Editor in Business Intelligence Development Studio, without needing to reinstall the SQL Server 2000 tools. The DTS package designer in this download was formerly accessed from the Data Transformation Services node in SQL Server 2000 Enterprise Manager.
Audience(s): Customer, Developer
Microsoft SQL Server Native Client Microsoft SQL Server Native Client (SQL Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 7.0, 2000 or 2005. SQL Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2005 features. This redistributable installer for SQL Native Client installs the client components needed during run time to take advantage of new SQL Server 2005 features, and optionally installs the header files needed to develop an application that uses the SQL Native Client API.
Audience(s): Partner, Developer
Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider The Analysis Services 9.0 OLE DB Provider is a COM component that software developers can use to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2005 Analysis Services. This provider implements both the OLE DB specification and the specification’s extensions for online analytical processing (OLAP) and data mining.
Note: Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider requires Microsoft Core XML Services (MSXML) 6.0, also available on this page.
Audience(s): Customer, Partner, Developer
Microsoft SQL Server 2005 Backward Compatibility Components The SQL Server Backward Compatibility package includes the latest versions of Data Transformation Services 2000 runtime (DTS), SQL Distributed Management Objects (SQL-DMO), Decision Support Objects (DSO), and SQL Virtual Device Interface (SQLVDI). These versions have been updated for compatibility with SQL Server 2005 and include all fixes shipped through SQL Server 2000 SP4.
Audience(s): Customer, Partner, Developer
Microsoft SQL Server 2005 Command Line Query Utility The SQLCMD utility allows users to connect, send Transact-SQL batches, and output rowset information from SQL Server 7.0, SQL Server 2000, and SQL Server 2005 instances. SQLCMD is a replacement for ISQL and OSQL, but can coexist with installations that have ISQL or OSQL installed.
Note: Microsoft SQL Server 2005 Command Line Query Utility requires Microsoft SQL Server Native Client, also available on this page.
Audience(s): Customer, Partner, Developer
Microsoft SQL Server 2005 Datamining Viewer Controls The Data Mining Web Controls Library is a set of Microsoft Windows Forms controls that enable software developers to display data mining models created using Microsoft SQL Server 2005 Analysis Services in their client-side applications. The controls in this library display the patterns that are contained in Analysis Services mining models.
Note: Microsoft SQL Server 2005 Datamining Viewer Controls requires Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider and Microsoft ADOMD.NET, also available on this page.
Audience(s): Partner, Developer
Microsoft SQL Server 2005 JDBC Driver In its continued commitment to interoperability, Microsoft has released and supports a new Java Database Connectivity (JDBC) driver for SQL Server 2005. The SQL Server 2005 JDBC Driver download is available to all SQL Server users at no additional charge and provides access to SQL Server 2000 and SQL Server 2005 from any Java application, application server, or Java-enabled applet. This is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application programming interfaces (APIs) available in J2EE (Java2 Enterprise Edition).
Audience(s): Partner, Developer
Microsoft SQL Server 2005 Management Objects Collection The Management Objects Collection package includes several key elements of the SQL Server 2005 management API, including Analysis Management Objects (AMO), Replication Management Objects (RMO), and SQL Server Management Objects (SMO). Developers and DBAs can use these components to programmatically manage SQL Server 2005.
Note: Microsoft SQL Server 2005 Management Objects Collection requires Microsoft Core XML Services (MSXML) 6.0 and Microsoft SQL Server Native Client, also available on this page.
Audience(s): Customer, Partner, Developer
Microsoft SQL Server 2005 Compact Edition Microsoft SQL Server 2005 Compact Edition is the next version of SQL Server Mobile adding the desktop platform. SQL Server Compact extends the SQL Server Mobile technology by offering a low maintenance, compact embedded database for single-user client applications for all Windows platforms including tablet PCs, pocket PCs, smart phones and desktops. Just as with SQL Server Mobile, SQL Server Compact is a free, easy-to-use, lightweight, and embeddable version of SQL Server 2005 for developing desktop and mobile applications.
Audience(s): Customer, Partner, Developer
Microsoft SQL Server 2005 Notification Services Client Components The SQL Server 2005 Notification Services Client Components package provides client APIs that enable subscription management and event submission within custom applications that include SQL Server 2005 Notification Services functionality. The subscription management APIs allow developers to create subscriptions and subscribers, and manage subscriber devices. The event submission APIs allow users to specify events using the event APIs or stored procedures.
Audience(s): Partner
Microsoft SQL Server 2005 Upgrade Advisor Upgrade Advisor analyzes instances of SQL Server 7.0 and SQL Server 2000 in preparation for upgrading to SQL Server 2005. Upgrade Advisor identifies deprecated features and configuration changes that might affect your upgrade, and it provides links to documentation that describes each identified issue and how to resolve it.
Audience(s): Customer, Developer
Microsoft .NET Data Provider for mySAP Business Suite, Preview Version SQL Server 2005 includes support for accessing SAP data by using the Microsoft .NET Data Provider for mySAP Business Suite. This provider lets you create an Integration Services package that can connect to a mySAP Business Suite solution and then execute commands to access data via supported interfaces. You can also create Reporting Services reports against a server running the mySAP Business Suite.
You can use the Microsoft .NET Data Provider for mySAP Business Suite in the SQL Server Import and Export Wizard and in various Integration Services features (including the Script task, the DataReader Source component, and the Script component), as well as the data processing extensions in Reporting Services.
The Microsoft .NET Data Provider for mySAP Business Suite is not included in SQL Server 2005. The preview version is licensed as pre-release software as outlined in the License Terms. See the Readme included with the download for information on the prerequisites for using the Microsoft .NET Data Provider for mySAP Business Suite.
Audience(s): Customer, Partner, Developer
Reporting Add-In for Microsoft Visual Web Developer 2005 Express The Reporting Add-In for Microsoft Visual Web Developer 2005 Express includes a ReportViewer control, an integrated report designer, and a comprehensive API that lets you customize run-time functionality. You can use the control to add interactive real-time data reports to your ASP.NET Web applications. Reports can use data from any ADO.NET DataTable or custom Business object. You can create reports that combine tabular, matrix, and visual data in free-form or traditional report layouts. An integrated report designer is included so that you can create the custom reports that bind to the control.
The Reporting Add-In is the same reporting component that is included with other editions of Visual Studio, but without support for Windows Forms applications. For more information including product documentation and samples, see the ReportViewer Controls (Visual Studio) topic on MSDN.
Audience(s): Developer
Microsoft Exception Message Box The exception message box is a programmatic interface that you can use in your applications for any tasks for which MessageBox may be used. The exception message box is a supported managed assembly designed to elegantly handle managed code exceptions. It provides significantly more control over the messaging experience and gives your users the options to save error message content for later reference and to get help on messages.
Audience(s): Developer
Data Mining Managed Plug-in Algorithm API for SQL Server 2005 The Managed Plug-in API is a Microsoft .NET object model that enables software developers to create plug-in data mining algorithms for SQL Server 2005 by using CLI-compliant languages, such as Visual C# 2.0. The object model is available as source code and it needs to be built on the developer’s computer. The package includes a step-by-step tutorial, a compiled HTML help file (.chm), as well as a sample plug-in algorithm developed in C#.
Audience(s): Partner, Developer
Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies Microsoft SQL Server 2005 Reporting Services Add-in for SharePoint Technologies allows you to take advantage of SQL Server 2005 Service Pack 2 (SP2) report processing and management capabilities in SharePoint. The download provides a Report Viewer web part, web application pages, and support for using standard Windows SharePoint Services.
Audience(s): Customer, Partner, Developer
Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007 Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007 allow you take advantage of SQL Server 2005 predictive analytics in Office Excel 2007 and Office Visio 2007. The download includes Table Analysis Tools for Excel, Data Mining Client for Excel, and Data Mining Templates for Visio.
Audience(s): Customer, Partner, Developer
SQL Server 2005 Performance Dashboard Reports The Microsoft SQL Server 2005 Performance Dashboard Reports are a set of Reporting Services report files that run within SQL Server 2005 SP2 Management Studio and later versions. These reports let SQL Server users more easily identify when a performance problem is occurring, and to identify the most likely cause. If more assistance is needed, the administrator can accurately describe the problem to technical support. This results in faster problem resolution.
Audience(s): Customer, Developer
SQL Server 2005 Best Practices Analyzer The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment.
Audience(s): Customer
Saludos
El Bruno
PD: el de la foto parece que es el héroe local de Alemania para SQL Server 2005 :D