Ernst & Young (EY), one of the world’s biggest accounting companies, kept a complete database backup on the public internet, ...

when used with an old SQL server version (or, in my case, a database with a compatibility level lower than 140). This happens because the STRING_AGG SQL function, which is used in the implementation ...

All connection strings to SQL now default to encrypted and generally need to trust the server certificate. This is easily done in the connection string but I don’t see how to do this in the settings ...

At Microsoft Build, SQL Server 2025 enters public preview with major enhancements in AI integration, performance, reliability and developer tools -- reaffirming Microsoft’s continued investment in its ...

DBeaver is a free, open-source, cross-platform SQL client and database administration tool. It is designed to support a wide variety of SQL and NoSQL databases, including MySQL and PostgreSQL. Its key ...

Microsoft unveiled .NET Aspire at the Build 2024 developer conference, describing it as an opinionated, cloud-ready stack for building observable, production ready, distributed, cloud-native ...

SQL, the Structured Query Language, remains one of the most widely used programming languages, coming in fourth in Stack Overflow’s research for 2023. Just over half (51.52%) of professional ...

One of the interesting new features in SQL Server 2008 is Change Data Capture. I wrote about Change Tracking in a previous blog entry. That will track the what, when and who but will not tell you ...