3 min read
0
How to Configure MSSQL Backup Compression as the Default Option
Introduction In Microsoft SQL Server, backup compression is a powerful…
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.
3 min read
2
Find blocking by T-SQL Queries
Blocking is an unavoidable and by-design characteristic of any relational…
2 min read
2
1 min read
2
Provide a SQL Login ALTER TRACE permission
Provide a SQL Login ALTER TRACE permission One SQL login…
4 min read
1
Extended Security Updates for SQL 2008
How to get SQL Extended Security Updates for SQL 2008/2008…
3 min read
0
Change ‘TempDB’ file location in SQL Server
Introduction The TempDB database is essential to SQL Server’s management…
3 min read
1
Determine or Estimated time (ETA) of Backup & Restoration
As a DBA you may face a few common questions…
4 min read
2
4 min read
0
8 min read
0
Find Server Information by TSQL script
Display all Server Information by using TSQL script The below…