A while back I asked for a change when creating DDL for SQL Server objects to use CREATE OR ALTER. This may have changed but not what I was expecting. I'm currently using dBeaver Community Edition v25 ...

SQLGlot supports the full CREATE TABLE syntax for temporal tables, but there's some cases missing around the ALTER TABLE syntax to add them after-the-fact. I've included code to create and clean up ...

You will fail to connect to your database if the SQL Server service is not running. If you try running the SQL Server service from the Services.msc app, you will ...

Microsoft's relational database engine has had the same licensing model since 2012. The new version released this week brings significant changes that brings SQL Server closer to Azure SQL's licensing ...

I want to cover one way you can do CI/CD for Azure Synapse Analytics serverless SQL pools using Azure DevOps in this post. Because I know it is a popular topic. It is related to my post about how you ...

SQL Server 2019 preview brings encryption technology to a broader set of scenarios by enabling rich confidential computing capabilities with the enhanced Always Encrypted feature, Always Encrypted ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...