May Phila SQL Server Users Group (PSSUG) Meeting
Location: Microsoft Malvern Office
45 Liberty Blvd
Wednesday, May 8th, 5:30 - 8:30pm
Short Session - The SQL Clinc
- As a part of an ongoing clinic for every meeting, bring your questions / problems to the meeting. If you have a problem that you would like to be solved, bring ias much detail as possible. For this session to be effective, we need enough information about the problem.Bring as much information as you can. Take this list as a starting point:
- if you have a slow query, bring the XML execution plan of all statements in question. The actual plan is preferred.
- if you need help writing a query, bring a script to create the tables involved and maybe some example data together with expected results
- if you need help with indexing, bring
- the query itself.
- a problem description and requirements (does not need to be written down, but would be helpful)
First Session - Joe D'Antoni
Topic: Using Compression to Improve Database Performance
Back in the old days, compression and databases was a really bad idea. Now, with powerful CPUs we can use to both improve performance and save disk space. We will cover the basics of how all compression and deduplication works, and then we will learn how SQL Server page and row compression work, and the special compression that is used in SQL 2012 Columnstore Indexes. We will demo performance and space savings in using compression.
Bio: Joe D'Antoni is a frequent speaker at SQL Saturday events. He is a SQL Server Architect at Comcast in West Chester, Pennsylvania with 10+ years of experience working on a wide variety of database platforms. His specialties include DR, HA and Virtualization
Keynote Session - Hilary Cotter
Topic: Stress testing SQL Server
How high can we go? Frequently in your career as a DBA you will be asked how much load can your SQL Server support. In this session, SQL Server MVP Hilary Cotter, shows you how to Microsoft tools to stress test your application and determine what your bottlenecks are and how high you can ramp up your workload.
Session Level: Advanced
Bio: SQL Server MVP Hilary Cotter is a 20 year IT veteran who has answered over 20,000 questions on the forums. Some of them correctly. He has worked on some of the largest and challenging SQL Server topologies in the world. He has been a SQL Server MVP for 12 years now