| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 05-11-2012 08:30 | Louis Davidson | Pre-Conference Session (full day) | Application & Database Development | Relational Database Design Workshop |
| 05-11-2012 08:30 | Rod Colledge | Pre-Conference Session (full day) | BI Information Delivery | BI Dashboards with Dashboard Designer & PerformancePoint Services 2010 |
| 05-11-2012 08:30 | Devin Knight, Brian Knight | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | Building a SQL Server 2012 BI Platform |
| 05-11-2012 08:30 | Tim Mitchell, Andy Leonard, Matt Masson, Jessica Moss, Michelle Ufford | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | SSIS Design Patterns |
| 05-11-2012 08:30 | Klaus Aschenbrenner | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Practical SQL Server Performance Troubleshooting |
| 05-11-2012 08:30 | Denny Cherry | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | SQL Server 2012 in a Highly Available World |
| 05-11-2012 08:30 | Robert Davis, Argenis Fernandez | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Demystifying Database Administration Best Practices |
| 06-11-2012 08:30 | Allen White | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Automate and Manage SQL Server with PowerShell |
| 06-11-2012 08:30 | Allan Hirt, Ben DeBow | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Real-World System Design for the DBA: Private Cloud and SQL as a Service |
| 06-11-2012 08:30 | Grant Fritchey | Pre-Conference Session (full day) | Application & Database Development | Query Performance Tuning: Start to Finish |
| 06-11-2012 08:30 | Itzik Ben-Gan | Pre-Conference Session (full day) | Application & Database Development | T-SQL Querying and Query Tuning Enhancements in SQL Server 2005-2012 |
| 06-11-2012 08:30 | Davide Mauri | Pre-Conference Session (full day) | BI Platform Architecture, Development & Administration | Building the Agile Data Warehouse with SQL Server 2012 |
| 06-11-2012 08:30 | Bob Ward, Adam Saxton | Pre-Conference Session (full day) | Enterprise Database Administration & Deployment | Customer Stories from the Front Lines |
| 06-11-2012 08:30 | Peter Myers | Pre-Conference Session (full day) | BI Information Delivery | Zero to BI Semantic Model with SQL Server 2012 |
| 07-11-2012 10:15 | Brian Moran | Regular Session (75 minutes) | Professional Development | Tax, Finance, and Money Tips for the Independent Consultant |
| 07-11-2012 10:15 | Jen Underwood, Carolyn Chau, John Sirmon | Regular Session (75 minutes) | BI Information Delivery | Mobile Business Intelligence |
| 07-11-2012 10:15 | Regular Session (75 minutes) | BI Information Delivery | PowerPivot 101 | |
| 07-11-2012 10:15 | Jes Schultz | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | The What, Why, and How of Filegroups |
| 07-11-2012 10:15 | Luis Vargas | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server 2012 AlwaysOn: Availability Groups Drilldown |
| 07-11-2012 10:15 | Peter Myers, Matthew Roche | Spotlight Session (90 minutes) | BI Platform Architecture, Development & Administration | 10 Extraordinary Things to Achieve with Integration Services 2012 |
| 07-11-2012 10:15 | Darwin Schweitzer | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | MAD About Data: Solve Problems and Develop a “Data Driven Mindset” |
| 07-11-2012 10:15 | Kevin Cox, Nicholas Dritsas | Regular Session (75 minutes) | Application & Database Development | SQLCAT: What Are the Largest SQL Server Projects in the World? |
| 07-11-2012 10:15 | Jason Strate | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | Extended Events: Work Smarter Not Harder |
| 07-11-2012 10:15 | Erin Stellato | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | DBCC Commands: The Quick and the Dangerous |
| 07-11-2012 10:15 | Steve Howard, Arvind Ranasaria | Regular Session (75 minutes) | Cloud Application Development & Deployment | SQLCAT: Best Practices and Lessons Learned on SQL Server in an Azure VM |
| 07-11-2012 10:15 | Sean Boon | Regular Session (75 minutes) | BI Information Delivery | Building Compelling Power View Reports |
| 07-11-2012 10:15 | Chris Webb | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | What's New in Analysis Services 2012? |
| 07-11-2012 10:15 | Regular Session (75 minutes) | Application & Database Development | XQuery and XML in SQL Server: Common Problems and Best Practice Solutions | |
| 07-11-2012 10:15 | Cindy Gross, Dipti Sangani | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | SQLCAT: Big Data – All Abuzz About Hive |
| 07-11-2012 13:30 | Stacia Varga | 1/2 Day Session (3 hours) | BI Platform Architecture, Development & Administration | Secrets of SSAS Storage |
| 07-11-2012 13:30 | Kasper de Jonge | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Developing and Managing a BI Semantic Tabular Model in SQL Server 2012 |
| 07-11-2012 13:30 | Matt Masson, Matthew Roche | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Enterprise Information Management: Bringing Together SSIS, DQS, and MDS |
| 07-11-2012 13:30 | Ewan Fairweather, Silvano Coriani | Regular Session (75 minutes) | Cloud Application Development & Deployment | SQLCAT: How Do I Troubleshoot My Database Now that It Is in the Cloud? |
| 07-11-2012 13:30 | Juergen Thomas | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | SQLCAT: Many-Core Processors, SSDs, Large Memory: How to Benefit SQL Server |
| 07-11-2012 13:30 | Robert Davis, Mark Broadbent, Brent Ozar, Amy Lewis, Rob Volk, Wendy Pastrick | Lightning Talks (75 min, 10 min/speaker) | Professional Development | Lightning Talks - 100 |
| 07-11-2012 13:30 | Robert Davis | Lightning Talks (75 min, 10 min/speaker) | Application & Database Development | How Bad Is Read-Only Access? |
| 07-11-2012 13:30 | Devin Knight | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Adapting Your ETL Solutions to Use SSIS 2012 |
| 07-11-2012 13:30 | Mark Stacey | Regular Session (75 minutes) | BI Information Delivery | PowerPivot 2 – Using NASA Data |
| 07-11-2012 13:30 | Wendy Pastrick | Lightning Talks (75 min, 10 min/speaker) | Professional Development | Work-Life Balance: It's Not Just for WIT |
| 07-11-2012 13:30 | Rob Volk | Lightning Talks (75 min, 10 min/speaker) | Application & Database Development | Regular Expressions in SSMS in 10 Minutes or Less |
| 07-11-2012 13:30 | Amy Lewis | Lightning Talks (75 min, 10 min/speaker) | BI Platform Architecture, Development & Administration | Become Less Fuzzy About Fuzzy Transformations! |
| 07-11-2012 13:30 | Bob Ward | 1/2 Day Session (3 hours) | Enterprise Database Administration & Deployment | Inside SQLOS 2012 |
| 07-11-2012 13:30 | Jerome Halmans, Gus Apostol | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | SQLCAT: SQLOS Memory Manager Changes in SQL Server 2012 |
| 07-11-2012 13:30 | Andrew Novick | Regular Session (75 minutes) | Application & Database Development | The Biggest Loser: Database Edition |
| 07-11-2012 13:30 | Louis Davidson | Regular Session (75 minutes) | Application & Database Development | Triggers: Born Evil or Misunderstood? |
| 07-11-2012 13:30 | Brent Ozar | Lightning Talks (75 min, 10 min/speaker) | Enterprise Database Administration & Deployment | Bob Dylan Explains TempDB |
| 07-11-2012 13:30 | Allen White | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Manage SQL Server 2012 on Windows Server Core with PowerShell |
| 07-11-2012 13:30 | Meir Dudai | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Replication vs. AlwaysOn: Scalability Solutions with SQL Server 2012 |
| 07-11-2012 13:30 | Don Kiely | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | The Evolution of Security in SQL Server 2012 |
| 07-11-2012 13:30 | Mark Broadbent | Lightning Talks (75 min, 10 min/speaker) | Enterprise Database Administration & Deployment | SQL Server AlwaysOn for Dummies |
| 07-11-2012 15:00 | Sanjay Mishra, Mike Weiner | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | SQLCAT: AlwaysOn HA/DR Design Patterns, Architectures and Best Practices |
| 07-11-2012 15:00 | Regular Session (75 minutes) | Application & Database Development | Inside Unstructured Data: SQL Server 2012 FileTable and Semantic Search | |
| 07-11-2012 15:00 | Brian Knight | Spotlight Session (90 minutes) | BI Information Delivery | Around the World with the SharePoint BI Toolbelt |
| 07-11-2012 15:00 | Doug Lane | Regular Session (75 minutes) | BI Information Delivery | Developers Are from Mars, Report Servers Are from Venus |
| 07-11-2012 15:00 | Robert Davis | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Tempdb: Performance and Manageability |
| 07-11-2012 15:00 | Hugo Kornelis | Regular Session (75 minutes) | Application & Database Development | Taking MERGE Beyond the Basics |
| 07-11-2012 15:00 | Denise McInerney | Spotlight Session (90 minutes) | Application & Database Development | Stop Bad Data in Its OLTP Tracks |
| 07-11-2012 15:00 | Brent Ozar | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Real-Life SQL Server 2012 Availability Groups: Lessons Learned |
| 07-11-2012 15:00 | Sean McCown | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Blazing Fast Backups |
| 07-11-2012 15:00 | Thomas LeBlanc | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Using SSIS 2012 for Data Warehouse ETL |
| 07-11-2012 15:00 | Paul White | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Understanding Parallel Query Execution |
| 07-11-2012 15:00 | Steve Jones, Andy Warren | Spotlight Session (90 minutes) | Professional Development | Learn About The Mentoring Experiment |
| 07-11-2012 15:00 | Ronald Yenko | Regular Session (75 minutes) | Professional Development | Tips and Tricks for Giving a Stellar Technical Presentation |
| 07-11-2012 16:45 | Lisa Gardner | Regular Session (75 minutes) | Application & Database Development | SQL Server and SharePoint: Best Frienemies |
| 07-11-2012 16:45 | Juergen Thomas | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | SQLCAT: How Does Microsoft Run Its SAP Landscape on Windows and SQL Server? |
| 07-11-2012 16:45 | Diego Oppenheimer | Regular Session (75 minutes) | BI Information Delivery | Building Self-Service BI Apps Using PowerPivot and Excel |
| 07-11-2012 16:45 | Rod Colledge | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | BI Architecture with SQL Server 2012 and SharePoint 2010 |
| 07-11-2012 16:45 | Sanjay Mishra, Jean-Yves Devant | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | SQLCAT: AlwaysOn Unplugged – Everything You Want to Know About AlwaysOn |
| 07-11-2012 16:45 | Prem Mehra, Lindsey Allen, Shep Sheppard | Regular Session (75 minutes) | Application & Database Development | SQLCAT: Real-World Case Study of Mission-Critical Active/Active Remote DCs |
| 07-11-2012 16:45 | Steve Hughes | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Building a Tabular Model Database |
| 07-11-2012 16:45 | Jen Stirrup | Regular Session (75 minutes) | BI Information Delivery | Mobile Business Intelligence for Everyone, Now! |
| 07-11-2012 16:45 | Karen Lopez, Neil Buchwalter | Regular Session (75 minutes) | Application & Database Development | Data Model-Driven Database Design in the Real World |
| 07-11-2012 16:45 | Erin Welker, Patrick Brady | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Monitoring SQL Server Analysis Services with DMVs |
| 07-11-2012 16:45 | Tobias Ternstrom, Jan Engelsberg | Regular Session (75 minutes) | Application & Database Development | Practical Uses and Optimization of New T-SQL Features in SQL Server 2012 |
| 07-11-2012 16:45 | Tim Chapman, Thomas LaRock | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | Choose Your Own Adventure: Performance Tuning |
| 07-11-2012 16:45 | Chuck Heinzelman | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Configuring Kerberos for SharePoint 2010 BI in 7 Steps |
| 07-11-2012 16:45 | Allen White | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | Maintain SQL Server System and Performance Data with PowerShell |
| 07-11-2012 16:45 | Robert Cain | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Installing and Configuring SQL Server 2012 Reporting Services |
| 08-11-2012 10:15 | Erin Stellato | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | Demystifying Database Statistics |
| 08-11-2012 10:15 | James Podgorski, Olivier Matrat, Steve Howard, Rafael Fernandez | Regular Session (75 minutes) | Application & Database Development | Bootstrapping Data Warehousing in Azure for Use with Hadoop |
| 08-11-2012 10:15 | Bob Meyers, Sivakumar Harinath | Regular Session (75 minutes) | BI Information Delivery | Using Power View with Multidimensional Models |
| 08-11-2012 10:15 | Kay Unkroth | Regular Session (75 minutes) | BI Information Delivery | Deploying and Managing a PowerPivot for SharePoint 2013 Infrastructure |
| 08-11-2012 10:15 | Kalen Delaney | Spotlight Session (90 minutes) | Application & Database Development | Storing Columnstore Indexes |
| 08-11-2012 10:15 | Brian Knight | Spotlight Session (90 minutes) | BI Platform Architecture, Development & Administration | Data Cleansing with SSIS 2012 |
| 08-11-2012 10:15 | Adam Machanic | Spotlight Session (90 minutes) | Application & Database Development | Query Tuning Mastery: The Art and Science of Manhandling Parallelism |
| 08-11-2012 10:15 | Melissa Coates | Regular Session (75 minutes) | BI Information Delivery | Dashboards: When to Choose Which MSBI Tool |
| 08-11-2012 10:15 | Carlos Bossy | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Data Modeling Best Practices for Enterprise Tabular Models |
| 08-11-2012 10:15 | Mladen Prajdić | Regular Session (75 minutes) | Application & Database Development | SQL Injection: From Website to SQL Server |
| 08-11-2012 10:15 | Meir Dudai | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Peer-to-Peer Replication: Real-Life Implementations and Best Practices |
| 08-11-2012 10:15 | Mark Broadbent | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | READPAST & Furious: Transactions, Locking, and Isolation |
| 08-11-2012 10:15 | Eric Kraemer, Bob Schmidt | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server Parallel Data warehouse |
| 08-11-2012 10:15 | Alberto Ferrari | Spotlight Session (90 minutes) | BI Platform Architecture, Development & Administration | Querying and Optimizing DAX |
| 08-11-2012 10:15 | Mindy Curnutt | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | SQL I/O Uh-Oh |
| 08-11-2012 13:30 | Oliver Engels | Lightning Talks (75 min, 10 min/speaker) | BI Platform Architecture, Development & Administration | SSRS, Kerberos, and SharePoint |
| 08-11-2012 13:30 | Brad McGehee | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | How to Defragment Indexes for Peak Performance |
| 08-11-2012 13:30 | Grant Fritchey | Regular Session (75 minutes) | Application & Database Development | What to Look for in Execution Plans |
| 08-11-2012 13:30 | Niko Neugebauer | Lightning Talks (75 min, 10 min/speaker) | Professional Development | Becoming a Master |
| 08-11-2012 13:30 | Bill Fellows | Lightning Talks (75 min, 10 min/speaker) | BI Platform Architecture, Development & Administration | Understanding the SSIS 2012 Deployment Model |
| 08-11-2012 13:30 | Mark Tabladillo | 1/2 Day Session (3 hours) | BI Platform Architecture, Development & Administration | Enterprise Data Mining with SQL Server |
| 08-11-2012 13:30 | Chuck Heinzelman | Regular Session (75 minutes) | BI Information Delivery | Running Reporting Services in SharePoint Integrated Mode: How and Why |
| 08-11-2012 13:30 | Denny Lee, Dave Mariani | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | How Klout Changed the Landscape of Social Media with Hadoop and BI |
| 08-11-2012 13:30 | Dandy Weyn | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Upgrading to SQL Server 2012 “Done Right” |
| 08-11-2012 13:30 | Marco Russo | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Near Real-Time Analytics with xVelocity (without DirectQuery) |
| 08-11-2012 13:30 | Aaron Nelson | Lightning Talks (75 min, 10 min/speaker) | Application & Database Development | 3.0: Not Your Granddaddy’s PowerShell |
| 08-11-2012 13:30 | Chris Webb | Regular Session (75 minutes) | BI Information Delivery | The Best Microsoft BI Tools You've Never Heard Of |
| 08-11-2012 13:30 | Paul Turley | Regular Session (75 minutes) | BI Information Delivery | Visual Report Design: Bringing Sexy Back |
| 08-11-2012 13:30 | Randy Knight | Regular Session (75 minutes) | Application & Database Development | Understanding Transaction Isolation Levels |
| 08-11-2012 13:30 | Aaron Nelson, Jes Schultz, Niko Neugebauer, Oliver Engels, Sanjaya Padhi, Bill Fellows | Lightning Talks (75 min, 10 min/speaker) | Professional Development | Lightning Talks - 101 |
| 08-11-2012 13:30 | Andreas Wolter | Regular Session (75 minutes) | Application & Database Development | SQL Server 2012 Security for Developers |
| 08-11-2012 13:30 | Sanjaya Padhi | Lightning Talks (75 min, 10 min/speaker) | Enterprise Database Administration & Deployment | Why DBAs Like Service Broker |
| 08-11-2012 13:30 | Klaus Aschenbrenner | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | ColumnStore Indexes: The Turbobooster Inside SQL Server 2012 |
| 08-11-2012 13:30 | Jean-Yves Devant | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | AlwaysOn: Availability Groups and Replication Working Together |
| 08-11-2012 13:30 | Jes Schultz | Lightning Talks (75 min, 10 min/speaker) | Enterprise Database Administration & Deployment | Lights! Camera! Piecemeal Restore! |
| 08-11-2012 13:30 | Neil Hambly | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | SQL Server 2012 Memory Management |
| 08-11-2012 15:00 | Stacia Varga | Regular Session (75 minutes) | Cloud Application Development & Deployment | Windows Azure SQL Reporting: What Is It, and Why Should You Care? |
| 08-11-2012 15:00 | Tim Mitchell | Regular Session (75 minutes) | Application & Database Development | Data Quality Services in the Enterprise |
| 08-11-2012 15:00 | Gail Shaw | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | What, Where, Why and How of Indexes |
| 08-11-2012 15:00 | Itzik Ben-Gan | Spotlight Session (90 minutes) | Application & Database Development | T-SQL Tips and Tricks |
| 08-11-2012 15:00 | Kevin Kline | Spotlight Session (90 minutes) | Professional Development | Leadership – Influence vs. Authority |
| 08-11-2012 15:00 | Lynn Langit | Regular Session (75 minutes) | Application & Database Development | NoSQL for the SQL Server Professional |
| 08-11-2012 15:00 | Roger Noble | Regular Session (75 minutes) | BI Information Delivery | Bad Reports: Fixing Their Mistakes |
| 08-11-2012 15:00 | Benjamin Nevarez | Regular Session (75 minutes) | Application & Database Development | Dive into the Query Optimizer: Undocumented Insight |
| 08-11-2012 15:00 | Mark Simms, Michael Thomassy | Regular Session (75 minutes) | Cloud Application Development & Deployment | SQLCAT: SQL Azure Design Patterns and Best Practices |
| 08-11-2012 15:00 | Mark Broadbent | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Moves Like Jagger: Upgrading to SQL Server 2012 |
| 08-11-2012 15:00 | Kasper de Jonge | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Enriching Your BI Semantic Tabular Models with DAX |
| 08-11-2012 15:00 | Peter Myers | Spotlight Session (90 minutes) | BI Information Delivery | Exploring PowerPivot and Power View in Excel 2013 |
| 08-11-2012 15:00 | Karen Lopez, Thomas LaRock | Spotlight Session (90 minutes) | Application & Database Development | Database Design Throwdown |
| 08-11-2012 15:00 | Rick Heiges | Regular Session (75 minutes) | Professional Development | Are You Cut Out for a Consulting Career? |
| 08-11-2012 17:00 | Rafael Salas | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Waiter, There's a Fly in My Data |
| 08-11-2012 17:00 | Buck Woody | Regular Session (75 minutes) | Cloud Application Development & Deployment | Data Storage in Azure for the Data Professional |
| 08-11-2012 17:00 | Brent Ozar | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | Diagnose T-SQL Performance Problems Fast with sp_Blitz |
| 08-11-2012 17:00 | John Lambert | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Load Millions of Records in a Split-Second with Partition Switching |
| 08-11-2012 17:00 | Ayad Shammout, Thomas Grohser, Michael Steineke, Sanjay Mishra, David Smith, Wolfgang Kutschera | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | SQLCAT: SQL Server 2012 AlwaysOn HA/DR Customer Panel |
| 08-11-2012 17:00 | Victor Isakov | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | What DBAs Should Know About Windows Server 8 |
| 08-11-2012 17:00 | Kendra Little | Regular Session (75 minutes) | Application & Database Development | Index Psychiatry: Diagnose and Treat the Top 5 Disorders |
| 08-11-2012 17:00 | Jeremiah Peschka | Regular Session (75 minutes) | Application & Database Development | A Developer's Guide to Dangerous Queries |
| 08-11-2012 17:00 | Devin Knight | Regular Session (75 minutes) | BI Information Delivery | Creating a Power View Reporting Solution |
| 08-11-2012 17:00 | Grant Fritchey | Spotlight Session (90 minutes) | Application & Database Development | Improve Query Performance by Fixing Bad Parameter Sniffing |
| 08-11-2012 17:00 | Tim Peterson | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Monitoring Analysis Services: What’s Going on with Your Cube Performance? |
| 08-11-2012 17:00 | Patrick LeBlanc, Peter Myers, Chuck Heinzelman, Matt Masson, Matthew Roche, Sean Boon | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | BI Power Hour |
| 08-11-2012 17:00 | Markus Ehrenmueller-Jensen | Regular Session (75 minutes) | BI Information Delivery | Microsoft BI End-User Tools 360° |
| 08-11-2012 17:00 | Joe Webb | Regular Session (75 minutes) | Professional Development | Providing Effective Feedback |
| 08-11-2012 17:00 | Max Uritsky | Regular Session (75 minutes) | BI Information Delivery | Connecting to the World's Data |
| 09-11-2012 08:00 | Lynn Langit | Regular Session (75 minutes) | Cloud Application Development & Deployment | Using Amazon's Cloud for the SQL Server Professional |
| 09-11-2012 08:00 | Paul Turley | Regular Session (75 minutes) | BI Information Delivery | Dashboard Design: Making Reports Pop |
| 09-11-2012 08:00 | n/a n/a | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | SQL Server 2012 Highly Available BI Environments: From the Field |
| 09-11-2012 08:00 | Mike Flasko | Regular Session (75 minutes) | Application & Database Development | Harnessing Big Data with Hadoop |
| 09-11-2012 08:00 | Len Wyatt | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | What’s New for Columnstore Indexes and Batch Mode Processing? |
| 09-11-2012 08:00 | Klaus Aschenbrenner | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Advanced SQL Server Troubleshooting |
| 09-11-2012 08:00 | Mark Davis | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Power (View)ful Tabular BI Semantic Model Development |
| 09-11-2012 08:00 | Bob Meyers | Regular Session (75 minutes) | BI Information Delivery | Tips and Tricks for Building Rich Reporting Services Reports |
| 09-11-2012 08:00 | Brad McGehee | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Configuring the OS for Optimal SQL Server Performance |
| 09-11-2012 08:00 | Wesley Brown | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Integrating Solid State Storage with SQL Server |
| 09-11-2012 08:00 | Adam Saxton | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Working with Claims and SQL Server BI Technologies |
| 09-11-2012 08:00 | Sean McCown | Regular Session (75 minutes) | Professional Development | Mouth Wide Shut: Coherent Interviewing |
| 09-11-2012 08:00 | Andrew J. Brust | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Microsoft's Big Play for Big Data |
| 09-11-2012 08:00 | Rohit Nayak | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Troubleshooting SQL Server 2012 Performance with Extended Events |
| 09-11-2012 08:00 | Kevin Cox | Regular Session (75 minutes) | Cloud Application Development & Deployment | SQLCAT: What Are the Largest Azure Projects in the World? |
| 09-11-2012 09:45 | Edwin M Sarmiento | Lightning Talks (75 min, 10 min/speaker) | Professional Development | Presentation WOW |
| 09-11-2012 09:45 | Christian Wade | Lightning Talks (75 min, 10 min/speaker) | BI Platform Architecture, Development & Administration | Is It an Alligator? Is It a Crocodile? No, It’s a Gecko! |
| 09-11-2012 09:45 | Neil Hambly | Lightning Talks (75 min, 10 min/speaker) | Enterprise Database Administration & Deployment | Effective Error Log Parsing |
| 09-11-2012 09:45 | Laerte Junior | Lightning Talks (75 min, 10 min/speaker) | Enterprise Database Administration & Deployment | T-SQL Health Check to Excel in Email in 10 Minutes with PowerShell |
| 09-11-2012 09:45 | Gabriel Villa | Lightning Talks (75 min, 10 min/speaker) | Application & Database Development | Utility Database: Quick and Dirty Website to Monitor Performance |
| 09-11-2012 09:45 | David DeWitt | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | Big Data Meets SQL Server |
| 09-11-2012 09:45 | Laerte Junior, Edwin M Sarmiento, Christian Wade, Neil Hambly, Julie Koesmarno, Gabriel Villa | Lightning Talks (75 min, 10 min/speaker) | Professional Development | Lightning Talks - 102 |
| 09-11-2012 09:45 | Julie Koesmarno | Lightning Talks (75 min, 10 min/speaker) | Application & Database Development | TRY CATCH in a Nutshell |
| 09-11-2012 09:45 | Kun Cheng | Regular Session (75 minutes) | Cloud Application Development & Deployment | SQLCAT: Architecture Patterns and Lessons Learned from Azure ISV Projects |
| 09-11-2012 09:45 | Alberto Ferrari | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Parent-Child Hierarchies in Tabular |
| 09-11-2012 09:45 | Tim Mitchell | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | When ETL Goes Bad: Handling Errors and Data Anomalies in SSIS |
| 09-11-2012 09:45 | Jessica Moss | Regular Session (75 minutes) | BI Information Delivery | Getting Reports on Your Schedule |
| 09-11-2012 09:45 | Bradley Ball | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Page and Row Compression Deep Dive |
| 09-11-2012 09:45 | Glenn Berry | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Migrating to SQL Server 2012 |
| 09-11-2012 09:45 | Jason Strate | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | Performance Tuning Through the Plan Cache |
| 09-11-2012 09:45 | Ross LoForte, Guy Bowerman | Regular Session (75 minutes) | Cloud Application Development & Deployment | SQL Server in Azure VM patterns: Hybrid DR, data movement and BI |
| 09-11-2012 09:45 | Leonard Lobel | Regular Session (75 minutes) | Application & Database Development | Geospatial Data Types in SQL Server 2012 |
| 09-11-2012 09:45 | Kevin Kline | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | Managing SQL Server in a Virtual World |
| 09-11-2012 09:45 | Jen Stirrup | Regular Session (75 minutes) | BI Information Delivery | Business Intelligence and Data Visualization in SQL Server 2012 |
| 09-11-2012 09:45 | Carlos Bossy | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Real-Time Data Warehouse and Reporting Solutions |
| 09-11-2012 09:45 | Regular Session (75 minutes) | Application & Database Development | Troubleshooting Spatial Query Performance: Deep Dive into Spatial Indexing | |
| 09-11-2012 13:00 | Matthew Roche, Rakesh Parida | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Using Advanced DQS Concepts to Solve Complex Data Quality Problems |
| 09-11-2012 13:00 | Wesley Brown | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | How I Learned to Stop Worrying and Love My SAN |
| 09-11-2012 13:00 | Kendra Little | Spotlight Session (90 minutes) | Enterprise Database Administration & Deployment | SQL Server First Responder Kit |
| 09-11-2012 13:00 | Marco Russo | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Inside DAX Query Plans |
| 09-11-2012 13:00 | Allan Hirt, Michael Steineke, David Smith | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | The Good, Bad, and Ugly of Deploying AlwaysOn Availability Groups |
| 09-11-2012 13:00 | Matt Masson, Wee Hyong Tok | Regular Session (75 minutes) | Cloud Application Development & Deployment | Data in the Sky: Efficient On-Premise to Cloud Data Transfer |
| 09-11-2012 13:00 | Wayne Sheffield | Regular Session (75 minutes) | Application & Database Development | Table Variables and Temporary Tables – What You Need to Know |
| 09-11-2012 13:00 | Angel Abundez | Regular Session (75 minutes) | BI Information Delivery | Mobile BI with SSRS and SharePoint |
| 09-11-2012 13:00 | Paul White | 1/2 Day Session (3 hours) | Application & Database Development | Query Optimizer Deep Dive |
| 09-11-2012 13:00 | Regular Session (75 minutes) | Application & Database Development | Taking SQL Server 2012 into the World of Spatial Data Management | |
| 09-11-2012 13:00 | Craig Purnell | Regular Session (75 minutes) | Professional Development | LinkedIn for SQL Server Professionals |
| 09-11-2012 13:00 | Luke Jian | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Optimizing SQL Server I/O with Solid State Drives |
| 09-11-2012 13:00 | Allan Folting, Akshai Mirchandani | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Optimizing Your BI Semantic Model for Performance and Scale |
| 09-11-2012 13:00 | Mark Simms, Nicholas Dritsas, Michael Thomassy, Ewan Fairweather, Silvano Coriani | Regular Session (75 minutes) | Cloud Application Development & Deployment | SQLCAT: How SQL Azure Supports Large-Scale Customer Deployments |
| 09-11-2012 13:00 | Andy Warren | Spotlight Session (90 minutes) | Professional Development | Building Your Professional Development Plan |
| 09-11-2012 14:45 | Cihan Biyikoglu | Regular Session (75 minutes) | Cloud Application Development & Deployment | Disaster Recovery for Federations in SQL Azure |
| 09-11-2012 14:45 | Denny Cherry | Regular Session (75 minutes) | Application & Database Development | Where Should I Be Encrypting My Data? |
| 09-11-2012 14:45 | Patrick LeBlanc | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Extending SSIS 2012 Reports with Analytics |
| 09-11-2012 14:45 | Stephan Stoltze | Regular Session (75 minutes) | BI Information Delivery | Analyzing SSAS Data with Excel |
| 09-11-2012 14:45 | Scott Shaw | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Licensing SQL Server for 2012 |
| 09-11-2012 14:45 | Gert Drapers, Barclay Hill, Adam Mahood | Regular Session (75 minutes) | Application & Database Development | Database Development with SSDT and Visual Studio 2012 |
| 09-11-2012 14:45 | Mindy Curnutt | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | CSI for SQL: Learn to be a SQL Sleuth |
| 09-11-2012 14:45 | Mark Stacey | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Slowly Changing Dimensions: An Integrated Approach |
| 09-11-2012 14:45 | Davide Mauri | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | DMVs: Power in Your Hands |
| 09-11-2012 14:45 | Regular Session (75 minutes) | BI Information Delivery | SharePoint for Business Intelligence | |
| 09-11-2012 14:45 | Mark Tabladillo | Regular Session (75 minutes) | Application & Database Development | Applied Enterprise Semantic Mining |
| 09-11-2012 14:45 | Julie Smith | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Data Quality Services – Finally! |
| 09-11-2012 14:45 | Dana Kaufman, Eric Kraemer | Regular Session (75 minutes) | Application & Database Development | Fast Track Data Warehouse and SQL Appliances |
| 09-11-2012 14:45 | Tiho Tarnavski | Regular Session (75 minutes) | Cloud Application Development & Deployment | Stream Data Processing in the Cloud with Windows Azure StreamInsight |
| 09-11-2012 16:15 | Melissa Coates | Regular Session (75 minutes) | BI Information Delivery | Managed Self-Service BI |
| 09-11-2012 16:15 | Dandy Weyn | Regular Session (75 minutes) | Application & Database Development | xVelocity In-Memory Technologies Overview |
| 09-11-2012 16:15 | Scott Shaw | Regular Session (75 minutes) | Professional Development | SQL Server in Healthcare |
| 09-11-2012 16:15 | Andrew J. Brust | Regular Session (75 minutes) | BI Platform Architecture, Development & Administration | Hadoop and Its Ecosystem Components in Action |
| 09-11-2012 16:15 | Robert Cain | Regular Session (75 minutes) | Application & Database Development | SQL Server Database Projects in SQL Server 2012 Data Tools |
| 09-11-2012 16:15 | Michael Antonovich | Regular Session (75 minutes) | BI Information Delivery | Hello, My Name Is DAX |
| 09-11-2012 16:15 | Allan Hirt | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Deploying SQL Server 2012 Failover Clustering Instances |
| 09-11-2012 16:15 | Paresh Motiwala | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Creating a SQL Server Best Practices Document |
| 09-11-2012 16:15 | Tobias Ternstrom, Umachandar Jayachandran | Regular Session (75 minutes) | Application & Database Development | T-SQL Application Compatibility in SQL Azure: Today and Tomorrow |
| 09-11-2012 16:15 | Srini Acharya | Regular Session (75 minutes) | Application & Database Development | SQL LocalDB: A No-Hassle, Lightweight SQL Express for Developers |
| 09-11-2012 16:15 | Don Kiely | Regular Session (75 minutes) | Application & Database Development | New Kid in Town: SQL Express LocalDB |
| 09-11-2012 16:15 | Todd Furst, Bill Emmert | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | Managing SQL Server with System Center 2012 (The "Better Together" Story) |
| 09-11-2012 16:15 | Regular Session (75 minutes) | Application & Database Development | Programmability and Queries in the Microsoft environment for Hadoop | |
| 09-11-2012 16:15 | Tim Ford | Regular Session (75 minutes) | Enterprise Database Administration & Deployment | You Can Do That with T-SQL? |
| 09-11-2012 16:15 | Steve Hughes | Regular Session (75 minutes) | Application & Database Development | A Window into Your Data: Using SQL Window Functions |
Event Date: 05-11-2012 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
To design a database correctly, there are several things you need to know, including the basics of relational theory, how to gather and apply requirements, normalization, etc. While having a good foundation in the fundamentals is more than many database designers have, it is only the start. In this workshop, we will go to the next level and get our hands dirty designing databases.
Event Date: 05-11-2012 08:30 - Category: Pre-Conference Session (full day) - Track: BI Information Delivery
Event Date: 05-11-2012 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
After the data warehouse is loaded, you're ready to roll up the data and provide slice and dice reporting with SQL Server Analysis Services. We'll walk through cube development and enriching your cubes with added business metrics, which are essential for your future dashboards. Last, we'll cover how to report against the data warehouse with SQL Server Reporting Services and SharePoint BI. Make sure you bring your own optional laptop so you can follow along as we design, load, and report against our BI solution.
Event Date: 05-11-2012 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
Event Date: 05-11-2012 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
Topics for the day include: • Windows OS settings • Storage configuration • SQL Server instance settings • Database settings • Index and statistics maintenance • Locking, blocking, and deadlocking • Memory management
Event Date: 05-11-2012 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
In addition to working through these high availability options, we will be discussing the most important part of high availability configuration, making sure you know how to select the correct high availability solution. After this workshop, you'll be able to choose which high availability decision to deploy for your needs and how to correctly deploy the selected solution.
Event Date: 05-11-2012 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
This workshop is a culmination of what we’ve learned through our experiences, testing, and understanding of how SQL Server operates. We will touch on best practices for all aspects of the DBA realm, from AD configuration to Windows Server deployments to SQL installs, with configuration settings galore. We will cover the "why's" behind the best practices, tips to make your daily duties easier, and what to look for in code reviews. And we’ll show you how to evaluate best practices for yourself.
Event Date: 06-11-2012 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
We'll wrap up with a look at the new PowerShell cmdlets introduced for SQL Server 2012 and how you can use PowerShell to manage SQL Server 2012 in server environments, including the new AlwaysOn technology and Windows Server Core. At the end of the day, you'll be ready to put PowerShell to work automating and managing SQL Server in your organization.
Event Date: 06-11-2012 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
You can standardize your configurations and offerings with the right planning and knowledge of your environment. But transforming the way you work from a purely administrative focus to running your DBA services more like a company is where the private cloud and SQL as a Service (SaaS) come into play. Join us to learn how to properly plan, deploy, and maintain SQL Server systems to support your company’s needs, whether you are using physical servers, virtualization, or both.
Event Date: 06-11-2012 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
We will start by covering how to gather query performance metrics using tools available directly from Microsoft, such as dynamic management objects and extended events. We’ll then move into common performance problems, how they show themselves in the metrics and execution plans, and how to address them. You will leave with a working knowledge of query performance tuning, a set of methods for identifying poorly performing queries, scripts to help out, and the knowledge you need to fix your own systems.
Event Date: 06-11-2012 08:30 - Category: Pre-Conference Session (full day) - Track: Application & Database Development
The more experience you have with a feature, the more interesting uses you find - the APPLY operator and ROW_NUMBER function are great examples of this. The newer the feature, such as the new and enhanced window functions, the more discoveries await you. This seminar will cover T-SQL querying and query tuning enhancements in the latest major releases of SQL Server, including window functions, sequences, OFFSET/FETCH, MERGE, grouping sets, date and time types and functions, APPLY, pivoting and unpivoting, CTEs, columnstore indexes, filtered indexes, and more!
Event Date: 06-11-2012 08:30 - Category: Pre-Conference Session (full day) - Track: BI Platform Architecture, Development & Administration
In this day-long workshop, the data warehouse rules! We'll define what it is, starting with basic theory. Then we'll move through well-known models and design patterns, best approaches, and tools you need to build and maintain a data warehouse that's flexible enough to support today's fast-changing business needs. But even the agile data warehouse needs a well-defined structure to support the "engineer-ization" of its development process and make it cost-effective.
Event Date: 06-11-2012 08:30 - Category: Pre-Conference Session (full day) - Track: Enterprise Database Administration & Deployment
Our toolset for these solutions will involve tools you use every day, along with some that push your limits. Did anyone say, “Debugger?” We will showcase real-world techniques that you can use to troubleshoot and resolve your top database issues, focusing primarily on the Engine, but also delving into other areas of SQL Server. And don’t forget about the demos. We will demonstrate how each issue occurred, walk through how we identified and resolved the problem, and look at new support features in SQL Server 2012 to help you going forward.
Event Date: 06-11-2012 08:30 - Category: Pre-Conference Session (full day) - Track: BI Information Delivery
We'll cover all three development approaches: multidimensional, tabular with the tabular project, and tabular with PowerPivot. These different approaches give you choice and flexibility, but which should you use when? We'll look at the benefits and limitations of each approach in detail so that you can make an informed decision about which data model to use. Then we'll cover Data Analysis Expressions (DAX) and Multidimensional Expressions (MDX), which let you enrich the data models with calculations and data access permissions.
Event Date: 07-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: Professional Development
We all know the answer to most questions is "it depends," but I will be surprised if you don't walk away from this session with a few new tips and tricks that could add hundreds of thousands of dollars to your bottom line as an independent consultant. We'll have at least 15 minutes at the end of the session to explore topics and questions from the audience.
Event Date: 07-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 07-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 07-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, we'll see how to create filegroups, create objects in them, move objects between them, and perform maintenance on them. We'll also walk through piecemeal restores. The information in this session will help you create databases that perform better and are easier to maintain.
Event Date: 07-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2012 10:15 - Category: Spotlight Session (90 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Whether you are a developer, BI professional, or data scientist – Microsoft BI and Big Data enable new scenarios and can transform organizations looking to gain competitive advantage. Come see some demos, join the discussion on architectural choices beyond traditional BI/DW, and see why everyone is MAD about data.
Event Date: 07-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 07-11-2012 10:15 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2012 10:15 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
In this session, we will explore DBCC commands that are useful for the DBA and developer and cover when to use them and how. Expect demonstrations that provide a practical application of these commands – both documented and undocumented – that database pros can quickly and easily use.
Event Date: 07-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
Event Date: 07-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 07-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
You'll get guidance on how to best store XML inside the database (relational vs. as XML datatype, with or without a schema, which XML Index to use) and performance tips when using XQueries and FOR XML queries. In addition, we'll take a quick preview of a new XML indexing option in development for one of Microsoft's premier banking ISVs that will be productized in a future release.
Event Date: 07-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
After this session, you'll be able to democratize access to Big Data using familiar tools such as Excel and a SQL-like language without having to write MapReduce jobs. You'll also understand Hive basics, uses, strengths, and limitations and be able to determine if/when to use Hive in combination with Hadoop.
Event Date: 07-11-2012 13:30 - Category: 1/2 Day Session (3 hours) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
During this session, we'll present the entire spectrum of our learnings working in customer projects around the world in instrumenting and analyzing these applications based on Windows Azure SQL Database.
Event Date: 07-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Throughput enhancements provided by new commodity hardware also strains network configurations and associated SQL Server and Windows functionality. We will look at identifying network issues and configurations to use to avoid these bottlenecks. We will also look at how to deploy SSDs and their impact on workload, as well as SAN Storage Tiering and SQL Server configurations to reduce IOPS bursts in shared SAN environments.
Event Date: 07-11-2012 13:30 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Professional Development
Brent Ozar - Bob Dylan Explains TempDB (DBA) Mark Broadbent - SQL Server AlwaysOn for Dummies (DBA) Rob Volk - Regular Expressions in SSMS in 10 Minutes or Less (AppDev) Robert Davis - How Bad is Read-only Access? (AppDev) Wendy Pastrick - Work-Life Balance: It's Not Just for WIT (PD)
Event Date: 07-11-2012 13:30 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Application & Database Development
Event Date: 07-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
We'll use a trick invented by the Ancient Greeks to consume Excel functions in PowerPivot, and we'll combine that technique with an advanced application of DAX and Slicers to apply custom formulas to your data. We'll finish up by pulling the PowerPivot model into Visual Studio, decorating and partitioning our model, deploying to Analysis Services, and showing off PowerView.
Event Date: 07-11-2012 13:30 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Professional Development
Event Date: 07-11-2012 13:30 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Application & Database Development
Event Date: 07-11-2012 13:30 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2012 13:30 - Category: 1/2 Day Session (3 hours) - Track: Enterprise Database Administration & Deployment
There’s practical value in understanding SQLOS internals, including helping you with SQL Server planning, design, management, monitoring, and troubleshooting. And this session will feature plenty of demos. I promise your brain will hurt when you leave this session, but I also promise you will have learned new things about the SQL Server Database Engine that you can put to use as administrators and developers.
Event Date: 07-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Before this change, the 'max server memory' sp_configure option contained only one type of memory allocation (i.e., single page – 8Kb). With the Memory Manager re-architecture improvement, all types of memory allocations will be accounted for by 'max server memory'. Come learn about what this change means for sizing memory for customer workloads in SQL Server 2012. You will also hear about related DMV and performance counter changes.
Event Date: 07-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: Application & Database Development
This session will show you how to put your database on a diet using compression, filtered indexes, maintenance, REBUILD and REORGANIZE, index management, and application changes. Topics will include how to calculate the storage required for each row, measure the actual storage of rows, and find hidden overhead such as Snapshot Isolation bytes. You'll see how to recover extra space and why NOT to SHRINK your database files. And you'll learn why log files grow, how to keep them under control, how to shrink log files the right way, and rebuilding files to recover the unused space.
Event Date: 07-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Yet for everything bad that can be said about triggers, there is one plain fact: They solve problems that cannot be addressed effectively anywhere else in the programming stack. In this session, we will contrast triggers with other methods of protecting data, such as client code and check constraints, and look at several use cases where triggers are the preferable path of protection (and many others where the opposite is true).
Event Date: 07-11-2012 13:30 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, you will learn how to architect the appropriate scalability solution for common scenarios in the database world. We will focus on replication and AlwaysOn – when you should you use which technology and how to maximize the benefit you achieve from each to meet your scalability needs.
Event Date: 07-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
During this session, we'll explore all the new security features in SQL Server 2012. When we're finished, you'll have everything you need to decide for yourself whether your databases will be adequately protected in SQL Server 2012 - or if security is getting way too onerous in SQL Server.
Event Date: 07-11-2012 13:30 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
You will learn how to build an effective HA/DR solution with a shared and/or non-shared storage model. We will also discuss upgrading from legacy solutions to new SQL Server 2012 AlwaysOn solutions with minimal downtime, as well as operational procedures to recover from a disaster with each of these solutions.
Event Date: 07-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
SQL Server 2012 provides you with an integrated storage solution that gives you both unstructured and structured data management with exciting new services, such as native Win 32 access and Statistical Semantic Search. This session will feature demonstrations as well as technical drill-down on how these technologies are built into the SQL Server engine and how you can take advantage of them in your applications.
Event Date: 07-11-2012 15:00 - Category: Spotlight Session (90 minutes) - Track: BI Information Delivery
Event Date: 07-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
In this couples therapy for you and Reporting Services, rekindle your passion by reviewing how reports perform best, seeing what the report server has been trying to tell you (but you haven't been listening), and discovering new and simple tricks you never knew your reports could do. You'll learn about the following and more:
• Dealing with blank extra pages • Designing reports for high performance • Powerful properties for precise layout and appearance • Troubleshooting using the execution log
After this session, you'll want to spend some time alone with your new old flame.
Event Date: 07-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
In this demo-rich session, we'll walk through the full syntax of the MERGE statement, go inside all the options, and see the possibilities. You'll also see the pitfalls that you need to be aware of if you, or someone else, uses MERGE – and how to solve them. Whether you already use MERGE or not, this session will show you new ways to tackle problems that would otherwise be much harder to solve.
Event Date: 07-11-2012 15:00 - Category: Spotlight Session (90 minutes) - Track: Application & Database Development
The session will draw on my years of personal experience managing busy e-commerce databases that support multi-million dollar businesses. Through real-life examples and demos, you'll see many ways that OLTP data quality can be compromised and how taking an integrated approach to this problem can make you more successful at your job.
Event Date: 07-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, you'll see some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query. You'll learn about the backup "execution plan" and how to access it. And understanding how to tune the individual portions of your backup process will let you knock 80% and even more off of your backup and restore time. I’m not holding anything back in this session. This is a method I’ve used for 15 years to tune my backups, and I’ve had great success.
Event Date: 07-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Incrementally loading data to a dimension and fact table with the Change Data Capture components is really slick. Data cleansing hangs with the best of them because of knowledge databases in DQS. And with SSIS Catalogs, a single source for deployment, configuration, and monitoring keep things well managed, with default reports and queries to the historical running data.
Event Date: 07-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2012 15:00 - Category: Spotlight Session (90 minutes) - Track: Professional Development
Event Date: 07-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: Professional Development
Event Date: 07-11-2012 16:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 07-11-2012 16:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session will show you the high availability and disaster recovery concepts of the underlying Windows 2008 R2 and SQL Server 2012 platform, especially the usage of AlwaysOn. We will also discuss lessons learned from DR exercises with large VMs, and see how patching is done with minimal downtime.
Event Date: 07-11-2012 16:45 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
In this session, we will discuss the integration points and demonstrate how you can use the PowerPivot add-in to further enhance Excel's data model by leveraging the additional BI modeling features available with PowerPivot. We will also cover new functionality delivered with the SQL Server 2012 PowerPivot add-in for Excel 2010.
Event Date: 07-11-2012 16:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2012 16:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2012 16:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
This session will share lessons learned and best practices of the Active/Active design and implementation, and we will demonstrate how to manage and monitor the solution. No need to wait for new product features!
Event Date: 07-11-2012 16:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2012 16:45 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Become your company's mobile BI expert - attend this demo-rich session to discover a number of novel ways to implement mobile BI from the technical perspective. You'll have the opportunity to try out mobile BI on mobile devices so you can maximize your learning experience with this technology. And we'll look at a variety of ways to deploy mobile BI using Microsoft technologies such as SharePoint, SQL Server Reporting Services, SQL Azure, Excel Services, and PowerPivot. After this session, you'll be ready to unleash mobile BI in your organization.
Event Date: 07-11-2012 16:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
The session will feature demos of common data modeling-to-database processes, including reverse engineering, forward engineering, generating DDL, alter scripts, and more. And you will leave with 10 tips for making model-driven database development successful in your organization's culture and environment.
Event Date: 07-11-2012 16:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2012 16:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 07-11-2012 16:45 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2012 16:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 07-11-2012 16:45 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-11-2012 16:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session will cover scale-out deployments, encryption keys, and service accounts. We'll also take a deep dive into the Report Manager. You'll see how security affects the management of reports, how to schedule reports to run automatically, and how to use data-driven subscriptions to effectively meet the needs of multiple users without the overhead of multiple reports. Finally, you'll see how to use both report snapshots and the report cache to minimize the impact on your data servers, return reports faster, and create an audit trail when needed.
Event Date: 08-11-2012 10:15 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
By the end of the session, you will understand: • How to view statistics and interpret the histogram • How and when to update statistics • How statistics affect the query optimizer • When you can let SQL Server manage statistics, and when you need to step in
Event Date: 08-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
We’ll compare and contrast the benefits of various storage techniques and cover a parallel-upload technique that has given us the best uptime performance. We’ll also show sample analytics running on Hadoop on Azure as an example of the workloads we’ve observed in early customer POCs.
Event Date: 08-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 08-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 08-11-2012 10:15 - Category: Spotlight Session (90 minutes) - Track: Application & Database Development
We'll look at the storage of the columns themselves and discuss the compression mechanisms that are used. We'll see how multiple columns in the columnstore index are organized into columns sets. And the metadata that gives you information about your columnstore indexes provides useful information that we'll examine. Understanding these new storage techniques and new query processing algorithms will let us see how SQL Server is able to perform the highly efficient batch mode processing.
Event Date: 08-11-2012 10:15 - Category: Spotlight Session (90 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 08-11-2012 10:15 - Category: Spotlight Session (90 minutes) - Track: Application & Database Development
In this session, you'll learn to take full advantage of SQL Server query parallelism. After a terminology review and technology refresher, the session will go deep, covering T-SQL patterns that allow certain queries to scale almost linearly across your multi-core CPUs. You'll see when and why the optimizer makes a parallel plan choice and how to impact the decision. Along the way, you’ll manipulate costs and row goals, challenge generally accepted tuning practices, and take complete control of your parallel queries.
Event Date: 08-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 08-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 08-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
In this session, we'll look at how an attacker would go about using SQL Injection to gain access to your database, see its schema and data, and do nasty stuff to both. Then we'll see how to battle such attacks at the UI front, the middle tier, and the SQL Server back end.
Event Date: 08-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
You will learn how to leverage peer-to-peer replication in real-life scenarios, seeing how replication can provide an optimal solution for many business requirements. We will also walk through best practices and see tips and tricks for easy implementation and maintenance of peer-to-peer replication.
Event Date: 08-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Join this revealing and thought-provoking session for answers. You'll wish you had known all these secrets sooner.
Event Date: 08-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session will focus on the new functionality and architecture. We will also cover some key concepts behind the cost-based optimizer for distributed scale-out systems and demonstrate improved integration with existing Microsoft BI tools and third-party tools (such as Cognos, Business Objects, and Informatica). Come hear about this new and exciting release of PDW and how it helps you address your data warehousing needs.
Event Date: 08-11-2012 10:15 - Category: Spotlight Session (90 minutes) - Track: BI Platform Architecture, Development & Administration
This session will introduce DAX as a query language, showing you the different ways of querying with DAX using real-world data. Some queries will be fast, others will need optimizations and a better understanding of query plans. We'll look at it all to give you a complete understanding of how to get the most out of DAX.
Event Date: 08-11-2012 10:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 08-11-2012 13:30 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: BI Platform Architecture, Development & Administration
Event Date: 08-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, you will learn how index fragmentation occurs, how it causes performance problems, how to determine index fragmentation, and different ways indexes can be defragmented. We will look at the pros and cons of REBUILD and REORGANIZE, how index defragmentation and statistics work together, and even how to reduce index fragmentation in the first place.
Event Date: 08-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: Application & Database Development
We'll look at the aspects of an execution plan that should be immediately checked, see why you should look at them, and walk through what to do about what you find. You'll be able to put all this information into immediate use when you return to the office. And you can apply this guidance to your SQL Server 2012 systems as well as older versions of SQL Server.
Event Date: 08-11-2012 13:30 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Professional Development
Event Date: 08-11-2012 13:30 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: BI Platform Architecture, Development & Administration
Event Date: 08-11-2012 13:30 - Category: 1/2 Day Session (3 hours) - Track: BI Platform Architecture, Development & Administration
Event Date: 08-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 08-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
We'll highlight the use of Big Data technologies – including Hadoop and Hive – with classic BI systems such as Analysis Services. After this session, you'll: • Understand the architectural components surrounding Hadoop, Hive, Classic BI, and the Tier-1 BI ecosystem • Have strategies for addressing the technical issues when working with extremely large cubes • See how to address the technical issues when working with Big Data systems from the DBA perspective
Event Date: 08-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 08-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
But is DirectQuery really the only option? By using partitions in a clever way and pushing the process time to its limits, it is possible to obtain good performance for near real-time systems. This session will show you the techniques for this solution and analyze how close we can get to real-time analysis by using in-memory databases.
Event Date: 08-11-2012 13:30 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Application & Database Development
Event Date: 08-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
In this demo-heavy session, you'll see how you can import data from the web and do ETL in the cloud with Data Explorer, plot your data on a map using Layerscape, explore relationships in Twitter using NodeXL, and find hidden patterns using the Excel Data Mining Add-ins for SQL Server 2012.
Event Date: 08-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Sure, Business Intelligence is all the rage but you don’t have to invest in an entire BI platform to have fresh, usable reports. These design techniques apply to enterprise analytic solutions and smaller-scale operational reporting.
Event Date: 08-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Whether you are a developer who needs to understand how isolation works and why NOLOCK is usually not an appropriate hint or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each isolation level and how it impacts the engine, then examine appropriate (and inapproriate) use cases for each.
Event Date: 08-11-2012 13:30 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Professional Development
Bill Fellows - Understanding the SSIS 2012 Deployment Model (BIA) Jes Borland - Lights! Camera! Piecemeal Restore! (DBA) Niko Neugebauer - Becoming a Master (PD) Oliver Engels - SSRS, Kerberos, and SharePoint (BIA) Sanjaya Padhi - Why DBAs Like Service Broker (DBA)
Event Date: 08-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: Application & Database Development
In this session, you'll see lots of techniques and best practices for tightening your databases' security in the design phase, including: • How to correctly use schemas to enforce and simplify security • Ownership chaining and its pitfalls • How to securely handle dynamic SQL to protect against SQL Injection • Code signing and the new Contained Databases and User-Defined Audit features that SQL Server 2012 provides for developers
Come see why these tools should be in every developer’s toolbox – your Admin will thank you.
Event Date: 08-11-2012 13:30 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Enterprise Database Administration & Deployment
Event Date: 08-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
We will explore row store vs. column store and how to change data in tables that have a columnstore index defined. We will also discuss segment elimination, batch mode execution, query memory grants, and how you can ensure that SQL Server will use your columnstore index as effectively as possible. Then, you will see a real-world example of how fast the columnstore index works on a table with more than 2 billion records – on commodity hardware.
Event Date: 08-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
We'll look at what replication roles and types of replication can be enabled with AlwaysOn AG. Then, we'll dig into the technical details of the changes that allow replication to run along with AlwaysOn AG and see how to achieve protection of the distributor. We'll also discuss what to expect of the combination of AlwaysOn AG and Change Data Capture/SQL Change Tracking. We'll finish up with a demonstration of how to configure a publisher and a subscriber on top of AlwaysOn AG and show how replication resumes after an availability group fails over.
Event Date: 08-11-2012 13:30 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Enterprise Database Administration & Deployment
Event Date: 08-11-2012 13:30 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session will dive into SQL Server 2012's new memory architecture. We'll see how to diagnose memory performance issues and gain insight into memory pressure issues. We'll also cover the settings to adjust memory configuration levels and their impact.
Event Date: 08-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
You'll see how easy it is to set up your first SQL Azure database and add SQL Reporting. SQL Reporting does not match SSRS feature for feature, but it does provide a solid platform that is perfect for certain reporting scenarios. You'll also learn exactly what SQL Reporting can do for you - and its limitations. With the information from this session, you'll be able to make an informed decision about using SQL Reporting to deliver Business Intelligence from the cloud.
Event Date: 08-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
In this session, we'll examine DQS and its role in the enterprise. We'll briefly examine the capabilities and architecture of DQS, discussing its strengths and weaknesses along the way. We'll also talk about some alternative approaches to data quality. Finally, we'll go through some practical examples of how to use DQS in real-world applications.
Event Date: 08-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 08-11-2012 15:00 - Category: Spotlight Session (90 minutes) - Track: Application & Database Development
You will see what makes some language features perform poorly and what you need to do to optimize them. Unfortunately, the default optimization of some language constructs is suboptimal, so you need to figure out workarounds for maximizing performance. We'll look at demos of a number of such cases and provide solutions. So sit back, relax, and have fun learning a thing or two you didn't know about T-SQL.
Event Date: 08-11-2012 15:00 - Category: Spotlight Session (90 minutes) - Track: Professional Development
You'll learn the fundamental difference between influence and authority and how you can achieve a high degree of influence without explicit authority. You'll also learn the eight techniques of influencing IT professionals, when to apply them, and how to best use them. And you'll discover the communication and procedural techniques that ensure your ideas get a hearing by bosses and peers, and how to best win support for them.
Event Date: 08-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 08-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 08-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
We'll cover operations such as parsing, binding, simplification, trivial plan, and full optimization. We'll also explore transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs.
Event Date: 08-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
Event Date: 08-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
We'll cover preparing and reporting for upgrade, upgrade strategies, performing the upgrade, and how to know the upgrade was successful. And we'll explore some advanced scenarios, including SQL Server 2012 on Server Core, preparing for AlwaysOn availability groups, upgrading your SQL failover cluster, and storage migration. After this session, you too can have “moves like Jagger.”
Event Date: 08-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 08-11-2012 15:00 - Category: Spotlight Session (90 minutes) - Track: BI Information Delivery
Power View, first released as a server-based report authoring tool with SQL Server 2012 and available in SharePoint Server 2010 Enterprise, will also be available in the Excel 2013 client. In this session, you'll see how to quickly and easily create compelling interactive reports and learn about the new features, including pie charts, maps, KPIs, hierarchies, drill down/drill up, and report styles.
The theory and demonstrations in this session will be based on the publicly available Office 2013 Preview.
Event Date: 08-11-2012 15:00 - Category: Spotlight Session (90 minutes) - Track: Application & Database Development
Data architects and database administrators have debated database design best practices for decades. Often, systems are built to handle current workloads, and as time progresses, the workloads increase but database performance doesn't scale accordingly. Attend this session to join the debate about the pros and cons of these design decisions. You'll learn about the contentious issues that will affect your end users most frequently and how to avoid them.
Event Date: 08-11-2012 15:00 - Category: Regular Session (75 minutes) - Track: Professional Development
Event Date: 08-11-2012 17:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
We'll dive into the DQS knowledge-driven approach, reusability, cleansing, and matching and explore the opportunities for collaboration between data stewards and IT professionals. You'll see how to create a Knowledge Base, define domains and rules to clean data, enrich data by using third-party data providers, and use the new SSIS DQS cleansing component.
Event Date: 08-11-2012 17:00 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
Event Date: 08-11-2012 17:00 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 08-11-2012 17:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, we'll begin with an introduction of horizontal partitioning and get insight into the relationships between data spaces, partitions, partition functions, partition schemes, filegroups, files, tables, and filetables. Then we'll walk through the simplest possible scenario for switching data in and out of partitioned tables with T-SQL, followed by examples of how to avoid the most common partition-switching errors. After this session, you'll be able to use the demo scripts to practice partition-switching as often as you want.
Event Date: 08-11-2012 17:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Co-speakers: David Smith, Michael Steineke, Ayad Shammout, Thomas Grohser, and Wolfgang Kutschera.
Event Date: 08-11-2012 17:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 08-11-2012 17:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 08-11-2012 17:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 08-11-2012 17:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 08-11-2012 17:00 - Category: Spotlight Session (90 minutes) - Track: Application & Database Development
Event Date: 08-11-2012 17:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
We'll walk through demos of some simple scripts for monitoring Analysis Services, focusing on monitoring the memory used by the Analysis Server. With this information, you can maximize the use of available memory on your system and know when you need to add memory or scale your Analysis Server solution to multiple servers.
Event Date: 08-11-2012 17:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 08-11-2012 17:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
• Excel • PowerPivot (Excel Add-in) • Report Builder and Report Designer (Reporting Services) • Dashboard Designer (PerformancePoint Services) • Power View
We'll build the same report with each of the tools, so you can concentrate on the tools and not on different reports. Then we'll see how to publish the reports in SharePoint and how to manage reports with and without SharePoint.
Event Date: 08-11-2012 17:00 - Category: Regular Session (75 minutes) - Track: Professional Development
In this session, you'll learn how to provide effective feedback to your peers and direct reports. You'll learn how to deliver feedback that encourages the behavior that you'd like to see repeated and provides recommended changes for behavior that is subpar or not acceptable. You'll also lean how to customize your feedback based on different personality types.
Event Date: 08-11-2012 17:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 09-11-2012 08:00 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
Event Date: 09-11-2012 08:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 09-11-2012 08:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 09-11-2012 08:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 09-11-2012 08:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 09-11-2012 08:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, we will look at the key resources that SQL Server uses – storage, CPU, memory – and how you can effectively troubleshoot them. You will learn how to identify performance bottlenecks and how to resolve them.
Event Date: 09-11-2012 08:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Knowing what features are used by Excel PivotTables, and what Power View users will see, can make a difference in your model design decisions. In this session, you will see the impact that model design decisions can make on each of these two client environments.
Event Date: 09-11-2012 08:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
You'll learn how to transform simple tables and matrices into so much more, how to use colors and graphics to emphasize data, and how to choose the right visual – plus a few other tricks.
Event Date: 09-11-2012 08:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
In this session, you will learn how the OS works with and affects SQL Server, how to configure the OS so it helps, rather than hinders, SQL Server’s performance, and how to troubleshoot key OS-related issues than can directly affect SQL Server. This session assumes you have minimal OS experience and focuses only on the areas of the OS that you need to understand to help ensure SQL Server’s optimal performance and availability.
Event Date: 09-11-2012 08:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 09-11-2012 08:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
If you are setting up Reporting Services 2012 with SharePoint 2010, you need to be aware of how this works and how it can affect you. We will also look at how PowerPivot can be effected by Claims configuration, which will bring us full circle back to Power View. Don't miss the demonstrations of some common issues you will encounter and how to correct them.
Event Date: 09-11-2012 08:00 - Category: Regular Session (75 minutes) - Track: Professional Development
Event Date: 09-11-2012 08:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In response, Microsoft has announced its planned implementation of Windows Server and Windows Azure implementations of Hadoop, the open source MapReduce engine widely used in Big Data implementations. And the plot thickens as Microsoft has also announced its plan to fit SQL Server BI tools on top of Hadoop to make the analysis part of Big Data work with familiar and accessible Microsoft technologies. Come to this session to get an overview of Big Data, Hadoop, and the Microsoft BI stack integration. And see how your skills can be applied to this rapidly growing part of the industry.
Event Date: 09-11-2012 08:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session will start by looking at the new XEvents in SQL Server 2012, including the new UIs available to help with configuration. We'll also look at the new XEProfiler tool that you can use to work with XEvents information, and then dive into some scenarios that show how to use XEvents to troubleshoot common performance problems on SQL Server.
Event Date: 09-11-2012 08:00 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
In this session, you'll learn about the architectures of the largest Azure projects in the world and discover when to chose the different storage options (SQL Azure vs. table vs. BLOB storage). You'll then be able to apply this information to your own projects.
Event Date: 09-11-2012 09:45 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Professional Development
Event Date: 09-11-2012 09:45 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: BI Platform Architecture, Development & Administration
Event Date: 09-11-2012 09:45 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Enterprise Database Administration & Deployment
Event Date: 09-11-2012 09:45 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Enterprise Database Administration & Deployment
Event Date: 09-11-2012 09:45 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Application & Database Development
Event Date: 09-11-2012 09:45 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 09-11-2012 09:45 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Professional Development
Edwin Sarmiento - Presentation WOW (PD) Gabriel Villa - Utility Database: Quick and Dirty Website to Monitor Performance (AppDev) Julie Koesmarno - TRY CATCH in a Nutshell (AppDev) Laerte Junior - T-SQL Health Check to Excel in Email in 10 Minutes with PowerShell (DBA) Neil Hambly - Effective Error Log Parsing (DBA)
Event Date: 09-11-2012 09:45 - Category: Lightning Talks (75 min, 10 min/speaker) - Track: Application & Database Development
Event Date: 09-11-2012 09:45 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
Event Date: 09-11-2012 09:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 09-11-2012 09:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, we'll talk about some of the things that can go wrong during package execution - and some of the defenses that can be built into SSIS to help head off those errors (or at least make the errors easier to troubleshoot). From error handlers to package restartability, and from logging methods to row count validation and remediation, we'll cover various ways to keep your ETL flowing when problems arise.
Event Date: 09-11-2012 09:45 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 09-11-2012 09:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
What are access methods and how in the SQL Engine do they affect compression? What are the “gotchas” of page compression? How does compression differ in the way it treats leaf and non-leaf level pages? What additional functionality did we get in DBCC Page, DMVs, Perfmon Counters, and Extended Events to support compression? And how do complex query plans affect compression? Come to this session to find out!
Event Date: 09-11-2012 09:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
This session will cover several different methods for migrating your data to SQL Server 2012 while meeting these objectives and minimizing your hardware and licensing costs. You will also learn how to help make the case that an upgrade makes good sense from a business perspective.
Event Date: 09-11-2012 09:45 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 09-11-2012 09:45 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
Event Date: 09-11-2012 09:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Demos will show how to integrate with Bing Maps and how to use the geospatial methods to easily calculate area, length, and distance and project new shapes based on intersection and overlap. We’ll also cover the latest geospatial enhancements in SQL Server 2012. Attend this session, and embrace spatial programming today!
Event Date: 09-11-2012 09:45 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
We'll review the benefits VMware provides, including hardware abstraction, easier failover, and simpler capacity planning. We'll also explore key tips to help administer a SQL Server instance running inside a virtual machine. You'll learn the differences in general administration, disaster recovery, and high availability on VMs; get a better understanding of activity and performance trends on VMs; and learn how to ensure effective capacity planning and optimal performance on VMs. If you’ve ever had a virtual deployment go bad, or if you’re struggling to manage the performance of virtualized SQL Servers, be sure to catch this session.
Event Date: 09-11-2012 09:45 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
• Power View and its impact for Data Visualization according to the principles of Stephen Few, Tufte, and other data visualization experts • PowerPivot improvements and new features • Reporting Services and its future in SharePoint
After this session, you can "hit the ground running" with BI and Data Visualization in SQL Server 2012.
Event Date: 09-11-2012 09:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 09-11-2012 09:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 09-11-2012 13:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
This session will introduce DQS concepts such as Term Based Relationships, Domain/Composite Domain Rules, and using Remote Data Services in Windows Azure marketplace. We will also cover “Cleanse to Knowledge Base” scenarios, demonstrating how to enhance your DQS KB as you cleanse, enabling a cycle of data quality improvement. If you’ve looked at DQS but aren’t sure how to get the most out of it for your data, come to this session to see how to move beyond the basics.
Event Date: 09-11-2012 13:00 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 09-11-2012 13:00 - Category: Spotlight Session (90 minutes) - Track: Enterprise Database Administration & Deployment
You'll get scripts to quickly narrow down the root cause of production problems and walk through queries to work with SQL Server 2005 and 2008, plus exciting new tools for SQL Server 2012. You'll also get a checklist to kick-start your response process. If you have a year's experience with database administration under your belt, this session will set you up to triage like a pro.
Event Date: 09-11-2012 13:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
The first step is understanding the DAX Query Plan, which is provided in SQL Server Profiler but requires some understanding of the operations performed by the formula engine and the storage engine. In this session, we'll see how queries are translated into query plans and then executed by the xVelocity in-memory engine, so that you can find the potential bottlenecks in a query plan and identify optimizations.
Event Date: 09-11-2012 13:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
These are just some of the questions this session will answer, giving you the practical tips and tricks for AGs and showing you the things that may trip you up along the way. All the lessons learned come from those who participated in the Technology Adoption Program (TAP) for AGs and have deployed the solution in production environments or helped customers plan and deploy in the real world. If you want to be successful with AGs, this session is for you.
Event Date: 09-11-2012 13:00 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
We’ll cover some common user scenarios and describe when and how to use the latest Microsoft data transfer technologies, including SQL Server Integration Services (SSIS), SQL Data Sync (a capability of SQL Database), and more.
Event Date: 09-11-2012 13:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
In this code-filled session, we’ll explore the similarities and differences of temporary tables and table variables, dispel some widespread myths about each, and answer the most important questions: When do I use one or the other? And what are the various impacts of doing so?
Event Date: 09-11-2012 13:00 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Tablets and smart phones are ubiquitous, but are we making effective use of them? We'll discuss the design approach to launch mission-critical dashboards and reports on smaller screen sizes using touch-screen technology. We'll look at iPad and Windows Phone, SSRS, and SharePoint from the perspectives of BI developers and business users, with an emphasis on data visualization best practices.
You'll learn about: • Current mobile apps that deliver BI on the Microsoft platform • Pros and cons of each delivery type • Resources for mobile BI development • How to design SSRS reports for mobile devices • How to design PerformancePoint dashboards for mobile devices • Administering cloud services for SQL Server and SSRS
Event Date: 09-11-2012 13:00 - Category: 1/2 Day Session (3 hours) - Track: Application & Database Development
Event Date: 09-11-2012 13:00 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Come hear about the spatial support in SQL Server and SQL Azure, the scenarios to consider, and the techniques available to add spatial support to your applications, including new spatial types, capabilities, and performance enhancements.
Event Date: 09-11-2012 13:00 - Category: Regular Session (75 minutes) - Track: Professional Development
Event Date: 09-11-2012 13:00 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 09-11-2012 13:00 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 09-11-2012 13:00 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
In this session, we’ll look at design solutions for web scale, leveraging a custom sharding approach vs. federations, and how to plan for capacity and size a deployment. We’ll also talk about how to help the application team instrument the app and build a telemetry system to collect the right data on performance and other areas, using VSTS on Azure or other test tools.
Event Date: 09-11-2012 13:00 - Category: Spotlight Session (90 minutes) - Track: Professional Development
This session is designed to get you thinking about all aspects of your career and, from there, moves into a discussion about time and money – how much of each are you willing to spend to get where you want to go? At the end of this presentation, you'll be ready to spend a few quiet hours charting all the things you want to do, figuring out which ones you can do with the resources available, and then writing down a plan to guide you for the next year.
Event Date: 09-11-2012 14:45 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
In this session, featuring lots of demos and samples, we'll go over options that the Azure platform provides in combination with federations to enable disaster recovery for such large-scale applications. We'll also look at the details for protecting against application upgrade disasters, from using hot standby copies to creating an on-premise warm standby or pairing data centers of your federations.
Event Date: 09-11-2012 14:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 09-11-2012 14:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 09-11-2012 14:45 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 09-11-2012 14:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 09-11-2012 14:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
This session will introduce SSDT and dive into a series of demonstrations on how you can develop, debug, refactor, and maintain SQL Server and SQL Azure databases from within the Visual Studio 2012 integrated environment.
Event Date: 09-11-2012 14:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Developed over a period of 30 years (initially for the mainframe), this methodology applies well to most database systems. Starting with the bottom-up analysis, we'll look at four basic areas of hardware performance issues: disk, memory, network, or processor. We'll also review what Perfmon counters to look at and what thresholds should cause concern. Next, we'll match that up with a top-down look at long-running queries using a server-side trace and querying the generated file(s). We'll finish off the session by discussing additional trace methods for "a million grains of sand," recompiles, and auto-stats.
Event Date: 09-11-2012 14:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 09-11-2012 14:45 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
From indexes to buffer cache analysis, from detecting the slowest queries to wait stats analysis, and from object dependencies to partitions data, we will expose and analyze the heart of SQL Server.
Event Date: 09-11-2012 14:45 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
We'll discuss the general use of SharePoint for BI and basic setup and installation of the farm, then fly over a completed SharePoint site. You'll tour SharePoint Central Administration, learning how to allow your site to take advantage of many BI features such as PowerPivot, Excel Services, and Reporting Services. With the release of SQL Server 2012, you'll also get a sneak peak at some improvements available in SharePoint for those who want to be on the cutting edge of this growing technology. Forget the slides – this tour will be all demo!
Event Date: 09-11-2012 14:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 09-11-2012 14:45 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
In this session, you will learn how to use the key parts of Data Quality Services (DQS): how to create a Knowledge Base, how to create Data Cleansing Projects to cleanse data both in the DQS client and inside SSIS 2012, and how DQS Matching Projects can integrate with Master Data Services (MDS) for de-duplication of data. We will focus on DQS but also look at how DQS, MDS, and SSIS function as a team in SQL Server's Enterprise Information Management stack.
Event Date: 09-11-2012 14:45 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Join this session to learn about the latest SQL Server Fast Track DW appliance products. We'll review the new SQL Server Fast Track 4.0 Data Warehouse methodology and the landscape of Microsoft’s data warehouse offerings, then dive into the specifics around the implementation of Fast Track in the new Data Warehouse appliance.
Event Date: 09-11-2012 14:45 - Category: Regular Session (75 minutes) - Track: Cloud Application Development & Deployment
Windows Azure StreamInsight allows event-driven applications to leverage cloud benefits such as scale-out and redundancy. In this session, we will walk through an end-to-end demo and explore the user model, current status, and roadmap of Windows Azure StreamInsight.
Event Date: 09-11-2012 16:15 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 09-11-2012 16:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
In this session you will learn about in-memory implementations and best practices using xVelocity and get a deeper understanding of in-memory optimization for datawarehousing, business intelligence and OLTP scenarios.
Event Date: 09-11-2012 16:15 - Category: Regular Session (75 minutes) - Track: Professional Development
Event Date: 09-11-2012 16:15 - Category: Regular Session (75 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 09-11-2012 16:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 09-11-2012 16:15 - Category: Regular Session (75 minutes) - Track: BI Information Delivery
Event Date: 09-11-2012 16:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 09-11-2012 16:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
We'll cover hardware, backups, backup tracking and archival, restores, security, high availability and disaster recovery, naming conventions, coding standards, creating new databases, updating databases, source control, SSIS, SSRS, new servers, technology refreshes, patching, performance monitoring, reassessing, multiple-environment infrastructure, and more. This document will come in handy, no matter what your organization. And if time permits, we'll discuss how to implement this best practices docuement in organizations with varying degrees of acceptance.
Event Date: 09-11-2012 16:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
From there, we will look at the planned feature additions to the Windows Azure SQL Database and how to simplify application migration to and from SQL Server, including how this relates to CDB. We will spend the final part of the presentation looking at how we will release future updates to T-SQL in the cloud, including breaking changes such as new reserved T-SQL keywords.
Event Date: 09-11-2012 16:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
In this session, we will introduce you to LocalDB, dive deep into its various capabilities, and contrast it with SQL Compact edition. We'll also see how LocalDB can be deployed and serviced, as well as how it is impacted by being used by multiple different applications. This discussion will give you a good understanding of the various aspects of LocalDB that make it an attractive local data store for application developers.
Event Date: 09-11-2012 16:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
It doesn't use any Windows services, only processes used and owned by applications using an instance of the database. An application works directly with databases as files rather than as server instances. This session will explore this latest version of SQL Server and see how it works in applications, letting you decide if the new kid is a flash in the pan or an upstart that will change how you write (some) database applications.
Event Date: 09-11-2012 16:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 09-11-2012 16:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development
Event Date: 09-11-2012 16:15 - Category: Regular Session (75 minutes) - Track: Enterprise Database Administration & Deployment
Through fun discussions and demos, we'll explore deriving file size growth from the msdb database and collecting schema information from the catalog views and performance information over time from the dynamic management objects, among other topics. Just think how valuable it will be to give your managers or clients information about the global environment on demand. The skills, tricks, and tips in this session will let you to do just that, without too much sweat on your part.
Event Date: 09-11-2012 16:15 - Category: Regular Session (75 minutes) - Track: Application & Database Development