It’s 2016. So why are we still dealing with T-SQL code and design patterns that were designed 7 versions ago?   In the 15 years I have been using databases professionally, we’re still dealing with: Peoples’ names are split into first name, last name and middle initial fields. Ignoring that this falls afoul of several of the…

Read More T-SQL Tuesday #83: Why Leave Well Enough Alone?

This week’s #sqlnewblogger posts! Author Post @eleightondick [T-SQL Tuesday] Data modeling: The trouble with prefixes | The Data Files @tomsql Adventures With TomSQL, aka Tom Staab @EdDebug Automatically name primary key constraints in SSDT | the.agilesql.club @rabryst Born SQL on Twitter: “Temporal Tables – Under the Covers with the Transaction Log.  @YatesSQL Community Involvement–Why Wait?…

Read More SQL New Blogger Challenge November 2015 Edition – Week 3 Digest

This week’s #sqlnewblogger posts! Author Post @arrowdrive Anders On SQL: T-SQL Tuesday #72: Data modelling gone extremely wrong @rabryst Time After Time – An Introduction to Temporal Tables in SQL Server 2016 using a DeLorean @EdDebug Deploy SSDT INSERTS in Batches | the.agilesql.club @ALevyInROC Don’t Trust the Wizard @DBA_ANDY Nebraska SQL from @DBA_ANDY: T-SQL Tuesday…

Read More SQL New Blogger Challenge November 2015 Edition – Week 2 Digest

Ed Leighton-Dick has renewed his New Blogger Challenge this month. Here are all (I think) the posts for this week after Ed posted his announcement. If I’ve missed any, please let me know and I’ll update. Author Post @arrowdrive Anders On SQL: First Timer Summit impressions. @EdDebug Deploy SSDT INSERTS in Batches | the.agilesql.club @EdDebug Looking at…

Read More SQL New Blogger Challenge, November Edition, Week 1 Digest

Spend any time around a 4 year old, and you will inevitably find yourself involved in a conversation which evolves into this: Please do this thing Why? Reasonable answer Why? Restatement of reasonable answer Why? Shorter, more frustrated restatement of reasonable answer Why? Because that’s what has to be done Why? Because Why? I give up.…

Read More Why Ask Why?