Mircea Dragan
Mircea Dragan is a Senior Computer Scientist with strong mathematical background, and extensive industrial and academic experience in domains including data security, fraud detection, anomaly detection, big data, event processing in streaming applications, database management, database migration and real time processing. Mircea has 18 years of hands-on programming experience in large international projects, as individual contributor, team member and team leader. He is also an experienced speaker, especially for academic audiences.
2020 Awards
2020 Awards
Comparison Data and Objects
- Compare SQL Server Databases - Part 2 (last update: 6/29/2020)
- How to Compare Database Schema in SQL Server - Part 1 (last update: 5/26/2020)
- How to Sync Two SQL Server Databases – Part 3 (last update: 7/28/2020)
Import and Export
- Export Data from SQL Server to Excel and Simulate COMPUTE BY Clause (last update: 5/20/2021)
- Export SQL Server Data to Excel and Add New Columns with C# (last update: 3/26/2021)
- Export SQL Server Data to Multiple Excel Worksheets with C# (last update: 11/18/2020)
- Export SQL Server Table to Excel with C# (last update: 10/28/2020)
- Import multiple Excel Worksheets into multiple SQL Server Database Tables (last update: 1/13/2022)
Microsoft Access Integration
- Convert MS Access to SQL Server with Always Encrypted Database (last update: 3/20/2020)
Microsoft Excel Integration
- How to Make a Chart in Excel from a SQL Server Database (last update: 1/6/2021)
Scripts
- Save SQL Server Database Structure as Json (last update: 1/13/2020)
TSQL
- Using SQL Server ROLL UP to Get Similar Results of COMPUTE BY (last update: 9/10/2020)
