4 min read
8
Find disk space using Stored procedure or TSQL
Introduction xp_fixeddrives only provide how much disk space is free…
Category: MSSQL
3 min read
0
Find text in Stored Procedures & then find JOB associate with Stored Procedure
Introduction Few days before I was asked to disable some…
3 min read
0
Increase the number of ErrorLog in SQL
If something goes wrong on the SQL database server, the…
2 min read
0
Move SQL Server database files to another location
Issue If any drive is full due to the large…
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
About SQL Server Versions
Introduction I always very much confused about SQL Server Versions.…
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…