I’ve been using Visual Studio with SQL Server Data Tools (SSDT) to develop and maintain SQL Server databases since 2008 for top companies in oil & gas, healthcare, and defense industries.
The databases I created included complex features that SSDT helped implement during development:
- Expert analysis system
- Bi-temporal insert-only
- Forecasting Activity-Based-Costing
- Multi-level hierarchy rollups
- Integrated Meta-Numerics C# CLR in SQL Server (https://github.com/dcwuser/metanumerics)
