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.)
2. Encryption and security
3. Log shipping
6. DB partitioning
7. Service Broker
8. Fault tolerance and High Availability
10. Master slave replication
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
Data Optimization and Cleansing
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. The cost of poor design is implementation at the expense of performance. Database design and data modeling is like the blue of your application.
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 manufacture steps were properly represented, accounted for and tracked. System output increased 5-fold along with a significant improvement in product quality.
When it comes to Remote DBA work, you need two radically different skills
In both cases we need to be extraordinarily organized and scientific about the approach, in order for database optimization to be assured.
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 consulting you want in your corner.
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.
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 the a sweat!
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.
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.
The Farber Consulting Group is proud to offer both 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.