Navicat Blog

May 2, 2018 by Robert Gravelle

Microsoft SQL Server is more than 30 years old now, and remains one of the most popular commercial relational databases in use today. It runs very efficiently with only minimal tweaking, but can also be tuned for optimal performance. Before fine tuning your SQL Server database, you first have to monitor its performance over a broad spectrum of conditions and workloads. In today’s tip, we’ll review a few of the most instructive metrics to monitor in order to gauge server performance.

April 24, 2018 by Robert Gravelle

One of the numerous significant changes to MySQL Server for version 8 includes a new component-based infrastructure. That will make the architecture more modular while allowing users to extend server capabilities through the addition of individual components.

Each component provides services that are available to the server as well as to other components. In fact, the server itself is now considered to be a component, equal to other components. Components interact with each other only through the services they provide.

April 17, 2018 by Robert Gravelle

In these turbulent times, encrypting your sensitive data only makes sense. The question is not so much whether to encrypt, but rather, which method of encryption to employ. There are several options, the three main widely used database encryption methods being:

April 10, 2018 by Robert Gravelle

In last week’s Getting Advanced Row Counts in MySQL (Part 2) blog we employed the native COUNT() function to tally unique values as well as those which satisfy a condition. In today’s final third instalment, we’ll learn how to obtain row counts from all of the tables within a database or entire schema.

April 4, 2018 by Robert Gravelle

In last week’s Getting Row Counts in MySQL blog we employed the native COUNT() function’s different variations to tally the number of rows within one MySQL table. In today’s follow-up, we’ll use the COUNT() function in more sophisticated ways to tally unique values as well as those which satisfy a condition.

Navicat Blogs
Feed Entries
Share
Blog Archives