SQL Server and Azure SQL - Challenge for Grouping Data Using Hierarchies August 11, 2023 4 min read Continue reading
SQL Server - How to identify timeout or interrupted connections using Extended Events (XE) or SQL Profiler (Trace) September 29, 2021 12 min read Continue reading
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 Continue reading
SQL Server - How to filter and separate the number and text from a string June 14, 2021 1 min read Continue reading
SQL Server - How to write numbers in full in Portuguese and English using T-SQL function June 10, 2021 7 min read Continue reading
SQL Server - What Is a Bitwise Operation and How to Store Multiple Values in the Same Column June 21, 2019 5 min read Continue reading
SQL Server Performance Tuning Tips - Implicit Conversion: Never Again February 3, 2019 13 min read Continue reading
SQL Server - NOLOCK vs READPAST: Do You Know the Difference Between the Two? January 27, 2019 5 min read Continue reading
SQL Server - How to identify instance startup parameters using T-SQL January 11, 2019 3 min read Continue reading
What changed in SQL Server 2012 regarding T-SQL - from the developers perspective December 29, 2018 19 min read Continue reading
SQL Server - How to Use the Management Studio Debugger September 10, 2018 1 min read Continue reading
SQL Server - Why You Should Not Use SET ANSI_WARNINGS OFF December 23, 2016 5 min read Continue reading
How to split a string into a table of substrings using a delimiter in SQL Server January 3, 2016 2 min read Continue reading
How to identify, delete and recreate Foreign Keys (FK) of a table in SQL Server October 6, 2015 2 min read Continue reading
Checking Permissions, Privileges and Accesses of a Database User in SQL Server September 7, 2015 21 min read Continue reading
Consuming the Google Maps API using OLE Automation in SQL Server July 27, 2015 3 min read Continue reading