Your browser does not support the audio element. Hey there, fellow developers! If you've ever dabbled in SQL, you've probably heard the golden rule: "Never use ...

Database administrator with 14+ years of hands-on experience in database management and database design. After spending 15 years as a SQL Server DBA, I've witnessed numerous technological evolutions, ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

This system stored procedure takes a table name as a parameter and generates a MERGE statement containing all the table data. This is useful if you need to migrate static data between databases, eg.

“Safeguarding customer systems with a firm & modern technical foundation, addressing current software limitations that risk destabilizing or increasing risk was our primary objective.” Alex McArthur, ...

I am starting this new year the same way I ended the last: taking antibiotics because my biological daughter brought home a nasty sinus bug from Carnegie Mellon’s preschool. This was after my first ...

The new ledger feature in SQL Server 2022 provides blockchain-based security to ensure data isn't tampered with. The ability to cryptographically guarantee the integrity of data is especially useful ...

Links to the documentation for T-SQL statements supported in dedicated SQL pool (formerly SQL DW). The following DMVs are applicable to dedicated SQL pool (formerly SQL DW), but must be executed by ...