(Shreyas R Gowda) A few days back one of my clients were facing a business down scenario, where in the DBA who was administering the SQL instance had quit the company and no other have the login access to that instance.

(Manvendra Singh) In the last tip, I explained how to remove Availability Group databases from an AlwaysON Availability Group (AOAG) configuration. In this tip, I will explain how to add a secondary database to an existing AOAG using both SQL Server Management Studio (SSMS) and T-SQL commands.

(Denny Cherry) Out of the box, SQL Server will encrypt some things by default to protect you and your data. Out of the box, SQL Server will encrypt the passwords which are sent up from the client to the SQL Server.

(Nakul Vachhrajani) I recently encountered an interesting question on the forums the other day. The question was how to determine the average time taken by a single execution of the report provided we know how many times the report ran and the total time taken for all those executions.

(Pinal Dave) One of the pre-requesting of Comprehensive Database Performance Health Check is to check if user has necessary system admin rights or not. It is almost impossible to help customer with SQL Server Performance if they do have a DBA who has access to system admin rights.

(Kathi Kellenberger) I’ve used other tools for monitoring SQL Server, but this was my first look at SQL Monitor made by Redgate Software.

(Manoj Pandey) In-Memory tables were introduced in SQL Server 2014 and were also known as Hekaton tables. You can check my previous articles about In-memory tables for [SQL Server 2014] and [SQL Server 2016].

(Don Castelino) This blog covers the process of migrating SAP ASE databases to Microsoft SQL Server using SQL Server Migration Assistant (SSMA) tool.

(Pinal Dave) Recently I faced a strange error related to SQL Server, during Comprehensive Database Performance Health Check. The error indeed surprised me because as I have been doing performance tuning consulting for over 10 years, this is the first time I walked into this error.

(Ben Richardson) Performance testing is one of the most critical criteria to evaluate SQL Server database efficiency. Poorly written queries affect database performance. However if you only have a small amount of data in the database, it becomes difficult to evaluate how well a query is performing.