In Unix, a timestamp is a whole number that represents a date and time. Learn how we can convert those correctly in SQL Server.
The post Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1 appeared first on SQLServerCentral.

Learn how to create SQL Server database tables, foreign keys, and create data to begin building a database to support application development.
The post How to Create a SQL Server Database, Tables, Foreign Keys and Data for an Application appeared first on SQLServerCentral.

This article continues looking at python code in Power BI to produce charts.
The post How to visualize Python charts in Power BI Part 2 appeared first on SQLServerCentral.

Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.
The post Understanding the System Function FILEPROPERTY() appeared first on SQLServerCentral.

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.
The post Rollbacks, Undos and Undonts appeared first on SQLServerCentral.

This article covers how to create multi-chart visualizations in Excel using data from SQL Server.
The post Data Visualizations for Excel Multi-Chart Sets with SQL Server Data appeared first on SQLServerCentral.

In this tip, we cover how to use the GENERATE_SERIES function to expand a range of dates into rows
The post How to Expand a Range of Dates into Rows with the SQL Server Function GENERATE_SERIES appeared first on SQLServerCentral.

Learn how you can set up and use Ledger tables in an Azure SQL Database to verify the integrity of your database changes.
The post SQL Ledger: Protecting Data in Azure SQL appeared first on SQLServerCentral.