Go inside PASS Summit 2012's full-day training classes in this Q&A series with our presenters:
- Andy Leonard, Jessica Moss, Matt Masson, Michelle Ufford, Tim Mitchell - SSIS Design Patterns
When designing ETL, assume that all inputs and outputs are volatile. Assume that all data is bad. Know that every process you build will eventually encounter a speed bump or even an all-out train wreck.
- Adam Saxton - Customer Stories from the Front Lines
Running System Center Advisor on systems is probably one of the single best things you could do for your database server… I've heard it labeled “CSS in a box,” and there have been plenty of times where had the customer been running that, they would have avoided a call to Support.
- Allan Hirt - Real-World System Design for the DBA: Private Cloud and SQL as a Service
If you work as a DBA, whether you like it or not, you’re running a business providing a service – even if it is for internal customers. If you think of it that way, it’s eye opening.
- Itzik Ben-Gan - T-SQL Querying and Query Tuning Enhancements in SQL Server 2005-2012
Some people believe in the theory that “never mind how you express your request – as long as it means the same thing, the optimizer will generate the same plan.” This may be the case in theory, but you know what Einstein said about theory and practice...
- Grant Fritchey - Query Performance Tuning: Start to Finish
Sometimes you get little improvements. Sometimes you get regressions. But sometimes, sometimes you get that giant improvement that makes people stop short and say, "Wow!"
- Denny Cherry - SQL Server 2012 in a Highly Available World
AlwaysOn Availability Groups are really the big HA solution these days for SQL Server 2012.
- Davide Mauri - Building the Agile Data Warehouse with SQL Server 2012
We cannot simply say “wait 6 months” to people who need data to make important business decisions. We need to change the way we deliver data warehouse solutions. That's why the Agile approach works so well.
- Klaus Aschenbrenner - Practical SQL Server Performance Troubleshooting
Almost every performance problem inside SQL Server has its root cause in bad indexing.
- Robert Davis and Argenis Fernandez - Demystifying Database Administration Best Practices
Practice the highly effective habit of “trust, but validate.” And safeguard your data - it is your most precious asset.
- Louis Davidson - Relational Database Design Workshop
Keep an open mind when doing design so as not to end up with the system you want and miss creating the system that is needed.
- Rod Colledge - BI Dashboards with Dashboard Designer & PerformancePoint Services 2010
Creating a good-looking dashboard is equal parts art and science, a fusion of creativity and information.