Expert Picks

Firm Foundations in Data Architecture

By Thomas LeBlanc, PASS Data Architecture Virtual Chapter Chair
Here it is - a PASS Data Architecture Virtual Chapter review of what we believe are the must-see sessions at PASS Summit 2012 for data architects.

Pre-Conference Sessions
  • Relational Database Design Workshop - Louis Davidson
    This Monday full-day workshop can be compared to the Saturday Night Live skit "I need more cow-bell." Take a trip for a day with an expert architect and author. From requirements gathering to database design to physical layout, this session will teach you more about data types, natural keys versus artificial/surrogate keys and relational theory.
  • Building the Agile Data Warehouse with SQL Server 2012 - Davide Mauri
    With all the new in-memory reporting going on, this day-long design session on Tuesday will be great for those jumping into the BI world and needing the basic building blocks for data marts and data warehouses. Plus, you will take away some design patterns and requirements-gathering SQL learning for your own best practices.
  • There’s nothing like getting the latest news and strategic roadmaps from Microsoft's top executives and hanging out with SQL Server geeks and bloggers at the Blogger Table in the back of the keynote room. And don’t forget to spend some time in the Hands-On Labs and expert tables all around the Summit.
Beginner Sessions
  • SQL Server MVP Andrew Novick tackles database size optimization problems with The Biggest Loser: Database Edition (AD-200). This looks to be an informative discussion on optimizing database storage and retrieval with the must-haves of database maintenance.
  • Join Neil Buchwalter and Karen Lopez for 75 minutes of data-driven design in Data Model-Driven Database Design in the Real World (AD-205-CA). Nothing like two database experts sharing their expert guide to database implementation. Let this session help you with proven real-world examples of improving your current and future databases.
  • SQL Server MVP and MCM Kendra Little will help you with indexes in Index Psychiatry: Diagnosis and Treat the Top 5 Disorders (AD-204). Five top indexing tips is just the right amount for new SQL Server DBAs.
Intermediate Sessions
  • Thomas LaRock and Karen Lopez are teaming up for the can’t-miss interactive session Database Design Throwdown (AD-322-S). This 90-minute Spotlight session will give you a break from the week’s information overload and prove that learning can be fun.
  • If you are looking to use a development environment integrated into TFS for source control, please attend Robert Cain’s SQL Server Database Projects in SQL Server 2012 Data Tools (AD-317). Ever since DataDude came on the scene the with earlier versions on SQL Server, Microsoft has keep this product supported and updated, which usually means people are using it. If only it came with a visual database diagram option.
  • As always with the Summit in Seattle, Microsoft is sending lots of presenters, including Len Wyatt and James Podgorski from the SQLCAT team. Their session on Big Data Warehousing (AD-300-M) looks to be a great session with real-world examples of Big Data.
  • What would the Summit be without SQL Server expert Kalen Delaney? Kalen’s session on Storing Columnstore Indexes (AD-321-S) will cover one of the newer ways to quickly retrieve data in data warehouses. This is marked as a 300-level presentation, but Kalen always goes deep into the technology.
Advanced Sessions
  • Microsoft is making available Dana Kaufman and Eric Kraemer to talk about Fast Track Data Warehouse and SQL Appliances (AD-302-M). If you have a large data warehouse system and need an appliance to spread the workload across multiple resources, this session is for you and your boss. Come find out about Microsoft’s partnership with hardware vendors to provide an all-in-one system for large workload
  • Page and Row Compression Deep Dive(DBA-401) looks to be the more advanced session for architect- minded DBAs, and Bradley Ball is a great resource about these powerful tools.


Why Attend?