SQL Server - How to identify all missing indexes in a database April 8, 2022 8 min read Continue reading
SQL Server - Useful Day-to-Day DBA Queries You Always Have to Search for Online July 15, 2019 73 min read Continue reading
SQL Server - How to identify and change the default schema of database users January 26, 2019 10 min read Continue reading
SQL Server - How to identify instance startup parameters using T-SQL January 11, 2019 3 min read Continue reading
SQL Server - How to identify the data type of columns and parameters of tables, views, stored procedures, and functions December 29, 2018 5 min read Continue reading
SQL Server - How to identify a slow or "heavy" query in your database July 8, 2018 26 min read Continue reading
SQL Server - How to View the Full Job Execution Return Message Even When It Exceeds 4000 Characters May 2, 2018 3 min read Continue reading
SQL Server - How to document the database and its objects (tables, procedures, columns) using Extended Property October 29, 2017 24 min read Continue reading
SQL Server - How to create an email alert for locks and blocked sessions in the instance using DMV's October 17, 2017 8 min read Continue reading
SQL Server - How to create error and exception monitoring in your database using Extended Events (XE) October 15, 2017 9 min read Continue reading
SQL Server - Query to Return Active Sessions with sp_WhoIsActive Without Consuming TempDB July 25, 2017 13 min read Continue reading
SQL Server - How to identify and monitor total, free, and used disk space by database datafiles March 5, 2017 8 min read Continue reading
SQL Server - How to copy/replicate a user's permissions February 19, 2017 11 min read Continue reading
SQL Server - How to find out when the instance was installed (installation date) January 29, 2017 1 min read Continue reading
SQL Server - Querying Instance Information from Windows Registry Using sys.dm_server_registry and xp_instance_regread April 23, 2016 3 min read Continue reading
How to find the last access date of a table or view and the last execution of a stored procedure in SQL Server April 2, 2016 3 min read Continue reading
How to List Jobs (schedules, commands, steps) via Query in SQL Server March 28, 2016 5 min read Continue reading
How to identify, delete and recreate Foreign Keys (FK) of a table in SQL Server October 6, 2015 2 min read Continue reading
Checking Permissions, Privileges and Accesses of a Database User in SQL Server September 7, 2015 21 min read Continue reading
How to Identify Inactive Sessions with Open Transactions in SQL Server August 22, 2015 2 min read Continue reading
How to convert the run_date and run_time columns from job_history to datetime in SQL Server May 7, 2015 2 min read Continue reading
How to estimate the remaining time for a backup in SQL Server May 6, 2015 1 min read Continue reading