Category Archives: Sql Server

SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing

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:

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

Dynamic Data Masking SQL Server 2016

Dynamic Data Masking SQL Server 2016 Hi friends, in this post we will discuss a newly added feature by SQL Server team to keep data safe, Dynamic Data Masking SQL Server 2016. Dynamic data masking SQL Server 2016 restrict sensitive data exposure to non-privileged users. Dynamic data masking feature used to hide sensitive data from unauthorised access and

Reporting Services Catalog Database File Existence

Reporting Services Catalog Database File Existence Hi friends, recently I am trying to reinstall SQL Server 2016 Developer edition on my system. As earlier version is SQL Server 2016 Release Candidate 2. During installation I got this error Reporting Services Catalog Database File Existence & Reporting Services Catalog Temporary Database File Existence. I already faced this error so

How to recover corrupt Master Database

How to recover corrupt Master Database Hi friends, in this post we are discussing a very important task played by a SQL Server DBA How to recover corrupt Master Database. In case of MASTER database corruption in SQL Server, you can’t able to start your SQL Server. So it is a wise approach to take backup