Was playing with STRING_SPLIT function the other day in my Azure SQL database instance and happened to notice a small enhancement which seems to have appeared. The STRING_SPLIT function now includes a new optional parameter which can be used for…
T-SQL GRAPH Table Tips : Demystifying SHORTEST_PATH function
Introduction This article is the last one in the series of blogs that I’ve written on GRAPH tables in SQLServer. The previous two articles were published in Technet Wiki and can be checked from the below link. Introduction to Graph…
Fun with SQL – Find out numbers where adjacent digit differs by 1
My friend and mentor Madhivanan had posted an interesting scenario on his blog https://exploresql.com/2020/05/01/fun-with-sql-find-out-numbers-where-adjacent-digit-differs-by-1/ and gave it as a challenge for others The question was below I decided to have a try myself on thisHere;s my version of the query…
SQLServer : Real Time Streaming RDBMS Data Using Apache Kafka Platform
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…
Graph Table Enhancements : Edge Constraints, Utility Functions
The second part of the article https://www.dataplatformcentral.com//2017/05/30/graph-tables-in-sql-2017/ can be found here https://social.technet.microsoft.com/wiki/contents/articles/53162.graph-table-enhancements-edge-constraints-system-utility-functions.aspx Here I have explained on the concept of Edge Constraints and how they can be used to enforce the relationships between Node tables within an Edge table. The article also…
T-SQL Tips: Generating Nested XML Structures Efficiently Using FLOWR Expressions
Introduction I have been thinking about publishing an article on this for quite a while now. Of late have been too busy (or may be lazy is a better word!) to write on this. Finally thought of breaking the . …
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…