SQL Server and Azure SQL - Challenge for Grouping Data Using Hierarchies August 11, 2023 4 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 - charindexada: A different function to split delimited strings November 3, 2019 4 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 and Power BI - How to Analyze and Generate Statistics from WhatsApp Group Conversations August 18, 2018 18 min read Continue reading
SQL Server 2016 - How to "travel through time" using Temporal Tables February 9, 2018 8 min read Continue reading
SQL Server - How to create recursive queries with CTE (Common Table Expressions) January 9, 2018 8 min read Continue reading
SQL Server - How to identify occurrences of a specific character in a string or table August 15, 2017 6 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 - Table-Valued Function to Split a String into Rows with Size Up to N Characters July 21, 2017 2 min read Continue reading
SQL Server 2016 SP1 - CREATE OR ALTER in procedures, functions, triggers, and views February 12, 2017 3 min read Continue reading
SQL Server - Importing and Exporting Data from Excel Spreadsheets June 15, 2016 5 min read Continue reading
SQL Server - How to batch run all .sql scripts from a folder or directory with SQLCMD June 14, 2016 3 min read Continue reading
SQL Server - How to export database data to a text file (CLR, OLE, BCP) June 3, 2016 16 min read Continue reading
Arithmetic Overflow in the SQL Server 2008 sys.syscolumns catalog view February 8, 2015 3 min read Continue reading