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
Enabling lock pages in memory for SQL Server
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
How to identify deprecated features in use on a SQL Server instance?
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,
Best practices for SQL Server Agent job history retention
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
New Software Assurance benefits for SQL Server HA and Disaster Recovery
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
Guide how to test and compare performance of two SQL Servers
You have your OLD SQL Server. I will be calling this server puppy: OLD, ServerA, or current. And you have the NEW SQL Server.
SQL Performance Tuning Report – 899,253% improvement
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
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
SQL Performance Tuning Report – Execution duration from 52 minutes down to 92 milliseconds?
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
SQL Server on Amazon RDS
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
What is a cursor in SQL Server and why do you need it?
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
SQL Server on Amazon RDS – Availability best practices
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
How to encrypt drives on live SQL Server with Always-On
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.