Mala Mahadevan

Querying Temporal Tables

Temporal tables a.k.a Table Versioning was introduced in SQL Server 2016 and is an easy, convenient way to track changes to data. A good introduction to temporal tables can be found here. One of the key advantages of versioning tables is easy of querying – or getting a ‘single pane of glass’ look of how […]

5 (2)

2019-07-29

5,377 reads

Pathways to Progress

One of the most significant and hardest challenges we face as data professionals (or generally anyone in IT) is how to keep up with learning. Most of us are...

2019-06-05 (first published: )

200 reads

Blogs

When using Powershell to control Azure the Cloud Shell doesn’t require an additional login.

By

When studying Azure one of the things you’ll be asked to learn is the...

SQL Server Statistics Health Reminder

By

I’ve written about statistics in SQL Server a few times now. Through conversations  I...

Running SQL Server containers as non-root

By

Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

transaction delay when replica unavailable - what effect?

By snomadj

I'm using AlwaysOn synchronous replica.  User issues an update on primary via SSMS.  In...

need to calculate Group by date

By nrdroque

hi, i'm creating a view and need some help. i have the column "valorTotal"...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers