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: October 2020

How to Check SQL Server Installation Date

October 29, 2020 Kloudspro

Ever tried to determine when the SQL Server instance was installed? You can execute the following query and see the create_date column in the result

Continue reading

ARM Client to Deal With ARM APIs

October 28, 2020 Kloudspro

ARMClient is a command line tool to interact with ARM APIs. In one of our previous posts we discovered that data retention period for Azure

Continue reading

Default Apache Spark Variables in Azure Databricks Notebook

October 26, 2020 Kloudspro

I came across some python code in one of my notebooks and realized that a variable called “sc” was referenced there which was not defined

Continue reading

Kusto Query Language (KQL) Cheatsheet

October 25, 2020 Kloudspro

Case-Sensitive Query starts with table name or search keywords usually in lowercase | symbol to separate commands in the query SecurityEvent | take 10 can

Continue reading

How to Ensure Singleton Execution of ADF Pipeline

October 24, 2020 Kloudspro

Many times we don’t think about it but in order to ensure the integrity and stability of our systems and data we pay attention to

Continue reading

Running ADF Pipelines Sequentially

October 24, 2020 Kloudspro

Getting worried about that even after placing Execute Pipeline activities one after the another, sequence is still not followed? Dependency in terms of execution is

Continue reading

Azure Log Analytics Pricing and Data Retention Period

October 23, 2020 Kloudspro

Few topics don’t need any briefing so let’s directly jump to the costing factors involved with Azure Log Analytics Workspace. You are charged for two

Continue reading

How to Get Path of Current Notebook

October 22, 2020 Kloudspro

In an earlier post, we saw how to get the absolute path of a notebook in Azure Databricks by navigating GUI in the workspace. In

Continue reading

Automatic Tuning – Azure SQL Database & Managed Instance

October 20, 2020 Kloudspro

Azure SQL Database and Azure SQL Managed Instance both are Azure’s PaaS implementations whereby Microsoft takes care of all management tasks of underlying systems. Automatic

Continue reading

A Practical Guide to Failover Groups

October 15, 2020 Kloudspro

Note: Practical guide here doesn’t mean a step-by-step approach to setup the service/feature but to mention the important points which are critical to understand for

Continue reading

A Practical Guide to Active Geo Replication

October 13, 2020 Kloudspro

Active Geo Replication is a database-level feature specific to Azure SQL Databases. It creates a secondary replica of your primary database which can be used

Continue reading

Query Store Catalog Views

October 12, 2020 Kloudspro

In the previous post we saw number of queries to analyze data captured by Query Store. In this post, we will present the data model

Continue reading

Query Store Sample Queries

October 12, 2020 Kloudspro

We have seen so far in the previous posts about the key concepts of Query Store and its configuration. Let’s now look at the queries

Continue reading

Query Store Configuration and its Parameters

October 12, 2020 Kloudspro

In the previous post we learnt about some basic concepts of SQL Server query store and some of the usage scenarios. In this post we

Continue reading

SQL Server Query Store – 4 part series

October 11, 2020 Kloudspro

SQL Server’s Query Store is generally considered as its flight recorder i.e. that black box which records everything about each query you execute on SQL

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...