Main differences between MS SQL Server native backup and 3rd party tools
Red9 Blog
by Jose
1y 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
1y 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
1y 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
1y 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
SQL Monitoring Software Tools
Red9 Blog
by Jose
1y ago
You don’t do monitoring? Wait… What? Well, that won’t work for me. Moving on. 3rd party SQL Software tools:  Red-Gate – I have heard good things. Never used it in a real world situation, so I can’t tell you much.Idera SQL Diagnostics Manager – this isn’t the best tool for monitoring. I’ve run into three DBAs that say “its great”. Every time, I thought I was missing something, but sadly in all cases those DBAs where just using defaults, and have not used monitoring to the level I am describing here. And that’s just not good enough (sloppy, in my book). After countless calls with ..read more
Visit website
SQL Server High Availability
Red9 Blog
by Jose
1y ago
If you need to introduce a high availability solution for one of your SQL Server databases, then there’s lots of confusion as to what it the right option for you. Given the number of options available it may make you unsure which implementation will meet the needs of your business. Review these tips to learn about the five high availability choices of the native SQL Server. SQL Server High Availability Solutions Finding the right high availability option can be difficult. Which option is right for you can depend on the following: Budget – first and foremost can you afford the HA solution ..read more
Visit website
Installing SSDT (SQL Server Data Tools) 2019
Red9 Blog
by Jose
1y ago
The Business Intelligence platform has been changing on each new version. In the beginning, it was part of the SQL Server setup, and then since SQL Server 2014 started to be distributed separately. Also, the name of this tool and its installation method started to vary from version to version of Visual Studio (VS). For installing the SQL Server Data Tools 2017, you need only download and execute. However, everything has changed in the 2019 version. This post aims to show all the processes of installing and configuring the SQL Server 2019 Business Intelligence development environment. Download ..read more
Visit website
How to fix Recovery Pending State in SQL Server?
Red9 Blog
by Jose
1y ago
This post will explain why a database operates in a RECOVERY PENDING state and show you some Methods to Fix it. These are technical processes. If you do not have the confidence to settle this problem, you can use our emergency SQL Support to help you do it in a simple and effective way. How to Check Database State? A Microsoft SQL Server database is always in one specific state. Identifying the database state and how a database can be moved between these different states will help you troubleshoot and fix many database problems and issues. These states include ONLINE, OFFLINE, RESTORING ..read more
Visit website
Case study – Tuning a slow report
Red9 Blog
by Jose
1y ago
Problem summary A report was taking a long time to complete. It was also causing deadlocks during the execution. What was done We started monitoring the SQL Server environment. A comprehensive methodology was applied to look at various levels SQL depended on: CPU, RAM, networking, storage, VMWare setup, Windows Operating System settings, and few more areas. It may seem like overkill to look at all the layers, but Red9 practices prove that comprehensive analysis is effective. Especially when stability and speed matter. After investigation, we created 3 indexed views, which helped to keep the da ..read more
Visit website
Best practices for SQL Server Installation
Red9 Blog
by Jose
1y ago
SQL Server installation does not often repeat, especially if you are using on-premises servers. In this article, you will see a few settings that are recommended to be reviewed after the SQL Server installation checklist. Preparation If possible, start with a freshly installed OS and install the latest drivers. Check if BIOS power management is disabled or set to OS control. Validate hardware compatibility with SQL Server prerequisites: Allocate an adequate amount of CPUs and RAM based on your estimated workload. Provision adequate disk space and set up correctly the Storage: Ensure that ..read more
Visit website

Follow Red9 Blog on Feedspot

Continue with Google
OR