The Farber Consulting provide database services such as: SQL Consulting and Remote DBA. Some of our consultants have more then 30 years of experience including MS MVP. See below some of our services that we provide to our clients and some case studies to support that.
Data Modeling, Data architecture (Oracle, SQL server, MySQL, AWS, SQL Azure.)
Encryption and security
Fault tolerance and High Availability
Master slave replication
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 primed for performance
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 features. The cost for poor design, is an implementation with a great expense of performance.
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 few options, but always something was 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 DBA work, you need two radically different skills
In both cases we need to be extraordinarily organized and scientific about approach.
Recurring mystery. 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 SQL sentry monitoring system there was no “smoking gun” that we could point to. Eventually, we narrowed it down too 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 CPU was a result of the first two. With this data we started looking for what changed on network/disk and found that one of the disks was changed to iSCSI. Culprit identified!!
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.
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. A 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 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 the stored procedure, triggers and views. When dealing with complex databases, it's essential to have good documentation, the tool that we use for the last 19 years is called xCase and definitely this way we get a global view of the entire model and quickly can pick up any draw back in the design.