In this post, we are going to see how to establish a connection to Azure SQL Server Database from within Azure Databricks Notebooks. We will
Assuming that you have created Azure Key Vault scope in Azure Databricks and created some secrets in the vault, you can use the below commands
Databricks CLI is a command line interface to Databricks platform. This is built on top of databricks REST APIs. Its commands are organized into different
You can use %run command to run another notebook in your current notebook. In fact, it includes or concatenates another notebook in your notebook. This
More significant for Azure SQL Database to determine who all are connected from which IP address and how many connections sys.dm_exec_sessions and sys.dm_exec_connections
This is similar to what we saw in SQL Script to Check Most Executed Queries in a SQL Server Database post with the difference that
sys.dm_exec_query_stats sys.dm_exec_sql_text to fetch the exact query sys.dm_exec_query_plan to fetch the query plan And again Thanks to Glenn Berry for sharing the script.
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
sys.partitions and sys.objects Consider ONLY Heap or Clustered Index that gives you the count Thanks to Glenn Berry for sharing the script.
When was the last time statstics were updated for a particular index You can filter it as per you needs to run it faster or
This may take some time to get executed if the database size is large You may filter it for some specific cases to run it
SQL Server 2019 introduced a new database engine feature called Accelerated Database Recovery. The primary purpose it serves is the faster database recovery be it
A quick summary of SQL Server compatability levles since its inception –
Recently, I came to know that Microsoft introduced completely a new module called “Az” to interact with Azure through PowerShell. We have been using AzureRM
We have been several times in to the scenario where we wish if we could retrieve the values from a column as a comma separated