Temporal tables - also known as system-versioned tables, but not to be mistaken with temporary tables - are a new feature of SQL Server 2016 that allow SQL Server to automatically keep a history of the data in the table. This tip from Koen Verbeeck introduces the new feature by explaining how to create a system-versioned table.
MVP Jody Roberts reviews GenesisOne T-SQL Source Code Unscrambler, a tool that aims to clarify code and server environments with simple diagrams and plain English.
In this level, we will first take a look at how to recognize columnstore indexes in some of the generic catalog views. After that we will investigate the new catalog views that have been added just for columnstore indexes.
The Data-Tier Application Package (DacPac), together with the Data-Tier Application Framework (DacFx), provides an alternative way to automate the process of scripting out, or deploying a SQL Server database, reporting on changes, or checking version-drift. As such, it seems to provide an obvious cost-free start for tackling automated Database Delivery as part of Database Lifecycle Management (DLM). We asked Phil Factor if it is ready for Prime-time.
The cloud is always going to be a challenge for security, but is it harder or easier than on premises? Steve Jones has a few comments.
There are unique considerations that apply to virtual machines that run SQL Server workloads in such environments. This document provides insight into considerations and best practices for running SQL Server in Hyper-V Dynamic Memory configurations on Windows Server.
Inspired by his visit to the battlefield of Waterloo, Grant Fritchey explains the dangers of doing things the way you've always done them and the need to challenge constantly your beliefs and understanding of how the technology you manage works.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
BCA KCP Pondok Indah Telpon/WA:085188120691 Jl. Metro Pondok Indah No.60 & 61 UA, Pd....
BCA KCP Pasar Kebayoran Lama Telpon/WA:085188120691 Jl. Raya Kby. Lama No.174, Cipulir, Kec. Kebayoran...
BCA KCP Tebet Barat 2 Telpon/WA:085188120691 Jl. Tebet Raya No.25 B Blok CI, Tebet...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers