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
Author: Kloudspro
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,
Azure Machine Learning Cheat Sheet
A picture is worth a thousand words and this image proves it all…a great reference point when you are dealing with choosing the algorithm for
Did You Know…That 0% Cost in SQL Query Plan is Not Actually 0%
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
Spark and Databricks Runtime Version
You can check the version of Spark running on the cluster your notebook is attached to as follows – … and to check the Databricks
Power BI: Use COUNTROWS instead of COUNT
Both COUNT() and COUNTROWS() functions accepts single parameter. The difference lies in the fact that COUNT() operates over a column whereas COUNTROWS() asks for the
Get Started With Azure Cloud Shell
Azure Cloud Shell is a command line interface to work with Azure resources for different administrative tasks. If you are not an administrator, a developer