Skip to content

Kloudspro

  • Quick Links
    • Microsoft Certifications
    • Azure Portal
    • Azure Data Factory
    • Power BI Service
    • Azure Data Centers
    • Azure Pricing Calculator
    • Microsoft Bug Bounty Program
  • Downloads
    • Azure IP Ranges
    • Azure Storage Explorer
    • SQL Server Management Studio (SSMS)
    • Power BI
      • Power BI Desktop
      • Tabular Editor 2.16.5
  • Azure Health Check
    • Azure Status
    • DevOps Status
    • Service Health
  • Contact

Month: July 2021

Azure Machine Learning Cheat Sheet

July 27, 2021 Kloudspro

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

Continue reading

Did You Know…That 0% Cost in SQL Query Plan is Not Actually 0%

July 23, 2021 Kloudspro

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

Continue reading

Spark and Databricks Runtime Version

July 22, 2021 Kloudspro

You can check the version of Spark running on the cluster your notebook is attached to as follows – … and to check the Databricks

Continue reading

Power BI: Use COUNTROWS instead of COUNT

July 22, 2021 Kloudspro

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

Continue reading

Get Started With Azure Cloud Shell

July 21, 2021 Kloudspro

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

Continue reading

Artificial Intelligence (AI) Feature(s) in SQL Server/Azure SQL Database

July 15, 2021 Kloudspro

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

Continue reading

SQL Script to Check Unused or Bad Indexes

July 10, 2021 Kloudspro

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

Continue reading

Did You Know…This About GPU Enabled Computers and Deep Learning

July 9, 2021 Kloudspro

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

Continue reading

SQL Script to Check Index Fragmentation

July 8, 2021 Kloudspro

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

Continue reading

man and woman leaning on table staring at white board on top of table having a meeting

How to Awake or Develop a Leader in You

July 4, 2021 Kloudspro

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

Continue reading

About the author

Top Posts

  • How to Check if Power BI Report is in Import Mode or Direct Query Mode
  • How to Increment a Variable in ADF (Azure Data Factory)
  • Converting base64 Encoding to String format in SQL
  • Kusto Query Language (KQL) Cheatsheet
  • How to Connect Power BI Dataset in SSMS

Recent Posts

  • Extracting zip code from an open text address field using T-SQL May 14, 2022
  • Azure Synapse Provisioning Issue in Southeast Asia Region: Not Accepting Creation of New Windows Azure SQL Database Servers at this Time April 27, 2022
  • Did You Know…Tumbling Window in Azure Stream Analytics is Nothing But A Hopping Window February 28, 2022
  • Integrate Tabular Editor (Free Version) in Power BI as External Tools in 2 Minutes December 17, 2021
  • Artificial Intelligence (AI) Features in Power BI November 17, 2021

Archives

  • May 2022 (1)
  • April 2022 (1)
  • February 2022 (1)
  • December 2021 (1)
  • November 2021 (1)
  • October 2021 (1)
  • September 2021 (4)
  • August 2021 (5)
  • July 2021 (10)
  • June 2021 (7)
  • May 2021 (2)
  • April 2021 (1)
  • March 2021 (7)
  • February 2021 (7)
  • January 2021 (6)
  • December 2020 (10)
  • November 2020 (7)
  • October 2020 (15)
  • September 2020 (8)
  • August 2020 (8)
  • July 2020 (3)
  • June 2020 (21)

Subscribe

Enter your email address to follow this blog and receive notifications of new posts by email.

 

Loading Comments...