What is Microsoft SQL Operations Studio

For various SQL Server database related operations, SQL Server management studio (SSMS) is used.

From SQL Server 2016, SSMS needs to be installed separately. Later it was included in the SETUP.exe for installing SQL Server.

SQL Operations Studio is now available in preview. What is Microsoft SQL Operations Studio ?

Error code 17051 while starting SQL Server services

It's been while I had connected to SQL Server installed in my laptop using SQL Server management studio (SSMS).

When I tried connecting using SSMS, I got error as shown in below screenshot:

H1B visa petition case status prediction model using Azure machine learning

In this post, let us see an example for Azure Machine learning - Classification model.

Steps involved to build an Azure ML experiment (classification model) that will predict based on the input data feed:
1) Data preparation
2) Choosing the Algorithm
3) Train, Score & Evaluate the model
4) Deploying the trained model 

SQL Server 2017 - Graph tables

Native graph databases have risen in popularity, being used for social networks, transportation networks, logistics, and much more. Graph database scenarios can easily be found across several business disciplines, including supply chain management, computer or telecommunication networks, detecting fraud attacks, and recommendation engines.

SQL Server offers graph database capabilities to model many-to-many relationships, handle applications that has hierarchical data and when there is need to analyze interconnected data and relationships.

SQL Serve(R) visualization on SSRS

We all know, SQL Server R Services is one of the new feature introduced in the recent release of SQL Server. 

Below are the benefits of integrating the R language within SQL Server:

i)  keep analytics close to the data 
ii) eliminate the costs and security risks associated with data movement.

So it means, we can use the rich and powerful R language within SQL Server management studio (SSMS) to create models and generate predictions using your SQL Server data. 

SQL Server 2016 - Getting started with R Services

R Services (In-Database) provides a platform for developing and deploying intelligent applications that uncover new insights.

R Services (In-Database) integrates the R language with SQL Server, you can keep analytics close to the data and eliminate the costs and security risks associated with data movement.

To install R Services

Publish an SSIS Package result set as a SQL View

From SQL server version 2012 onwards there is an in-built mechanism to publish SSIS package result set into SQL view

1.    Requires SSIS package to be designed with Data Streaming Destination.

This destination component needs to be separately downloaded in 2012 and 2014. From 2016, it is part of standard toolbox item.

2.    Running Data Feed Publish Wizard

    i)  Creates a linked server – SSISOLEDB.

    ii) Creates a SQL view in the specified database.

Below are the steps to publish an SSIS Package result set as a SQL View

SSRS 2016 Mobile reports

In this post, I have provided quick walk-through on Integration of Mobile reports with SSRS 2016 

Below are the pre-requisites to play with mobile reports, Inside Azure VM – Install below software’s:

1.       Microsoft Visual C++ 2012 Redistributable (x86) - 11.0.61030
2.       Microsoft SQL Server Mobile Report Publisher
3.       Microsoft® SQL Server® 2016 Report Builder
4.       Configured a Firewall for Report Server Access
5.       AdventureWorks Databases and Scripts for SQL Server 2016 CTP3