Do you know the feeling when someone gives you a flat file to import, without any schema information? You have to dump it in your database as-is, then spend …
Here is something that will save you lots of time and headaches when trying to connect to Azure SQL Managed Instances, especially from onprem servers or from …
Welcome to 2020! I wanted to start this year by giving to all my fellow consultants another way to troubleshoot our beloved SQL Servers; I’ve already …
Azure Data Studio is starting to mature and some neat features are coming to the vscode-based (and now multidatabase and multiplatform) tool. We got query plans …
It must have happened you at least once to find identity columns with values that from one row to the next one jump by 1000’s rows, of course without …