I’m as good at procrastination as the next person. And because of that I waited until last night to finish my PASS Summit session submissions. I’d actually written them all up a couple months ago but hadn’t put together the goals for each session.
I am hoping that I get a session selected and will admit that I might have submitted too many. I submitted about half of the presentations that I am interested in currently writing. When a good idea passes across my desk, laptop, fingers… it goes into a presentation idea document.
Since others have shared their submissions, I thought I’d share a few of mine. I probably submitted too many presentations but there wasn’t any imposed restrictions and I am sure the people on the selection committee will love reading them all.
So here goes:
Improving Daily Imports with Partitioned Tables
At some point, everyone struggles with loading data to OLTP systems. The business needs the data loaded so that users can work through the data. But the users can’t afford the downtime to get the data into the production tables. In this session we’ll review this problem and how to use partitioning to alleviate this issue.
- Basic understanding for partitioned table concepts
- Familiarity with OLTP systems
- Identify situations where partitioned tables can improve database performance
- Demonstrate partitioned table solution for daily imports
- Provide understanding of the pro’s and con’s to selecting partitioned tables as a import solution for an OLTP system
Getting To Know Your Indexes
Without proper indexing SQL Server can be hard pressed to create efficient and performant execution plans. Dynamic Management Views (DMV) and system views provide a slew of information about indexes that can be used to analyze indexes within SQL Server. In this session we’ll go under the hood of SQL Server to look at DMVs and system views to know what indexes you have, should have, and how they feel about the way applications are treating them.
- Understanding of performance tuning needs
- Experience with Database design
- Identify methods to analyze current and potential indexes
- Learn how to alleviate stress found on indexes
- Demonstrate methods for tuning indexes
Necessarily Evils, Building Optimized CRUD Procedures
Every developer loves them and a lot of DBAs hate them. But there are many and valid reasons for creating generic SELECT, INSERT, UPDATE, and DELETE procedures. In this session, we’ll go through designing CRUD procedures that utilize new and existing SQL features to create CRUD procedures that are optimized for performance.
- Understand application data access requirements
- Understanding of basic T-SQL coding skills
- Identify the uses for CRUD procedures in databases
- Identify the common problems associated with CRUD procedures
- Demonstrate methods for writing performant CRUD procedures
Last but not least, have you registered for the PASS Summit yet? It’s less than 7 months away. I’m going… though I need to get travel worked out still.