Prototyping is my favorite part of programming. I like building new stuff and getting things working. It’s no surprise, then, that I am a big fan of MongoDB and NoSQL in general. Don’t get me wrong: I ...

Leonardo Boscaro, EMEA Sales Leader, Nutanix Database. In most large enterprises, the greatest concentration of operational complexity sits quietly inside SQL Server estates. Hundreds, and in some ...

Following on from my post two weeks ago about how to get the details of Power BI operations seen in the Capacity Metrics App using the OperationId column on the Timepoint Detail page, I thought it was ...

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.

pre-commit is a nice development tool to automatize the binding of pre-commit hooks. After installation and configuration pre-commit will run your hooks before you commit any change. CREATE OR REPLACE ...

Part of the SQL Server 2022 blog series. Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...