Prairie.Code() Sessions tagged sql

SQL Server DevOps

In this session, we'll start from the beginning and discuss the decisions you need to make when deciding how you want to build and deploy SQL Server schema changes. We'll talk about Migration vs Model based approaches and the pros and cons of both. We'll discuss common gotcha's and review the workflows I've gone through to get to a successful build and deploy pipeline up and running in no time (including a SQL Server database that got its start over 25 years ago).

Speaker

Scott Sauber

Scott Sauber

Professional Software Consultant, Lean TECHniques

Document databases vs. Relational Databases: An honest comparison and things to consider

Many developers still struggle to understand which application scenarios might benefit from utilizing a document database or a relational database. Both of these options are powerful and many vendors have great products ready to build on. Unfortunately not one size fits all and there are definite scenarios where choosing one or the other will give your application architecture a leg up. There are also scenarios where a hybrid of using both a document database and a relational database might be the best choice.

We will discuss the benefits and tradeoffs of each option, how they differ, and give real-world design tips to consider when building on either. We will also discuss the current options available for database platforms in both the relational and document DB space. Many examples of real code and architectures will be given.

Speaker

Kevin Grossnicklaus

Kevin Grossnicklaus

President, ArchitectNow