Query Development

SQL Server – ISNULL x COALESCE: Knowing the Differences Between the Two Functions

Azure SQL Database – STRING_SPLIT function finally gets parameter to include number of positions

November 5th, 2021
0
Database Query Development News SQL Server

SQL Server – How to identify timeout or broken connections using Extended Events (XE) or SQL Profiler (Trace)

September 29th, 2021
0
Database Query Development SQL Server

SQL Server – Using TRANSLATE to replace multiple REPLACE

September 28th, 2021
0
Database Query Development SQL Server

SQL Server - How to identify the store closest to the customer (or the distance between 2 locations) from the zip code (without API)

SQL Server – How to filter and separate the number and text of a string

SQL Server – How to consult the dollar (USD), euro (EUR) or any other currency in real time with API and SQLCLR

June 10st, 2021
1
Database CLR Query Development Integrations SQL Server

SQL Server – How to write a full number in Portuguese and English using T-SQL function

SQL Server - The “new” GREATEST and LEAST functions

November 27th, 2020
1
Database Query Development SQL Server

SQL Server - How to know how long a specific database has been online

October 30th, 2020
1
Database Query Development Maintenance SQL Server