Rackspace helps maximize virtualization advantages!
This blog explains how to move a Microsoft® SQL Server® database hosted on-premises (or on Amazon® EC2 or Azure®) to Amazon Relational Database Service (RDS). This move requires backing up your SQL database to an AWS S3 bucket and restoring the database on your AWS RDS instance from that S3 bucket.
Oracle® version 220.127.116.11 has incorporated two new features based on Hub and Leaf node architecture. The new features are:
- Flex Cluster
- Flex Automatic Storage Management (Flex ASM)
This blog compares Amazon Web Services to the Oracle Cloud, which is an infrastructure-as-a-service offering, and explores the features and services that both the providers support.
This post discusses how to set up log shipping, which is a disaster recovery (DR) solution, with existing Microsoft® SQL Server® AlwaysOn-configured databases.
This blog covers the essentials of how to use the advanced security option to secure sensitive data within an Oracle® database by using Transparent Data Encryption (TDE). This feature enables you to encrypt database columns and manage encryption keys.
Microsoft® SQL Server® Query Store, as the name suggests, is like a store that captures the database history of executed queries, query runtime execution statistics, and execution plans. Because the data is stored on a disk, you can retrieve the query store data anytime for troubleshooting purposes, and SQL Server restarts do not affect the data. Use Query Store, which was introduced in SQL Server 2016 and is available in all later editions, to troubleshoot performance issues caused by query plan changes.
No matter how good our code is, if we cannot test it properly, it is a tedious task to modify or enhance it. This situation results in problems for both users and developers.
The blog describes corruptions that can occur at the database level in Microsoft® SQL Server®, how to detect them, and how to correct them by using advanced restore and repair techniques.
Database backup and recovery is one of the crucial day-to-day activity that a database administrator (DBA) performs. A database backup is the copy of your data that can be used to recover the data in the event of data loss.
This blog shows you how to backup Apache® Cassandra® databases and restore them after a failure.