Latest From Kloudspro

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…

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…