3 min read
0
Author: OTI
Welcome to OurTechIdeas.com, your go-to destination for SQL Server DBA-related tech insights. We are a dedicated team of experts passionate about sharing our knowledge and expertise with the community. Join us as we explore the world of SQL Server, offering valuable tips, tutorials, and innovative solutions.
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…
2 min read
0