Procure SQL is a proud sponsor of PASS SQL Saturday Houston, June 17, 2017! This is a 100% free event for you, your employees, teammates or anyone interested in learning SQL Server for free. Make sure you sign up and come on down.
Please stop by the booth and say hello to me. I would love to meet you! Mention that you read this blog and I will have a gift for you!
I will have a prize wheel to spin for cool prizes, one of which is a hand spinner! They are all the rage. Have you ever played with one? They are great for calming me during heavy database work!
Our founder, John Sterrett, will be speaking at 4pm. Be sure to drop in and say hello before or after the session!
His session is titled Table Partitioning: the Secret Weapon for Your Big Data Problems.
"Is big data starting to slow you down? Is data growth putting your maintenance tasks in danger of not meeting your service level agreements? Do you wish you could archive old data with minimal impact to your tables during the archive process? Do you wish you could eliminate the majority of the data in your tables when you query them? If so, it's time you consider implementing table partitioning to help with your general performance and to reduce your maintenance window for completing your maintenance tasks. In this session, you will learn how table partitioning works and when it should be implemented. You will be able to understand how to initially configure partition functions and partition schemes to have a rock solid partitioned table. You learn how to implement new features added in SQL Server 2014 to improve table partitioning. Finally, you will learn how to implement an automated sliding window to maintain your partitioned tables for ensuring optimal performance."