The Red9 Blog
Get our new tips before anyone else. Enter your email below to join our private list!
Most Popular Red9 Posts
Latest From Red9
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
You have your OLD SQL Server. I will be calling this server puppy: OLD, ServerA, or current. And you have the NEW SQL Server.
Case Study… and a new big gain! Here is another recent SQL Server performance tuning report. Improvements achieved: CPU from 51,628 to 12 Reads from
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.