6 min read
0
List all Login, User & DB Role in SQL Server
Description This script generates a list of Logins, Users and…
Flash Blogs
Latest Posts
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…
2 min read
0
3 min read
0
Shrinking TempDB in SQL Server: A Step-by-Step Guide
Introduction In SQL Server, TempDB is a system database used…
2 min read
0
How to change SQL Server instance name
Scenario Troubleshooting host name changes. When the machine name is…