1 min read 0 MSSQL SQL Instance Last restart date and time in SQL Server Soyeluddin Biswas 29 September 2019 Introduction: When your SQL instance was last restarted? I understand it is very simple script but we often forget simple…
2 min read 2 MSSQL Database restore history in SQL Server Soyeluddin Biswas 27 September 2019 Introduction This script will help you to get the restore history for all the databases. If you need to know…
4 min read 2 MSSQL How to create database user on secondary node if DB is in readonly mode in SQL Server? OTI 27 September 2019 Scenario How to provide ‘db_dataread’ database role to a SQL login when the database is in AlwaysOn & secondary node…
3 min read 0 MSSQL Exploring Database File Information with T-SQL OTI 25 September 2019 Introduction In the world of database management, having a clear understanding of the file information is crucial for optimizing performance…
3 min read 0 MSSQL Find Physical file location for all the databases in SQL Server Soyeluddin Biswas 25 September 2019 Introduction Very often DBAs need to find the location of the physical file (MDF, LDF & NDF) of a database.…
2 min read 0 MSSQL Set Auto growth for all the databases wit T-SQL Soyeluddin Biswas 24 September 2019 Introduction Managing the growth of database files is an essential aspect of maintaining a healthy SQL Server environment. As databases…
3 min read 2 MSSQL Find database growth size and store in a table in SQL Server OTI 24 September 2019 Introduction Managing database sizes is a crucial task for database administrators. Monitoring database growth and tracking size changes over time…
4 min read 8 MSSQL Find disk space using Stored procedure or TSQL OTI 24 September 2019 Introduction xp_fixeddrives only provide how much disk space is free on each drive but not the maximum space of the…
3 min read 0 MSSQL Find text in Stored Procedures & then find JOB associate with Stored Procedure OTI 23 September 2019 Introduction Few days before I was asked to disable some ‘JOB’ in a production SQL Server. But the task was…
3 min read 0 MSSQL Increase the number of ErrorLog in SQL OTI 21 September 2019 If something goes wrong on the SQL database server, the error log is the first place we look for information.…