Tip of the Day: Partitioning in SQL Azure

Today’s Tip…

Did you know you can use partitioning in SQL Azure now? Following the documentation here https://msdn.microsoft.com/en-us/library/ms188730(v=sql.120).aspx for standard partitioning you can better manage your data in SQL Azure tables. The only caveat (since there are no filegroups in SQL Azure) is your scheme must direct all partition to primary such as:

image