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…
How to solve OPENQUERY MySQL Update Issue Using ODBC DSN
This blog explains an issue you’re likely to face while executing a remote UPDATE query against a MySQL server over a linked server connection using ODBC DSN based connectionstring Scenario Recently I was working in a project where I required…
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…
Whats New in SSIS 2016 – Expose SSIS Package Data Externally as a View
Introduction SQL 2016 has brought in lots of new and exciting features on the plate. One of the pretty cool feature that was added to SSIS in SQL 2016 is the ability to expose the data directly as a SQLServer…
SQL Server 2016 Available for General Availability Now
SQL 2016 has been released for general availability now You can find the download links from MSDN The evaluation period is for 180 days https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016 SQL 2016 comes with lots of useful and cool features including Native JSON support Always…
T-SQL Tips: Can a UDF Return Values of Multiple Datatypes?
This was a question raised in one of the forums recently.This blog explains how we can create a user defined function (UDF) which can return values of different datatypes under different conditions.Consider the case where we require creating a user…