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

9,462 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: )

204 reads

Blogs

Azure Platform Series: How to setup Azure Cloud Shell

By

This blog post will be a series on the Azure Platform and some things...

Daily Coping 5 June 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing

By

I’m working on a project where it’s useful to automate environment setup and teardown...

Read the latest Blogs

Forums

Attach and Detach Method vs SQL Manage object method

By Nusc

Hi there, if you want to detach a database you would right click on...

How to generating Excel File with multi sheet by using SQL server 2012?

By ahmed_elbarbary.2010

I need to create stored procedure or query or any thing on SQL server...

performance tuning for a subquery

By rohitkocharda

Hey Guys I have a quick questions regarding a better way to write a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers