Sunday, June 30, 2013

Install and evaluate SQL Server 2014

In my previous post I summarized the features that are special to SQL Server 2014 (Hekaton). Things will move very fast where data is concerned.

Now you can get the full product guide (, 23.3 MB) from here:

After downloading you can use any of these OS:Windows 7, Windows 8, Windows Vista, Windows XP. Make sure you have enabled ActiveX Controls and plug-ins.
The following is quoted from the Visual Studio site,
 "The SQL Server 2014 CTP will expire after 180 days or on Dec. 31, 2013, whichever comes first. Download options include an ISO DVD image, CAB file or Azure version. Microsoft recommends the ISO or CAB version to test the software's new in-memory capabilities"

Some of these should be known before you install:
  • SQL Server 2014 CTP1 is only supported on x64 architecture
  • You have to use SSMS installed with SQL Server 2014 CTP1 to administer
  • There is no feature pack associated with SQL Server 2012 CTP1
  • Use SQL Server 2014 CTP1 on Windows Azure for testing the features and not performance testing.
  • You can update SQL Server 2012 SP1 to SQL Server 2014 CTP1
On what platforms can you install SQL Server 2014 CTP?

It is not very clear if it can be installed on Windows 7 and Windows 8. The documentation is sparse. 

I did try it on Windows 7(x64) and the rules check did not complain (of course I have others that I should remove):

Friday, June 28, 2013

Do you want to learn SQL Server Reporting Services 2012 in record short time?

Learning SQL Server 2012 Reporting Services was released today by Packt publishers. This is my second book on Microsoft SQL Server Reporting Services (which may be called a second edition). It is enlarged to include Reporting Services Integration with SharePoint 2010. With 566 pages it is somewhat thicker than the first edition (Learning SQL Server 2008 Reporting Services). However, the book has a large number of screen shots like my first book and is somewhat thinner than most other books in this genre. The reviewers and technical editors have put in a lot of effort and time to make this happen.

I take this opportunity to thank the reviewers (Satya Shyam Jayanty and Ritesh Shah) for their meticulous reading of the manuscript; the technical editors, Azharuddin Sheik, Mausam Kothari, Varun Pius Rodrigues, and Lubna Shaikh and many others at Pakct Publishing for their excellent editing and Microsoft Forums' (MSDN, Technet and SharePoint) help for answering so many of my questions.

Summary of Hands-on tasks you learn:
  • Install SQL Server 2012, SharePoint Server 2010, and configure Reporting Services both native and SharePoint Integrated on Windows 7
  • Install SSDT and author reports, both local and remote, and deploy them to report servers
  • Develop desktop and web applications by using Report Viewer controls
  • Author different kinds of reports with the latest gadgets by working with Report Builder
  • Manage access to the report server, report scheduling, report delivery, report uploads, and downloads with Report Manager
  • Create Tabular Models with SQL Server Analysis Services and deploy them to SSAS Server using SSDT
  • Author Power View Reports from your SharePoint Site and export them as Power Point files
  • Learn to create Data Driven alerts in SharePoint and monitor them on SQL Agent on SSMS
  • Work with Windows Azure Reporting Services using Windows Azure Portal and SSMS
  • Write applications in SSIS and WPF to access reports and access native server reports from SharePoint Site
I hope this book is appreciated as much as the earlier one.

This book can now be bought from the publishers as well as other online book sellers:

If you are using SQL Server 2008 then this book is for you,
The links in the book are available here:

Tuesday, June 18, 2013

Links in the book, Learn SQL Server Reporting Services 2012

My new book on SQL Server Reporting Services 2012 is about to be released and this post provides a list of links referenced in the book, sorted chapter wise.

Hyperlinks provide a gateway to the extensive literature that can be accessed on the Internet. They provide information (collective knowledgebase) above and beyond what one finds in a single article,book,blog or other media formats. However links in a printed book are useful to only those readers who would go to any lengths to find information but irksome, frustrating and almost useless to the others. They are of course useful in online formats such as eBooks.

In order to conform to page count limit set by the publishers (as you might have noticed computer books have become heftier and heftier) and yet provide guidance to the readers there is no better way than publishing a list of links that is chapter-wise sorted and placed in a location that is easy to access. This post is an attempt to do just that. However some essential information from Microsoft Documentation is used as is in the book in some of the chapters.

Chapter 1: Overview and Installation – SQL Server Reporting Services 2012

Operating System Requirements

Software requirements (Power Shell)

Finding processor cores of the computer

Download link for SQL Server2012 Enterprise Evaluation x64 bit

Options for SharePoint Integration

Distributed replay controller

Configuring reporting services 2012

SQL Server 2012 Security related link

Setting up IE browser to start with Administrator Privileges

SQL Server 2000 database files

Attaching and detaching databases

Attaching/Detaching step-by-step

Running script files, step-by-step

Choosing SharePoint Server for SQL Server 2012 Integration

Installing SharePoint 2010 on Windows 7(x64)

SharePoint 2010 hardware and software requirements

Download link SharePoint2010 Trial

Installing Microsoft Sync Frame work 1.0(x64)

Get Microsoft SQL Server 2008 Native Client MSI

Download and Install Windows 6.1-KB974405-x64.msu

Get Microsoft Chart Controls for Microsoft .NET Framework 3.5 (KB2500170).

SharePoint2010 and SQL Server 2012 choice

Reporting Services 2012 Add-in for SharePoint 2010

Making changes to application pool identity

Chapter 2: SQL Server Reporting Services 2012 Projects with Visual Studio 2012

SSDT and SQL Server 2012

SSDT first time problems

SSDT and SSRS 2012

SSDT December 2012 update

Report Designer

Problem with report preview in VS Designer

First edition

Learning SQL Server Reporting Services 2008, ISBN: 9781847196187, Packt Publishing, 2009

Export problem to MS Access

Visual Studio 2012 Ultimate download site

Report Viewer Controls

Visual Studio 2010 download site

Detailed description of Report Builder 2.0 Part 1 Part 2

RDL and RDLC Schemas

Report Viewer Runtime 2008 version

Report Viewer Runtime 2010 package

Report Viewer Runtime 2010 SP1

Report Viewer Runtime 2012

Chapter 3: Overview of SQL Server Reporting Services 2012 Architecture, Features, and Tools

Major Components of Native Mode installation

SharePoint Standalone Deployment for SQL Server 2012 Integration

Reporting Services 2012 Configuration details

Regarding Report Parts and their usage

ESRI Shape Files

Regarding Report scheduling

Creating, modifying and deleting Schedules

Power View Features

Authentication – Report Servers

URL access parameters

Reporting Services Default Extensions

Security, Data Processing, Rendering, Report Processing and Delivery Extensions

Chapter 4: Working with Report Manager

Report Manager 2012 - Overview

Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008

Tasks and permissions on Native mode report server

Launch error from while launching Report Builder from Report Manager

Report Manager Site Settings

Report Manager F1 Help

System Role assignments (New/Edit)

Clickthrough Reports (SSRS)

Exporting Reports (Report Builder and SSRS)

Caching Reports (SSRS)

Chapter 5: Working with Report Manager

Learning SQL Server 2008 Reporting Services, Jayaram Krishnaswamy, Packt publishing, ISBN: 9781847196187, 1st Edition, March 2009

Chapter 5: Working with Report Builder 3.0

Report Builder: ENU\x86\ReportBuilder3.msi (24.8 MB) file download link

Report Builder 2.0 Interface description Part 1

Authoring Reports with Report Builder 2 Part 2

Data source properties - credentials

Chapter 7: Report Authoring with Report Builder 2.0

Learning SQL Server 2008 Reporting Services, Jayaram Krishnaswamy, Packt publishing, ISBN: 9781847196187, 1st Edition, March 2009

Report Parts in Report Designer (SSRS)

Chapter 6: Power View and Reporting Services

Business Intelligence Semantic Model

What’s new in Power View

Comparison of Multidimensional and Tabular Model

Overview of Power View

Power View Visualization

Practicing Power View online

News about Windows Azure HDInsight; and Power View/Power Pivot

Tabular Model and default field set

Measures: Tabular Data Model

Power View with Multidimensional model

Chapter 7: Self-service Data Alerts in SSRS 2012

Data Alerts details

Setting up content types in SharePoint site

SharePoint Integrated Reporting Services proxy site

About alert Rules and Alert Scheduling

Chapter 8: Reporting Services and Programming

URL Access

Deprecated prefixes (DSU and DSP) in SQL Server Reporting Services 2012

URL Access syntax for SharePoint Integrated Reporting Services server

Report Viewer: CodePlex Site link

Stream callback and Report Viewer

Report Server Web Services Management Endpoints

ReportExecution2005 end point

SharePoint proxy endpoints

SharePoint Integrated mode ReportService2006

Windows Management Framework 3.0 (PowerShell) download

Power Shell quick reference (Cheat sheets)

PowerShell script for getting all Prerequisites to install SharePoint server 2010

Making changes to Application Pool

Power Shell – In depth link

System.Management namespace details

RSS disambiguation

Configuring Reporting Services URL

Writing custom code for reports

Chapter 9: Windows Azure SQL Reporting

Windows Azure SQL Reporting Services limitations

Pricing for hosting reports on Windows Azure SQL Reporting

Main link for pricing

MSDN Forums

Technet forums

Windows Azure Portal- link to old portal

Windows Azure Service - known issues

Comprehensive reference to SQL Azure with hands-on examples

Microsoft SQL Azure: Enterprise Application Development, ISBN:9781849680806, Packt Publishers, 2010

Chapter 10: Applications Accessing Report Servers

Windows Presentation Foundation in Visual Studio

Web Browser Class (.NET Framework 4.5)

Browser WebBrowser.Navigate () method

View and Explore Native Mode Reports Using SharePoint Web Parts (SSRS)

SQL Server Integration Services

Chapter 14: Web Service task to convert miles to kilometres

SQL Server Integration Services Using Visual Studio 2005, ISBN: 9781847193315, Packt Publishers, 2007

Tuesday, June 4, 2013

Hekaton becomes SQL Server 2014

Blocking and Locking will be a thing of the past

In-memory OLTP Processing:
SQL Server 2014 (former codename Hekaton) has built-in, in-memory capability for OLTP Transactions with not so expensive hardware requirements. The release date of SQL Server 2014 was annonuced at its TechEd conference in New Orleans this week.

The ink is still fresh on my new book, Learning SQL Server Reporting Services 2012 and Microsoft has announced another version already. Well, Microsoft is known for its relentless offerings. Transactions can be disk/memory based which does not require expensive boxes and with this feature Microsoft tries to distinguish itself from the likes of SAP Hana (Oracle Database with its Exadata and Exalytics). The performance is very fast but only 50 times faster but not Hekaton faster (Hekaton means 100!!!).

In-memory Business Intelligence:
This is already a reality. Look at the terrific features of Power View. You can go two ways with Power View: Power Pivot via EXCEL or Tabular Model with SSAS.

Get a jump start from scratch on your acquaintance  with Power Views with my forthcoming book,
Learning SQL Server Reporting Services 2012

Read more on SQL Server 2014 here-> tiwht wyaoracle.html.

What is the latest MySQL Version available?

The latest version for Windows (x86) version of MSI installer can be found here: ...