4 min read
8
Find disk space using Stored procedure or TSQL
Introduction xp_fixeddrives only provide how much disk space is free on each drive but not the maximum space of the…
Flash Blogs
Banner Posts
4 min read
0
Everything was fine yesterday—now it’s super slow!
SQL Server DBA Troubleshooting Guide: Why Are Queries Suddenly Crawling? If you manage SQL Server databases, you’ve heard the panic:“Everything was fine yesterday—now it’s super…
Latest Posts
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 ‘JOB’ in a production SQL Server. But the task was…
3 min read
0
Increase the number of ErrorLog in SQL
If something goes wrong on the SQL database server, the error log is the first place we look for information.…
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…
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…