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
SQL Server - How to send the contents of a table or query in the body of the email as HTML 6 July 2020 4 Database Query Development SQL Server
SQL Server and Power BI: How to load Stored Procedure data into SQL Server with DirectQuery June 16st, 2020 2 Database Business Intelligence (BI) Query Development Hacks Power BI SQL Server
SQL Server - How to export the contents of a column to XML files April 12 2020 1 Database Query Development SQL Server
SQL Server - Using STRING_SPLIT to transform strings from a row into columns February 5rd, 2020 1 Database Query Development SQL Server
SQL Server - String or binary data would be truncated: What is, how to identify root cause and how to fix December 3th, 2019 0 Database Query Development Errors Data Formatting and Validation SQL Server
SQL Server - Charindex: A Different Function to Break Split Strings November 3th, 2019 3 Database Query Development SQL Server
SQL Server - How to identify and replace “strange things” (hidden characters) in strings and tables August 17st, 2019 4 Database Query Development SQL Server
SQL Server - What is bitwise operation and how to store multiple values in the same column June 21st, 2019 2 Database Query Development What not to do SQL Server