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
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?
What is a Microsoft SQL Server Cursor? A SQL cursor is a database object which is used to manipulate data in a set, row-by-row processing,
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
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
SQL Server data type choices and why they matter
Choosing the right data types for variables, your tables, and stored procedures not only improves performance by ensuring a correct execution plan, but it also
Little bobby tables and SQL 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
[Best Practices] SQL Server migration to Amazon RDS
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 and 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
SQL Server High Availability – *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.