page.title.tag — Dirceu Resende

SQL Server - Change Tracking vs CDC: When and how to implement lightweight data tracking

December 31, 2025 15 min read

SQL Server - How to identify and compress tables and indexes without data compression

August 24, 2023 8 min read

SQL Server - How to create login auditing using instance logs

August 15, 2023 4 min read

SQL Server and Azure SQL - Challenge for Grouping Data Using Hierarchies

August 11, 2023 4 min read

PowerAlerts - The best SQL Server alerting and monitoring system you have ever seen!

March 22, 2023 9 min read

SQL Server and Azure SQL Database - How to Return CPU and Memory Usage Using T-SQL

May 3, 2022 4 min read

SQL Server - How to identify the query that fired a DML trigger on a table

May 2, 2022 6 min read

SQL Server - How to identify and monitor trigger execution

May 2, 2022 7 min read

SQL Server - Beware of the SecurityAdmin Server Role: Using Privilege Escalation to Become Sysadmin

April 18, 2022 5 min read

SQL Server - How to identify the closest store to the customer (or the distance between 2 locations) from the ZIP code (without API)

June 15, 2021 28 min read

SQL Server - Encrypting Passwords with Symmetric Encryption Functions: EncryptByPassPhrase and DecryptByPassPhrase

December 26, 2019 13 min read

SQL Server - charindexada: A different function to split delimited strings

November 3, 2019 4 min read

SQL Server - Useful Day-to-Day DBA Queries You Always Have to Search for Online

July 15, 2019 73 min read

SQL Server - Security Checklist - A stored procedure with more than 70 security items to validate your database

May 12, 2019 4 min read

SQL Server - Understanding the Risks of the TRUSTWORTHY Property Enabled in a Database

February 24, 2019 7 min read

SQL Server - How to avoid SQL Injection? Stop using Dynamic Query with EXEC(@Query). Now.

February 24, 2019 16 min read

SQL Server - How to identify and collect information from slow queries using Extended Events (XE)

February 19, 2019 11 min read

SQL Server - How to avoid and protect yourself from Ransomware attacks, like WannaCry, on your database server

February 12, 2019 10 min read

What changed in SQL Server 2012 regarding T-SQL - from the developers perspective

December 29, 2018 19 min read

SQL Server - How to identify the queries that use a specific index through the plan cache

December 9, 2018 5 min read

SQL Server + AD Authentication - Kerberos + NTLM = Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

December 1, 2018 4 min read

SQL Server 2016 - How to encrypt your data using Always Encrypted

October 20, 2018 12 min read

SQL Server and Power BI - How to Analyze and Generate Statistics from WhatsApp Group Conversations

August 18, 2018 18 min read

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

SQL Server Express and Developer - How Far Can We Go with the Free Versions of SQL Server?

June 2, 2018 7 min read

SQL Server - How to identify the version and edition of all server instances using xp_regread and PowerShell

March 4, 2018 10 min read

SQL Server 2016 - How to "travel through time" using Temporal Tables

February 9, 2018 8 min read

SQL Server - How to create recursive queries with CTE (Common Table Expressions)

January 9, 2018 8 min read

SQL Server - How to identify and collect information from slow queries using Trace (SQL Server Profiler)

September 30, 2017 5 min read

SQL Server - How to identify occurrences of a specific character in a string or table

August 15, 2017 6 min read

SQL Server - How to convert an RTF string to text (Remove RTF tags) using CLR (C#) or PowerShell

August 8, 2017 8 min read

SQL Server - How to convert an HTML string to text (Remove HTML tags) using CLR (C#)

August 8, 2017 3 min read

Analysis Services - How to Use XMLA or PowerShell to Process Cubes and Dimensions via T-SQL or SQL Agent Job

August 6, 2017 10 min read

SQL Server - Table-Valued Function to Split a String into Rows with Size Up to N Characters

July 21, 2017 2 min read

SQL Server - Understanding and Disabling Autocommit

April 3, 2017 5 min read

SQL Server - How to identify and monitor total, free, and used disk space by database datafiles

March 5, 2017 8 min read

SQL Server 2016 - How to query ZIP code information using the Bemean API and the JSON_VALUE function

March 5, 2017 4 min read

SQL Server - Understanding SQL Agent Permissions and Roles: SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRole

February 28, 2017 7 min read

SQL Server - Implementing Access Control and Audit Logs in CLR (C#) Usage

February 28, 2017 5 min read

SQL Server - How to copy/replicate a user's permissions

February 19, 2017 11 min read

SQL Server 2016 SP1 - CREATE OR ALTER in procedures, functions, triggers, and views

February 12, 2017 3 min read

SQL Server - How to integrate the database with Telegram and send messages using CLR (C#)

February 5, 2017 8 min read

SQL Server - How to integrate the database with Slack and send messages using CLR (C#)

February 4, 2017 9 min read

SQL Server - How to integrate the database with Ryver and send messages using CLR (C#)

February 4, 2017 5 min read

SQL Server - How to integrate with FTP and list, upload, and download files using CLR (C#)

November 6, 2016 18 min read

SQL Server - How to run PowerShell and Prompt-DOS (MS-DOS) scripts using CLR (C#)

September 11, 2016 6 min read

SQL Server - Importing and Exporting Data from Excel Spreadsheets

June 15, 2016 5 min read

SQL Server - How to batch run all .sql scripts from a folder or directory with SQLCMD

June 14, 2016 3 min read

SQL Server - How to export database data to a text file (CLR, OLE, BCP)

June 3, 2016 16 min read

SQL Server - Cannot resolve the collation conflict between ... in the equal to operation.

May 25, 2016 6 min read

SQL Server - Heterogeneous Queries Require the ANSI_NULLS and ANSI_WARNINGS Options to Be Set for the Connection

May 22, 2016 3 min read

SQL Server - Querying Instance Information from Windows Registry Using sys.dm_server_registry and xp_instance_regread

April 23, 2016 3 min read

SQL Server 2016 - List of new features and resources

April 3, 2016 9 min read

Arithmetic Overflow in the SQL Server 2008 sys.syscolumns catalog view

February 8, 2015 3 min read