SQL Server - How to Validate Email and Email Domain Using SQLClr (C#) May 26, 2022 14 min read Continue reading
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 Continue reading
SQL Server - Rounding numbers following the ABNT NBR 5891 standard June 15, 2018 7 min read Continue reading
SQL Server - How to convert an RTF string to text (Remove RTF tags) using CLR (C#) or PowerShell August 8, 2017 8 min read Continue reading
SQL Server - How to convert an HTML string to text (Remove HTML tags) using CLR (C#) August 8, 2017 3 min read Continue reading
SQL Server - How to query national, state, municipal, and optional holidays from an API using OLE Automation and CLR (C#) December 1, 2016 4 min read Continue reading
SQL Server - How to identify weak, empty, or user-name passwords November 24, 2016 4 min read Continue reading
How to validate state registration for all states using C# and SQL Server CLR August 12, 2016 17 min read Continue reading
Valid CPF and CNPJ generator for SQL Server environment testing November 22, 2015 3 min read Continue reading
How to Convert Integers to Hexadecimal, Octal and Binary (and Vice Versa) in SQL Server November 22, 2015 2 min read Continue reading
How to convert milliseconds, seconds or minutes to TIME in SQL Server November 18, 2015 1 min read Continue reading
How to calculate business days in SQL Server (dCalendario Table) July 29, 2015 7 min read Continue reading
How to create a table with the national, state and movable holidays in SQL Server July 28, 2015 5 min read Continue reading
How to remove accents and special characters from a string in SQL Server July 27, 2015 2 min read Continue reading
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 Continue reading
How to validate state registration using a T-SQL function in SQL Server May 18, 2015 15 min read Continue reading
How to convert the run_date and run_time columns from job_history to datetime in SQL Server May 7, 2015 2 min read Continue reading
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 Continue reading
Working with the Base64 encryption algorithm in SQL Server February 18, 2015 2 min read Continue reading
Validating CPF, CNPJ, Email, Phone and ZIP Code in SQL Server February 17, 2015 6 min read Continue reading