Analysis Services - How to monitor the progress of cube processing by SQL Server August 14, 2023 24 min read Continue reading
PowerAlerts - The best SQL Server alerting and monitoring system you have ever seen! March 22, 2023 9 min read Continue reading
SQL Server and Azure SQL Database - How to Return CPU and Memory Usage Using T-SQL May 3, 2022 4 min read Continue reading
SQL Server - How to identify the query that fired a DML trigger on a table May 2, 2022 6 min read Continue reading
SQL Server - How to list the largest tables and indexes in the database and show the size of each October 1, 2021 5 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 integrate the database with Slack and send messages using Python and sp_execute_external_script July 15, 2018 8 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 find how long the instance has been online or when it was started May 9, 2018 6 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 - How to identify and collect information from slow queries using Trace (SQL Server Profiler) September 30, 2017 5 min read Continue reading
SQL Server - How to generate deadlock history monitoring for routine failure analysis September 30, 2017 12 min read Continue reading
SQL Server - How to read and write events in Windows Event Viewer using CLR (C#) September 2, 2017 5 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 identify and monitor disks, total, free, and used disk space February 26, 2017 10 min read Continue reading
SQL Server - How to identify, monitor, and prevent overflow in IDENTITY and SEQUENCE columns of tables with many rows February 8, 2017 6 min read Continue reading
SQL Server - How to integrate the database with Telegram and send messages using CLR (C#) February 5, 2017 8 min read Continue reading
SQL Server - How to integrate the database with Slack and send messages using CLR (C#) February 4, 2017 9 min read Continue reading
SQL Server - How to integrate the database with Ryver and send messages using CLR (C#) February 4, 2017 5 min read Continue reading
SQL Server - How to send SMS Torpedoes using the CLR (C#) and the Mais Resultado API (PG Soluções) February 4, 2017 7 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 - How to identify weak, empty, or user-name passwords November 24, 2016 4 min read Continue reading
SQL Server - Session Running for a Long Time with the SpreadRequest / DatabaseMail Command October 31, 2016 3 min read Continue reading
How to use the Pushbullet API to send SMS messages in C#, PHP, Java or through SQL Server (with CLR) September 11, 2016 9 min read Continue reading
SQL Server - How to list and kill Windows processes using CLR (C#) September 11, 2016 5 min read Continue reading
SQL Server - How to audit permission errors on objects using SQL Profiler (Trace) September 10, 2016 5 min read Continue reading
SQL Server - How to stop, start, and list Windows services remotely August 7, 2016 8 min read Continue reading
SQL Server - How to Check if a Server is Responding Using Ping and CLR (C#) August 6, 2016 1 min read Continue reading
SQL Server - How to create a data change history for your tables (audit logs) July 17, 2016 7 min read Continue reading
SQL Server - Using sp_WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries and Much More June 26, 2016 15 min read Continue reading
SQL Server - How to Implement Login Audit and Control (Logon Trigger) July 19, 2015 9 min read Continue reading
How to create an audit trigger to log object manipulation in SQL Server July 18, 2015 6 min read Continue reading
How to create an audit to monitor the creation, modification and deletion of Jobs in SQL Server June 5, 2015 4 min read Continue reading
SQL Server - How to enable and configure Database Mail to send and monitor emails through the database (sp_send_dbmail) March 19, 2015 12 min read Continue reading