[EN] SQL Server 2008 R2 Service Pack 2 CTP + Extras are Available

LOGO__SQLServer2008R2SP2Yes. Now it’s official. Few days before May 14th this stuff was available for special groups (preferred customers, and MVP’s) and now is for everyone as Customer Technology Preview. Service Pack 2 for SQL Server 2008 R2 [build: 10.50.3720.0] Of course IS NOT for production environment. Is for preview, testing, observing and generally is for helping Microsoft producing final RTM version. This Service pack contains all updates. If You have SQL Server 2008 R2 environment, You can download, install, test and send feedback to Microsoft SQL Server Team. of course this package have few important solutions for earlier reported errors such as (based form Microsoft site):

  • Reporting Services Charts Maybe Zoomed & Cropped
    Customers using Reporting Services on Windows 7 may sometime find charts are zoomed in and cropped.  To work around the issue some customers set ImageConsolidation to false.  
  • Batch Containing Alter Table not Cached
    In certain situations with batch files containing the alter table command, the entire batch file is not cached.  
  • Collapsing Cells or Rows, If Hidden Render Incorrectly
    Some customers who have hidden rows in their Reporting Services reports may have noticed rendering issues when cells or rows are collapsed.  When writing a hidden row, the Style attribute is opened to write a height attribute. If the attribute is empty and the width should not be zero.  

From my perspective this stuff have another one great feature: at the same time we can use all three parts: Service Pack 2 CTP for SQL Server 2008 R2  and Service Pack 2 CTP for SQL Server 2008 R2 Express and Service Pack 2 CTP for SQL Server 2008 R2 for Feature Pack. Lets look for all parts.

Service Pack 2 CTP for SQL Server 2008 R2  

You can download editions for all platforms: IA64 (335MB), x86 (239MB) and x64 (350MB) and for all editions: Parallel Computing Edition, Datacenter Edition, Enterprise Edition and Developer Edition, Standard Edition, Web Edition, Workgroup Edition.

You will find links and explanations for download at THIS page.

*** **** ***

Service Pack 2 CTP for SQL Server 2008 R2 Express

If You use only Express Edition, You can also use all necessary update from this package, dedicated for all versions: SQL Server Express x64 (182MB) & x86 (161MB) & 32_x86 (140MB); SQL Server Express with Advanced  Services x64 (1005MB) & x86 (891MB); SQL Server With Tools x64 (339MB) & x86 (316MB); SQL Management Studio x64 (188MB) & x86 (184MB). You should still remember about Limitations : SQL Server Express supports 1 physical processor, 1 GB memory, and 4 GB storage.

You will find links and explanations for download at THIS page.

*** **** ***

Service Pack 2 CTP for SQL Server 2008 R2 for Feature Pack.

And last but not only least, last and super interesting part is for all external features. What is Feature Pack? Is fantastic collection of stand-alone packages which provide additional value for SQL Server 2008 R2 SP2. The list of features is very interesting, as usual:

Microsoft® SQL Server Report Builder 3.0 for Microsoft® SQL Server 2008 R2 SP2 CTP
Report Builder 3.0 introduces additional visualizations including maps, sparklines and databars which can help produce new insights well beyond what can be achieved with standard tables and charts. The Report Part Gallery is also included in this release – taking self-service reporting to new heights by enabling users to re-use existing report parts as building blocks for creating new reports in a matter of minutes with a “grab and go” experience. Additionally, users will experience significant performance improvements with enhancements to the ability to use Report Builder in server mode. This allows for much faster report processing with caching of datasets on the report server when toggling between design and preview modes. | Audience(s): Customer, Partner, Developer

Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2010
The Microsoft SQL Server 2008 R2 Reporting Services Add-in for Microsoft SharePoint Technologies 2010 allows you to integrate your reporting environment with SharePoint to experience the benefits of using the collaborative environment provided by SharePoint. Once you install the Reporting Services Add-in and configure your servers for integration, you can publish Reporting Services content to a SharePoint library and then view and manage those documents directly from a SharePoint site. | Audience(s): Customer, Partner, Developer

Microsoft® SQL Server® 2008 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2007
Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies allows you to take advantage of new SQL Server 2008 report processing and management capabilities in SharePoint integrated mode. This version also includes Report Builder server mode, and the ability to launch Report Builder directly from a Report Server. The download provides a Report Viewer Web part, Web application pages, and support for using standard Windows SharePoint Services 3.0 or Microsoft Office SharePoint Services 2007. | Audience(s): Customer, Partner, Developer

Microsoft® Connector 1.1 for SAP BW for SQL Server® 2008 R2
The Microsoft Connector for SAP BW is a set of managed components for transferring data to or from an SAP NetWeaver BW version 7.0 system. The component is designed to be used with the Enterprise and Developer editions of SQL Server 2008 R2 Integration Services. To install the component, run the platform-specific installer for x86, x64, or Itanium computers respectively. For more information see the Readme and the installation topic in the Help file. | Audience(s): Partner, Developer

Microsoft® System CLR Types for SQL Server® 2008 R2
The SQL Server System CLR Types package contains the components implementing the geometry, geography, and hierarchy id types in SQL Server 2008 R2. This component can be installed separately from the server to allow client applications to use these types outside of the server. | Audience(s): Customer, Partner, Developer

Microsoft® SQL Server® 2008 R2 Remote Blob Store
The SQL Server Remote Blob Store is a method for storing blobs of unstructured data in an external Content Addressable data store. The component consists of a client-side DLL that is linked into a user application, as well as a set of stored procedures to be installed on SQL Server. Run the self-extracting download package to create an installation folder. The setup program contained there will install RBS on X86, X64, and Itanium-based computers. | Audience(s): Developer, DBA

Microsoft® SQL Server® 2008 R2 Upgrade Advisor
Microsoft SQL Server 2008 R2 Upgrade Advisor analyzes instances of SQL Server 2000, SQL Server 2005 and SQL Server 2008 in preparation for upgrading to SQL Server 2008 R2. Upgrade Advisor identifies feature and configuration changes that might affect your upgrade, and it provides links to documentation that describes each identified issue and how to resolve it.

Microsoft® SQL Server® 2008 R2 Native Client
Microsoft SQL Server 2008 R2 Native Client (SQL Server 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 2000, 2005, or 2008. SQL Server Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2008 R2 features. This redistributable installer for SQL Server Native Client installs the client components needed during run time to take advantage of new SQL Server 2008 R2 features, and optionally installs the header files needed to develop an application that uses the SQL Server Native Client API. | Audience(s): Customer, Partner, Developer

Microsoft® SQL Server® 2008 R2 Command Line Utilities
The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server 7.0, SQL Server 2000, SQL Server 2005, and SQL Server 2008 and 2008 R2 instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server 2008 R2 and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files. | Audience(s): Customer, Partner, Developer

Microsoft® SQL Server® Service Broker External Activator for SQL Server® 2008 R2
The Microsoft SQL Server 2008 R2 Service Broker External Activator is an extension of the internal activation feature in SQL Server 2008 R2 that lets you move the logic for receiving and processing Service Broker messages from the Database Engine service to an application executable that runs outside SQL Server. By doing this, cpu-intensive or long-duration tasks can be offloaded out of SQL Server to an application executable, possibly in another computer. The application executable can also run under a different Windows account from the Database Engine process. This gives administrators additional control over the resources that the application can access. Run the self-extracting download package to create an installation folder. Read Books Online for more information. The single setup program will install the service on x86, x64, and IA64 computers. Read the documentation for more information. | Audience(s): Customer, Developer

Microsoft® Windows PowerShell Extensions for SQL Server® 2008 R2
The Microsoft Windows PowerShell Extensions for SQL Server2008 R2 includes a provider and a set of cmdlets that enable administrators and developers to build PowerShell scripts for managing instances of SQL Server. The SQL Server PowerShell Provider delivers a simple mechanism for navigating SQL Server instances that is similar to file system paths. PowerShell scripts can then use the SQL Server Management Objects to administer the instances. The SQL Server cmdlets support operations such as executing Transact-SQL scripts or evaluating SQL Server policies. | Audience(s): Customer, Partner, Developer 

Microsoft® SQL Server® 2008 R2 Shared Management Objects
The SQL Server Management Objects (SMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer SQL Server objects and services. This object model will work with SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2. | Audience(s): Customer, Partner, Developer

Microsoft® SQL Server® 2008 R2 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 2008 R2 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 2008 R2 languages. | Audience(s): Customer, Partner, Developer

Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2
The Analysis Services 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 2008 R2 Analysis Services. This provider implements both the OLE DB specification and the specification’s extensions for online analytical processing (OLAP) and data mining. | Audience(s): Customer, Partner, Developer

Microsoft® SQL Server® 2008 R2 Analysis Management Objects
Analysis Management Objects (AMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer Analysis Services objects. | Audience(s): Customer, Partner, Developer

Microsoft® Datamining Viewer Controls For Microsoft® SQL Server® 2008
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 2008 Analysis Services in their client-side applications. The controls in this library display the patterns that are contained in Analysis Services mining models. | Audience(s): Customer, Partner, Developer

You will find links and explanations for download at THIS page.

AS ALWAYS: ENJOY!!!

[EN] SQL Server Features Packs | 2005

LOGO__SQL2005When we work with SQL Server (the number like: 2005, 2008, 2012 and edition like: express, standard… doesn’t matter) we need some extra features for connectivity, productivity, reporting ans many other things and ideas. For better opportunity of our effective work we can download and instal something like “Features Pack”. In fact they are exist from SQL Server 2005 version. For a moment, in this post – we’re back to the… past.

For SQL Server 2005 we can use for example Feature Pack for Microsoft SQL Server 2005 – November 2005 (it’s probably the last version). One feature from this pack will be very important with the connection of my previous post about Idera’s SQL Permissions tool (it’s called Microsoft SQL Server 2005 Backward Compatibility Components or just SQLServer2005_BC). Just for a moment.  In this pack we can find a lot of interesting ans sometimes absolutely necessary features. Before we look for features, we should understand three “targets” of all installation files (and If You are not one of this, of course You still can use it):

    Customer [C] : An individual may want to install this for additional licensed functionality such as interoperability.
    Partner [P]: An ISV may want to ship this as a redistributable component as part of their application.
    Developer [D]: A programmer may want to install this to support application development.

Let’s look for details, links, targets:

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.
| LINKS x32 x64 ia64 | {Audience(s): C, P, D}

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.
| LINKS x32 x64 ia64 SDK | {Audience(s): P, D}

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 SQL Server Integration Services, SQL Server Analysis Services, Replication, 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 both x86 and x64 computers. Read the installation guide and Readme for more information.
| LINKS oneversion | {Audience(s): C, D}

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.
| LINKS oneversion |{Audience(s): C} | SQLServer2008 too (build 10.0.0001.0000)

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.
| LINKS x32 | {Audience(s): C, P, D}

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.
| LINKS x32 | {Audience(s): C, D}

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.
| LINKS x32 x64 ia64 | {Audience(s): P, D}

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.
| LINKS x32 x64 ia64 | {Audience(s): C, P, D}

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.
| LINKS x32 x64 ia64 | {Audience(s): C, P, D}

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.
| LINKS x32 x64 ia64 | {Audience(s): C, P, D}

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.
| LINKS x32 x64 ia64 | {Audience(s): P, D}

Microsoft SQL Server 2005 JDBC Driver
In its continued commitment to interoperability, Microsoft provides a Java Database Connectivity (JDBC) driver for use with SQL Server. The SQL Server JDBC Driver is available to all SQL Server users at no additional charge, and provides access from any Java application, application server, or Java-enabled applet. For more information and to obtain the latest version of the SQL Server JDBC Driver, follow the download link below.
| LINKS x32&x64 tar.gz SITE | {Audience(s): P, D}

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.
| LINKS x32 x64 ia64 | {Audience(s): C, P, D}

Microsoft SQL Server 2005 Mobile Edition
Use SQL Server 2005 Mobile Edition (SQL Server Mobile) to rapidly develop applications that extend enterprise data management capabilities to mobile devices. For the latest SQL Server Mobile add-ins, updates, tools, and components, visit the SQL Server Mobile Download site.
| LINKS oneversion | {Audience(s): C, P, D}

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.
| LINKS x32 x64 ia64 | {Audience(s): P}

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.
| LINKS oneversion | {Audience(s): C, D}

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.
| LINKS x32 | {Audience(s): C, P, D}

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.
| LINKS x32 | {Audience(s): D}

If we don’t use SQL Server 2005 in the first look, they are not interesting for us. But, just till the moment of using external tools or meeting with new customer. As always – better to know.

Enjoy

[EN] SQL Server 2012 Developer Training Kit Web Installer Phase One & Two-Fourth

In previous post I wrote about standard (just two-click technology) features from Microsoft® SQL Server® code name ‘Denali’ Community Technology Preview 3 (CTP 3) Feature Pack. Now I want to write about a little bit complicated (from the download/installation point of view) features. All are available from different pages, however all links You can find on general Page for Feature Pack HERE. Let’s play with they!

All features which I installed last night are not so big. Summarize all X64 Packages are about 146 MB in 17 installation files. The second part (look for all below) are for X64 Packages about  578 MB in 10 Files. Similar to previous post and next one in future almost all description are copied from Microsoft site. OK Let’s Play again…

Capture_CTP3FP_B_01

Step.01 | Master Data Services Add-in For Microsoft Excel The Master Data Services Add-in for Excel gives multiple users the ability to update master data in a familiar tool without compromising the data’s integrity in MDS. From within the Add-in, users can publish data to the MDS database with the click of a button. Administrators can use the Add-in to create new model objects and load data without ever launching any administrative tools, helping to speed deployment. With the Master Data Services Add-in for Excel, all master data remains centrally managed in MDS, while the ability to read or update the data is distributed to those who need it. | DOWNLOAD: MasterDataServicesExcelAddin.msi X86 Package or X64 Package

Capture_CTP3FP_B_02

Step.02 | PowerPivot for Microsoft Excel Microsoft® PowerPivot for Microsoft® Excel 2010 provides ground-breaking technology, such as fast manipulation of large data sets (often millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through Microsoft® SharePoint 2010. Microsoft® PowerPivot for Microsoft® Excel 2010 is a data analysis tool that delivers unmatched computational power directly within the software users already know and love — Microsoft® Excel. You can transform mass quantities of data with incredible speed into meaningful information to get the answers you need in seconds. You can effortlessly share your findings with others | DOWNLOAD: PowerPivot_for_Excel.msi X86 Package or X64 Package and README

Capture_CTP3FP_B_03

Step.03 | Report Builder Report Builder provides a productive report-authoring environment for IT professionals and power users. It supports the full capabilities of SQL Server code name ‘Denali’ CTP 3 Reporting Services. The download provides a stand-alone installer for Report Builder. Report Builder provides data visualizations that include charts, maps, sparklines, and data bars that can help produce new insights well beyond what can be achieved with standard tables and charts. Use Report Builder to create reports and shared datasets. Publish report parts, and then browse the Report Part Gallery to reuse existing report parts as building blocks for creating new reports quickly with a “grab and go” experience. | DOWNLOAD: ReportBuilder3.msi X86 Package (ONLY 32bit!!)

After installation of Excel Addins: Power Pivot, Reporting Services and Master Data You worksheet will change for this:

CaptureEXCL

Nice tabs isn’t? Load Test, PowerPivot, MasterData and Team. One exeption: almost all addins requires You special configuration, so chect documentations.

Capture_CTP3FP_B_04

Step.04 | Reporting Services Add-in for Microsoft SharePoint Technologies The Microsoft SQL Server code name ‘Denali’, Community Technology Preview 3 (CTP 3) Reporting Services Add-in for SharePoint Products is a Web download that integrates Reporting Services report server with a deployment of Microsoft SharePoint 2010 products. The Reporting Services Add-in provides the following functionality: >> Interactive data exploration and visualization >> Open/save reports in Report Builder from a SharePoint library >> A Report Viewer Web Part >>Web pages for create  manage reports and data sources >> Support for standard SharePoint Foundation 2010 / Server 2010 >> ability to use SharePoint permission levels and roles to control access to report server content. | DOWNLOAD: rsSharePoint.msi X64 Package (in oposite to Report Builder ONLY 364bit!!)

Capture_CTP3FP_B_05a

Step.04 | SQL Server Compact 4.0 Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications. SQL Server Compact 4.0 has a small footprint and supports private deployment of its binaries within the application folder, easy application development in Visual Studio and WebMatrix, and seamless migration of schema and data to SQL Server. | DOWNLOAD: SSCERuntime_-ENU.msi X86 Package or X64 Package

Capture_CTP3FP_B_06

Step.05a | Microsoft Drivers 3.0 for SQL Server for PHP CTP1 The Microsoft Drivers for PHP for SQL Server are PHP 5 extensions that allows for the reading and writing of SQL Server data from within PHP scripts. The SQLSRV extension provides a procedural interface while the PDO_SQLSRV extension implements PDO for accessing data in all editions of SQL Server 2005 and later. | DOWNLOAD: SQLSRV30.EXE X86 Package 

Capture_CTP3FP_B_06a

Step.05b | …PHP CTP1 The major improvement in the version 3.0 CTP1 release is support for SQL Server Codename "Denali" features including: LocalDB and AlwaysOn. Additionally, support for Buffered Queries was added. This release is available to all SQL Server users at no additional charge. Please read carrefuly: It’s still version for SQL Server CodeName DENALI CTP1 and agreements are not very new: Apache License are from January 2004.

Capture_CTP3FP_B_07

Step.06a | Microsoft® SQL Server® StreamInsight 1.2 Microsoft® StreamInsight is a platform that enables the continuous and incremental processing of unbounded sequences of events (event streams) from multiple sources with near-zero latency. These requirements, shared by vertical markets such as manufacturing, oil and gas, utilities, financial services, health care, web analytics, and IT and data center monitoring, make traditional store and query techniques impractical for event driven, timely and relevant processing of data. The ability to monitor, analyze and act on data in motion provides significant opportunity to make more informed business decisions in near real-time

Capture_CTP3FP_B_07a

Step.06b | We should read agreement and must accept it (of course) These are the new features in StreamInsight 1.2: >> Resiliency against planned and unplanned downtime through checkpointing. >> Better support for predictive modeling and pattern matching scenarios through new user-defined stream operators. >> Improved administrator experience through performance counters. >>  Improved administrator experience through the administrative event log. >> Improved development experience through support for nested event type structures and additional LINQ expressions. With the installation precess we have four files, one for server and one for client both for two platforms: DOWNLOAD: StreamInsight.msi X86 Package or X64 Package and DOWNLOAD: StreamInsightClient.msi X86 Package or X64 Package

Capture_CTP3FP_B_07b

Step.06c | Name and Company are important but not too much. What is Client version of StreamInsight? The Microsoft® StreamInsight Client package installs a subset of Microsoft® StreamInsight which lets you implement only the client side functionality: Connecting to an existing StreamInsight server, managing queries, and using the debugger tool. It does not support running an embedded server or creating a StreamInsight service. The installation of the Microsoft® StreamInsight Client does not need a product key.

Capture_CTP3FP_B_07c

Step.06d | We can create instance on the installation process or later. We must create separate instance for data store in future. Why? For performance, especially when we will work with StreamInsight with typical data: · Process monitoring i.e. scheduling, control, and inventory including processing such as RFID, bar codes, process monitoring at oil and gas refinery · Financial algorithmic trading, compliance monitoring, fraud detection, risk management · Click stream analysis on websites , context sensitive navigation and ad-delivery model · Utility grid monitoring – demand from meters and supply from generation units combined with energy trading · Patient Monitoring (Healthcare) · Network traffic monitoring, security intrusion detection · IT monitoring · Telecom network monitoring · Anomaly detection

Capture_CTP3FP_B_07d

Step.06e | Choosing Evaluation or Production Edition. For testing we can choose defaul option: Evaluation Edition. For Production Environment we choosing “Product-Key” Version. Please remember about availability for SQL Server:  StreamInsight Standard for SQL Server in versions: Standard, Enterprise, Web and StreamInsight Premium for SQL Server in versions: Datacenter, Developer, Evaluation.

Capture_CTP3FP_B_07e

Step.06f | On next windows we choosing: creating SI Host Windows Service and privileges. What is SI Host Windows Service? When we click “Create…” will happen: 1. The Windows NetworkService account is used as the login account for the service. Users with administrative privileges can change the login account for the service after Setup is complete. 2. An XML configuration file for the service is created. The typical installation location is C:\Program Files\Microsoft StreamInsight 1.2\Host\<instance_name>. This configuration file contains server-specific parameters such as the type of metadata store as well as Windows Communication Foundation-specific parameters. If, for example, the StreamInsight server URI of the service instance must be modified, the configuration file must be edited by a user with administrative privileges.

Capture_CTP3FP_B_07f

Step.06g | Almost end – Install

Capture_CTP3FP_B_07g

Step.06h | We need about 10 minutes for Express Edition (ok, I need on my laptop)

Capture_CTP3FP_B_07h

Step.06i | If we have previous (before 4.0) version of SQL Server Compact Edition, we must install Cumulative Update 4 for SQL Compact Edition 3.5. You can READ about it or directly REQUEST download file. Next screen called Finish.

Capture_CTP3FP_B_08a

Step.07a | Semantic Language Statistics CTP3 The Semantic Language Statistics Database is a required component for the Statistical Semantic Search feature in Microsoft SQL Server code name ‘Denali’. You can download this database from this page, attach it to your SQL Server “Denali” instance, and register it to use the new Semantic Search features. Statistical Semantic Search provides deep insight into unstructured documents stored in SQL Server databases by extracting and indexing statistically relevant key phrases and similar documents based on this keyphrases. Semantic Search builds upon the existing Full-Text Search feature in SQL Server, and enables new scenarios that extend beyond keyword searches into the meaning of the document. Solutions that are now possible include automatic tag extraction, related content discovery, and hierarchical navigation across similar content. For example, users can query the index of key phrases to build the taxonomy for an organization, or for a corpus of technical documents. Or for example in an HR scenario, a recruiter can query the document similarity index to identify resumes that match a job description. Developers can easily enable Semantic Search using familiar Fulltext search syntax. They can then access Semantic Search results using the new Semantic Rowset functions (similar to CONTAINSTABLE and FREETEXTTABLE). Semantic Search follows all of the Fulltext index population models to work seamlessly in the existing Fulltext scenarios. | DOWNLOAD: SemanticLanguageDatabase.msi X86 Package or X64 Package

Capture_CTP3FP_B_08b

Step.07b | Installation process is very simple. Just few clics. But when we look for disk cost we will se 750 MB is required for this installation. We can…

Capture_CTP3FP_B_08c

Step.07c | …change default folder for different place. We save almost 400MB. It will be important for us in future (especially that it’s place on partition C).

In the second part we installed almost all necessary features for our future learning. Let’s check the SQL Server 2012 Developer Training Kit Installer. Was something changed based on first post?

Capture_SQLSRV2012_DevKitUpdate_15

Better, but not ideal. We will working with this installation…