Monthly Archives: May 2017

Migrate an SQL database from Windows to Linux using backup-and-restore and SMB Protocol

Posted on May 16, 2017 by Prashanth Jayaram

In an attempt decouple systems, we may modularize them. In most cases, we would need to move databases from one server to another—sometimes, even move them from Windows to Linux. In the case of moving a database to Linux, SQL Server’s … Continue reading →

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

Installation of SQL Server vNext CTP on Linux Distribution CentOS 7

Posted on May 10, 2017 by Prashanth Jayaram

It was a paradigm shift in December 2016, when Microsoft made their SQL Server database available for Linux; it was the first time in history that Microsoft ever designed SQL Server to run on a non-Windows operating system. SQL Server … Continue reading →

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

Understanding Database Backup Encryption in SQL Server

Posted on May 3, 2017 by Prashanth Jayaram

Terabytes of data, millions of rows; the entire business depends on this — a database administrator’s responsibility is as massive as it sounds. Apart from keeping the data secure, a database administrator also has to keep the system up and … Continue reading →

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