The SQL Server Hit List - Our Least Favorite Features
Compañeros, in episode 57 of the SQL Data Partners Podcast we take a page from the SQL Server Radio podcast and discuss some SQL Server features we think could improve. We talk about the redundancy of default maintenance plans, the pain of autogrowth and autoshrink, why NO LOCK hints shouldn’t be used, what’s so bad about Activity Monitor, and more. It should be noted here, that we LOVE SQL Server, we just being a bit picky with some of the tools.
Our Top SQL Server Offenders
- Default file autogrowth settings
- Default maintenance plans
- Shrink database or Auto Shrink
- NOLOCK Hints
- Table Variables
- Instance settings – Processors tab
- SQL Server Log File Viewer
- Sql Server Logs file history options
- Spatial Data
- Data Tuning Advisor
- Activity Monitor
We also chat about the what, where, why, and how of the Dedicated Administrator Connection (DAC) in SQL Server.
SQL Server Radio Ep 50: 50 Features
SQL Data Partners Podcast Episode 48: Is the On-Premise Data Warehouse Dead?
Understanding the SQL Server NOLOCK hint
MSDN: Maintenance Plans
The Dedicated Admin Connection: Why You Want It, When You Need It, and How To Tell Who’s Using It
MSDN: Diagnostic Connection for Database Administrators
Meet the Hosts
With more than 10 years of working with SQL Server, Carlos helps businesses ensure their SQL Server environments meet their users’ expectations. He can provide insights on performance, migrations, and disaster recovery. He is also active in the SQL Server community and regularly speaks at user group meetings and conferences. He helps support the free database monitoring tool found at databasehealth.com and provides training through SQL Trail events.
Eugene works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 8 years and speaks regularly at user groups and conferences. He also helps run the GroupBy online conference.
Kevin is a Microsoft Data Platform MVP and proprietor of Catallaxy Services, LLC, where he specializes in T-SQL development, machine learning, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL, president of the Triangle Area SQL Server Users Group, and author of the books PolyBase Revealed (Apress, 2020) and Finding Ghosts in Your Data: Anomaly Detection Techniques with Examples in Python (Apress, 2022). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.