There are tools available from Microsoft, as well as from a number of third party vendors, to ease the process of integrating database unit testing into your development environments and your continuous delivery pipeline.
This session isn't about any of those tools, but is an attempt to get back to basics - with the open source tSQLt framework - and address questions such as:
No particular experience of automated testing is required, we'll be talking about database testing "from the ground up". A good grasp of Transact-SQL constructs will be helpful in understanding the examples.
Do you work for an institution that fears its DBAs could go rogue on their production databases?
Do you want to revoke continuous sysadmin permissions from your DBA team in an attempt to avoid being the next WikiLeak?
Do you have concerns that the DBA team is querying sensitive databases?
Then you need Uptight Database Security. Come to this session to learn how to deploy a configurable permission model that provides on-demand access to SQL Server databases. This model allows DBAs to do routine work without sysadmin, and elevate permissions to sysadmin only during production emergencies or disaster recovery scenarios.
Attendees will leave this session with the fundamental knowledge and scripts to implement a low hassle solution that provides DBAs the minimum necessary access required to maintain a production database server.