Join Our Group Online!
PASS Business Analytics 2016 Conference San Jose, CA May 3-4
PASS Summit 2016 Seattle, WA October 24-28
St. Louis SQL Server User Group Meeting
December 8th 1:00 pm- 4:00 pm cdt
Grant Fritchey, SQL Server MVP, works for Red Gate Software as Product Evangelist. In his time as a DBA and developer, he has worked at three failed dot–coms, a major consulting company, a global bank and an international insurance & engineering company. Grant currently serves on the Board of Directors for the PASS organization of data professionals. He is the author of the books SQL Server Execution Plans (Simple-Talk) and SQL Server Query Performance Tuning (Apress). Grant earned the nickname “The Scary DBA.” He even has an official name plate, and displays it proudly.
Abstract: Automating Database Deployments
Deploying your database changes to production can be nerve-wracking. We'll discuss methods that take the stress out of the process by ensuring that you practice your deployments using continuous integration before you ever get near production. Automating the deployment and testing processes through your testing and pre-production environments can make the whole experience of production deployments more repeatable, more reliable and more robust.
In this session, we'll explore the concepts of continuous integration and continuous delivery for databases – what to consider, the challenges, the benefits, the testing, and the crucial approval gates necessary for a reliable production deployment. We'll discuss these and other release strategies as you think about how to evolve your deployment pipeline towards a more automated approach, starting with continuous integration and ending at your production systems.
Clayton Hoyt MCDBA, MCPD, has over 21 yrs. of IT experience and began working with SQL Server 6.5 in 1998. He currently is a Senior SQL Server DBA at a private investment firm in Clayton Missouri. In addition to teaching SQL Server in a classroom setting, he has had the opportunity to speak at Day of .NET in 2014 on the topic “SQL Server and the .NET Developer”. He presented globally through a web-casted IT symposium in 2004 held at the Millennium Conference Center in St. Louis on the topic of “Hardening SQL Server”. In addition to his public speaking, he has published 2 articles on the topic of Electronic Medical Records in the Chiropractic Practice.
Abstract: Temporary Objects
This lecture will discuss temporary objects with an emphasis on the differences between temporary tables and table variables. Discussing the pros and cons of when each is best used and more importantly avoided. Temporary stored procedures and temporary views in the form of CTEs will also be touched upon if time permits.