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.
Implementing ETL Logging on Lakehouse using Delta Lake’s Time Travel capability
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.
The post Implementing ETL Logging on Lakehouse using Delta Lake's Time Travel capability appeared first on SQLServerCentral.
Working with T-SQL function AVG ()
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.
The post Working with T-SQL function AVG () appeared first on SQLServerCentral.
SQL Monitor: On-demand demo [Watch now]
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.
The post SQL Monitor: On-demand demo [Watch now] appeared first on SQLServerCentral.
How to tell what SQL Server versions you are running
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.
The post How to tell what SQL Server versions you are running appeared first on SQLServerCentral.
SQL Server Sample Databases
Learn how to get and install sample databases for SQL Server.
The post SQL Server Sample Databases appeared first on SQLServerCentral.
The post SQL Server Sample Databases appeared first on SQLServerCentral.
Security in MySQL: Part One
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.
The post Security in MySQL: Part One appeared first on SQLServerCentral.
SQL Database Snapshots for Reporting, Auditing and Data Recovery
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.
The post SQL Database Snapshots for Reporting, Auditing and Data Recovery appeared first on SQLServerCentral.
