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.

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 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)

Microsoft Access Integration

Convert MS Access to SQL Server with Always Encrypted Database (last update: 3/20/2020)

Scripts

Save SQL Server Database Structure as Json (last update: 1/13/2020)

T-SQL

Using SQL Server ROLL UP to Get Similar Results of COMPUTE BY (last update: 9/10/2020)