page.title.tag — Dirceu Resende

SQL Server 2025 - We finally have native regular expression (regex)

December 30, 2025 29 min read

SQL Server - The SQL Agent Job Execution History Is Disappearing

May 10, 2023 7 min read

SQL Server - How to Synchronize Table Data Between Different Databases Using Trigger

August 13, 2022 4 min read

SQL Server - How to Validate Email and Email Domain Using SQLClr (C#)

May 26, 2022 14 min read

SQL Server - Password Policies: Expiration, Mandatory Change and Login Lockout After N Attempts

May 21, 2022 11 min read

SQL Server - ISNULL vs COALESCE: Understanding the Differences Between the Two Functions

May 8, 2022 6 min read

SQL Server and Azure SQL Database - How to Identify Key Lookup Occurrences Through Plan Cache

April 14, 2022 7 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 identify timeout or interrupted connections using Extended Events (XE) or SQL Profiler (Trace)

September 29, 2021 12 min read

SQL Server - Using TRANSLATE() to Replace Multiple REPLACE() Calls

September 28, 2021 7 min read

SQL Server - How to write numbers in full in Portuguese and English using T-SQL function

June 10, 2021 7 min read

SQL Server - The new GREATEST and LEAST functions

November 27, 2020 2 min read

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

November 9, 2020 9 min read

SQL Server - How to Know How Long a Specific Database Has Been Online

October 30, 2020 2 min read

SQL Server - How to send the content of a table or query in the body of the email as HTML

July 6, 2020 11 min read

SQL Server and Power BI - How to Load Stored Procedure Data in SQL Server with DirectQuery

June 16, 2020 7 min read

SQL Server - User Can Only Connect with Sysadmin Permission: Login Failed for User, Reason: Login-Based Server Access Validation Failed with an Infrastructure Error

February 5, 2020 2 min read

SQL Server - Using STRING_SPLIT to Transform Strings from One Row into Columns

February 5, 2020 6 min read

SQL Server - I set Max Server Memory to 0 and now I cannot connect to the instance

December 23, 2019 3 min read

SQL Server - TCP Dynamic Ports vs TCP Port: Dynamic vs Static Port

December 13, 2019 5 min read

SQL Server - String or Binary Data Would Be Truncated: What It Is, How to Identify the Root Cause and How to Fix It

December 3, 2019 8 min read

SQL Server - How to send messages to WhatsApp contacts, groups and broadcast lists via API

December 2, 2019 35 min read

SQL Server - Power BI Gateway Problem When Using External IP or Hostname to Access the Database

November 3, 2019 5 min read

SQL Server - How to identify and replace "strange things" (hidden characters) in strings and tables

August 18, 2019 5 min read

SQL Server - Avoiding Queries on Specific Columns with Column-Level Security (CLS)

July 14, 2019 6 min read

SQL Server - Statements Could Not Be Prepared: Case Expressions May Only Be Nested to Level 10

July 6, 2019 2 min read

stp_SecurityChecklist - Best Practices and Security Checklist for SQL Server

June 23, 2019 3 min read

SQL Server - What Is a Bitwise Operation and How to Store Multiple Values in the Same Column

June 21, 2019 5 min read

SQL Server - Permissions to Use OLE Automation: Yes, the Documentation Is Wrong

May 7, 2019 4 min read

SQL Server - When You Should Use ORDER BY in Queries and When You Should Never Use It

February 24, 2019 5 min read

SQL Server - Using Calculated or Computed Columns for Performance Tuning

February 13, 2019 8 min read

SQL Server - How to avoid brute force attacks on your database

February 11, 2019 21 min read

SQL Server Performance Tuning Tips - What Is the Difference Between Seek Predicate and Predicate?

February 8, 2019 1 min read

SQL Server Performance Tuning Tips - Implicit Conversion: Never Again

February 3, 2019 13 min read

SQL Server - NOLOCK vs READPAST: Do You Know the Difference Between the Two?

January 27, 2019 5 min read

SQL Server - How to Use Auditing to Map Real Required Permissions for a User

January 20, 2019 8 min read

SQL Server - How to identify instance startup parameters using T-SQL

January 11, 2019 3 min read

SQL Server - What Is the Difference Between @@ERROR and ERROR_NUMBER()?

January 1, 2019 4 min read

SQL Server Express Challenge - Is It Possible to Exceed the 10 GB Data Limit in a Database?

December 30, 2018 14 min read

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

SQL Server - How to hide databases from unauthorized users

December 9, 2018 4 min read

SQL Server - The Activated Proc dbo.sp_syspolicy_events_reader Running on Queue msdb.dbo.syspolicy_event_queue

December 9, 2018 4 min read

SQL Server - How to identify locks, blocks, and blocking sessions

December 6, 2018 7 min read

SQL Server - How to Use EXECUTE AS to Run Commands as Another User (Impersonate) and How to Prevent It

November 13, 2018 29 min read

SQL Server - How to identify data conversion errors using TRY_CAST, TRY_CONVERT, TRY_PARSE, ISNUMERIC, and ISDATE

October 7, 2018 2 min read

SQL Server - How to Use the MERGE Command to Insert, Update and Delete Data with Just One Command

September 22, 2018 15 min read

SQL Server - Using Trace Flag 3226 to Avoid Recording Informational Messages Generated by Backups in the SQL Server Log

September 22, 2018 3 min read

SQL Server - How to pass a table as a parameter to Stored Procedures and Functions

September 18, 2018 8 min read

SQL Server - How to Use the Management Studio Debugger

September 10, 2018 1 min read

SQL Server - Using CROSS JOIN (Cartesian Product) to Create Rows in the Query Result

July 14, 2018 4 min read

SQL Server - How to recover the source code of deleted objects (View, Stored Procedure, Function and Trigger)

July 8, 2018 9 min read

SQL Server - Understanding In-Memory OLTP (Hekaton) Tables: Durable vs Non-Durable

June 24, 2018 16 min read

SQL Server - Rounding numbers following the ABNT NBR 5891 standard

June 15, 2018 7 min read

SQL Server - How to identify deprecated features being used on the instance (Extended Events - XE)

May 26, 2018 4 min read

SQL Server - How to Use Regular Expressions (REGEXP) in Your Database

May 22, 2018 22 min read

SQL Server - How to View the Full Job Execution Return Message Even When It Exceeds 4000 Characters

May 2, 2018 3 min read

SQL Server - How to standardize the collation of all database columns

March 15, 2018 22 min read

SQL Server - Using Resource Governor for Greater Control of Server Resources

February 14, 2018 15 min read

SQL Server 2016 - How to protect your data using Row Level Security (RLS)

February 12, 2018 11 min read

SQL Server - How to monitor and audit data changes in tables using Change Data Capture (CDC)

February 7, 2018 9 min read

SQL Server - Trigger to Prevent and Block Changes in Tables

February 4, 2018 3 min read

SQL Server - How to improve formatting of combined query output with SET STATISTICS IO and TIME

January 21, 2018 3 min read

SQL Server - Data Masking with Dynamic Data Masking (DDM)

January 3, 2018 10 min read

SQL Server - How to document the database and its objects (tables, procedures, columns) using Extended Property

October 29, 2017 24 min read

SQL Server - Using the FORMAT() Function to Apply Masks and Formatting to Numbers and Dates

October 10, 2017 15 min read

SQL Server - Introduction to Performance Tuning Study

September 30, 2017 16 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 - File Operations Using xp_cmdshell: How to List, Read, Write, Copy, Delete and Move Files

August 29, 2017 6 min read

SQL Server - How to query Active Directory (AD) information using Linked Server (ADSI)

August 23, 2017 5 min read

SQL Server - How to recover the source code of an encrypted object (WITH ENCRYPTION)

August 22, 2017 8 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 track Correios packages and items after WEBSRO deactivation

July 21, 2017 6 min read

SQL Server - Audit Trigger for Permissions and Privileges at Database and Instance Level (GRANT / REVOKE)

July 19, 2017 2 min read

SQL Server - Performance Comparison Between Scalar Function (UDF) and CLR Scalar Function

March 24, 2017 14 min read

SQL Server - Your Instance Constantly Shows "Starting Up Database" and "Databases in Recovery" Messages: Learn About AUTO_CLOSE

March 23, 2017 5 min read

SQL Server - How to query and consume WordPress RSS feeds using CLR or xp_cmdshell (cURL)

March 19, 2017 8 min read

SQL Server Management Studio (SSMS) - How to Enable the Dark Theme

March 12, 2017 3 min read

SQL Server - How to Transfer Logins Between Instances Generating Reverse Engineering of Users, Logins and Permissions

February 27, 2017 15 min read

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

February 26, 2017 10 min read

SQL Server - Grouping data using ROLLUP, CUBE and GROUPING SETS

February 12, 2017 9 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 send emails from the database using CLR C#

January 31, 2017 8 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 send the result of a query by email in HTML format using the CLR (C#)

January 28, 2017 9 min read

SQL Server - How to monitor your favorite TV shows by consuming a JSON webservice with JSON_VALUE and CLR (C#)

January 25, 2017 4 min read

SQL Server - Msg 443: Invalid Use of a Side-Effecting Operator RAND Within a Function

December 26, 2016 3 min read

SQL Server - Using the SQLQueryStress Tool to Optimize Your SQL Queries

December 25, 2016 4 min read

SQL Server - Why You Should Not Use SET ANSI_WARNINGS OFF

December 23, 2016 5 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

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

September 11, 2016 5 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 - The Data Types Datetime and Time Are Incompatible in the Add Operator

July 16, 2016 3 min read

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

June 26, 2016 15 min read

SQL Server - How to read, import and export data from XML files

June 18, 2016 27 min read

SQL Server - The Server May Be Running Out of Resources or the Assembly May Not Be Trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE

June 16, 2016 2 min read

SQL Server - Error Using OPENROWSET: Access to the Remote Server Is Denied Because No Login-Mapping Exists

May 28, 2016 3 min read

SQL Server - How to resolve the Warning Null value is eliminated by an aggregate or other SET operation

May 22, 2016 2 min read

SQL Server - How to list, read, write, copy, delete and move files with CLR (C#)

May 7, 2016 11 min read

SQL Server - How to perform UPDATE and DELETE with TOP x records

May 7, 2016 2 min read

SQL Server - The Danger of Using JOIN Between Columns of Different Data Types

April 29, 2016 2 min read

Using Sequences in User-Defined Functions in SQL Server

April 28, 2016 2 min read

Using the Default SQL Server Trace to Audit Events - fn_trace_gettable()

April 23, 2016 5 min read

SQL Server - The Database Owner SID Recorded in the Master Database Differs from the Database Owner SID Recorded in Database

April 21, 2016 3 min read

Introduction to SQL CLR (Common Language Runtime) in SQL Server

March 24, 2016 18 min read

Links to download Microsoft Visual Studio 2015 and SQL Server 2014

November 29, 2015 3 min read

Identifying tables with IDENTITY columns in SQL Server

November 16, 2015 1 min read

Enabling and using dedicated remote administrator connection (DAC) in SQL Server

October 4, 2015 4 min read

Checking Permissions, Privileges and Accesses of a Database User in SQL Server

September 7, 2015 21 min read

SQL Server undocumented extended procedures

August 28, 2015 6 min read

How to use JSON in SQL Server 2008, 2012 and 2014 - Reading JSON strings, importing into the database and exporting to XML

July 25, 2015 14 min read

SQL Server - Timeout When Executing a Query on a Linked Server

May 8, 2015 1 min read

Validating CPF, CNPJ, Email, Phone and ZIP Code in SQL Server

February 17, 2015 6 min read

Identifying and resolving orphaned users in SQL Server with sp_change_users_login

February 8, 2015 9 min read

SQLCMD - The SQL Server command-line utility

November 30, 2014 5 min read

Importing CSV files into SQL Server database

June 14, 2014 4 min read