Profile cover photo
Profile photo
Sathyanarrayanan S

Post has attachment
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...

Post has attachment
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 ...

Post has attachment
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 cost...

Post has attachment
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)...

Post has attachment
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...

Post has attachment
SQL Server access Previous / Next rows and first / last row from partitioned resultset
From SQL Server 2012, new built-in analytic functions are introduced, using that we can easily access subsequent/previous row in the same result set without the use of a self-join  and first/last value in an ordered set of values. In this post, let us see s...

Post has attachment
SQL Server - Example for invoking sql file through SQLCMD
SQLCMD  utility lets us execute Transact-SQL statements, Stored procedures, and other script files at the command prompt, in SSMS Query Editor in SQLCMD mode, in a Windows script file or in an operating system (Cmd.exe) job step of a SQL Server Agent job. I...

Post has attachment
SSRS Exporting reports to different file formats
Till SQL Server 2012 below are the supported file formats for exporting SSRS reports : From 2016, We can export a Reporting Services report to another file format PowerPoint We can export to other formats while previewing report in Report Builder, Report De...

Post has attachment
SQL Server Error - Msg 9412, Level 16, State 1
We will get this error when we are trying to query XML in SQL Server. If that XML is invalid, Say for example if the closing tag ">" is missed in the input XML Below error message will be throwed : Msg 9412, Level 16, State 1, Line 1 XML parsing: line 6, ch...

Post has attachment
SQL Server - Error Msg 9400, Level 16, State 1, Line
We will get this error when we are trying to query XML in SQL Server.    Each and every XML node should have closing node like this <element>....</element>. XML will become invalid when it has backslash "\" instead of forward slash "/" Below error will be t...
Wait while more posts are being loaded