[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…


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


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


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:


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


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!!)


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


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 


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.


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


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


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.


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


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.


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.


Step.06g | Almost end – Install


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


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.


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


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…


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?


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

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

Capture_SQLSRV_codeplexBased on requirements to install SQL Server 2012 Developer Training Kit (right, part of those requirements are only my scary Halloween imagination) – some words in previous post – I decided to install almost all addictional software. In worse case scenario (I’m pesimist since my birthday) I’ll reinstall my system – it’s not virtual. In best case scenario: nothing will happen.

First part based on Microsoft® SQL Server® code name ‘Denali’ Community Technology Preview 3 (CTP 3) Feature Pack. The smallest phase of One-Third phase of First Phase are below (in sweet sixteen steps). I hope it will help You with plan for installation (almost all description are copied from Microsoft site).


Step.01 | Data-Tier Application Framework CTP 3 >> The SQL Server Data-tier Application (DAC) framework is a component based on the .NET Framework that provides application lifecycle services for database development and management. Application lifecycle services include extract, build, deploy, upgrade, import, and export for data-tier applications in SQL Azure, SQL Server code named ‘Denali’ CTP 3, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, and limited support for SQL Server 2000. | DOWNLOAD: dacframework.msi X86 Package or X64 Package


Step.02 | Transact-SQL Language Service CTP 3 >> The SQL Server Transact-SQL Language Service is a component based on the .NET Framework which provides parsing validation and IntelliSense services for Transact-SQL for SQL Server code name ‘Denali’ CTP 3, SQL Server 2008 R2, and SQL Server 2008 | DOWNLOAD: tsqllanguageservice.msi X86 Package or X64 Package


Step.03 | Transact-SQL ScriptDom CTP 3 >> Microsoft SQL Server Transact-SQL ScriptDom is a .NET Framework API that provides parsing and scripting services for Transact-SQL. This API supports SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server code name ‘Denali’ CTP 3 versions. | DOWNLOAD: SQLDOM.msi X86 Package or X64 Package


Step.04 | Connector 1.1 for SAP BW for SQL Server® code name ‘Denali’ CTP 3 > 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 with the SQL Server code name ‘Denali’ CTP 3 Integration Services | DOWNLOAD: AspBI.msi X86 Package or X64 Package


Step.05 | System CLR Types for SQL Server® code name ‘Denali’ CTP 3 >>The SQL Server System CLR Types package contains the components implementing the geometry, geography, and hierarchy id types in SQL Server code name ‘Denali’ CTP 3. This component can be installed separately from the server to allow client applications to use these types outside of the server. | DOWNLOAD: BISQLSysClrTypes.msi X86 Package or X64 Package


Step.06 | Remote Blob Store CTP 3 >> 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. | DOWNLOAD: RBS.msi X86 Package or X64 Package and CodePlex Sample Page

One exeption for RBS – because I use only Express Editions and don’t want to use large objects now (who knows what will be tomorrow) I missed this installation.


Step.07 | Native Client CTP 3 >> Microsoft SQL Server 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, 2008 and 2008 R2. SQL Server Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server code name ‘Denali’ features. This redistributable installer for SQL Server Native Client installs the client components needed during run time to take advantage of new SQL Server code name ‘Denali’ features, and optionally installs the header files needed to develop an application that uses the SQL Server Native Client API. | DOWNLOAD: sqlncli.msi X86 Package or X64 Package


Step.08 | Command Line Utilities CTP 3 >> 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, 2008 R2, and ‘Denali’ CTP 3 instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server code name ‘Denali’ CTP 3 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. | DOWNLOAD: SqlCmdLnUtils.msi X86 Package or X64 Package


Step.09 | Service Broker External Activator >> The Microsoft SQL Server Service Broker External Activator is an extension of the internal activation feature in SQL Server code name ‘Denali’ 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. | DOWNLOAD: SSBEAS.msi X86 Package or X64 Package


Step.10 | Upgrade Advisor CTP 3 >> Microsoft Upgrade Advisor analyzes instances of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 in preparation for upgrading to SQL Server code name ‘Denali’. 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. | DOWNLOAD: SSBUA.msi X86 Package or X64 Package


Step.11 | PowerShell Extensions >> The Microsoft Windows PowerShell Extensions for SQL Server code name ‘Denali’ 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. | DOWNLOAD: PowerShellTools.msi X86 Package or X64 Package


Step.12 | ADOMD.NET CTP 3 >> 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 code name ‘Denali’ CTP 3 Analysis Services. ADOMD.NET is a Microsoft ADO.NET provider with enhancements for online analytical processing (OLAP) and data mining. | DOWNLOAD: SQLSERVER2008_ASADOMD10.msi X86 Package or X64 Package


Step.13 | Analysis Management Objects CTP 3 >> 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. | DOWNLOAD: SQLSERVER2008_ASAMO10.msi X86 Package or X64 Package


Step.14 | Transact-SQL Compiler Service CTP 3 >> Microsoft SQL Server Transact-SQL Compiler Service is a set of components that provide the compilation and validation services for Transact-SQL. This component can be used only via the Microsoft SQL Server Data-Tier Application Framework Build API. | DOWNLOAD: SQLLS.msi X86 Package or X64 Package


Step.15 | Shared Management Objects CTP 3 >> 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 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server code name ‘Denali’ CTP 3. | DOWNLOAD: SharedManagementObjects.msi X86 Package or X64 Package


Step.16 | Analysis Services OLE DB Provider CTP 3 >> 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 code name ‘Denali’ CTP 3 Analysis Services. This provider implements both the OLE DB specification and the specification’s extensions for online analytical processing (OLAP) and data mining. | DOWNLOAD: SQLServer2008_ASOLEDB.msi X86 Package or X64 Package

Of course it is just beginning. We can use (from this Feature Pack) some other tools such as Microsoft® Drivers 3.0 for PHP for SQL Server® CTP1 (unfortunately still for CTP1 version) and Microsoft® OLEDB Provider for DB2 v4.0 for SQL Server code name ‘Denali’ CTP 3 and of course Microsoft® SQL Server® Migration Assistant SQL Server Migration Assistant (SSMA) is a family of products to reduce the cost and risk of migration from Oracle, Sybase, MySQL and Microsoft Access databases to SQL server or SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing.

1. Microsoft SQL Server Migration Assistant for Access
2. Microsoft SQL Server Migration Assistant for MySQL
3. Microsoft SQL Server Migration Assistant for Oracle
4. Microsoft SQL Server Migration Assistant for Sybase
5. Microsoft SQL Server Migration Assistant for Sybase PowerBuilder Applications

So. As we see we have a lot of “SQL Server Area” software which could be interesting, important and/or necessary for learning time. In this “phase of phases” I wrote about simple (except RBS) clicking applications and features, available for direct download from THIS site. In next I wrote about fatures available from personalized sites.

[EN] A little bit words about Juneau… phase one

LOGO__SSDT_JuneauCTP3Juneau. Very close to Denali (code name of next edition of SQL Server). But what is it exactly? Few days ago (about 11th July) Microsoft delivered for SQL Server Peoples new version of new tool. His (or her?) name is Juneau. It is capitol of the state of Alaska. On the other side: it is SQL Server Developer Tools (SSDT) in version 3 of Community Technology Preview. Yes I know. Where I have been on CTP1 and CTP2 time? Somewhere… but not here. Hope to see CTP3 as last before next SQL Server release.

What exactly Juneau is: based Microsoft Product Team public information: …is a project announced at SQL PASS on November 9, 2011. SSDT represents our continued investment and commitment to integrating data into the development experience when targeting SQL Server and SQL Azure.  SSDT unifies SQL Server and SQL Azure development for both professional database and application developers. Integrated within the Visual Studio environment, it accelerates development of T-SQL, Reporting, Integration Services, Analysis Services, and data-enabled .NET projects. In addition, SSDT can be installed standalone without Visual Studio, a commitment we are making to professional database administrators (DBAs) that want the full set of SQL Server schema and T-SQL capabilities, but not necessarily the full Visual Studio application development environment. SSDT will ship with the next release of SQL Server (SQL Server code-named “Denali”) in 2012, and the public Community Technology Preview 3 (CTP3) will be publicly downloadable this summer at the same time as the SQL Server “Denali” CTP3. SSDT supports SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server “Denali”, and SQL Azure development

As I wrote before this CTP3 is available for everyone, so You can go HERE for downloading, or wait for may next post to know a little bit more about installation. About the requirements… Microsoft said: because it is installing via Web Installer, all what You need will be downloading and installing in the process of installation Juneau. Uff. I hate this sentence. So next post will be about requirements, and next one about installation… In the meantime short announcement look like this:


Upss… I forgot, in next posts I’ll use different system (probably I have one in English…)

This post is my first in the series of few posts about this tool. Next posts I will write as soon as possible…