Dinesh Asanka
Dinesh Asanka started his carrier in the software industry in 1993 as a trainee programmer. Then he has worked for many organizations as a Software Engineer, Data Warehouse Engineer, Database Designer, Data Architect, Senor Database Specialist and Senior Architect.
Dinesh has Bachelors of Science in Electrical Engineering from University of Moratuwa, Sri Lanka and an MBA in Information Technology, Masters of Science in Artificial Intelligence from the University of Moratuwa Sri Lanka. Currently, he is working towards a Masters on Fuzzy Data warehousing.
Dinesh is a visiting lecturer at Sri Lanka Institute of Information Technology, University of Moratuwa, University of Ruhuna, and the Institute of Information Technology for subjects such as Data Management, Data Science, Big Data Analytics and Database Administration.
Dinesh is also a presenter at Colombo Big Data Community, Sri Lanka Institute of Artificial Intelligence, sqlSaturday, DevDay, IEEE etc.
Dinesh Asanka is also a frequent columnist in many popular SQL Server web sites.
Dinesh is keen on research areas such as Databases, Data Mining, Data Science, Big Data, Artificial Intelligence, etc.
2018 Awards

- SQL Server Analysis Services SSAS Hardware Configuration Recommendations (last update: 4/29/2019)
- Create Key Performance Indicators KPI in a SQL Server Analysis Service Cube (last update: 5/31/2019)
- Migrating On-Premises Microsoft SQL Server Business Intelligence Solution to Azure (last update: 9/17/2019)
- Infrastructure Planning for a SQL Server Data Warehouse (last update: 1/23/2019)
- SQL Server Attach and Detach Database Examples (last update: 1/8/2020)
- Why Surrogate Keys are Needed for a SQL Server Data Warehouse (last update: 7/24/2018)
- Create an Extended Date Dimension for a SQL Server Data Warehouse (last update: 7/31/2018)
- Monitoring SQL Server Analysis Services with Extended Events (last update: 7/30/2019)
- Loading Historical Data into a SQL Server Data Warehouse (last update: 6/6/2018)
- Script to Create and Update Missing SQL Server Columnstore Indexes (last update: 10/26/2018)
- SQL Server Clustered Index Behavior Explained via Execution Plans (last update: 8/28/2018)
- How to Retry SQL Server Integration Services Control Flow Tasks (last update: 12/6/2018)
- SQL Server Integration Services CDC Tasks for Incremental Data Loading (last update: 3/21/2019)
- SQL Server Maintenance Plan Index Rebuild and Reorganize Tasks (last update: 5/14/2019)
- Understanding SQL Server Recovery Models and Transaction Log Use (last update: 4/2/2018)
- SQL Server Resource Governor Configuration with T-SQL and SSMS (last update: 7/9/2019)
- Generic Approach to Identify Modified SQL Server Rows (last update: 1/30/2018)
- SQL Server Temporal Tables Overview (last update: 11/16/2018)