5 SQL Hacks: November Community Round-up
Welcome to the SquaredUp Community Round-up. This month, we are zooming in on the language of databases that we are all too familiar with – SQL. We’ve scoured the web for the best SQL hacks, so you don’t have to. Enjoy!
ONE TO READ
STRING_SPLIT
Basics
Ever needed to split up data that's been conflated into a large character field? Steve Jones shares how to do so easily with STRING_SPLIT.
ONE TO WATCH
Unpivot: Convert data from columns into rows
Watch this tutorial to learn how to convert data from Columns into Rows using SQL's Unpivot operator.
ONE TO FOLLOW
Twitter:
Pinal Dave
Want a constant stream of up-to-date SQL tips and tricks? Follow Pinal Dave, the SQL Server Performance Tuning expert behind SQL Authority!
ONE to join
Free webcast: Sizing storage in SQL
Brent Ozar shows how to gauge storage requirements by measuring existing workloads and predicting the way databases interact when consolidated.
Continue learning
Dashboard Story
Garden Irrigation water usage dashboard with SQL
Customer Story
