Pass-Tv

Ecco i numeri della galassia PASS, presentati al Summit 2014…

 

…mi pare non siano necessari commenti!

Sempre più professionisti, tecnici e analisti ritengono che questo evento sia un importantissimo momento di formazione e scambio culturale in cui è possibile accedere a risorse con competenze e professionalità elevatissime, mi riferisco agli Speaker, ai componenti del Team SQLCAT, ai tecnici che presidiano la SQL Server Clinic e ai componenti del Team di sviluppo di SQL Server.

Sul canale SQLPASS TV è stata pubblicata la sessione Troubleshooting Clusters tenuta da Allan Hirt (@SQLHA) durante lo scorso PASS Summit 2013.

Abstract

Whether you are new to clusters or have years of experience, you may still cross your fingers when implementing a failover cluster instance (FCI) of SQL Server or an availability group (AG). Both require an underlying Windows Server failover cluster (WSFC), but how many DBAs are involved in the planning and deployment of it? What happens if you try to install an FCI or configure an AG and things don’t work? Or worse, what if the implementation fails after going live in production? This session will cover how to diagnose what went wrong and the free tools available to you, as well as demonstrate how to fix common issues that every DBA should know about.

Sul canale SQLPASS TV è stata pubblicata la sessione “Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad” tenuta da Kimberly Tripp (@KimberlyLTripp) durante lo scorso PASS Summit 2013.

Abstract

When data distribution is heavily skewed, cardinality estimation (how many rows the query optimizer expects each operator to process) can be wildly incorrect, resulting in poor quality query plans and degraded performance. You’ve probably seen the advice to update all statistics if a query plan looks wrong - but is that the right advice? In many cases, no! These are “sledgehammer” approaches, and while they might solve some problems (usually parameter sniffing problems), they don’t solve the actual problem. In this session, you’ll learn a generalized yet tailored-to-the-table way to solve query plan quality problems for very large tables (VLTs). Topics will include creating, using, and updating filtered statistics; using forced parameterization and templatized plan guides; and understanding stored procedures and how they can leverage filtered statistics.

Sul canale SQLPASS TV è stata pubblicata la sessione Building Your T-SQL Tool Kit: Window Function Fundamentals tenuta da Christina E. Leo (@christinaleo) durante lo scorso PASS Summit 2013.

Abstract

Have you pulled a script to identify duplicates from a blog post but couldn’t quite get it to work because you weren’t sure what that ROW_NUMBER() function was doing? Maybe you heard talk about creating running totals without using subqueries, but you got frustrated when the groups weren’t totaling correctly. Or maybe, you’ve never even heard of window functions. All are good reasons to attend this all-demo session, which demystifies this versatile T-SQL tool. First, we’ll break apart the OVER clause, the key to understanding how window functions work. Then we’ll expand on each group of functions that can use the OVER clause: ranking, aggregate, and analytic functions. Finally, we’ll look at real scenarios where this tool works and talk about performance considerations. When you leave, you’ll have the fundamentals you need to fully develop your mastery of window functions.

Sul canale SQLPASS TV è stata pubblicata la sessione Automate Your ETL Infrastructure with SSIS and PowerShell tenuta da Allen White (@SQLRunr) durante lo scorso PASS Summit 2013.

Abstract

Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious, and it’s easy to miss something in the process of generating the same basic package over and over again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session, we’ll see how you can use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.

Sul canale PASStv è stata pubblicata la sessione How to Use DMVs to Diagnose Performance Issues tenuta da Glenn Berry durante lo scorso PASS Summit.

Le DMVs (DMV + DMF) forniscono informazioni sullo stato di salute dell’istanza SQL Server. Permettono di diagnosticare problemi di performance e rappresentano uno strumento utilissimo sia per i DBA che per gli sviluppatori; aumentano ad ogni versione di SQL Server e dopo averle toccate con mano non potrete più farne a meno vi consiglio quindi di non perdervi questa sessione!

PASS Summit 2013 si è concluso, e anche quest’anno i numeri sono positivi:

• 2000 aziende rappresentate
• Si riconferma l’evento singolo, più grande al mondo, dedicato a SQL Server
• Partecipanti da 52 paesi del mondo
• 5000 registrazioni
• Più di 500000 ore di formazione erogate da collaboratori volontari

Questo è video di benvenuto: Welcome live from PASS Summit 2013

Visto il successo avuto nelle precedenti edizioni, anche quest’anno le keynote, alcune sessioni e interviste (41 in totale!) sono state trasmesse in live-streaming e subito rese disponibili per essere riguardate on-demand sul canale SQL PASS TV. In altre parole, nuove ore di formazione gratuite, fruibili quando lo si desidera. Per chi non ha potuto partecipare, questa è un’ottima occasione per avere un assaggio dell’evento, ecco i link…

Sul canale SQLPASS TV di YouTube, continua la pubblicazione delle sessioni erogate al PASS Summit 2011. Questa settimana è stata pubblicata la sessione What’s New in Security for SQL Server Code Name “Denali” tenuta da Il-Sung Lee (Senior Program Manager @ Microsoft).

Abstract

Security continues to be a top concern for database administrators as they face the ever-present threat of data breaches and the increasing pressures from compliance regulations such as PCI and HIPAA. Fortunately, SQL Server 2008 delivered some key features, such as TDE and SQL Server Audit, to help administrators achieve their security goals and Denali makes further progress with enhancements to Audit and security manageability. This session takes an experienced users approach to the advanced topic of recent security enhancements to SQL Server and explains the new changes coming to Denali and how they can help you satisfy your security objectives.

Sul canale SQLPASS TV, continua la pubblicazione delle sessioni erogate al PASS Summit 2011. Questa settimana è stata pubblicata la sessione Who is Responsible? The Vendor or the DBA? I due speaker: Erin Stellato (nei panni del software vendor) e Mike Walsh (nei panni del DBA) hanno dato vita ad una sessione interattiva che vi farà comprendere come sia possibile migliorare il rapporto tra DBA e software vendor.

Abstract

Database administrators - you don’t really trust your third party software vendors, do you? Software vendors - you think most of the DBAs out there are hiding things, don’t you? Well guess what, you’re both right! Join Erin Stellato (representing vendors) and Mike Walsh (representing DBAs) for an interactive session where they will tackle some of the toughest challenges that DBAs and vendors face when working with each other. Attendees will walk out with a better understanding of what both parties can do to contribute to a successful relationship, as well as a set of fair questions to ask to set the right expectations from the start. Attend our session to see if a Vendor and DBA really can get along, and listen in on some real life horror story examples of how not to do it.

Sul canale SQLPASS TV, continua la pubblicazione delle sessioni erogate al PASS Summit 2011. Questa settimana è stata pubblicata la sessione Building a Professional Development Plan tenuta da Andy Warren.

Abstract

Ready to take the next step in your career? Ready to build a plan that will get you there? This session will show you a process for building a comprehensive professional development plan - a road map to get to where you want to go! This session is designed to help you build a professional development plan using the same techniques that are used for building business plans. We’ll talk about obtaining and managing resources, setting realistic goals, tracking progress, and what to do when you get off plan. We’re going to look at more than pure technical learning. We’ll discuss how and when to modify your plan to include networking, writing, social engagement, and managing and leadership skills - and talk about the most effective ways to do it. We’ll touch lightly on the value of a mentor and ways to find a good mentor. We will also discuss changing how you look at your career, adopting the mindset of the consultant even if you prefer to retain your status as an employee. It’s not an easy change, but it’s a powerful one, and that is an important component of a professional development plan. At the end of this session you should be ready to spend a day building a plan that will help you move your career forward to a goal that you’ve selected.