2 min read
0
Move SQL Server database files to another location
Issue If any drive is full due to the large database data file (LDF or MDF) size! How to moving…
Category: MSSQL
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 uncommon to encounter situations where important data mysteriously disappears from…
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 used TSQL queries for DBAs, how to use them effectively,…
1 min read
0
About SQL Server Versions
Introduction I always very much confused about SQL Server Versions. To check the SQL Server version by TSQL we may…
14 min read
1
SQL Server DBA Frequently Asked Questions
What is RDBMS? Relational Database Management Systems (RDBMS) are database management systems that maintain data records and indices in tables.…
5 min read
1
Monitoring and Analyzing SQL Server Sessions with T-SQL
Introduction SQL Server is a powerful relational database management system used by organizations to store and manage their data. As…
2 min read
0
Create User Defined db_executor database role
Fixed database roles in SQL Server include db_datareader, db_datawriter and other. These roles grant users read and write access to…
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) sp_helpdb2) select db_id('DBName')3) select db_name(DBID)4) select * from sys.dm_exec_sessions, dm_exec_connections5)…
6 min read
0
SQL Server Log shipping
What is LOG SHIPPING in SQL Server DBA? Log shipping: Shipping of transaction log files from the primary server database…