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…
Category: MSSQL
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:…
3 min read
2
SQL Server Upgradation
What is SQL Server UPGRADATION? Upgrading means, migrating sql server…