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 TRY
SQL Samples Dashboard
Try out this SQL dashboard created in SquaredUp’s free dashboarding tool, Community Edition. One basic query, 7 different visualizations!
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.
Don't miss the next SquaredUp Community Round-up. Sign up here to receive it in your inbox each month.