2 min read
1
TSQL to find index fragmentation in SQL Server
To determine index fragmentation in SQL Server, you can use…
Category: MSSQL
3 min read
0
13 min read
0
6 min read
0
List all Login, User & DB Role in SQL Server
Description This script generates a list of Logins, Users and…
3 min read
0
How to check database encryption in sql server
Introduction Data security is a critical aspect of database management,…
1 min read
0
4 min read
0
Check SQL Server Version & license details
As a SQL Server DBA, I would rephrase the statement…
4 min read
1
SQL Server DBA Roles and Responsibilities
Are you interested in the world of database management? Do…
7 min read
0
Identify and Store Active Transactions
Scenario How to Identify and Store Currently Running Queries in…
4 min read
0
Backup TDE protected database on Azure Managed Instance
We can take a COPY_ONLY backup of a TDE protected…