Our Tech Ideas | Great minds discuss ideas!
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…
Read FullIntroduction 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…
Read FullIntroduction: 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…
Read FullIntroduction 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…
Read FullScenario 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…
Read FullIntroduction 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…
Read FullIntroduction 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…
Read FullIntroduction 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…
Read FullIntroduction 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…
Read FullIntroduction 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…
Read Full
