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 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…
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…
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…
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…
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, adaptive query query processing etcAlso great improvement can be seen in the performance of datawarehouse workloads in Linux environment.…
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 my recent projects had an interesting requirement which I thought would be worth sharing…