Skip to content
SQLDoubleG
Menu
  • Home
  • Articles
  • SQL-G Hacks
  • Language: English
    • English English
    • Español Español
Menu

T-SQL Tuesday #92, Lessons learned the hard way

Posted on Monday July 3rd, 2017

#tsql2sday is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate, so no matters you are an experienced blogger or you just want to start writing about SQL Server, this is a real good chance to add something to the community tsql2sdayHello all and welcome to a new #tsql2sday event that I’m proudly hosting for this month.

#tsql2sday is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate, so no matters you are an experienced blogger or you just want to start writing about SQL Server, this is a real good chance to add something to the community.

This month’s topic

For this month, I want you peers to write about those important lessons that you learned the hard way, for instance something you did and put your systems down or maybe something you didn’t do and took your systems down. It can be also a bad decision you or someone else took back in the day and you’re still paying for it…

There are so many things to share here so everybody can learn from each others mistakes, because all of us were once a beginner and no one is born with any knowledge about SQL Server.

Please do not be ashamed of sharing your experiences, you can anonymize the whole story if you want but remember all people make mistakes, the important is to learn from them and try not to repeat them in the future.

The rules

There a few rules to participate in this party, nothing complicated but let’s remind them to everyone.

  • Your post must be published between 00:00:00 UTC and 23:59:59 UTC on Tuesday, July 11th
  • Include the T-SQL Tuesday logo in the top of your post and link your post back to this one (preferably via a comment on this post)
  • If you’re on Twitter, tweet your post using the #tsql2sday (if you’re not on Twitter, get on it!)

I really look forward to reading your blog posts.

Thanks.

23 thoughts on “T-SQL Tuesday #92, Lessons learned the hard way”

  1. Pingback: T-SQL Tuesday #92, Lessons learned the hard way – T-SQL Tuesday
  2. Kennie Nybo Pontoppidan says:
    Monday July 10th, 2017 at 07:31 PM

    Hi Raul,

    Great topic! Here is my contribution:

    http://www.pontop.dk/single-post/2017/07/10/T-SQL-Tuesday-92—how-missing-indexes-tore-down-the-systems-at-the-IT-University-of-Copenhagen

    Reply
  3. Denis Gobo says:
    Tuesday July 11th, 2017 at 12:58 AM

    And here is my contribution: https://sqlservercode.blogspot.com/2017/07/t-sql-tuesday-92-lessons-learned-hard.html

    Reply
  4. Rob Farley says:
    Tuesday July 11th, 2017 at 03:05 AM

    Here you go… http://sqlblog.com/blogs/rob_farley/archive/2017/07/11/learning-the-hard-way-referenced-objects-or-actual-objects.aspx

    Reply
  5. Blobeater says:
    Tuesday July 11th, 2017 at 08:55 AM

    I went with rookie mistake theme…. I am ashamed I did this! 🙁

    https://blobeater.blog/2017/07/11/sql-server-rookie-mistakes/

    Reply
  6. Andy Levy says:
    Tuesday July 11th, 2017 at 12:33 PM

    A trio of lessons learned: https://therestisjustcode.wordpress.com/2017/07/11/t-sql-tuesday-92-lessons-learned-the-hard-way/

    Reply
  7. Bert Wagner says:
    Tuesday July 11th, 2017 at 01:48 PM

    Great topic, thanks for hosting this month. https://blog.bertwagner.com/my-most-embarrassing-sql-moment-9cf6fa786ef3

    Reply
  8. Aaron Bertrand says:
    Tuesday July 11th, 2017 at 02:01 PM

    Thanks Raul!
    https://blogs.sentryone.com/aaronbertrand/t-sql-tuesday-92-lessons-learned-hard-way/

    Reply
  9. Kenneth Fisher says:
    Tuesday July 11th, 2017 at 02:14 PM

    Thanks for hosting Raul! Here’s mine: https://sqlstudies.com/2017/07/11/save-and-save-often/

    Reply
  10. Pingback: T-SQL Tuesday #92, Lessons Learned The Hard Way – The SQL Professor
  11. Matthew McGiffen says:
    Tuesday July 11th, 2017 at 04:01 PM

    Thanks for hosting this – I’ve taken the opportunity to add my voice in the war on table variables!
    https://matthewmcgiffen.com/2017/07/11/think-twice-before-using-table-variables/

    Reply
  12. Chris Yates says:
    Tuesday July 11th, 2017 at 04:04 PM

    Thaks for hosting; mine can be found at https://chrisyatessql.wordpress.com/2017/07/11/t-sql-tuesday-92-lessons-learned-the-hard-way/

    Reply
  13. Garland MacNeill says:
    Tuesday July 11th, 2017 at 04:48 PM

    This promises to be a very interesting topic. Looking forward to the responses.
    https://sqlmac.com/lessons-learned-hard-way/

    Reply
  14. Garland MacNeill says:
    Tuesday July 11th, 2017 at 04:49 PM

    I can’t wait to read some of these…
    https://sqlmac.com/lessons-learned-hard-way/

    Reply
  15. Pingback: Indexing a HUGE Table – nate_the_dba
  16. Nate says:
    Tuesday July 11th, 2017 at 08:27 PM

    Thank you for hosting! This is my FIRST entry for a T-SQL Tuesday, I hope the community enjoys:
    http://wp.me/p7D6Ye-16a

    Reply
  17. Pingback: Mistakes Engineers Learn | Edwin M Sarmiento
  18. Edwin M Sarmiento says:
    Tuesday July 11th, 2017 at 08:41 PM

    Thanks for hosting this month’s T-SQL Tuesday. I’ll throw mine in the hat and see if I win something 🙂

    http://www.edwinmsarmiento.com/mistakes-engineers-learn/

    Reply
  19. Andy Galbraith says:
    Tuesday July 11th, 2017 at 08:43 PM

    Thanks for hosting!

    BLOG: Nebraska SQL from @DBA_ANDY: T-SQL Tuesday #92 – Trust But Verify http://nebraskasql.blogspot.com/2017/07/t-sql-tuesday-92-trust-but-verify.html?spref=tw #tsql2sday #Ntirety #sqlserver

    Reply
  20. Pingback: T-SQL Tuesday #92 – Lessons Learned the Hard Way… – No Column Name
  21. Shane O'Neill says:
    Tuesday July 11th, 2017 at 09:57 PM

    Thanks DoubleG, here’s my contribution https://nocolumnname.wordpress.com/2017/07/11/t-sql-tuesday-92-lessons-learned-the-hard-way/

    Reply
  22. Pingback: What would you tell your younger self?
  23. Pingback: My Most Embarrassing SQL Moment – SQL with Bert Wagner

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

  • About this blog
  • Articles
  • Development
  • Free Training
  • Security
  • SQL Server 2016
  • SQL-G Hacks
  • T-SQL Tuesday

Latest Posts

  • T-SQL Tuesday #158, Implementing Worst Practices
  • T-SQL Tuesday #155 –The Dynamic Code Invitation
  • FillFactor, the Untold Story
  • How I Compared 1000’s of database’s schemas at once
  • How to Update SQL Server Stats The Right Way
©2025 SQLDoubleG | Design: Newspaperly WordPress Theme