Profile cover photo
Profile photo
Visakh Murukesan
219 followers
219 followers
About
Visakh's posts

Post has attachment
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.  We designed a SSIS package ...

Post has attachment
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 in HTML format so I had s...

Post has attachment
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. SQL 2016 provides similar kind of fu...

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

Post has attachment
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 about how you can use T-SQL code...

Post has attachment
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 data to be tra...

Post has attachment
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 it makes it really awesome to know th...

Post has attachment
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 database view object which can be accessed using...

Post has attachment
SQL Server 2016 Available for General Public 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...

Post has attachment
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 define...
Wait while more posts are being loaded