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
Author: Kloudspro
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
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
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
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
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
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
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.
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
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
Did You Know…This About CTAS vs. SELECT…INTO
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
A Practical Guide to Deal With JSON Data in SQL
As promised in the previous post while talking about Azure IP ranges and service tags, I mentioned that I will be writing next post to
Azure IP Ranges and Service Tags
Interested in knowing Azure data center IP ranges or service tags (Azure Services like Storage, Azure SQL databases etc.)? It’s not that difficult. Microsoft provides
Azure Purview Pricing Explained
Azure Purview is now in GA – General Availability mode so please read this post for latest pricing information. In an earlier post few months
SQL Script to Check Tables Defined With All Columns as NULL
Off late, I was asked to do a quick review of a database and it was one of the things that I always look for….generally,