SQL Server migration to Amazon RDS Strategies
Red9 Blog
by Mark Varnas
9M ago
We talked about availability and security best practices on Amazon RDS. Completing the series of posts, today we will learn about Migration on Amazon RDS using SQL Server. In this article, best practices will be defined for the Native Backup/Restore and AWS data migration service. But let’s first learn what Amazon RDS is. Why do you even need to migrate to Amazon RDS? And what benefits does it contain for you? What is Amazon RDS? Amazon Relational Database Service (Amazon RDS) is an Amazon Web Services managed SQL database service. Amazon RDS assists with database management chores like migrat ..read more
Visit website
SQL Performance Tuning: 7 Tips to Boost Your TSQL Queries
Red9 Blog
by Mark Varnas
9M ago
If you, like other software professionals, think that RDBMS settings can be left as default for improved SQL query performance tuning, then you are wrong.  Default RDBMS settings are far from being the optimal ones and not optimizing can result in performance issues. The good news, however, is that you can improve SQL query performance with little to no technical knowledge.  Despite being indispensable, SQL performance tuning is a rare skill for software teams to have. So, today I will let you know some essential techniques that never change to make your queries run faster in the Mic ..read more
Visit website
How to prevent SQL Injections
Red9 Blog
by Mark Varnas
11M ago
Being one of the top three most common web hacking techniques and most dangerous software weaknesses worldwide, it’s vital that your organization knows its implications and takes appropriate actions to address them immediately. It has been listed as number three in both the Common Weakness Enumeration (CWE) in 2022 and 2023, and in the Open Worldwide Application Security Project (OWASP) in 2021, where it was the top #1 in 2017. And there’s a reason for that: it is one of the easiest to exploit vulnerabilities due to the growth of internet-facing applications and the available tools and details ..read more
Visit website
SQL Server migration to Amazon RDS Strategies
Red9 Blog
by Mark Varnas
11M ago
We talked about availability and security best practices on Amazon RDS. Completing the series of posts, today we will learn about Migration on Amazon RDS using SQL Server. In this article, best practices will be defined for the Native Backup/Restore and AWS data migration service. But let’s first learn what Amazon RDS is. Why do you even need to migrate to Amazon RDS? And what benefits does it contain for you? What is Amazon RDS? Amazon Relational Database Service (Amazon RDS) is an Amazon Web Services managed SQL database service. Amazon RDS assists with database management chores like migrat ..read more
Visit website
SQL Performance Tuning: 7 Tips to Boost Your Queries
Red9 Blog
by Mark Varnas
11M ago
If you, like other software professionals, think that RDBMS settings can be left as default for improved SQL query performance tuning, then you are wrong.  Default RDBMS settings are far from being the optimal ones and not optimizing can result in performance issues. The good news, however, is that you can improve SQL query performance with little to no technical knowledge.  Despite being indispensable, SQL performance tuning is a rare skill for software teams to have. So, today I will let you know some essential techniques that never change to make your queries run faster in the Mic ..read more
Visit website
Amazon RDS: The complete guide for AWS Managed Instance
Red9 Blog
by Mark Varnas
11M ago
Looking for Amazon RDS (AWS RDS) SQL Server content? Step-by-step guides? Start here.  Basics: An introduction to Amazon RDS:  What is Amazon RDS? What is AWS RDS used for? Why do you want a managed SQL Server or relational database service? Is RDS SaaS? Discover how to get started migrating SQL to the cloud. Amazon AWS Storage Selection Guide for SQL Server:  Which AWS storage options work best for SQL Servers? S3 or Simple Storage Service? Which EBS volume types? Discover how to choose between S3, EBS, EFS and others. Migrate your on-premise SQL Server to AWS RDS: Learn about ..read more
Visit website
Main differences between MS SQL Server native backup and 3rd party tools
Red9 Blog
by Jose
3y ago
One of the essential responsibilities of SQL Server DBAs includes planning and implementing proper Backup and Recovery. There are various methods and tools for performing SQL Server backups, with each one having its advantages and disadvantages. Here is a bunch of text explaining that section. Here is a bunch of text explaining that section. Here is a bunch of text explaining that section. Here is a bunch of text explaining that section. SQL Server Native backups SQL Server has a built-in mechanism to automate regular database backups through maintenance plans or custom j ..read more
Visit website
Amazon RDS: The complete guide for AWS Managed Instance
Red9 Blog
by Jose
3y ago
Are you looking for Amazon RDS (AWS RDS) content? How to improve performance? Complete step-by-step guides? Best practices? Start on this page. The basic: An introduction to Amazon RDS:  What is Amazon RDS? What is AWS RDS used for? Why do you want a managed relational database service? Is RDS SaaS? Discover how to get started moving to the cloud. Amazon AWS Storage Selection Guide for SQL Server:  Which AWS storage options work best for SQL Servers? S3 or Simple Storage Service? Which EBS volume type? Discover how to choose between S3, EBS or EFS. Migrate your on-premise SQL Server ..read more
Visit website
New Blog Post Template
Red9 Blog
by red9red
3y ago
Here Is My H2 Header Here is a bunch of text explaining that section. Here is a bunch of text explaining that section. Here is a bunch of text explaining that section. Here is a bunch of text explaining that section. Here is a bunch of text explaining that section. Here Is My H3 Header Here is a bunch of text explaining that section. Here is a bunch of text explaining that section. Here is a bunch of text explaining that section. Here is a bunch of text explaining that section. Here is a bunch of text explaining that section. Here Is My H4 Header Here is ..read more
Visit website
Database Assessments
Red9 Blog
by Jose
3y ago
Bring your data to Red9 and ensure that your SQL Server infrastructure on-premise or on cloud is deployed in a way that is optimal for your needs. Our Database Assessments is a customized service focused on delivering bright pieces of evidence about the status of your database system performance and maintenance strategy. This is a proactive action to prevent possible issues and problems that may cause service disruption or downtime. It’s like having a firefighter putting out the fire before it becomes a forest fire. Our goal is to make it as easy as possible for you to understand. Understand h ..read more
Visit website

Follow Red9 Blog on FeedSpot

Continue with Google
Continue with Apple
OR