Welcome to another edition of T-SQL Tuesday! Started by Adam Machanic (b|t), this is the SQL Server community’s monthly blog party, where everyone is invited to write about a common topic.
I am honored to be your host this month. This month, I’d like to ask everyone to blog about SQL Server Defaults. While SQL Server CAN be run with just the default settings, doing so is far from ideal. As we progress through our careers, many of us build lists of things we change. Let’s blog about those! And don’t think this month’s topic is constrained to just the SQL Server engine. SSIS & SSAS are absolutely fair game as well. SQL Server developer tools – sure! Want to take a different spin on “defaults,” go right ahead and be creative!
Need Ideas?
Do you have a checklist of “always change” settings? Blog about that!
Do you have a preferred method for mass-deploying your changes? Blog about that!
Do you have a specific default setting you ALWAYS change? Deep dive & blog about that!
Want to Participate?
- Write a blog post about the topic. Don’t have a blog? Start one!
- Include the T-SQL Tuesday Logo and link it back to this post.
- Publish your blog post Tuesday, July 14, between 00:00 GMT & 23:59 GMT.
- Leave a reply below with a link to your blog post (for the round-up).
- Share you post with the community! Tweet it out using the #tsql2sday hashtag!
Let’s have some fun! I’m looking forward to everyone’s contributions & learning something new!
Every Byte Counts 
Ok – thanks for hosting Andy, gave me the incentive to reboot my blogging career, so cheers. http://martincatherall.com/?p=1083&preview=true
Actually, here’s the better URL – http://martincatherall.com/2015/07/07/tsql-tuesday-68-backup-checksum-default/
Thanks, Andy for hosting! Great topic! Just say no! (just like the 80s 🙂 Here’s my post: http://bit.ly/TSQL2Sday68
Thanks for submitting! Glad you had fun with it!
Did I goof something – I’ve already received several other early entries (should be next Tuesday, right)?
Hi Andy, nice topic. It’s indeed next tuesday 🙂
I’ll try to participate as well!
Here’s mine, now that the second Tuesday has come around: http://sqlblog.com/blogs/rob_farley/archive/2015/07/14/check-the-settings-when-installing-sql-server.aspx
Thanks for hosting, Andy.
Thanks for hosting, Andy! Here’s my contribution: https://nancyhidywilson.wordpress.com/2015/07/13/tsql2sday-68-just-say-no-to-defaults/
Here is My official entry
http://bit.ly/1MqEon4
Hi Andy, here’s my contribution:
http://sqlkover.com/2015/07/14/t-sql-tuesday-68/
I changed the permalink settings, so here’s the new URL for the blog post: http://sqlkover.com/t-sql-tuesday-68/
Sweet, link-back worked! Thank you Andy for hosting this month’s #tsql2sday! Lots of great posts so far!
Many thanks to Andy.
Here is my German post:
http://www.sql-aus-hamburg.de/t-sql-tuesday-68-just-say-no-to-defaults-optimierung-der-sql-server-defaults/
Thanks Andy! My co-worker, Lori Edwards, is on vacation this week, but her entry is here:
http://blogs.sqlsentry.com/loriedwards/t-sql-tuesday-68-just-say-no-to-defaults/
Hi Andy, I managed to finish my contribution. Thanks for hosting.
Great topic Andy! Here’s my contribution. http://sqlstudies.com/2015/07/14/tsql-tuesday-68-what-is-my-configuration/
Here is mine. http://www.jamesdorame.com/index.php/2015/07/14/defaults-defaults-defaults-everywhere-and-maybe-that-is-bad-t-sql-tuesday-68/ Thanks for hosting Andy
And my entry is also ready, here:
http://blogs.sqlsentry.com/aaronbertrand/t-sql-tuesday-68-defaults/
Thanks again
Aaron
Thanks for hosting Andy! My entry is here: http://blogs.sqlsentry.com/justinrandall/t-sql-tuesday-68-sql-server-agent/