Database

SQL Server - The “new” GREATEST and LEAST functions

November 27th, 2020
1
Database Query Development SQL Server

SQL Server - How to know the date of a user's last login

November 9th, 2020
0
Database Monitoring 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

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

SQL Server - User only connects to the instance with sysadmin permission - Login failed for user 'teste'. Reason: Login-based server access validation failed with an infrastructure error

February 5rd, 2020
4
Database Errors SQL Server

SQL Server - Using STRING_SPLIT to transform strings from a row into columns

February 5rd, 2020
1
Database Query Development SQL Server

TOP 10 2019 technical articles you liked best

December 30th, 2019
0
Database SQL Server

SQL Server - Encrypting passwords with the symmetric encryption functions ENCRYPTBYPASSPHRASE and DECRYPTBYPASSPHRASE

December 25th, 2019
0
Database Safety SQL Server