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
[2020 Single database] SQL Server health check
This SINGLE Database Health Check is a customized service focused on delivering clear pieces of evidence about the status of your database system performance and
Should I migrate my SQL Server to Linux?
With SQL Server 2017, and now SQL Server 2019, SQL Server is available on Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu. For
Why data type choices matter?
I’ll use this opportunity to remind you of something. Choosing the right data types for variables, your tables, and stored procedures not only improves performance
What is SQL Server injection?
SQL injection is a technique in which attackers insert malicious code into strings fields of an application (Web or not) that are later delivered to an instance of
SQL Server migration to Amazon RDS best practices
We talked about availability and security best practices on Amazon RDS. Completing the series of posts, today we will know about Migration on Amazon RDS
SQL Server on Amazon RDS – security best practices
Let’s discuss running SQL Server on Amazon RDS and security best practices. We already reviewed some availability best practices, and now will focus on security
Using PowerShell to monitor disk usage
Part of the database and system administrator’s daily routine consists of monitoring disk usage. It can be achieved manually, however, it is much more logical
High Availability in SQL – all you need to know
You probably heard Service Level Agreement (SLA), Recovery Time Objective (RTO) and Recovery Point Objective (RPO) terminology. Another common phrase is – High Availability –
What is SQL Server parameter sniffing?
SQL Server generates a query plan for a stored procedure using (sniffing) the parameters sent by the first time. By “first time” means that SQL
Selecting the right database for your application
There is a trend we’re seeing across the industry, a single application using multiples databases. The companies are no longer standardizing on a particular database.
How to use SQL Server FILESTREAM feature for large databases
Do’s and don’ts What is SQL Server FileStream feature? This feature allows adding unstructured documents into the database. You can store images, PDFs, videos, or
[2020] Amazon AWS Storage Selection Guide for SQL Server – When to use S3, EBS or EFS
Which AWS storage options work best for SQL Servers? If you are looking for AWS storage options for SQL Servers for your EC2 instance, your