Pass

Sul canale SQLPASS TV, continua la pubblicazione delle sessioni erogate al PASS Summit 2011. Questa settimana è stata pubblicata la sessione SQL Server Execution Plans (From Compilation to Caching to Reuse) tenuta da Maciej Pilecki (SQL Server MVP, MCM).

Abstract

Execution plan reuse is one of the most important aspects of building well-performing and scalable SQL Server solutions. But it’s also the one that is often overlooked during the design phase and becomes very difficult to troubleshoot later. In this session we will discuss in details the following aspects of SQL Server execution plans: compilation, re-compilation, parameterization, caching, reuse and aging. You will leave this session with full understanding of how to improve your server’s performance by increasing execution plan reuse (and how to avoid reuse in case this is necessary).

Stati resi pubblici a tutti, non solo ai partecipanti, una selezione di 10 sessioni del PASS Summit 2012. Tra le sessioni si trovano vere e proprie perle come quella di Bob Ward sugli internals di SQL Server 2012, giusto per citarne una che contiene informazioni altrimenti introvabili

Trovate qui l’indice:

Sul canale SQLPASS TV, continua la pubblicazione delle sessioni erogate al PASS Summit 2011. Questa settimana è stata pubblicata la sessione Top 10 Things You Didn’t Know About SSIS in SQL Server 2012 tenuta da Matt Masson (SQL Server Integration Services Team).

Abstract

By now you all know about the major SSIS improvements in SQL Server code name “Denali” - the enhanced Developer Experience, the Project & Parameter model, and the new Server based deployment features. This session will cover many of the other major improvements to the product that are sure to bring a smile to your face. With hundreds of customer reported Connect issues fixed, the upcoming release will be the highest quality release to date. Come find out more!

Anche quest’anno torna il PASS Rally Nordic, evento di un giorno dedicato a SQL Server, in Europa, in cui saranno presenti i migliori speaker internazionali:

• 1 day of deep-dive pre-conference seminars
• 2 full days of top technical sessions focused on: - BI Platform Architecture, Development and Administration - Database and Application Development - Enterprise Database Administration and Deployment
• A special 1-day Executive Track for decision makers, architects and executives
• Great networking with your SQL Server peers in a fun, casual environment

Entro il 10 Maggio potete risparmiare 300 Euro sull’iscrizione!

Sul canale SQLPASS TV, continua la pubblicazione delle sessioni erogate al PASS Summit 2011. Questa settimana è stata pubblicata la sessione Introduction to Data Mining in SQL Server Analysis Services tenuta da Brian Knight (Owner @ Pragmatic Works).

Abstract

Data mining is one of the key hidden gems inside of Analysis Services but has traditionally had a steep learning curve. In this session, you’ll learn how to create a data mining model to predict who is the best customer for you and learn how to use other algorithms to spend your marketing model wisely. You’ll also see how to use Time Series analysis for budget and forecast prediction. Finally, you’ll learn how to integrate data mining into your application through SSIS or custom coding.

Sul canale SQLPASS TV, continua la pubblicazione delle sessioni erogate al PASS Summit 2011. Questa settimana è stata pubblicata la sessione Zero to Cube - Fast Track to SSAS Development tenuta da Adam Jorgensen (President @ Pragmatic Works Consulting).

Abstract

This session was TOP 3 in its track last year and is always a crowd pleaser. I won a coveted Summit Spolight Session at SQL Rally this year by popular vote and it has been a hit at SQL Saturday’s all over the east coast because it is 100% demo and driven with real world data the attendees can get and use themselves. In this session, the attendees will learn how to drive and build an Analysis Services cube and reports as they rotate through the podium as volunteers. This session will show the crowd how simple it is to begin delivering powerful analysis to your end user community without going through a significant development cycle.

Sul canale SQLPASS TV di YouTube, continua la pubblicazione delle sessioni erogate al PASS Summit 2011. Questa settimana è stata pubblicata la sessione Developing and Managing a Business Intelligence Semantic Model tenuta da Cathy Dumas (Program Manager @ Microsoft).

Abstract

Use the new features in SQL Server code name “Denali” to develop and manage a BI Semantic Model in Analysis Services. We will discuss the new capabilities in creating your BI Semantic Models, using PowerPivot as a starting point, and how to troubleshoot your models.