Profile cover photo
Profile photo
Visakh Murukesan
243 followers
243 followers
About
Posts

Post has attachment
SSIS Tips: Enforcing TLS 1.2 For SSIS 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 projects, there was a SQL Agent...
Add a comment...

Post has attachment
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 which indicated that preview tab ...
Add a comment...

Post has attachment
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 and time formats. Though I rely upon fr...
Add a comment...

Post has attachment
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 time  in SQLServer and had eluded my knowledge till now. This article explains on the details of the function along w...
Add a comment...

Post has attachment
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 probably k...
Add a comment...

Post has attachment
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 non E...
Add a comment...

Post has attachment
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 range Emp Y: Can you check if there was any server restart? Emp X: Oh y...
Add a comment...

Post has attachment
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 in this was the ability to organize the ta...
Add a comment...

Post has attachment
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 much easier to create data model to deal with complicated scenarios like multi linked hierarchies, many to many relation...
Add a comment...

Post has attachment
SSRS Tips: Creating 2012/2014 BI Templates Using VS 2015
Introduction With the release of VS 2015 shell, its now possible to utilize the BI templates available init for creating SSRS reports, SSIS packages and SSAS projects compatible with server versions 2012 till 2016 from the same unified environment. This qui...
Add a comment...
Wait while more posts are being loaded