boB has been involved in software development since 1972 when he started programming (FORTRAN 66 on Hollerith punch cards). During his eighteen-year tour of duty in the U.S. Marine Corps he programmed on a magnetic drum based computer system. In 1993 he started working with SQL Server 4.2.1 and has developed, tuned and administered every version since. During his 12+ years at Microsoft he has focused on SQL Server – Microsoft Partner Advantage, Premier Field Engineering, he was the PM for the Certified Master and Certified Architect program, Premier Developer and currently is a Data Platform Solution Architect in the Health and Life Sciences vertical.
Prior to Microsoft, he was Director of Database Technologies for Avanade’s West Region and before that Vice President of Sun Healthcare Systems.
Additionally, he holds the MCA, MCM, MCSM, MCSE, MCSD, and MCT certifications and Microsoft Data Scientist and Big Data Professional Degrees. He helped develop 10 certification exams in the SQL Server and .NET space over the years.
Using DACFx to solve real-world problems
In a cloud-first world, DB DevOps are critical, not only from a functional perspective but even more from both scalability of operations and availability perspectives. Here are some of the challenges faced by SaaS ISVs and enterprises using Azure SQL DB or SQL Server: – How do you minimize downtime due to database schema changes? – How do you deploy at scale across hundreds or thousands of databases? – How do you ensure end-to-end security at the DB layer regardless of the type of the query? SQL Server offers some great DB DevOps capabilities with SSDT and SQLPackage. Underlying these are the SQLDOM parser and the DACFX libraries. I will showcase the power of these libraries by using some real-world use cases (with demos!), each of which was encountered in direct customer engagement by the SQLCAT team and field counterpart.