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
Author: Kloudspro
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
Artificial Intelligence (AI) Feature(s) in SQL Server/Azure SQL Database
As shown in the previous post that Artificial Intelligence has become or if not convinced yet then let’s say that is becoming an integral part
SQL Script to Check Unused or Bad Indexes
sys.indexes, sys.objects and sys.dm_db_index_usage_stats Checks where writes are greater than the reads i.e. index maintenance is higher than the benefit it is serving during read
Did You Know…This About GPU Enabled Computers and Deep Learning
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
SQL Script to Check Index Fragmentation
This may take some time to get executed if tables are heavy in the database sys.indexes, sys.objects and sys.dm_db_index_physical_stats() Mode can be “Sampled”, “Limited” or
How to Awake or Develop a Leader in You
I have always been saying that more than a professional, we are humans and the interpersonal skills that we develop as part of our usual
sp_MSforeachdb: Hidden Gem of SQL Server
Almost every DBA or anyone who has got a good exposure of working with SQL must have used this procedure i.e. sp_msforeachdb. This is a
SQL Script to Check Row Count of Each Table
Need to check row count of each table in the database in an efficient manner? Here is the query that you can simply copy and
Did You Know…Power BI Scheduled Refreshes are Paused Automatically if…
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
Most Common Issue in Restoring Azure SQL Database bacpac File to Local Database Instance
If you have ever tried to bring your Azure SQL Database data to local instance through .bacpac file then there are high chances that you
Measure Your Productivity in Power BI with Zero Efforts and Instantly
Last week Microsoft released Teams activity reports in Power BI that allows you to analyze how much time you have been spending on meetings, how