Remote DBA for MS SQL, MySQL, Oracle and use it only when you need it

Remote DBA for MS SQL, MySQL, Oracle and use it only when you need it

The Farber Consulting Group provides database services such as: SQL Consulting and Remote DBA services. Some of our consultants have more than 30 years of experience including MS MVP. See some of our services that we provide to our clients and some case studies to support that in the below article.

1. Data Modeling, Data architecture (Oracle, SQL server, MySQL, AWS, SQL Azure.)

• - Transnational relational database modeling and design
• - Designing a consistent DB API
• - Integrating structured and non-structured data
• - Data model as a key to your business success
• - Building a scalable able data platform
• - Database optimization for speed and accuracy

2. Encryption and security
3. Log shipping
4. Replication
5. Mirroring
6. DB partitioning
7. Service Broker
8. Fault tolerance and High Availability
9. AlwaysOn
10. Master slave replication

Database Programming (Oracle - PL/SQL, SQL server - T-SQL, MySQL, AWS, SQL Azure.)

Our MySQL or MS SQL consulting firm offers the following benefits to your organization:

• Best practices consulting and implementation.
• Stored Procedures, functions, triggers etc.
• DB Queue programming (Service Broker).
• processing XML data
• Error handling in procedures and functions.
• Interacting with the application layer.
• ORM - (Object-Relational Mapping) primed for performance
• CLR programming.
• Data Optimization and Cleansing.

Data Modeling and Database Design Services

Some people think that Data Modeling is only for data warehouses. In reality, it’s primarily for transnational systems because if you don’t create a proper model, your application will not be able to implement all of the features properly. Think of the database design and data modelling as the blueprint for your application. You need the design to be done well in order to reap all of the benefits of the professionally developed application.

Case study - Move from minimum viable product to a production system

An advance integrated circuit manufacturer with a patented technology needed to move from minimum viable product to a production system. For that purpose, they need to keep track of each step of chip manufacture, system build out, etc. Without a proper database model, they simply couldn’t proceed. They tried a few options, but something was always missing or not working properly. With our assistance all manufacturing steps were properly represented, accounted for and tracked. System output increased 5-fold along with a significant improvement in product quality.

Database Administration Services

When it comes to Remote DBA work, you need two radically different skills:

1. Forward-looking / designer skills that enable us to build resilient systems that are resistant to failure
2. Archeologist / investigator skills that enable us to analyze a problem, get to the root cause and identify the change that caused it.

In both cases we need to be extraordinarily organized and scientific about the approach, in order for database optimization to be assured.

Case Study - Intermittently recurring performance problem

Consider this recurring mystery to understand the importance of database optimization. Once upon a time on an SQL server far away, there was an intermittently recurring performance problem. It would come and go at seemingly random intervals, and there seemed to be no reason to it. Just a sudden slowdown that went away after some time. Even with historical data from an SQL sentry monitoring system there was no “smoking gun” that we could point to. Eventually, we narrowed it down to a few factors and had to perform co-variance analysis on historical data, thereby discovering a hidden relationship between network, disk, and CPU utilization. It was clear that the CPU issue was a result of the first two. With this data, we started looking for what changed on the network/disk and found that one of the disks was changed to iSCSI. Culprit identified! Now that is the kind of MySQL remote dba consultant you want in your corner.

Database Programming

Some people think that a database should be purely a data storage device. So much so that they don’t allow development of stored procedures and functions. But, the truth is that for a performance application you want to do as much manipulation as possible close to data - on the database server. With databases getting more and more sophisticated we can even implement asynchronous processes that truly push the edge. Don’t trust your SQL consulting to a team that doesn’t fully understand how vital your database is to all of your company’s other systems.

Case Study - Service Broker Queues as a Solution

Here is a perfect example of burst performance optimization. This happened on an SQL server-based system that was used to process various events. Sometimes events would overwhelm the system, slowing down the entire platform. At other times, events would slow to a trickle, wasting capacity. What was our solution? Service Broker Queues. With a bit of tinkering, we were able to refactor the system to allow asynchronous handing off of events. Event ingestion rate went up to 1.5 million/s and all related components were no longer tied to SQL Server performance. As for the database itself, it was able to function at its theoretical peak throughput (approximately 40K transactions/s) to process all events without breaking a sweat!

Reverse database Engineering

In many cases we get the database from a new client, but we do not have the E-R diagram or the actual physical model. Reverse database engineering allows us to re-create the model from an existing schema and extract any info for the relations between the tables, the indexes per each table, and the stored procedure, triggers, and views. When dealing with complex databases, it's essential to have good documentation. The tool that we have used for the last 19 years is called xCase, and this way we get a global view of the entire model and quickly can pick up any drawback in the design.

Why Convert MS Access to Web?

The modern business world takes place mostly in the cloud. This allows for fewer onsite servers and less in-house need for IT support. The remote DBA services provided by the Farber Consulting Group are perfect for forward-thinking businesses like yours who want to stay on the cutting edge.

When you convert MS Access to Web – effectively taking your database and putting it in the cloud – you take your productivity to a whole new level. Now your team can work from the office, from home, or even while traveling. Your sales team and your clients can get instant access to key parts of the database that provide necessary information such as whether an order has been filled or what your present inventory looks like.

Remote DBA Services and More in NY, NJ, and Beyond!

The Farber Consulting Group Inc. is proud to offer both MySQL remote DBA and MS SQL Remote DBA and onsite SQL consulting services in New York and New Jersey. But you don’t have to operate in the area to take advantage of our remote DBA services and our experience in database optimization. To learn more, call us today at 732-536-4765.