Blog covers all things for Microsoft SQL Server

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?


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

Edureka – Data Science Training by Edureka Drive Business Insights from Massive Data Sets Utilizing the Power of R Programming, Hadoop, and Machine Learning.

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 – 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.