Boyd Evert, IT Director, A/P Recovery
Boyd is IT Director at A/P Recovery located in Charleston, South Carolina . He has designed and implemented data-driven solutions since 1995. Boyd has been working with SQL Server since the release of 2000 and has built several large data-driven solutions exceeding 2 billion rows and 20TB. Boyd has worked with many Fortune 500 companies including Wal-Mart, Target Stores, Home Depot, Best Buy, CVS, ConAgra and Bank of America. Boyd is the founder and president of the Charleston SQL User Group and the cofounder of the NWA SQL User Group.
How to Design a Data-Driven Application that will Scale
We will discuss best practices for database design including an overview of normalization, what it is and why it’s important. We’ll also consider common mistakes and why they should be avoided. This will be a hands-on discussion, so bring your laptops. The sample data and code will be available for download prior to the presentation.
Why Projects Fail
Projects fail for many reasons. Usually the stated reason, or the “official” reason, has little to do with why a project failed; it’s either oversimplified or wrong. After considering several recent case studies of project failures, we'll discuss the root causes and the lessons that can be learned. We'll conclude with a discussion of best practices that can be used in our current projects.
How to Write T-SQL Code that will Scale
We will discuss best practices for writing T-SQL code. As in every other programming langue, there are several ways of coding the same task, but not all will scale. We will discuss how to determine what will scale best and why. We’ll also consider common mistakes and why they do not scale. This will be a hands-on discussion, so bring your laptops. The sample data and code will be available for download prior to the presentation.
Bring your questions!