page.title.tag — Dirceu Resende

Analysis Services - How to monitor the progress of cube processing by SQL Server

August 14, 2023 24 min read

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

SQL Server - How to Find the Last Login Date of a User

November 9, 2020 9 min read

SQL Server - How to identify a slow or "heavy" query in your database

July 8, 2018 26 min read

SQL Server - How to find how long the instance has been online or when it was started

May 9, 2018 6 min read

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

SQL Server - How to create error and exception monitoring in your database using Extended Events (XE)

October 15, 2017 9 min read

SQL Server - How to generate deadlock history monitoring for routine failure analysis

September 30, 2017 12 min read

SQL Server - How to read and write events in Windows Event Viewer using CLR (C#)

September 2, 2017 5 min read

SQL Server - Query to Return Active Sessions with sp_WhoIsActive Without Consuming TempDB

July 25, 2017 13 min read

SQL Server - How to identify and monitor disks, total, free, and used disk space

February 26, 2017 10 min read

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

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

SQL Server - How to find out when the instance was installed (installation date)

January 29, 2017 1 min read

SQL Server - How to identify weak, empty, or user-name passwords

November 24, 2016 4 min read

SQL Server - Session Running for a Long Time with the SpreadRequest / DatabaseMail Command

October 31, 2016 3 min read

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

SQL Server - How to list and kill Windows processes using CLR (C#)

September 11, 2016 5 min read

SQL Server - How to audit permission errors on objects using SQL Profiler (Trace)

September 10, 2016 5 min read

SQL Server - How to stop, start, and list Windows services remotely

August 7, 2016 8 min read

SQL Server - How to Check if a Server is Responding Using Ping and CLR (C#)

August 6, 2016 1 min read

SQL Server - How to create a data change history for your tables (audit logs)

July 17, 2016 7 min read

SQL Server - Using sp_WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries and Much More

June 26, 2016 15 min read

Monitoring DDL and DCL operations using SQL Server fn_trace_gettable

April 4, 2016 3 min read

Monitoring automatic space growth (Autogrowth) events in SQL Server databases

April 4, 2016 2 min read

How to identify running jobs via Query in SQL Server

August 22, 2015 6 min read

SQL Server - How to Implement Login Audit and Control (Logon Trigger)

July 19, 2015 9 min read

How to create an audit trigger to log object manipulation in SQL Server

July 18, 2015 6 min read

How to create an audit to monitor the creation, modification and deletion of Jobs in SQL Server

June 5, 2015 4 min read

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