Author Archives: Mandeep Singh

TRANSFER MAINTENANCE PLANS FROM ONE SQL SERVER TO OTHER

TRANSFER MAINTENANCE PLANS FROM ONE SQL SERVER TO OTHER Hi friends, in this post we will discuss about how to TRANSFER MAINTENANCE PLANS FROM ONE SQL SERVER TO OTHER. Maintenance plans are nothing but SSIS packages which SQL Server creates itself under MSDB database. And best thing is that we can import/export them from one SQL

sqlcmd command not found on Ubuntu

sqlcmd command not found on Ubuntu Hi friends, in this post we will discuss about a error which comes when we installed MSSQL TOOLS on Ubuntu. Error is: sqlcmd command not found on Ubuntu. I installed MSSQL Tools as told by microsoft blog step by step, but sqlcmd is not working and gives error. I googled

Install MSSQL Tools on Ubuntu

Install MSSQL Tools on Ubuntu Hi friends, in this post we will learn how to Install MSSQL Tools on Ubuntu. BCP, SQLCMD and Microsoft ODBC drivers are installed by following below steps. Earlier we had discussed how to Install SQL Server on Ubuntu. sqlcmd: Command-line query utility. bcp: Bulk import-export utility. Steps to Install SQL Server Tools on Ubuntu:

Unable to lock the administration directory (/var/lib/dpkg/), is another process using it?

Unable to lock the administration directory (/var/lib/dpkg/), is another process using it? Hi friends, recently I am working on Ubuntu 16.04 for MSSQL Server testing on Ubuntu. And when I try to uninstall MSSQL Tools, I end up with this error: E: Could not get lock /var/lib/dpkg/lock – open (11 Resource temporarily unavailable) E: Unable

Install SQL Server on Ubuntu

Install SQL Server on Ubuntu Hi friends, in this post we will learn how to Install SQL Server on Ubuntu. Recently SQL Server team releases SQL Server vNext CTP 1.1 for Linux. It’s the same SQL Server database engine that runs on windows with some of many features and services. Installation of SQL Server on Ubuntu is

Always Encrypted SQL Server 2016

Always Encrypted SQL Server 2016 Always Encrypted is a new feature introduced in SQL Server 2016. Always Encrypted SQL Server 2016 main objective is to protect sensitive data from unauthorized access. Unlike TDE, as well, Always Encrypted allows you to encrypt only certain columns, rather than the entire database. Always Encrypted option enables data encryption