07/12/2010 While there are a great many books, blogs, and articles out there on T-SQL, there are always a few little "tricks" that many people overlook, or that many authors assume readers know.

While ledger is a game-changer for security, SQL Server 2022 also introduced new functionality around Dynamic Data Masking (DDM), T-SQL enhancements and more.

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.

While SQL Server 2022 (with Cumulative Update KB5050771 installed) executes the query successfully without any errors, I am receiving a syntax warning stating that XML_COMPRESSION is an incorrect ...