Most of us work with the time in a variety of ways in our applications. Temporal tables use the time on the server,but Steve notes today that we might want to capture other types of time.

Create Table DDL via TSQL

by Lowell Izaguirre

SQLServerCentral.com

A stored procedure from longtime community member Lowell Izaguirre, returns the CREATE TABLE definition for any table, including PK, UQ, Identity, FK, Defaults, and more.

GDPR in the USA

by Grant Fritchey

SimpleTalk

GDPR enforcement began in May of 2018, but if you are doing business in the US, you may not think it applies to you. Grant Fritchey explains why you might be wrong about that and why you need to act now.

Scripting Custom SQL Server Clones for Database Development and Testing

by Additional Articles

Redgate

Phil Factor shows how to automatically apply T-SQL modification scripts during image and clone creation. Using this technique you can, for example, apply data masking to all clones, or customize an individual clone to work on a special variant or branch version, or set up instance level objects like Agent jobs or linked servers.

Building a Database Engine

by Steve Jones

SQLServerCentral

software development

Someone tried to build a database engine from scratch. While not something Steve wants to do, it's an interesting exercise.

4 Top Tips for starting your database DevOps journey

by Additional Articles

Redgate

DevOps and Continuous Delivery (CI/CD)

Want to get database DevOps implemented where you work but unsure where to start or how? We’ve written a handy blog to help you begin your database DevOps journey....