In Unix, a timestamp is a whole number that represents a date and time. Learn how we can convert those correctly in SQL Server.
Learn how to create SQL Server database tables, foreign keys, and create data to begin building a database to support application development.
This article covers how to create multi-chart visualizations in Excel using data from SQL Server.
Rollback scripts are designed to allow us to recover safely from a failed deployment that leaves the database in an indeterminate state. They must check exactly what needs to be reverted before doing so. If you work with an RDBMS that cannot support transaction DDL rollback they are vital. This article proposes a strategy where you create and test a rollback file, at the same time as the forward migration, and reuse it as a Flyway undo script.
In this tip, we cover how to use the GENERATE_SERIES function to expand a range of dates into rows