OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Nat Sundar

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 writes at https://sqlnat.wordpress.com/. He can be contacted via LinkedIN and on Twitter at @SQLNat.
Nat Sundar
06 April 2017
Nat Sundar
06 April 2017

Comparing SSIS Catalog Contents Using DBFit Framework

8
When you are doing the rapid deployment of an updated SSIS project, there are a number of things you have to check to make sure that the deployment will be successful. These will include such settings as the values in environment variables, Package parameters and project parameters. The DbFit test framework turns out to be ideal for the purpose of doing final checks as part of a deployment process, as Nat Sundar demonstrates.… Read more
8
Nat Sundar
08 March 2017
Nat Sundar
08 March 2017

Using the DbFit Framework for Data Warehouse Regression Testing

12
It is ironic that the users of database application need to rely on the very technologists that created the system to then devise and run their acceptance tests. Surely someone has devised a test system for databases that is simple enough for ordinary tech-savvy people to use and for them to create the tests? Yes they have. Fitnesse DbFit is a mature product that can, and does, test SQL Server databases, and Nat Sundar explains how to set it up and do it.… Read more
12
Nat Sundar
12 January 2017
Nat Sundar
12 January 2017

Deployment Automation for SQL Server Integration Services (SSIS)

14
SSIS was not originally designed with automated deployment in mind. However, any database that uses SSIS projects and their packages needs a way of scripting the deployment of them if the database is to be deployed rapidly, or via a build server. Nat Sundar shows a technique that can be extended to manage the scripted deployment of SSIS projects. … Read more
14