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
Fail-safe operator for SQL Server agent
No failsafe operator What is a fail-safe operator in SQL Server? A fail-safe operator is a backup user who receives the alert if the designated
SQL Server shrink: Best Practices.
DBCC Shrink ran recently What is database file shrinking in SQL Server? Shrinking data files recovers space by moving pages of data and returning it
SQL Server max memory parameter
Why should you care about Max memory setting in SQL Server? SQL RAM max memory default setting is terrible. The server has to have a
Auto growth SQL Server: Best Practice
File growth options What is SQL Server Database Autogrowth setting? It’s a procedure used by the SQL Server engine to expand the database size when
Enabling lock pages in memory for SQL Server
Lock Pages in Memory setting What is lock pages in memory option? It is a security setting that allows accounts to keep data in physical
How to identify deprecated features in use on a SQL Server instance?
What does it mean when “deprecated features are use”? What are the deprecated feature in SQL Server? Every release of SQL Server adds new features.
SQL Server Agent job history retention [Best Practices]
SQL Agent Jobs history settings What is the SQL Server Agent Job History Retention? It will determine the amount of Job History records that SQL
New Microsoft Software Assurance benefits for SQL Server High Availability (HA) and Disaster Recovery (DR)
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. Will
[Case Study] Tuning SQL Performance and improving speed by 899,253% (not a typo)! How did we do it?
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
[Case Study] SQL Performance Tuning and how we took TSQL run from 52 minutes down to 92 milliseconds! How did we do it?
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