Blog: Visakh Murukesan

208 blogs updated: 7 min. ago
SSIS Tips: Handling UTF 8 Based File Data
IntroductionQuite a few times there were cases where we had to transfer CSV data containing non English based characters to SQLServer databa...
05-08-2017 14:05:51 Visakh Murukesan SQL Server
SQL 2017 Tips: Avoiding Gaps in IDENTITY, SEQUENCE Based Column Values
Scenario One of the common conversations I've come across in a typical work day is as below Emp X: I just found that the IDENTITY column val...
20-06-2017 06:37:52 Visakh Murukesan SQL Server
SQL 2017 Tips: Creating Table On The Fly Onto A Specific FileGroup
IntroductionOne of the frequently used and the most popular features in SQLServer is the ability to create a table on the fly based on a que...
16-06-2017 10:56:05 Visakh Murukesan SQL Server
Graph Tables in SQL 2017
Graph based tables is one of the most exciting features that has been included in the latest release of SQLServer. With graph tables its muc...
30-05-2017 22:14:08 Visakh Murukesan SQL Server
SSRS Tips: Creating 2012/2014 BI Templates Using VS 2015
IntroductionWith the release of VS 2015 shell, its now possible to utilize the BI templates available init for creating SSRS reports, SSIS p...
03-05-2017 10:51:32 Visakh Murukesan SQL Server
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, ad...
20-04-2017 09:19:04 Visakh Murukesan SQL Server
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...
13-04-2017 07:52:21 Visakh Murukesan SQL Server
WinSCP Tips: Passing Credentials With Special Characters
ScenarioRecently there was an issue faced in one of our projects on a file processing system that we designed. The file processing system wa...
21-10-2016 11:27:43 Visakh Murukesan SQL Server
SSRS Tips : Fixing Format Issues in MHTML Rendered SSRS Reports
ImpetusThe impetus for writing this blog came from a recent issue I faced while setting up email based subscription for one of my MIS report...
26-08-2016 10:53:25 Visakh Murukesan SQL Server
What's New in SQL 2016 - Temporal Tables
IntroductionMost of us are familiar with CDC tables in SQL Server. CDC or Change Data Capture is used to track and capture the DML changes h...
02-08-2016 08:35:03 Visakh Murukesan SQL Server

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.