Graph based tables is one of the most exciting features that has been included in the latest release of SQLServer. With graph tables its much easier to create data model to deal with complicated scenarios like multi linked hierarchies, many…
SSRS Tips: Creating 2012/2014 BI Templates Using VS 2015
Introduction With the release of VS 2015 shell, its now possible to utilize the BI templates available init for creating SSRS reports, SSIS packages and SSAS projects compatible with server versions 2012 till 2016 from the same unified environment. This…
SQL 2017 CTP Released!
SQLServer 2017 CTP is out for public preview now.SQLServer 2017 has some exciting features on board like resumable online index rebuild, adaptive query query processing etcAlso great improvement can be seen in the performance of datawarehouse workloads in Linux environment.…
SSIS Tips: Case Study – Extracting ZenDesk data using SSIS
Impetus Its been a long time since I wrote a blog.The main reason was that I’ve been super busy with some exciting projects of late.One of my recent projects had an interesting requirement which I thought would be worth sharing…
WinSCP Tips: Passing Credentials With Special Characters
Scenario Recently there was an issue faced in one of our projects on a file processing system that we designed. The file processing system was designed to process third party files which had to be downloaded from a FTP location. …
SSRS Tips : Fixing Format Issues in MHTML Rendered SSRS Reports
Impetus The impetus for writing this blog came from a recent issue I faced while setting up email based subscription for one of my MIS reports for enterprise wide distribution. The report content had to be embedded within the email…
What’s New in SQL 2016 – Temporal Tables
Introduction Most of us are familiar with CDC tables in SQL Server. CDC or Change Data Capture is used to track and capture the DML changes happening in a table and makes use of log entries for capturing the information.…
Whats New in SQL 2016 – Native JSON Function Support – Performing Data Manipulations in JSON Documents
This is the last and the final article in the series which discusses on the native JSON support in SQL 2016.Previously I had blogged on how JSON documents can be generated from relational data using FOR JSON construct here http://visakhm.blogspot.ae/2016/06/whats-new-in-sql-2016-native-json.html…
Whats New in SQL 2016 – Native JSON Function Support – Parsing JSON Document to Shred Relational Data
Previously I had blogged about the native support for JSON in SQL 2016 and the ability to generate JSON documents from relational data using FOR JSON syntax here .This blog is next in the series on JSON support and explains…
Whats New in SQL 2016 – Native JSON Function Support – Generating JSON documents using FOR JSON clause
One of the most sought after feature that got included in SQL 2016 is the native support for JSON data in Transact SQL. JSON has become kind of de-facto standard for data transfer in web applications these days. As such…