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 and 20+ online databases, I needed an efficient solution to…
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 the SQL Server database? We will use different SQL Queries…
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 also we can use GUI to find the same. Both…
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 use the WHERE CLAUSE. Script — ============================ — Owner: SOYELUDDIN…
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 role to a SQL login when the database is in…
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 into T-SQL and explore how to retrieve essential details about…
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 query. Run the script to get the SQL Server database…
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 settings to ensure optimal performance and prevent storage-related issues. In…
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 blog post, we will explore an automated solution using T-SQL…
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 out Drive Space for SQL server with Drive Space, Free…