Webinar review: Top 10 SQL Server Mistakes made by DBAs by Kevin Kline. Kline is a principal program manager at Sentry One. Sentry One mission from their website: ‘SentryOne empowers the Microsoft data professional to achieve breakthrough performance across physical, virtual and cloud environments’.
Kline discusses in detail 10 SQL Server mistakes that DBAs make. BTW, the mistakes listed below are mostly due to process and business issues.
- Storage
- Business Ignorance
- No Troubleshooting Methodology
- Going with the Defaults
- Security as an Afterthought
- Inadequate Automation
- Wrong Feature or Technique for the Job
- Apathy about Development, DevOps, and Change Management
- Inadequate Preventative Maintenance
- Backups <> Recovery
Thinking Space but not I/O Speed
SSD is a game changer for I/O
Master all aspects of SQL Server internals
Guardian of corporate assets – THE DATA not the hardware
Know your business cycles, best down times, benchmarks, whats normal, etc
Need a step by step methodology for root-cause analysis
Reliability is Microsoft default settings. Not performance!
SQL injection is still the #1 hack
How do you find out the who, what, and when of a breach?
Work “smarter” instead of “harder”
There are no IT projects.
There are business projects solved using IT.
DBAs must consider all T-SQL code as the realm of the Dev team
Change management of database artifacts is very important
DevOps vs Change Control versus CI/CD?
Database consistency checks (DBCC), Backups, Restore checks
Defragmentation, Fill factor, Pad Index, Index Statistics
Can you actually restore older, archived data?
How long will it take?
TEST!
Kline also discussed some bonus SQL Server blunders like no SQL agent alerts, etc. Kline mentioned some free SQL Server DBA tools like the Sentry One resource library, #sqlhelp on twitter, dbatools.io, olahallengren.com, sp_whoisactive, sp_firstresponderkit and Glenn Berry’s diagnostic DMV queries.
Kline really hits it on the head for this list of SQL Server mistakes made by DBAs. As Kline stated ‘It’s all about the DATA… All the time, Every time’! Thumbs up for the webinar ‘Top 10 SQL Server Mistakes made by DBAs’. A must watch for all SQL Server DBAs!
SQL Serer DBAs don’t make mistakes! uhhhhh… Right?
Ad
Udemy – SQL Server 2019: Whats New – In this course you will learn about the major new enhancements and features in SQL Server 2019 and SSMS 18.0.
Advertisement
Amazon Prime Visa - Get a Amazon Gift Card instantly upon approval of Amazon Prime Visa
Chase Checking - Open your Chase checking account and get a bonus!
Chase Freedom Flex - Earn unlimited cash back with the Chase Freedom Flex credit card.
Chase Freedom Unlimited - Earn cash back with the Chase Freedom Unlimited credit card.
Chase Saphire - Open your Chase Saphire Preferred or Reserve and get bonus points and more!
Discover - Get a bonus when you open an eligible Discover account.
Marriott Bonvoy Credit card - Open your Marriott Bonvoy Credit card and get a new Cardmember bonus!
Rakuten - Sign up for Rakuten and earn cash back on your purchases at 3500+ stores. 20M+ members in the U.S. have earned over $3.2B in Cash Back at their favorite stores.
Schwab - Open a Schwab account and get up to $1,000 depending on your net deposit.
Xfinity - Open an Xfnity mobile or internet account and get a bonus