Category Archives: SQL Server 2016

How to create backup to multiple disk files

By using Ms SQL Server any edition you can  create a full backup to multiple disk file, which is the best solution. In a steps of one Job you can do it by using this Transact SQL, as it follows: … Continue reading

Posted in SQL Server 2014, SQL Server 2016 | Tagged , , , | Leave a comment

Concept and basics of Temporal tables in SQL Server 2016

In this article I’ll cover all aspects of a new SQL Server 2016 feature, Temporal Tables (System-Versioned), including: Introduction What is a temporal table? Why Temporal table? How does temporal table work? Consideration and limitation Temporal tables vs CDC Creation … Continue reading

Aside | Posted on by | Tagged , | Leave a comment

SQL Server can be installed on Linux

Announcing SQL Server on Linux more…

Posted in SQL Server 2016 | Leave a comment

SQL Server 2016

This gallery contains 1 photo.

The SQL Server 2016 Community Tech Preview 3.0 is ready. http://msft.it/6184BPXJy

Gallery | Leave a comment

Introducing: SQL Server 2016 Community Technology Preview 2.3

This gallery contains 1 photo.

The SQL Server 2016 Community Technology Preview 2.3 is now available for download! Take a look at the new enhancements on the blog: http://msft.it/6182ByXSE

Gallery | Leave a comment

Download the new SQL Server 2016

This gallery contains 1 photo.

Download the new SQL Server 2016 Community Technology Preview (CTP) 2.1 and capture, transform, and analyze data at any size & scale. Learn more: http://cic.ms/OxF5M9

Gallery | Tagged , | Leave a comment

Always Encrypted: SQL Server 2016 includes new advances that keep data safer

SQL Server 2016 will include new advances that keep valuable personal data protected, even when it isn’t being used. Read more about Always Encrypted as a part of the first public preview! http://cic.ms/N12JDy

Posted in SQL Server 2016 | Tagged , , | Leave a comment