3 min read
0
List of jobs associated with database in SQL Server
Introduction As a Database Administrator (DBA), my recent task involved…
Flash Blogs
Latest Posts
3 min read
1
1 min read
0
SQL Instance Last restart date and time in SQL Server
Introduction: When your SQL instance was last restarted? I understand…
2 min read
2
Database restore history in SQL Server
Introduction This script will help you to get the restore…
4 min read
2
How to create database user on secondary node if DB is in readonly mode in SQL Server?
Scenario How to provide ‘db_dataread’ database role to a SQL…
3 min read
0
Exploring Database File Information with T-SQL
Introduction In the world of database management, having a clear…
3 min read
0
Find Physical file location for all the databases in SQL Server
Introduction Very often DBAs need to find the location of…
2 min read
0
Set Auto growth for all the databases wit T-SQL
Introduction Managing the growth of database files is an essential…
3 min read
2
Find database growth size and store in a table in SQL Server
Introduction Managing database sizes is a crucial task for database…
4 min read
8
Find disk space using Stored procedure or TSQL
Introduction xp_fixeddrives only provide how much disk space is free…