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
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
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.