Find Stored Procedures related to Table in SQL Server
This guide will help you find SP related to table in the SQL Server database or Azure SQL database using client tools like SSMS.
This guide will help you find SP related to table in the SQL Server database or Azure SQL database using client tools like SSMS.
A deadlock occurs when two or more processes or transactions block each other from continuing because each has locked a database resource that the other transaction needs. This article describes how to find deadlock in SQL Server database.
The server principal is not able to access the database “master” under the current security context.
This article describes how to Grant Access to Azure SQL Database for SQL Server users, Azure AD user, and managed identity.
DACPAC file is essential when migrating your on-premise SQL Server database to Azure. This is because Azure SQL database does not support regular SQL Server backups (.bak) files for restorations and requires a separate type of backup file called BAKPAC – Data-Tier Application Export (.bacpac file). Moreover, to create a BACPAC file, you must first create a DACPAC file to ensure that your database is ready for a BACPAC export. This article will show how to take a DACPAC extract of an on-premise SQL Server database.
Azure Data Factory is a Microsoft cloud ETL service for serverless data integrations and orchestrations. It supports a lot of source and target connectors including Azure SQL database. I will describe how to connect to Azure SQL from data factory using Managed Identity.
Error AADSTS900021: Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid. Tenant identifiers may not be an empty GUID Azure SQL Connection.
Azure Data Studio is an open-source data management tool that enables working with SQL Server, Azure SQL DB, and Azure Synapse from Windows, macOS, and Linux. It is a one-stop shop to query, design, and manage your databases and data warehouses, on-premise or in the cloud. In this article, we will see 5 most interesting features of Azure Data Studio for SQL developers.
This article describes how to get local time zone date in Azure SQL database using an user defined scaler function and AT TiME ZONE.
Automate Azure SQL Database index and statistics maintenance tasks using the Azure Elastic Job agent.