What Are Natively Compiled Stored Procedures? These procedures are a new feature introduced in SQL Server 2014 that allows for faster and more efficient execution of queries and business logic that access memory-optimized tables. Memory-optimized tables are tables...
Welcome to our blog, which is more than just a record of our experiences. It’s a resource.
Our blog is an invaluable resource for anyone struggling with the challenges of managing a database, applications, or clouds.
We understand the difficulties involved in troubleshooting, building, improving, securing, and operating these platforms,
and we’re here to share our insights and expertise with you. Browse through our collection of blog posts below,
and don’t hesitate to leave your comments and feedback.
NORETRIEVE Option for Db2 ROLLFORWARD in Data Loss Event
The NORETRIEVE parameter of a Db2 ROLLFORWARD command is a powerful tool that can be used to recover data from a database during a disaster or other data loss event. When the NORETRIEVE parameter is specified, Db2 will roll forward the database to a defined point in...
Introducing db2pdtop.pl
When monitoring CPU utilization on a Db2 server, each Db2 instance generally has a single db2sysc process (per database partition) consuming CPU on the server. The db2sysc process is made up of many threads. While it's possible to see CPU utilization of each thread...
Overcoming the Top 15 Challenges of Oracle Database Migration to the Cloud
As more and more businesses move their operations to the cloud, one of the most common challenges faced is migrating existing on-premise Oracle databases to the cloud. While this move can bring significant benefits, such as increased scalability, flexibility, and cost...
Informix or Db2: Which Database is Right for Your Business?
Choosing the right database for a business can be a critical decision that impacts the organization's overall success. In this blog post, we will explore the differences between Informix and Db2 databases and the factors to consider when choosing between them....
One-way SSL Configuration Steps
With the increasing need for security in data transfer, MySQL provides an option for enabling SSL/TLS encryption to secure communication between the client and the server. SSL (Secure Sockets Layer) and its successor TLS (Transport Layer Security) use a combination of...
10 Tips for Securing MySQL Database
MySQL is one of the most widely used relational database management systems in the world. With its popularity comes the need to ensure the security of the data it manages. Below are some tips for securing a MySQL database. 1. Use Strong Passwords Passwords are the...
Why You Need XTIVIA’s Virtual-DBA SharePoint Services to Manage Your SharePoint Systems
SharePoint is a powerful platform for managing and sharing data, documents, and information within organizations. However, managing SharePoint systems can be complex and time-consuming, especially if you don't have in-house expertise. This is where XTIVIA's...
10 MongoDB Mistakes Companies Should Avoid
MongoDB is one of the most popular NoSQL databases for modern web applications. It is designed to be scalable, flexible, and easy to use. However, like any technology, it is not immune to misuse or abuse. In this article, we will discuss the top 10 things a company...
Azure SQL Database, Managed Instances, and Virtual Machines
Microsoft Azure offers various database management options for organizations based on their specific requirements. There are three primary SQL database offerings: Azure SQL Database, Azure SQL Managed Instance, and SQL Virtual Machines (VMs). In this blog post, we...