1 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.
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…
3 min read
0
6 min read
0
How To Check Free Space in Data and Log Files in SQL Server
In a database, data and log files are used to…