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!
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.
Watch this tutorial to learn how to convert data from Columns into Rows using SQL’s Unpivot operator.
Want a constant stream of up-to-date SQL tips and tricks? Follow Pinal Dave, the SQL Server Performance Tuning expert behind SQL Authority!
Try out this SQL dashboard created in SquaredUp’s free dashboarding tool, Community Edition. One basic query, 7 different visualizations!
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.