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 Mohammad Gufran Jahangir
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 User Step 1: Create User in Azure SQL Database You…
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 that records all changes made to the database. It’s a…
What is SQL Server Statistics and how to Collect/Update Statistics in SQL Server Database.
In Azure SQL Server, statistics are database objects that contain information about the distribution of data in one or more columns of a table or indexed view. These statistics provide…
Query session status runnable, sleeping, suspended, running and background meanings in SQL server Database
In SQL Server, when you query the session status, you can encounter various states that provide information about what a session is currently doing. Here are some common session statuses…
Troubleshooting Connectivity issues & Timeout error [258]. Unable to complete login process due to delay in prelogin response/ Pre-Login Handshake Failed
If trying to connect Azure SQL Server database and getting below Error: Error Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Timeout error [258]. . Error: Microsoft…
How to Create User login and User in Azure SQL server using SQL Server Management Studio(SSMS)
To Create User login and User in Azure SQL server using SQL Server Management Studio(SSMS) Step 1 : Create user logon from master database where ‘abc’ is login name Step…
What is fragmentation in Azure SQL Server? How to check fragmentation for table? How to rebuilt table to reduce fragmentation?
What is fragmentation in Azure SQL server? Fragmentation in Azure SQL Server, or any SQL Server, refers to the condition where the data pages of a database or index are…