L.A. SQL Server Professionals Group

Welcome to the Los Angeles SQL Server Professionals Group

Next Meeting

Thursday,

April

11

Kevin Kline: Architectural Choices: Why Design Impacts Performance on Microsoft SQL Server

  • In-Person @ Microsoft Store, 10250 Santa Monica Blvd, #1045 Los Angeles, California, United States (map)
  • 18:30 - 21:30 Pacific Daylight Time
  • Language: English

Sponsored by SentryOne!    We will have swag for everyone!

Architectural Choices That Affect Performance:
Why Design Impacts Performance on Microsoft SQL Server

This session takes you through ten common design choices made during the creation of a Microsoft SQL Server database application which hurts performance of your application.

This session is great for Developers who have not had much training on database and for DBAs who are usually concerned with keeping servers up and running, but not done much database design. We’ll cover a variety of topics, such as:

·         What are the basics of tables and indexes? How do data type choices directly impact the size, I/O burden, and performance of applications?

·         What are the most common database design issues that surface in application code? How can you detect them?

·         What are the primary techniques database designers use to improve performance when optimizing a database design?

If you are a DBA, do you have scripts you can run to perform these checks? If you are a Dev, do you know which common design choices are actually pitfalls? If not, then you should attend!  This session takes you through a variety of demos that show what sort of anti-patters are common in applications you buy on the open market, how to detect them and, when possible, how to refactor those problems. Don’t miss out!

Presented by Kevin Kline:
Kevin is a noted database expert and software industry veteran currently serving as the Principal Program Manager at SentryOne, a leading vendor of database tools. A Microsoft Data Platform MVP since 2003, Kevin was a founding board member and former president of the Professional Association for SQL Server. He has authored more than ten books, including the best-selling SQL in a Nutshell. Kevin contributes a monthly column to Database Trends magazine. Kevin is a top-rated speaker on technology and professional development topics at conferences worldwide such as Microsoft Ignite/TechEd, the PASS Summit, DevTeach, Oracle OpenWorld, and IT/Dev Connections. He tweets at @kekline and blogs at http://KevinEKline.com.

https://blogs.sentryone.com/kevinkline/slides-scripts-architectural-choices-impact-performance-microsoft-sql-server/

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids