Query Development — Dirceu Resende

SQL Server and Azure SQL - How to Create a Calendar Table Using SQL Including Holidays

August 11, 2023 21 min read

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

August 11, 2023 4 min read

[Live] - Microsoft Reactor - GitHub Copilot + Databases: more productivity writing SQL instructions

July 26, 2023 1 min read

SQL Server and Azure SQL - How to Delete or Update Data in Large Tables

November 9, 2022 4 min read

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

May 8, 2022 6 min read

Azure SQL Database - STRING_SPLIT function finally gets a parameter to include position numbers

November 5, 2021 1 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 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 - How to filter and separate the number and text from a string

June 14, 2021 1 min read

SQL Server - How to query the dollar (USD), euro (EUR), real (BRL), or any other currency rate in real time with API and SQLCLR

June 11, 2021 16 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 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 - How to export the content of a column to XML files

April 13, 2020 5 min read

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

February 5, 2020 6 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 - charindexada: A different function to split delimited strings

November 3, 2019 4 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 - What Is a Bitwise Operation and How to Store Multiple Values in the Same Column

June 21, 2019 5 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 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

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

December 29, 2018 19 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

What changed in SQL Server 2008 regarding T-SQL - From the developers perspective

September 26, 2018 6 min read

SQL Server 2012 - How to create data pagination in query results with OFFSET and FETCH

September 25, 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 - 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 and Power BI - How to Analyze and Generate Statistics from WhatsApp Group Conversations

August 18, 2018 18 min read

SQL Server - How to create code versioning for your Stored Procedures in HTML with change comments

July 16, 2018 10 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 identify a slow or "heavy" query in your database

July 8, 2018 26 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 Use Regular Expressions (REGEXP) in Your Database

May 22, 2018 22 min read

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

March 15, 2018 22 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 - 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 - Write T-SQL Like a Ninja Using Redgate SQL Prompt

September 3, 2017 6 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

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 - How to calculate the difference in years (age) between two dates using T-SQL or CLR

April 9, 2017 4 min read

SQL Server - How to create an Excel-like AutoSum using Window functions (Running totals)

March 6, 2017 4 min read

SQL Server 2016 - Using native JSON support (JSON_VALUE, JSON_QUERY, OPENJSON, FOR JSON, ISJSON, JSON_MODIFY)

February 19, 2017 16 min read

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

February 12, 2017 3 min read

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

February 12, 2017 9 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 - How to create a Secret Santa draw using Transact-SQL

December 27, 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

How to create a random password generator written in PHP, C# (CSharp) or Transact-SQL (T-SQL)

September 18, 2016 3 min read

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

July 17, 2016 7 min read

SQL Server - How to concatenate rows grouping data by a column (Grouped concatenation)

June 19, 2016 9 min read

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

June 18, 2016 27 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 - How to import text files into the database (OLE Automation, CLR, BCP, BULK INSERT, OPENROWSET)

May 29, 2016 7 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 perform UPDATE and DELETE with TOP x records

May 7, 2016 2 min read

Using Sequences in User-Defined Functions in SQL Server

April 28, 2016 2 min read

SQL Server 2012 - Working with Sequences and comparisons with IDENTITY

April 28, 2016 7 min read

How to retrieve the greatest value among multiple columns in a SQL Server table

April 2, 2016 2 min read

How to split a string into a table of substrings using a delimiter in SQL Server

January 3, 2016 2 min read

How to Convert Integers to Hexadecimal, Octal and Binary (and Vice Versa) in SQL Server

November 22, 2015 2 min read

How to Convert Numbers to Roman Numerals in SQL Server

November 21, 2015 1 min read

How to convert milliseconds, seconds or minutes to TIME in SQL Server

November 18, 2015 1 min read

Understanding how indexes work in SQL Server

October 11, 2015 18 min read

How to remove accents and special characters from a string in SQL Server

July 27, 2015 2 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

How to export data from a SQL Server table to HTML

July 12, 2015 7 min read

How to validate state registration using a T-SQL function in SQL Server

May 18, 2015 15 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

Running a Command in All Databases of the SQL Server Instance

March 8, 2015 3 min read

Working with cryptographic functions (MD4, MD5, SHA1, SHA2_256 and SHA2_512) using the HASHBYTES function of SQL Server

February 18, 2015 2 min read

Working with the Base64 encryption algorithm in SQL Server

February 18, 2015 2 min read

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

February 17, 2015 6 min read

Similarities and Differences Between DELETE, TRUNCATE and DROP TABLE

February 17, 2015 4 min read

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

February 8, 2015 3 min read

SQL Server SET commands

December 20, 2014 8 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

Searching text in all columns of all tables in SQL Server

June 14, 2014 3 min read

SQL Server - Splitting strings into substrings using a separator (Split string)

June 14, 2014 9 min read

How to remove HTML tags from a string in SQL Server

June 7, 2014 5 min read