Webinar review of: Architectural Choices That Affect Performance: Why Design Impacts Performance on Microsoft SQL Server by Kevin Kline, Principal Program Manager, SentryOne.
In Kline’s words: “…ten common design choices made during the creation of a Microsoft SQL Server database application which hurts the performance of your application.
… great for Developers … and for DBAs who are usually concerned with keeping servers up and running…”.
Here’s a handful of the items covered in the webinar.
Unexpected architectural choices that impact performance:
- Server instance
- File layout
- Tables
- Indexes
- Columns
- Data types
- Data constraints
- Data attributes
- Data quality
- Concurrency
Special architectural options for better performance
- Columnstore
- In-Memory OLTP
- Data compression
Lots of demos, best practice information, what to avoid, performance impediments, ways to fix performance issues and better performance choices.
I give the webinar “Architectural Choices That Affect Performance” a thumbs up!
DBAs you can make the tough choices! Right?
Ad
Udemy – Microsoft SQL Server 2019 – An introduction 
Udemy – Get top courses for as low as $12.99!
Pearson Education (InformIT) – eBook Deal of the Day
Pluralsight – Start your Free Trial today! – Don’t let technology outpace you. Work smarter and master your craft with a technology learning platform that will help you build better and create more.
Pluralsight – Get your Skill IQ with a Free Assessment from PluralSight
Coursera – You’ve got a deep network, a great resume, and a top-notch LinkedIn profile. Start building in-demand skills on Coursera, and your career will be ready to take off. Start your 7-day risk-free trial today. – Take the world’s best courses, online.
Whizlabs – Online Training for Agile Certified Practitioner (PMI ACP)® Certification Exam | Enroll Now
Edureka – 
RetiredDBA.com is compensated if you click to an advertiser website and/or you make a purchase after clicking to an advertiser website. This does not INCREASE the price you pay. The income is used to continue to provide as much free content as possible.