Kevin Feasel

Kevin Feasel

Kevin Feasel is a Microsoft Data Platform MVP and CTO at FareGame Inc, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (, president of the Triangle Area SQL Server Users Group (, and author of PolyBase Revealed ( A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.

CTO @ FareGame Inc


(Login to save favorite sessions)

Optimizing Backup Performance using Data Science Techniques

One of the most important tasks for a database administrator is taking (and testing!) backups. As databases get larger and larger, the amount of time it takes to perform a backup can grow as well, to the point where your backups take longer than your available backup window. There are several settings we can use to optimize backup performance, such as buffer counts, maximum transfer size, and the number of files, but trying every combination of settings on a single production-sized database could take weeks or even months. In this talk, we will apply data science techniques to the problem of backup settings optimization and look at different models for approaching the problem and analyzing data. Some statistics background would be helpful, but is not required; the big requirement is a desire to speed up backups.

Van Halen
4:30 PM
Live session URL