This month marks the 72nd T-SQL Tuesday. Adam Machanic’s (b|t) started the T-SQL Tuesday blog party in December of 2009. Each month an invitation is sent out on the first Tuesday of the month, inviting bloggers to participate in a common topic. On the second Tuesday of the month all the bloggers post their contribution to the event for everyone to read. The host sums up all the participant’s entries at the end of the week. This month I’m the host and the topic is …
Data Modeling Gone Wrong
The purpose of SQL Server, is to make sure that the databases are kept safe and run as optimally as possible. The problem is, if the data model is flawed, or not maintained, then no matter how optimally the SQL Server is configured, the database won’t be able to function efficiently.
I would like to invite you to share some data modeling practices that should be avoided, and how to fix them when they do occur.
Rules for T-SQL Tuesday Blog Party
Rule 1: Make sure that you include the T-SQL Tuesday image at the top of the post which will help identify your post as a T-SQL Tuesday blog post. Please include a link back to this invitation too.
Rule 2: Publish your post sometime next Tuesday using GMT. Here’s a link to a GMT time convertor. For example, in California, that would cover 5 pm Monday to 5 pm (PDT) Tuesday.
Rule 3: Come back here and post a link in the comments so that I can find all the posts for the round up.
Rule 4: Don’t get yourself fired. Make sure that you either generalize your post or get permission to blog about anything from work.
Rule 5: If you roam the Twitterverse, then don’t forget to Tweet about your blog post with the hashtag #tsql2sday.
Rule 6: Go read someone else’s blog on the subject!
Final Rule: Have fun!
[…] month, Mickey Stuewe (b|t) hosted T-SQL Tuesday, giving us a topic of “data modeling gone wrong“. This is a fantastic topic – there are just so many ways that data modeling can go […]
Oh bugger… Forgot to post link here. Blog was out on date, just not this update 🙂
http://t-sql.dk/?p=1330
No worries. I found it on Twitter in the #sql2day feed. 🙂
[…] T-SQL Tuesday #72 Invitation – Data Modeling Gone Wrong […]
[…] Expressions with PowerShell Using SQL Prompt to Accelerate the Top 10 Most Common Database Scripts T-SQL Tuesday #72 – Data Modeling Gone Wrong PASS Summit and MVP Summit 2015 The Voice of the DBA Implementing Continuous Integration for […]
[…] Mickey Stuewe hosted T-SQL Tuesday this month. Her topic: data modeling gone wrong. A few choice posts on the topic follow. […]
Insufficient time to do the subject justice. A couple of memories here, though… https://thelonedba.wordpress.com/2015/11/10/t-sql-tuesday-72-data-modelling-gone-wrong/
Hey Mickey! Thanks for hosting, here’s my entry:
http://www.sqlservercentral.com/blogs/pearlknows/2015/11/10/t-sql-tuesday-no-72-is-your-data-model-normal/
Great topic! Of course, nothing could possibly go wrong 🙂
Thanks for hosting this month; mine can be found at https://chrisyatessql.wordpress.com/2015/11/10/t-sql-tuesday-72-invitation-data-modeling-gone-wrong/
Thanks Mickey!
http://clarkcreations.net/blog/tsql2sday-data-modeling-gone-wrong/
Thanks Mickey!
Nebraska SQL from @DBA_ANDY: T-SQL Tuesday #72 – Implicit Conversion Problems http://nebraskasql.blogspot.com/2015/11/t-sql-tuesday-72-implicit-conversion.html #tsql2sday #sqlnewblogger #Ntirety
Thanks for hosting!! That time a beer broke my database, https://tpet1433.wordpress.com/2015/11/10/that-time-a-beer-broke-my-database-t-sql-tuesday-72/
[…] Thank you Mickey Stuewe (B|T) for hosting T-SQL Tuesday #72 – Data Modeling Gone Wrong […]
Awesome topic Mickey! Here’s my contribution:
http://weblogs.sqlteam.com/robv/archive/2015/11/10/t-sql-tuesday-72-data-modeling.aspx
[…] she has a great topic. Data Modeling is something few people seem to do, especially developers, and it often can go wrong. That’s the topic, and I have a short […]
[…] is T-SQL Tuesday. This month’s host is Mickey Stuewe (@SQLMickey) with a challenge to blog about data modelling mistakes we’ve seen. Unfortunately, it’s an easy topic to blog about because proper data modelling often falls by the […]
[…] month Mickey Stuewe (b|t) is hosting and has asked for some data modeling practices that should be avoided, and how to fix […]
Thanks Mickey!
http://blogs.sqlsentry.com/aaronbertrand/t-sql-tuesday-72-models-gone-wild/
Thanks for hosting Mickey! Here’s mine: http://sqlstudies.com/2015/11/10/why-are-you-still-using-datetime/
Data modelling gone extremely wrong. http://bit.ly/1Y256bZ
Why are you still using datetime?
It’s almost Thanksgiving time again! Let’s see, what am I thankful for? T-SQL Tuesday! Someone
Great topic thanks! http://www.hyperbi.co.uk/tallynumber-tables-in-sql-server-tsql2sday/
[…] part of #TSQL2sday Mickey Stuewe (b|t) has proposed a question looking at best practices when someone has made some bad design […]
Cheers Mickey. http://sqlblog.com/blogs/rob_farley/archive/2015/11/10/what-s-driving-your-data-model.aspx
What’s driving your data model?
If data modelling were easier, I doubt there would be as many books on the subject, and we wouldn’t have
[…] first TSQL Tuesday post on the new blog is an invite by my friend and sql sister Mickey Stuewe (b|t). It is regarding data modeling practices that are well avoided and how problems rising as a […]
Enjoy: http://www.sqlstad.nl/performance-tuning/data-modeling-gone-wrong/
[…] month, Mickey Stuewe is hosting, and the topic she chose is “Data Modeling Gone Wrong”. Pull out your stories about horrible data structures you’ve seen, or write something about […]