Archive for September 2019

Introduction As a Database Administrator (DBA), my recent task involved listing all the jobs running in a production SQL Server environment, along with their respective databases. With over 200+ jobs…

Introduction In this article, we will try to pull all sizes from SQL server. How to find Database Size in SQL Server? How to Get size of all tables in…

Introduction: When your SQL instance was last restarted? I understand it is very simple script but we often forget  simple scripts. Hence I thought to write this simple script and…

Introduction This script will help you to get the restore history for all the databases. If you need to know the restore history only for a single database then please…

Scenario How to provide ‘db_dataread’ database role to a SQL login when the database is in AlwaysOn & secondary node DB is in readonly mode? Introduction To provide ‘db_dataread’ database…

Introduction In the world of database management, having a clear understanding of the file information is crucial for optimizing performance and storage. In this technical blog post, we will dive…

Introduction Very often DBAs need to find the location of the physical file (MDF, LDF & NDF) of a database. Simply we can obtain the output by executing the below…

Introduction Managing the growth of database files is an essential aspect of maintaining a healthy SQL Server environment. As databases grow over time, it becomes crucial to configure appropriate growth…

Introduction Managing database sizes is a crucial task for database administrators. Monitoring database growth and tracking size changes over time are essential for capacity planning and performance optimization. In this…

Introduction xp_fixeddrives only provide how much disk space is free on each drive but not the maximum space of the drive & percentage of free space. If you need to find…