Nat Sundar
Nat Sundar is working as an independent SQL BI consultant in the UK with a Bachelor’s Degree in Engineering. He has considerable years of experience with the UK Financial Services Industry (mainly in Insurance and Investment Banking).
He is passionate about SQL Server, SSIS, SSAS, SSRS and MDX. He has presented at SQLBits, SQLPass and the SQL London User Group. He has special interest towards Continuous Integration, Continuous Delivery and Deployment automation for the SQL BI (SSIS, SSAS and SSRS) stack.
He can be contacted at [email protected], via LinkedIN and on Twitter at @SQLNat.
2018 Awards
2017 Awards
2016 Awards
Application Development
- Getting Started with Scrum for SQL Server Development Projects (last update: 1/13/2017)
Data Science
- Beginners Guide to Python for SQL Server Professionals (last update: 5/24/2018)
Database Administration
- SSIS Package for Automated Code Deployment of SQL Server Database Changes (last update: 1/2/2017)
DevOps
- Getting Started with GitHub for SQL Server Developers (last update: 12/20/2018)
Import and Export
- Different Ways to Import JSON Files into SQL Server (last update: 3/1/2018)
- Import and Export VARCHAR(MAX) data with SQL Server Integration Services (SSIS) (last update: 11/6/2017)
- Import Nested JSON Files to SQL Server with SSIS (last update: 4/10/2018)
- Importing Complex JSON files using SQL Server Integration Services (last update: 4/26/2018)
Integration Services Administration
- Deploy Multiple SQL Server Integration Services SSIS Projects Using C# (last update: 12/11/2017)
- Deploy SQL Server Integration Services Projects to Multiple Environments Using C# (last update: 12/22/2017)
- Deploy SQL Server Integration Services SSIS Projects Using C# (last update: 11/17/2017)
Integration Services Control Flow Transformations
- Search for Multiple File Extensions with the SSIS Foreach File Enumerator (last update: 2/14/2017)
Integration Services Development
- Data Sampling in SQL Server Integration Services (last update: 12/20/2016)
- Debugging Control Flow in SQL Server Integration Services - Part 1 (last update: 11/24/2016)
- Debugging Control Flow in SQL Server Integration Services – Part 2 (last update: 12/6/2016)
- Defining Workflow in SSIS using Precedence Constraints (last update: 3/20/2017)
- Developing a File Watcher Task for SQL Server Integration Services (last update: 2/2/2017)
- Importing JSON Files Using SQL Server Integration Services (last update: 3/23/2018)
- Metadata Driven SQL Server Integration Services Data Flow Transformations Using BIML (last update: 11/8/2016)
- Metadata Driven SQL Server Integration Services ETL Development Using BIML (last update: 10/26/2016)
- SSIS Variable and Expression Example - Part 1 (last update: 12/28/2016)
- Using BimlScript to Increase SQL Server Integration Services (SSIS) Productivity (last update: 10/19/2016)
Partitioning
- Implementation of Sliding Window Partitioning in SQL Server to Purge Data (last update: 2/22/2018)
Power BI
- Analyze UK Petition Data Using Power BI (last update: 1/18/2018)
- Analyzing Multiple Pages of UK Petition Data Using Power BI (last update: 1/31/2018)
- Analyzing Multiple Personal Accounts using Power BI (last update: 8/22/2017)
- Analyzing Personal Finances using Power BI (last update: 7/14/2017)
- Analyzing Personal Finances with Power BI - Expenses Versus Budget (last update: 7/24/2017)
- Calculating MTD, QTD, YTD, Running and Cumulative Total in Power BI (last update: 5/31/2017)
- Creating a Date Dimension Table in Power BI (last update: 5/24/2017)
- Creating Custom Maps to Display Data with Power BI (last update: 2/13/2018)
- Design Patterns for Calculated Tables in Power BI (last update: 6/20/2017)
- Power BI use case - Developing a Personal Finance Calculator (last update: 7/6/2017)
Professional Development Career
- Data Science for SQL Server Professionals (last update: 5/14/2018)
Python
- Data Science: Cleansing Your Data Using Python (last update: 6/5/2018)
Reporting Services Administration
- Accessing SQL Server Reporting Services Data Using PowerShell (last update: 5/18/2016)
- SQL Server Reporting Services Data Source Deployment Automation with PowerShell (last update: 8/31/2016)
Reporting Services Development
- Implement Continuous Delivery for SQL Server Reporting Service Reports (last update: 10/6/2016)
