One of the primary challenges Western Cooperative Electric has faced was the necessity to process large amounts of data from numerous sources. In particular, the team needed to consolidate 15-minutes interval read data for 12,000 electric meters for a period of 3 years. This consolidation was necessary to build a model to compare the current billing structure for electric usage to the rates implemented after a Cost of Service Study. The primary needs were:
The default SQL Server Management Studio and VS Code did not satisfy the experts’ requirements. Western Cooperative Electric needed a more powerful, flexible, and inclusive tool to provide all the necessary functionality. After searching on the Web, the team chose dbForge Studio for SQL Server for its code completion features, database documentation module, and robust database search capabilities.
dbForge Studio for SQL Server has proven to be the most efficient solution to resolve all the tasks set by the company with its convenient and user-friendly interface for SQL coding, auto-completion feature, and the possibility to execute queries against the existing databases.
The team uses this IDE to create complex database models for any scenario. It allows composing any SQL query, from the simplest to the most complex stored procedures. The data is processed to provide meaningful calculations to the managers.
It is more than just a database-centric solution for coding tasks. dbForge Studio for SQL Server has other tools that helped the developers speed up coding on the fly. It improves productivity and allows the developers to focus on other projects. Without dbForge Studio for SQL Server, the developers had to build large models in Excel and SSMS. Now, the company is able to significantly shorten the time to create such models.