I've been thinking a lot lately about what it actually takes to make an AI agent genuinely useful for database work, both for administration and for application access to the data tier. Writing the ...

Azure Synapse Analytics was first revealed by Microsoft in November 2019, at its Ignite conference in Orlando, back when we still had live events. With just a few months to go until its first birthday ...

This tool is currently only supported on Windows and PowerShell. It has not yet been tested on PowerShell Core. It will though work remotely against SQL Server on Linux. NOTE: For SQL Server 2014 and ...

I realized how much easier my life would be if SQL had a mode() aggregate function. (I'm using it in the mathematical sense). I'm guessing that either I use SQL in a wierd way or there is a good ...