SQLBits 2019

Getting your Database off to a Right Start

Start your database off right so you can scale when you need to
When you create a new database and your database objects do you ensure you have done everything you can to give it the chance to shine when things get tough? How many times have you seen objects created with all the defaults and down the road it becomes out of control due to the size, amount of data or even activity? If you really want to ensure your database and the objects contained in it can scale and perform well as it grows you need to do the proper homework before you ever create the database. We will walk thru the various factors that affect performance and scalability under real life conditions and help you understand how to properly configure them up front to avoid issues down the road. Scalability is all about having a proper foundation to build on.