Blog: Visakh Murukesan

213 blogs updated: 7 min. ago
SQL Tips: String Or Binary Data Truncated Error Message Enhancement
IntroductionI'm sure lots of us who have been developing in SQLServer over ages would agree to the fact that the error String or binary data...
29-10-2018 09:28:04 Visakh Murukesan SQL Server
SQL Agent Tips: Using JOBID Token in T-SQL Job Steps To Fetch The Job GUID
IntroductionOne of the pretty cool features available in SQL Server Agent is the ability to use tokens for returning values for many system ...
16-10-2018 10:30:30 Visakh Murukesan SQL Server
SSIS Tips: Enforcing TLS 1.2 For SSIS 2012 Connections
Impetus The main inspiration behind this article comes from a recent issue faced in one of my projects for configuring TLS 1.2 based connect...
14-08-2018 10:39:26 Visakh Murukesan SQL Server
SSRS 2017 Tips: Solving Default Font Issue in SSDT 15.5 Preview
Impetus The impetus for writing this article came from a recent question which was asked in one of the forums.This was regarding the creatio...
19-02-2018 10:08:04 Visakh Murukesan SQL Server
SQL Tips: Demystifying FORMAT behavior in Datetime vs Time Values
Introduction Since SQL 2012 , one of the functions which I used quite regularly on my day to day coding has been the FORMAT function. The ma...
08-11-2017 13:16:20 Visakh Murukesan SQL Server
SQL Tips: Exploring Agent_Datetime Function
Introduction Recently there was a discussion in one of the forums which helped me to learn about a function which has been there for a long ...
31-10-2017 12:15:10 Visakh Murukesan SQL Server
SQL 2017 Tips: Tweaking IDENTITY_CACHE Setting to Avoid IDENTITY Column Gaps
IntroductionIn my discussions with my fellow colleagues as well as on my online interactions with the developer community, I've come across ...
24-10-2017 14:18:01 Visakh Murukesan SQL Server
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

© 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.