Month: September 2019
List of jobs associated with database in SQL Server
Introduction As a DBA I was asked to list out all job…
All about database size, file size & table size in SQL Server
Introduction In this article, we will try to pull all sizes from…
SQL Instance Last restart date and time in SQL Server
Introduction: When your SQL instance was last restarted? I understand it is…
Database restore history in SQL Server
Introduction This script will help you to get the restore history for…
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 login when…
Databases sizes in Bytes, MBs & GBs in SQL Server
Introduction Get all SQL Server databases sizes in Bytes, MBs & GBs….
Physical file location for all the databases in SQL Server
Introduction Very often DBAs need to find the location of the physical…
Set Auto growth for all the databases in SQL Server
Introduction Below script will give the command to execute to change the…
Calculate database size ‘Growth Rates’ on daily basis in SQL Server
Introduction To calculate database size ‘Growth Rates‘ on a daily basis in…
Find the Drive Space,free and percentage Using T-SQL in SQL Server
Introduction xp_fixeddrives only provide how much disk space is free on each…
Find text in Stored Procedures & then find JOB associate with Stored Procedure in SQL Server
Introduction Few days before I was asked to disable some ‘JOB’ in…
Increase the number of ErrorLog in SQL
Increase the number of ErrorLog in SQL Server If anything goes wrong…
Move SQL Server database files to another location
Issue If any drive is full due to the large database data…
Find the user who executed DELETE on tables
Find the user who executed DELETE on tables in SQL Server To…
TSQL Queries Used by SQL DBA in day to day
Some TSQL queries used by SQL DBA in day to day activities…
About SQL Server Versions
Introduction I always very much confused about SQL Server Versions. To check…
Step By Step Installation Of Microsoft SQL Server 2017
Introduction Install Microsoft SQL Server Express for free. You can install and…
MSSQL Frequently Asked Questions in SQL Server | FAQ
What is RDBMS? Relational Database Management Systems (RDBMS) are database management systems…