The VALUES clause makes inserting literal values into a table simple and easy. In this article, Joe Celko explains how to use the VALUES clause.
The post The VALUES clause or building tables out of nothing appeared first on SQLServerCentral.

In this article I demonstrate how to use Delta Lake's time travel functionality for ETL logging along with steps to take to implement.
The post Implementing ETL Logging on Lakehouse using Delta Lake's Time Travel capability appeared first on SQLServerCentral.

Learn about the T-SQL function, AVG(), and see how it is used in a few different cases.
The post Working with T-SQL function AVG () appeared first on SQLServerCentral.

Haven't seen SQL Monitor in a while? If you'd like to see how it enables you to always have the answers to the health of your estate, and proactively find potential problems before they impact your users, here's a 30 minute demo for you to watch whenever it suits you.
The post SQL Monitor: On-demand demo [Watch now] appeared first on SQLServerCentral.

Check out this tip to easily find out what version of SQL Server you are running.
The post How to tell what SQL Server versions you are running appeared first on SQLServerCentral.

Learn how to get and install sample databases for SQL Server.
The post SQL Server Sample Databases appeared first on SQLServerCentral.

There are several tools available to keep a MySQL database secure. In this article Lukas Vileikis discuses access control and user privileges.
The post Security in MySQL: Part One appeared first on SQLServerCentral.

In this article we look at how to create a SQL Server database snapshot and how snapshots can be used for reporting, auditing and more.
The post SQL Database Snapshots for Reporting, Auditing and Data Recovery appeared first on SQLServerCentral.