A couple of weeks ago, I posted an Invitation to T-SQL Tuesday #68: Just Say No to Defaults. Last week, #SQLFamily responded in force with 22 blog posts! There’s a fantastic wealth of information across all of these blog posts and I was blown away!
Without further ado, here’s the round-up!
- Aaron Bertrand (@AaronBertrand) discusses SQL Server Setup & “Installing All The Things!” (Should I add a trademark notation to that phrase for you?)
- Andy Yun (@SQLBek) explored SSMS & Keyboard Query Shortcuts.
- Angela Henry (@SQLSwimmer) explores her two two quick wins to improve performance.
- Björn Peters offers us a post in German, discussing Min & Max Server Memory. (Thank goodness for Google Translate!)
- Bob Pusateri (@SQLBob) shares some of his Defaults to Change, not only in SQL Server, but in Windows as well.
- Cathrine Wilhelmsen (@cathrinew) explores using Batch Update change defaults in SSIS packages.
- Chris Sommer (@cjsommer) discusses using Powershell & SMO and explores an example.
- Daniel Mellor (@sqlsanctum) writes about his top six defaults that he makes changes to.
- Jason Brimhall (@sqlrnnr ) takes an interesting twist, to talk about the one default we all share – ourselves. He also wrote a preview post the week prior, showing us how to track changes via Extended Events.
- Jens Vestergaard (@vestergaardj) shares his exploration of Powershell & Desired State Configuration and discusses how it can be useful for changing Defaults.
- Jim Dorame (@DBAJD) gives us an excellent checklist of six items that he always explores, including Model DB!
- Justin Randall (@jh_randall) takes a turn by exploring SQL Server Agent.
- Kenneth Fisher (@sqlstudent144) reminds us of the importance of documenting our changes, and explores what can be automated to aid that.
- Koen Verbeeck (@Ko_Ver) gives us a SSIS-centric post, talking about changes he recommends.
- Lori Edwards (@loriedwards) shares three of her Defaults to change.
- Martin Catherall (@MartyCatherall) writes an informative post about Backup Checksum.
- Mike Fal (@Mike_Fal) flexes his PowerShell with a detailed exploration of Desired State Configuration.
- Nancy Hidy Wilson (@NancyHidyWilson) writes about SQL Agent, and a setting she addresses after installation.
- Rob Farley (@rob_farley) writes about something I am guilty of rarely ever thinking about – Default Collation.
- Robert Pearl (@PearlKnows) took the time to expand on the topic from a higher level, offering a wide variety of topics & solutions for further reading.
- Steve Jones (@way0utwest) explores one of the default settings on his must-change list.
I want to thank everyone for participating and sharing your knowledge. And I hope that those of you who are reading, but not yet blogging, will join us, start your own blog, and begin sharing your knowledge and your stories too!
Until next time!