AZURE SQL SERVER
-
Login Timeout issue when trying to connect Azure SQL database from on-premises Microservice GG system
The error message you are encountering is a login timeout issue when trying to connect to the EDH_DEV database using…
-
How To check the time zone in Azure SQL Server
In Azure SQL Server, the time zone is generally set to UTC (Coordinated Universal Time), and it cannot be changed…
-
Azure SQL Server Database Administration Role Interview Question and Answer
Here is a list of Azure SQL Server Database administration interview questions and answers, organized from basic to advanced levels:…
-
Azure SQL Server Database Interview Question and Answer
Here is a list of Azure SQL Server Database interview questions and answers, organized from basic to advanced levels: Basic…
-
How to provide permission for SHOWPLAN to access the execution plan in Azure SQL Server DB
o provide permission for SHOWPLAN access in an Azure SQL Database, you’ll need to follow these steps. SHOWPLAN allows users…
-
Query to check Statistics of tables in an Azure SQL Server database
To include the schema in the query to check statistics on a table in Azure SQL Server, you can modify…
-
Best Practice of Stored procedures using Synapse SQL in Azure Synapse Analytics?
Here are best practices for using stored procedures with Synapse SQL in Azure Synapse Analytics, explained with examples: 1. Encapsulation…
-
External tables supported in Azure Synapse Analytics
An overview of the external table types supported in Azure Synapse Analytics Hadoop-Based External Tables: Native External Tables (Preview): Key…
-
External tables using SQL pools in Azure Synapse Analytics
Here’s a guide on using external tables with SQL pools in Azure Synapse Analytics 1. Create an External Data Source:…
-
Different ways to limit access for the users on different schemas in Azure synapse Analytics
1. User-Defined Schemas: 2. Row-Level Security (RLS): 3. Server-Level Roles: 4. Credentials and External Users: 5. Dynamic Data Masking (DDM):…
-
How to Create or edit a log alert rule from Azure Monitor
Accessing the alert rule wizard in the Azure portal There are several ways that you can create a new alert…
-
What is Kusto Query Language (KQL) and How to Use KQL to Query Audit Log
Kusto Query Language (KQL) is used to write queries in Azure Data Explorer, Azure Monitor Log Analytics, Azure Sentinel, and…
-
Azure SQL Database audit log format
Azure SQL Database auditing tracks database events and writes them to an audit log in your Azure storage account, or…
-
What is Difference between Azure activity ,Azure diagnostics and Azure metrics logs
Here’s a comprehensive explanation of the differences between Azure Activity Log, Azure Diagnostics Logs, and Azure Metrics for Azure SQL…
-
What is Diagnostic settings in Azure Monitor?
This Blog will give information about creating and configuring diagnostic settings to send Azure platform metrics and logs to different…
-
How to Use Auditing to analyze audit logs and reports
Analyzing audit logs using Auditing for Azure SQL Database and Azure Synapse Analytics. You can use Auditing to analyze audit logs…
-
Different ways to Auditing Azure SQL Database and Azure Synapse Analytics
The default auditing policy includes the following set of action groups, which audits all the queries and stored procedures executed…
-
Query to get list of Schema and table name in Azure SQL database
The query below lists all tables in an Azure SQL Database. Columns Rows Sample results
-
Direct access and access through Azure Active Directory (AD) groups – Azure SQL Database
Direct Access to User Access Through AD Group Comparison Considerations Step by Step Explanation with Example Granting Direct Access to…
-
How to Get SQL Server database transaction log usage?
What is transaction log in SQL Server? In SQL Server, the transaction log is a crucial component of the database…
Follow Us
Recent Posts
- Azure Data Lake Storage Gen2 (ADLS Gen2), with a specific message stating that the lease is not present
- Login Timeout issue when trying to connect Azure SQL database from on-premises Microservice GG system
- How To check the time zone in Azure SQL Server
- How to check Azure SQL failed connections?
- Common Integration Runtime (IR) registration errors
Categories
- Amperity 1
- Ansible 15
- Ataccama 1
- AWS 3
- Azure 82
- Azure Databricks 24
- Azure DevOps 7
- Azure Fundamental 12
- AZURE SQL SERVER 25
- Azure Synapse Analytics 18
- bash scripting 1
- CloudOps 9
- CrowdStrike 1
- Docker 3
- Git and GutHub 15
- Google BigQuery 1
- Linux 12
- Microsoft Fabric 20
- Oracle GoldenGate 1
- php 4
- powershell 1
- Python 21
- SFTP Server 1
- SRE 1
- terraform 20
- ubuntu 2
- Uncategorized 48
- virtual machine 1
Tags
Ansible interview questions that are commonly asked in interviews Ansible Variables Apache Spark Azure Azure Databricks Azure SQL Server Database Interview Question and Answer Condition module executations in Ansible Playbook Connectivity issues & Timeout error [258] Different ways to Auditing Azure SQL Database and Azure Synapse Analytics Examples for Terraform Variables Exploring Regions and Availability Zones in Azure Getting Error on running- sudo add-apt-repository ppa:ondrej/php Git and GitHub – What is Git Bash (Part -2) How do you create a CloudOps strategy that aligns with business objectives? How to install php.x.x-gd and php.x.x-sodium manually in ubuntu if Composer update failed How to push/pull and clone files between Local machine and GitHub How to start with Git How to Use Auditing to analyze audit logs and reports lakehouse Main Tasks of an SRE (Site Reliability Engineer) Management Group and Subscription Microsoft Fabric OneLake shortcuts in Microsoft Fabric Stash Syllabus for learning Databricks Unity Catalog from beginner to advanced levels Terraform Provisioner Troubleshooting an application in Linux Types of branch What is SQL Server Statistics and how to Collect/Update Statistics in SQL Server Database What tools and technologies are essential for effective CloudOps?