2 min read
0
Move SQL Server database files to another location
Issue If any drive is full due to the large…
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
0
Find the user who executed DELETE on tables in SQL Server
Introduction In the world of SQL Server administration, it’s not…
15 min read
18
TSQL Queries Used by SQL DBA in day to day
In this article, we’ll explore some of the most commonly…
1 min read
0
14 min read
1
SQL Server DBA Frequently Asked Questions
What is RDBMS? Relational Database Management Systems (RDBMS) are database…
5 min read
1
Monitoring and Analyzing SQL Server Sessions with T-SQL
Introduction SQL Server is a powerful relational database management system…
2 min read
0
Create User Defined db_executor database role
Fixed database roles in SQL Server include db_datareader, db_datawriter and…
1 min read
0
SQL DBA Regular Alerts & Tickets (Service Request and Incident)
Customer Raised Tickets Monitoring Tool/Alerts Raised
1 min read
0
Important & Handy TSQL Commands
Space Management TSQL Commands 1)sp_spaceused2)dbcc sqlperf(logspace)3)xp_fixeddrives Information TSQL Commands 1)…
6 min read
0
SQL Server Log shipping
What is LOG SHIPPING in SQL Server DBA? Log shipping:…