SQL Server database migration is considered as a process that helps to move the previous implementation to a newer version of SQL Server, and require different locations with a strategic decision. Therefore, in this blog, we are going to discuss most important aspects that need to be examined before and after migrating to the SQL Server. This article is intended to provide guidance that can help to create the migration plan. Continue reading “Checklist for SQL Server Database Migration & Its Best Practices”
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:
In this article I’ll cover all aspects of a new SQL Server 2016 feature, Temporal Tables (System-Versioned), including:
- What is a temporal table?
- Why Temporal table?
- How does temporal table work?
- Consideration and limitation
- Temporal tables vs CDC
- Creation and configuration
- Clean up and removal
AS we know, Microsoft released SQL Server 2016 RTM version (13.00.1601.5) and in November of 2016 updated it by the latest CU (Security Bulletin MS16-136 (CU) KB #3194717) (13.0.2186.0) you can check this update from here.
To complete the post please check it over SQLShack
Announcing SQL Server on Linux more…
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