Category: Performance Item:  Lock Pages in Memory setting What is lock pages in memory option? It is a security setting that allows accounts to keep

Category: Reliability Item:  Deprecated features in use What is the deprecated feature in the sql server? Every release of SQL Server adds new features. However,

Category: Reliability Item: SQL Agent Jobs history settings What is the SQL Server Agent Job History Retention? It will determine the amount of Job History

Recently, Microsoft announced new rights to build a holistic, high availability (HA) and disaster recovery (DR) plan for SQL Server customers licensing with Software Assurance

SQL Performance Tuning Case Study… and a new big win! Here is another recent SQL Server performance tuning report. Improvements achieved: CPU from 51,628 to

Microsoft Dynamics 365 is a cloud ERP and CRM enterprise platform for organizations announced by Microsoft in July 2016. They built it for maximum flexibility

Real sample #13 Here what can be done when you have one of our DBA plans. During monitoring session was observed this query running for

Amazon RDS is managed database service it makes it easy to provision and run relational databases in the cloud. It supports several relational engines starting

A SQL cursor is a database object which is used to manipulate data in a set, do row-by-row processing, instead of the T-SQL commands that

What is Amazon RDS? Amazon RDS is a fully-managed database service that allows you to provision and run relational databases in the cloud. It supports

To encrypt drives for AlwaysOn I would suggest these steps: Do encryption during low usage hours. Encrypt drives on SECONDARY first. Without taking AlwaysOn offline.