Problem Statement There is an application database hosted in a SQLServer instance which is capturing data from a automation software including the readings as well as general health related details of multiple machines. The requirement asks for the creation of…
SQL Tips: String Or Binary Data Truncated Error Message Enhancement
Introduction I’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 would be truncated.The statement has been terminated. is one of the most frustrating errors…
SQL Agent Tips: Using JOBID Token in T-SQL Job Steps To Fetch The Job GUID
Introduction One of the pretty cool features available in SQL Server Agent is the ability to use tokens for returning values for many system parameters at runtime (for example Server Name, Job Name, Database Name etc).Recently there was an issue…
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 connectivity to a HTTP endpoint and steps taken in resolving the same Scenario In one of the…
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 creation of SSRS report using VS 2017 shell based SQLServer Data Tools. There was a post…
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 major use case has been in formatting date and time based values to custom date…
SQL 2017 Tips: Tweaking IDENTITY_CACHE Setting to Avoid IDENTITY Column Gaps
Introduction In my discussions with my fellow colleagues as well as on my online interactions with the developer community, I’ve come across a good amount of cases where people have raised a concern over the IDENTITY behavior in SQLServer.As you…
SSIS Tips: Handling UTF 8 Based File Data
Introduction Quite a few times there were cases where we had to transfer CSV data containing non English based characters to SQLServer database. Though it seems straightforward there are few things we need to consider while working with CSV containing…
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 values for couple of tables have jumped to a new rangeEmp Y: Can you…
SQL 2017 Tips: Creating Table On The Fly Onto A Specific FileGroup
Introduction One of the frequently used and the most popular features in SQLServer is the ability to create a table on the fly based on a query. This has saved my day on numerous occasions. Only thing I was missing…