How tSQLt can help build unit tests

"tSQLt" is a unit testing framework for SQL Server. In real-world scenario
there are customers with their QA team subject to run nearly 50 distinct
simple to complex TSQL statements as part of their testing. In order to
complete a test case they are subject to run multiple TSQL statements manually, take the result set from one query and either a column value, or based on the result set, modify the 2nd query before running and reviewing its result set. They literally have to do this one hundreds of databases. How can we make it easier for the team performing
this laborious manual task? "tSQLt" is one such solution that can accomplish it.
Let us explore "tSQLt" as to what it is, what it can do and how it can be integrated into CI/CD pipelines.

6pm - 6:30pm - Dinner, networking, setup
6:30pm - 8pm - Presentation

Dinner and venue provided by Robert Half ([https://www.roberthalf.com/us/en/locations/ca-sacramento/2180-harvard-st](https://www.roberthalf.com/us/en/locations/ca-sacramento/2180-harvard-st))

Speaker:
Saru Radhakrishnan

Saru Radhakrishnan is a member of the Sacramento SQL Server Group for almost a decade. Saru is a Microsoft Certified Professional (MCP) and has 3+ decades of experience in the roles ranging from SQL Server Database Administrator, Architecture and Database development.
He specializes in performance tuning, implementation of high availability SQL Server Platform using Always On and Azure cloud-based SQL Server implementation (IAAS, PAAS).

He can be contacted at [email protected](http://[email protected])
and his linked-in profile is (https://www.linkedin.com/in/saravanan-saru-r-62b4602/).

Host or Publisher Meetup Events