Extracting zip code from an open text address field using T-SQL
Sometime we come across a situation where we need the ZIP code of an address but the raw data from operational systems is coming as an address collected from an open field i.e. ZIP code is part of the address itself. With such an open field provision you can not expect a consistency that ZIP…
Azure Synapse Provisioning Issue in Southeast Asia Region: Not Accepting Creation of New Windows Azure SQL Database Servers at this Time
We came across a provisioning issue for Azure Synapse Analytics workspace about a couple of weeks ago. This was for the first time for us that we experienced one of its own kind issue for any of the resources on Microsoft cloud platform so thought to share this with you all. After doing some basic…
Did You Know…Tumbling Window in Azure Stream Analytics is Nothing But A Hopping Window
This post is a part of the series “Did You Know” whereby the purpose is to share some quick key point of a particular concept that helps us to be informed on top of our head or something that we want to be revisited quickly. So, no detailed discussions on the topic but a straight…
Integrate Tabular Editor (Free Version) in Power BI as External Tools in 2 Minutes
You can easily integrate Tabular Editor in Power BI under the External Tools menu by following the simple steps as – Download the Tabular editor from this blog’s menu => Kloudspro => Downloads => Power BI => Tabular Editor 2.16.5. Note that if you download through Google then you may come across Tabular Editor 3.0…
Artificial Intelligence (AI) Features in Power BI
We have already seen in an earlier posts how AI is there in our day-to-day life and what features in SQL Server are AI-powered. Let us now see lot of its existence in today’s everyone’s favorite tool i.e. Power BI. We all know that Power BI is a mature, modern and enterprise BI tool that…
Azure Purview Pricing Update – With General Availability
Azure Purview is now Generally Available with lots of updates in terms of pricing, security and the shortcomings around schema update that we had during the preview period. Let us quickly see in this post how better it has become in terms of its cost – The very first thing we need to catch up…
Did You Know…TempDB Size in Azure Synapse Dedicated SQL Pool (SQL DWH)
This post is a part of the series “Did You Know” whereby the purpose is to share some quick key point of a particular concept that helps us to be informed on top of our head or something that we want to be revisited quickly. So, no detailed discussions on the topic but a straight…
Converting base64 Encoding to String format in SQL
You might have seen at various places, images being represented as normal ASCII characters…those are nothing but the image’s binary data encoded into ASCII format. This encoded format is base64 which is more commonly used these days to encode binary data. This is not necessarily for encoding image’s binary data but can be used to…
SQL Script to Check Partition Information in a SQL Server Database
Few months ago, we talked about how to partition a table in SQL Server database. Let us now look at a script that you can keep handy if you need to check the details of all different partitions and the related information of all the tables in database – This script can be executed on…
Analytics: Rounding Off Problem
If you are into analytics then you must have witnessed this many times in your life that sum of all those numbers that you rounded off for each category is not equal to 100% when you see the grand total. To some beginners, it sounds like a problem but once you understand it then you…