Sunday, December 29, 2013

SQL Training in Honolulu: SQL Server Reporting Services 2012

This is a comprehensive, hands-on course. The above course will be offered as a non-credit course by the Pacific Center for Advanced Technology Training

 Course summary:
SQL Server Reporting Services 2012
Report writing is one of the most important IT related jobs in an enterprise. 
Among the BI stack components the component that provides most employment is Reporting 
Services.

This course is for you if you would like to master report writing/authoring 
using SQL Server Reporting Services. The course begins with a presentation of 
essential technical background, after which you will work through guided 
hands-on exercises.

You will start off learning the details of installing SQL Server 2102 
Developer edition and configuring Native mode Reporting Services. For 
authoring reports and interacting with reporting services you will also learn 
how to install and work with Report Builder 3.0. This is essential for 
deploying authored reports to report sever.

Report Manager the web front end is an essential part of Reporting Services 
2012 and you will learn a comprehensive set of tasks that you can carry out.
A working knowledge of Report Manager's ability to carry out administrative 
tasks related to all aspects of reports; creating shared data sources, folder 
and folder hierarchies on the report server, and report models; managing 
security and subscriptions; and configuring data driven subscriptions is 
essential for managing reports.

Many applications depend on embedding these reports so that the user has the 
opportunity to view these reports. To this end, an understanding of how to 
embed report viewer controls in windows and web projects is essential. You 
will learn the basics of creating these applications.

During each meeting the students will be assessed for their knowledge, 
competency and proficiency in installing, configuring, authoring, deploying, 
and managing reports.

The hands-on exercises will draw largely from the authors first and second editions of his book on SQL Server Reporting Services 2012.

 

and the first edition related to SQL Server 2008


Course schedule: 
Feb 3 - Mar 17, 2014; Mondays and Wednesdays; 5:30 pm - 8:30 pm; 12 meetings

Location:
Honolulu Community College

Friday, December 27, 2013

SQL Training in Honolulu: Introduction to Structured Query Language (SQL)

This is a comprehensive, hands-on course.

The above course will be offered again as a non-credit course by the Pacific Center for Advanced Technology Training

Course summary:
Databases, organized repositories of information, have become indispensable in today's world. In this introductory course you will learn about relational databases and the basics of Structured Query Language (SQL) including sorting; grouping result sets; using DDL, DML, DCL, and TCL. All SQL statements will initially be written for one table. Most practical, modern and relational databases will include a large number of tables and SQL queries have to access information from several tables. This course will then introduce you to querying more than one table. With this skill you will be able to query two or more tables in a database. This is a hands-on course which will take you from installing SQL Server 2012; learning the ins and outs of SQL Server Management Studio and of course a full dose of SQL.

The course covers most of the requirements to take Microsoft’s latest certification (98-364), the Microsoft Technology Associate.  During each meeting the students will be assessed for their knowledge, competency and proficiency in SQL.

Schedule:
Feb 4 - Mar 6, 2014; Tuesdays and Thrusdays; 5:30 pm - 7:30 pm; 10 mtgs

Thursday, December 26, 2013

Deploying DAC to SQL Server 2014

The acronym DAC in SQL Server has many different meanings as in the following bullet list:
  • DAC - Data-tier Application
  • DAC - Dedicated Administrator Connection
  • DAC - Data Access Components
  • DAC - Data Application Component
This post describes deploying a Data-tier Application extracted from SQL Server 2012 Express database to SQL Server 2014 CTP1 (should work with CTP2 as well). The two servers are on two partitions on a x64 bit Windows laptop, with SQL Server 2012 on Windows 7 Partition and CTP1 on Windows 8 Preview partition.

There are no issues for this deployment and the next few images shows the stages of deployment wizard while deploying to SQL Server 2014 CTP1. We start with a .dac file created on Windows 7 partition and copied over to the desktop on Windows 8 partition.





 
The steps are very clear and you may also review the following for more detailed discussion of DAC with earlier versions on older OS.


https://www.packtpub.com/article/working-with-data-application-components-sql-server-2008-r2
http://hodentekmsss.blogspot.com/2010/07/sql-server-2008-r2-and-data-tier.html

Friday, December 20, 2013

Querying SQL Server 2012 with Power Query

Power Query is a great way to access data and Power View is a great way to view a report.

Some details of Power Query can be found here,
http://hodentek.blogspot.com/2013/12/what-is-microsoft-power-query.html
http://hodentekhelp.blogspot.com/2013/12/what-is-difference-between-ms-query-and.html

Power View is covered in detail in my book,


This post shows how you may connect to SQL Server 2012 Express and query the databases therein using Power Query.

Step 1. If you have not installed the add-in do it now. Get it from this link here,
http://www.microsoft.com/en-us/download/details.aspx?id=39379

Step 2. Launch MS Access 2010 ( or your version). You should see in the splash screen that the add-in is also loaded.

Step 3. Anyway verify it from the Excel Options window that you can access from File menu as shown.

Step 4. Click menu item Power Query followed by From Database as shown.


Step 5. Click From SQL Server Database. In the window that pops-up type in the server name as shown. There is no browse feature here, you have to manually enter as shown.



Step 6. Click OK after entering SQL Server name and the following window pops-up.


Step 7. You can choose encrypted or unencrypted for you connection. Here Unencrypted is chosen.

Step 8. Click Save. The query window appears with a default name Query1 as shown. Here Northwind has been expanded to show the tables.


Step 9. Click on Categories as shown. The table content gets shown on the right side.


Step 10. You can further process the query using the built-in controls which can be displayed by right clicking the corner of the table as shown.


Step 11. The chosen options updates the steps, each time you make a choice a step is added as shown. Note that this next query is from AdventureWorksLT2012 database.


This will be saved to the workbook which you may name appropriately by completing this window. Right now there is no link to publish this result except saving it to the SkyDrive and use it later.

Enjoy

Saturday, December 14, 2013

Query Designer in SQL Server 2012 Express

 Running queries is one of the basic tasks that you undertake. You have two options in SQL Server 2012 Express (also in all other versions), use T-SQL and execute the statements in the query pane of SQL Server 2012 or use the query designer. You will be able to design the query in the designer but you will not be able to execute inside the designer. Once you design the query in the editor the T-SQL code that gets generated is copied to the query pane. Once the T-SQL code is in the pane you can execute (using the Toolbar item EXECUTE(!) to run the query

There are two ways you can bring up the query designer

Step 1. Open a Query pane by right clicking either the Server Node or right clicking one
of the user databases as shown.
 SERVER NODE


USER DATABASE NODE

Step 2. Once the query pane is open, click inside the query pane. The main menu
changes
to display the Query menu item as shown.

 


Step 3.Click Query menu item to display a drop-down list and click on Design Query in Editor or Ctrl+Shift+Q
 

This should bring up the designer as shown.


Step 3b. Another way is to right click inside the query pane and choose Design Query in Editor as before.

 

Tuesday, November 12, 2013

Download this SQL Server 2014 CTP2 Reporting Services Add-in to integrate with Microsoft SharePoint


Report Integration for SQL Server 2012 and SharePoint 2010 was described comprehensively in my latest book:

The new features Power View and Data Alerts were treated in two complete chapters:

Chapter 6: Power View and Reporting Services
Six hands-on exercises

Chapter 7: Self service Data Alerts in SSRS 2012
Three hands-on exercises

The SharePoint 2010 used in the book should work equally well with SQL Server 2014 CTP2.

SQL Server 2014 CTP1 installation was described here.
http://hodentekmsss.blogspot.com/2013/09/installing-sql-server-2014-ctp1-on.html

Programs have been updated and new versions have appeared.
SQL Server 2014 is now in CTP2

Now how does one start working with features like Power View and Data Alerts?

You need to install and work with recent versions.

You need the following :
Microsoft® SQL Server® 2014 Reporting Services Add-in for Microsoft SharePoint®, Community Technology Preview 2 (CTP2)

You can download the above from here:
http://www.microsoft.com/en-us/download/details.aspx?id=40738

Details from the above site are here:

·         The SQL Server 2014 CTP2 Reporting Services Add-in for Microsoft SharePoint technologies deploys the Reporting Services user interface pages and features on a SharePoint web front-end server.



After 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. The Reporting Services Add-in provides the following functionality:

      • Power View, a feature of Microsoft SQL Server 2014 CTP2 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, and presentation experience. It provides drag-and-drop ad hoc reporting for business users such as data analysts, business decision makers, and information workers. Power View reports are in a new file format, RDLX.
      • Open reports in Report Builder from a SharePoint library, and save reports to SharePoint libraries.
      • A Report Viewer Web Part, which provides report-viewing capability, export to multiple rendering formats, page navigation, search, print, and zoom.
      • SharePoint web pages so that you can create subscriptions and schedules, and manage reports and data sources.
      • Support for standard SharePoint Foundation 2010 and SharePoint Server 2010 features including document management, collaboration, security, and deployment with report server content types.
      • The ability to add the Reporting Services Report Viewer Web Part to any page or dashboard on a SharePoint site and customize its appearance.
      • The ability to use SharePoint permission levels and roles to control access to report server content. You can also use SharePoint forms authentication to support access over Internet connections.
      • Reporting Services data alerts, a data-driven alerting solution for SharePoint Server 2010 Enterprise Edition that informs you about changes in report data that are of interest to you, and at a relevant time.



 

Don't miss this huge collection of SQL Server related articles

These were mostly reported during the time SQL Server 2008 was the recent version. The migration related articles and front end related articles basically used SQL Server 2008.

 
  
Creating a matrix report using the Analysis Services Cube 


 In this article by Dr. Jayaram Krishnaswamy, we will be authoring a report based on an analysis services CUBE. Reviewing Jayaram's other OLAP related articles may greatly help in understanding this article. Creating the CUBE will be essential to work with this...
  
Manage SQL Azure Databases with the Web Interface 'Houston'
 

version of SQL Server 2008 is R2. This article by Jayaram Krishnaswamy , is based on a project named 'Houston' which is a web based SQL Azure management tool that has not gone into production but can be tested using the SQL Azure Labs portal at http://www.SQLAzureLabs.com . In this article we look at some of the features of this web...
  
Working with Data Application Components in SQL Server 2008 R2
 

Jayaram Krishnaswamy In the August CTP Microsoft introduced Data-Tier Applications and several new features were introduced in the Nov 2009 CTP. Registering, Viewing & comparing and upgrading Data-Tier applications were added. This article by Dr. Jayaram...

Creating an Analysis Services Cube with Visual Studio 2008 - Part 2
 

Jayaram Krishnaswamy As noted in Part 1 , OLAP presents Business Intelligence via what is known as a CUBE. A Cube has many dimensions and it provides a faster method to access the intelligence compared to the structured querying...
 
Creating a Web Page for Displaying Data from SQL Server 2008


Dr. Jay Krishnaswamy This article by Jayaram Krishnaswamy describes how you may connect to SQL Server 2008 and display the retrieved data in a GridView Control on a web page. Trying to establish a connection to the SQL Server 2008 is ...

 




Jayaram Krishnaswamy SQL 2008 server is the latest in the line of Microsoft database servers and this article by Dr. Jayaram Krishnaswamy discusses the challenges one may face in installing the Developer version of this product  ....


  
Microsoft Lightswitch Application using SQL Azure Database


on August 23rd for the general public while it has been used by MSDN members and Microsoft insiders for couple of months. This article by Jayaram Krishnaswamy shows how you may download and install this program. The article also shows how you may develop a simple database application using this product retrieving data from the Cloud hosted relational ....
  
MySQL Data Transfer using Sql Server Integration Services (SSIS)
 

Jayaram Krishnaswamy There are a large number of posts on various difficulties experienced while transferring data from MySQL using Microsoft SQL Server Integration Services. While the transfer of data from MySQL to Microsoft SQL Server...
  
MySQL Linked Server on SQL Server 2008
 

Jayaram Krishnaswamy Linking servers provides an elegant solution when you are faced with running queries against databases on distributed servers or looking at your distributed assets on disparate databases. This article by Dr. Jay Krishnaswamy explains how...
 
Migrating from MS SQL Server 2008 to EnterpriseDB


Dr. Jayaram Krishnaswamy In this article by Dr. Jayaram Krishnaswamy , we will learn about migration of data from MS SQL Server 2008 to EnterpriseDB. Migration Studio bundled with the EnterpriseDB download is a collection of tools to...


  
Creating an Analysis Services Cube with Visual Studio 2008 - Part 1


data. This two part article by Dr. Jayaram Krishnaswamy describes how a Cube is designed using Visual Studio 2008 and how it may be browsed on the Analysis Server. In Part 1, the necessary items for creating the Cube, namely the Data Source and Data Source Views are described.   Reviewing Jayaram's other OLAP...
  
Transferring Data from MS Access 2003 to SQL Server 2008


two non-Microsoft databases. Both Microsoft and proprietary data source providers are available to connect to many different database products. In this article by Dr. Jayaram Krishnaswamy , we will be transferring data from an MS Access database to a database on SQL Server 2008. Both the source of data and the destination database are on the same...
  
Creating a Simple Report with Visual Studio 2008


Jayaram Krishnaswamy Report Services, Analysis Services, and Integration Services are the three pillars of Business Intelligence in Microsoft's vision that continues to evolve. Reporting is a basic activity, albeit one of the...




  
Displaying SQL Server Data using a Linq Data Source

provided by the Linq to SQL classes, a class generator that maps SQL server objects to the model. The class files generated support CRUD operations. In this article by Dr. Jay Krishnaswamy , we will be adding a LinqDataSource control in Visual Studio 2008 to a ASP.NET website and configuring it by providing a data context. The data context will...
  
Overview of SQL Server Reporting Services 2012 Architecture, Features, and Tools


MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook () () This article by Jayaram Krishnaswamy  the author of  Learning SQL Server Reporting Services 2012,  provides a summarized overview of SQL Server Reporting Services 2012 and the background information ...
  
Using the Data Pager Control in Visual Studio 2008


or it can be installed manually after installing the ListView. In this article both of them are described. While the number of items displayed in a list can be declaratively coded, it is possible to set it at page load time as well. This article by Dr. Jayaram Krishnaswamy describes how you may connect to SQL Server 2008 and display the retrieved...
Moving a Database from SQL Server 2005 to SQL Server 2008 in Three Steps


Jayaram Krishnaswamy There are several options if one wishes to move a database from a SQL Server 2005 to SQL 2008 Server. First of all there is a 'Copy Database Wizard' in SQL 2008 Server which is meant for transferring...


  
Microsoft Lightswitch: Querying and Filtering Data


will not be wrong. Just like you take information out of the table, make changes to it and return it to the table, you do likewise with entity sets. In this article by Jayaram Krishnaswamy , author of Microsoft Visual Studio Lightswitch Business Application Development , we will take a look at querying a single entity...

 
SSIS Applications using SQL Azure
 

Report Server providing full support with a web service frontend for a variety of reporting needs—from web-based reporting to embedded reporting. In this article by Jayaram Krishnaswamy , author of Microsoft SQL Azure Enterprise Application Development , we will be leveraging SSIS, SSRS, and the tools used to address ETL processes, and Report...


  
  
Oracle SQL Developer Tool 1.5 with SQL Server 2005
 

party vendor products to Oracle. Please review the following articles on the earlier versions 1.1 and 1.2: MS Access Queries with Oracle SQL Developer 1.2 Tool and Migrating MS Access 2003 Data using the Oracle SQL Developer 1.2 . In the present article by Dr. Jayaram Krishnaswamy the latest version of this tool [Oracle SQL Developer 1...
  


Jayaram Krishnaswamy In this article by Dr. Jay Krishnaswamy , a Microsoft Chart Control will be bound to a Linq Data Source using LinqDataSource control and a pie chart displays the data. We will be going through the following ...

Ground to SQL Azure migration using MS SQL Server Integration Services

Jayaram Krishnaswamy In this article by Dr. Jayaram Krishnaswamy , you will learn how to migrate a table from your ground based SQL Server 2008 to your cloud based SQL Azure instance using MS SQL Server Integration Services...
 
Copying a Database from SQL Server 2005 to SQL Server 2008 using the Copy Database Wizard


Jayaram Krishnaswamy This article by Jayaram Krishnaswamy shows how to migrate a database from SQL Server 2005 (should work for 2000 as well) to SQL Server 2008 using the Copy Database tool in SQL Server 2008. In an earlier article we saw how this can ...
  


features 128-bit file level encryption. It is referential integrity compliant; supports multiple connections; has transactions support with rich data types. In this tutorial by Jayaram Krishnaswamy , various scenarios where you may need to connect to SQL Server Compact using Visual Studio IDE (both 2008 and 2010) are described in detail. Connecting ...

Authoring an EnterpriseDB report with Report Builder 2.0

Jayaram Krishnaswamy This article by Dr. Jayaram Krishnaswamy shows step-by-step how you may retrieve data from a database on a Postgres Plus server and display the results in a report generated using Report Builder 2.0. Report ... 
 
  
Term Extraction Tasks in SQL Server Integration Services 

stop the flow review it and turn it on to let the data flow to the next step. You may provide a name to the Data Viewer. There are four types of data viewers (Grid, Histogram, Scatter Plot, and Chart) and the 'Grid' type is used in this article. Build the Project and Execute the Package This is easy. Click on the menu item Build...  
 
 
 
the tools that can be leveraged working with SQL Azure, but a few third-party vendors and others have also created tools for SQL Azure. In this article by Jayaram Krishnaswamy , author of Microsoft SQL Azure Enterprise Application Development , we will discuss the Microsoft Tools.   Microsoft...

  
Data Access with ADO.NET Data Services 

 

operating on the data. In this article by Dr. Jayaram Krishnaswamy , you will learn how to create a ADO.NET Data Service from scratch. You will also learn how you may access data using the URI constructs. The backend data for this tutorial comes from a copy of Northwind database named TestNorthwind on a named instance of SQL Server 2008. In order...

  
Writing XML data to the File System with SSIS

Jayaram Krishnaswamy This article by Dr. Jayaram Krishnaswamy , shows how you may retrieve XML data from a relational database and write it to a folder on your file system as a text or xml file using Microsoft SQL Server Integration...

  
Working with the Report Builder in Microsoft SQL Server 2008: Part 1 

Jayaram Krishnaswamy Report Builder 2.0 is feature-rich reporting tool with the latest Microsoft Office look and feel. In this two part article by Jayaram Krishnaswamy , we will see how the Report Builder 2.0 provides an extremely ...

  
Programmatically Creating SSRS Report in Microsoft SQL Server 2008
 
Jayaram Krishnaswamy In this article by Dr. Jayaram Krishnaswamy , the process of programmatically creating the SQL Server Reporting Services (SSRS) tabular report is described. You will be creating a very simple report using the...

 
Working with the Report Builder in Microsoft SQL Server 2008: Part 2
 
Jayaram Krishnaswamy In the previous part of the article, we had a look at the Report Builder overview and described the Report Builder 2.0 interface . In this part by Jayaram Krishnaswamy , we will discuss about Enabling and reviewing ...

Wednesday, November 6, 2013

Twiiter IPO and SQL Server

Use SQL Server Reporting Services to report from Twitter:

http://hodentek.blogspot.com/2009/06/authoring-report-using-twitter-api.html

Tomorrow is Twitter IPO. Expectations are running high. In October it was between 17 to $20. Two days ago it was 23 to $25 and today it has gone up, may be $27 to $29. Only tomorrow can tell.

On the eve of this I provide my Twitter related posts on my Hodentek blog. I seem to remember that my Twitter article to SSQUG.org was published. I will check it out.

Please follow this link:
http://hodentek.blogspot.com/search?q=Twitter

Monday, October 28, 2013

Training Course in Honolulu: Introduction to Structured Query Language (SQL)-Starting November 5,2013

If you are interested in this course you can still register.
Please get in touch with Gerald Cerny (gcerny@hawaii.edu)

Details here:
http://hodentek.blogspot.com/2013/08/introduction-to-structured-query.html

Sunday, October 27, 2013

Error on page 27 of my book, 'Learning SQL Server Reporting Services 2012'

Reporting an error on page 27 in my book 'Learning SQL Server Reporting Services 2012', Packt Publishing, ISBN: 978-1-84968-992-2, June 2013.

Despite an editorial process that took over 2 months and atleast 3 revisions, an error like this one can exist in the document. I sincerely apologize for this error on page 27 in my book, after Step.15.

Error type: Images duplicated instead of two separate figures.

Correction:
Remove the figure that is duplicated
Insert the replacement image in its place. 

Details: Instead of the image immediately after 'Step 15', review the replacement image.

I request the readers of this blog to review the following link which shows the steps to configure the service accounts.
http://hodentekmsss.blogspot.com/2013/09/installing-sql-server-2014-ctp1-on.html

Here is the replacement image.



Here is an image of the relevant page taken from the pref-final edition.

 

Sunday, October 20, 2013

SSDT for SQL Server 2014 CTP2

You will get SQL Server 2014 CTP2 Data Tools BI Project templates if you install Microsoft SQL Server 2014 Data Tools BI for Microsoft Visual Studio 2012, CTP2. Note that this does not work with Microsoft SQL Server 2012. It is supported only on x64 architecture of Windows Servers 2208 R2 and 2012 but on both X32 and X64 for Windows 7 and Windows 8.

Download link here
http://www.microsoft.com/en-us/download/details.aspx?id=40736

This is the file that is installed and is strictly to support CTP2 only:
SSDTBI_VS2012_x86_ENU.exe(537.1 MB), Version:12.0.15240 Published date:10/14/2013

This installs the Microsoft SQL Server 2014 CTP2 Data Tools Business Intelligence project templates for Analysis Services, Integration Services, and Reporting Services.

Make sure you have these on the computer as prerequisites:
•Microsoft .NET Framework 4.5
•Microsoft Visual Studio 2012 Shell (Isolated) Redistributable Package
•Microsoft Visual Studio 2012 Shell (Integrated) Redistributable Package
•Microsoft Visual Studio Tools for Applications 2012
•Microsoft Report Viewer 2012 Runtime

Details of December 2012 update here.

SSDT 2012 news here.

 

Thursday, October 17, 2013

You want to back up your prior version SQL Server data to Windows Azure ? No Problem!

SQL Server 2012 supported backing up database to Windows Azure . Of course higher versions will also be capable and in fact SQL Server 2014 will also do so more easily. What if you wanted to backup your SQL Server 2005, SQL Server 2008, SQL Server 2008R2 to the Cloud. Well, a new 3 step tool released by Microsoft can do it, no problem(it appears). The tool supports backup compression and encryption to boot.

Access tool download link here:
http://www.microsoft.com/en-us/download/details.aspx?id=40740



For prior versions of SQL Server, the Tool provides (from Microsoft site):
  • Easy integration with Windows Azure Blob Storage.
  • Off-site SQL Server backups, accessible from anywhere.
  • Encryption and compression for cloud and on-premises SQL Server backups.
  • SQL Server Backup/restore with Windows Azure Blob Storage Service
  • Backup/Restore feature details here:

    http://msdn.microsoft.com/en-us/library/jj919148(v=sql.120).aspx

    Wednesday, October 16, 2013

    SQL Server 2014 CTP2 is out, get it fast.

    It is available for immediate download.

    Don't click on the start to get evaluation! It won't take you to SQL Server 2014 CTP2.

    Access the main link here:
    http://www.microsoft.com/en-us/sqlserver/sql-server-2014.aspx

    New capabilities :
    Promises new in-memory capabilities
    Promises new cloud capabilities

    Here is a cutout from product documentation.


    Want to check it out, download from here:
    http://www.microsoft.com/en-us/download/details.aspx?id=39269
    The installation should follow the same steps as in installing SQL Server 2014 CTP1.

    Get full screen shots here.
    http://hodentekmsss.blogspot.com/2013/09/installing-sql-server-2014-ctp1-on.html

    Complete product guide here:
    http://www.microsoft.com/en-us/download/details.aspx?id=39269

    Mahalo,
    Jay

    Friday, September 27, 2013

    Installing SQL Server 2014 CTP1 on a Windows 8 computer

    This post describes  installation of SQL Server 2014 CTP1 on a Windows 8 partition of a computer which has Windows 7 Ultimate on the other partition.

    The reason for installing SQL Server 2014 CTP1 on the Windows 8 partition were described in the previous post here:

     http://hodentekmsss.blogspot.com/2013/09/some-problems-to-install-sql-server.html

    The setup program was run from a disc created from an .iso file from the download page here:

    http://technet.microsoft.com/en-us/evalcenter/dn205290.aspx

    The installation steps and the various considerations have been described in great detail in my two books here.
    http://hodentek.blogspot.com/2013/06/learn-sql-server-2012-reporting.html

    http://www.packtpub.com/learning-sql-server-2008-reporting-services/book?mid=010409ofvkyp

    I will present only the screen shots with some relevant explanations.

    The disc is in the dvd drive with the OS as Windows 8 Preview (expired at this time).

     
     
    Running the Setup.exe brings up the installation center which does the setup support rules check as shown.

     
    Clearly to proceed further the Visual Studio program shown in the next screen must be removed.
     
     
    After removing the file the Setup.exe was run again and this time there are no complaints regarding older programs.

    Click OK.


     
     The option is the 'Evaluation edition'. Click Next. Then you accept the license terms and click Next to install the files required for this installation.
     
     
    When this is finished click Install.
     
    Installation steps will start.
     

    There is only one warning. No worry,  Click Next. In the Setup Role window you can choose the way you want to install the server. Here only the first option was chosen. In 'Learning SQL Server Reporting Services 2012' book I have completely described all the options. Herein, only first option will be used.

     
    Click Next. In the Feature Selection window all options have been chosen. You should install only those you require as it will require lot more resources for everything to be installed. The screen was fully stretched out to see everything there is to install. The explanation for the highlighted item is shown alongside on the right.
     
     
    Click Next. The program checks to see if the installation will proceed without a problem.
     

    Click Next.

     
    Now you need to specify whether you require a named instance of the server or a default instance. The default instance will be named MSSQLSERVER, but the named instance takes whatever name you provide here.
     
    Although the author planned a named instance and went through the complete steps, the computer automatically shutdown (may be something that was built-in to windows 8 if the license has expired) and the server was not configured completely. A default instance was later installed following essentially the same steps.
     
    click Next. Now the program looks at the space available for the program. The program requires over ~7GB.
     
     
     
    Click Next. You need to configure the server as well as collation. The screen shows the default that comes up.
     
     
     
    This was modified so that the 'admin' (single user) can work with the server. The same Account Name and password (that of the computer administrator) for all the programs and services as shown in the next image was used.
     

    The entry for object name was arrived at by clicking the Advanced button on the above and choosing the appropriate account as shown here. The chosen user is one at the very bottom of the screen. When you double click the line in this window, it gets into the previous window (you need not type in).

     
    Click OK to Select User or Group window and it gets into the Account Name window. Type in the password for the user. Repeat the same for all programs and services as shown.
     
     
    Choose the default collation. Click Next. Next is  Database Engine Configuration
     
     
    Here the Windows Authentication will be used and the current user is the administrator
    as well. The Windows 8 partition has the name 'Newwin8' and the Windows 7 partition was called 'Hodnetekwin7' which was used in the previously cited book.
    Also Windows 8 uses the LiveID of the user for username and therefore the current user is 'Jayaram Krishnaswamy' shortened as 'Jayaram'. I am not sure if this will create a problem while typing in credentials. Data Directories are part of the Database Engine Configuration.

     
    FileStream is also part of Database Engine Configuration. Place check marks as shown.
     
     
    Click Next. Analysis Services configuration page comes with two options to choose from. Here the 
    Multidimensional Model configuration is chosen. In the early stages of SQL Server 2012 you were required to use the 'Tabular Model' option to be able to create Power View reports in SQL Server Reporting Services in SharePoint Integrated mode. This restriction does not apply anymore. 
     
     
    Similar to Database Engine you designate the current user as admin (or any other you choose to). The Data Directories tab gives you an option to modify the location but here the defaults are chosen. Click Next. 

    You move on to Reporting Services Configuration as shown. Install only is not the option used and it works better as quite a lot of the Configuration will be complete when you finish the installation. Otherwise you need to configure from scratch. For SharePoint Integration only necessary files are installed and you will have to use SharePoint's Central Administration to complete. This part is explained in detail in my previously cited book here, http://hodentek.blogspot.com/2013/06/learn-sql-server-2012-reporting.html
     
     
    Click Next.  The Distributed Replay Controller is very much like SQL Profiler but more versatile and scalable. It is included here for completeness only. Read the notes on the right. The Current user has unlimited access to this service.
     
     
    Click Next. You need to specify the controller and the directories for the client files. Default is chosen.
     
     
    Click Next. The error reporting so that Microsoft can improve installations.  Place checkmark (suggested).
     
     
    Click Next. Installation Configuration Rules will be checked.  It is looking good!
     

    Click Next. Ready to Install page is displayed. Review all the options you have chosen. Of  course you could still make changes by hitting the 'back<<' button and make changes.


    Click Install. The installation begins.


    During this process the computer shutdown (automatically) due to Windows 8 problem. When it was rebooted it did not pick up from this point.

    The Setup.exe was run once again and a default instance was installed following the same line as indicated above). The installation was a success as shown.

     
    The SQL Server 2014 CTP1 related items appear as apps as shown here.


    Clicking on the last app, 'SQL Server Management Studio' brings up the splash as shown.

     
    The login is very similar to the previous versions and brings up the Object Explorer after entering the credentials.


    An attempt was made to look at the instances of SQL Server installed through the discovery tool as shown.

     
    Looks like Analysis Services (mysore) was installed but not configured.
     
    This completes the installation of SQL Server 2014 CTP1 on Windows 8 preview.