provides tidbits, ideas and insights to all things Microsoft SQL Server.

Home / SQL Server / DBAs can you make the tough choices?

DBAs can you make the tough choices?


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.

This div height required for enabling the sticky sidebar

Sponsor Ads

RetiredDBA Websites

Just OutletsChicago Job Resource
Retired DBALuxury Matters
Tradin Stuff
Value Buyers