21 Missing Features in SQL Server on Linux

In last tip, I have explained about new features introduced in SQL Server 2017. SQL Server support on Linux based…

SQL Server Backup & Recovery Interview Questions & Answers

This article is based on SQL Server backup & recovery interview questions and answers. You can access SQL Server Architecture…

SQL Server Alwayson Error 35250: Joining database on Secondary Replica resulted in an error

We got this Microsoft SQL Server error 35250 while configuring Alwayson Availability Group on one of the SQL Server Instance.…

10 New Features in SQL Server 2017 Database Engine

SQL Server 2017 is major release that are coming with lots of new features. The most debated new feature in…

Install SQL Server Agent on Ubuntu Server

I have shown how to install SQL Server 2017 on Ubuntu server that have internet access in my last article.…

Install SQL Server 2017 on Ubuntu with Internet Access

We can easily install SQL Server 2017 on Ubuntu server if we have internet access to the online repositories but…

SQL Server DBA Interview Questions & Answers

This is second series of SQL Server DBA Interview questions & answers. I have published SQL Server Interview questions &…

Fix AOAG Listener Error 19471: Kerberos Status is Showing The handle is Invalid

I was configuring AlwaysOn Availability Group between two replicas. Everything was configured successfully but Listener was failed to create with…

Why Should You Always Turn Off Database Auto Shrink Property?

SQL Server Auto Shrink is database property that allow database engine to automatically shrink database files if its value set…

Understanding Database Autogrowth in SQL Server

We use SQL Server database Autogrowth setting to automate database file growth. This property is very helpful if you use it…