If you were selected to speak this year, congratulations. I look forward to attending many of your sessions! If you like the “I’m Speaking” image I added to my blog, feel free to use it in your own blog or other materials.
If you weren’t selected to speak this year, take Kendra Little’s (web|@kendra_little) advice. Please, keep speaking. This will be my 5th year attending the PASS Summit and my 4th year speaking. I was not selected to speak in 2013, but I did not let that stop me from submitting in 2014. And it paid off.
The DBA’s Guide to Administering BI Systems
Duration: 3 hours
Track: BI Platform Architecture, Development & Administration
Being a DBA is hard when there are few resources to help you, but this is the life of a DBA for BI systems. Resources for BI typically center around development and architecture and client tools, and resources for DBAs are generally for OLTP systems. In this session, you will be provided with the resources you need.
We will start with the best practices for managing SSAS, SSRS, and other BI systems, and then we will take deep dive into the scripting languages XMLA and MDX for administrative tasks and troubleshooting with Analysis Services’ version of DMVs. We will finish up by looking at how to create automated maintenance jobs for SSAS.Also seen here: Bradley Ball (Summit 2014|Blog|@SQLBalls)
Boosting Performance with Indexing
Duration: 75 minutes
Track: Application & Database Development
Are your queries slow? Are your I/O counts through the roof? Then Dr. SQLSoldier has this wondrous tonic that will fix these ailments and more. This incredible elixir is called Indexing.
For the incredibly low price of absolutely free, you will learn multiple techniques for applying Indexing to your ailing queries. Return your queries to the youthful vim and vigor they had when there was only a little data in the database.
You too can amaze and astound your friends and coworkers by applying Indexing. Become the office hero. I’ll show you how. I’ll teach you three easy methods for indexing:
1. Query-centric indexing
2. Indexing with DMVs
3. Tools for index analysis
Don’t wait! Act now!