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