Pass-Tv

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.

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.

Sul canale SQLPASS TV, continua la pubblicazione delle sessioni erogate al PASS Summit 2011. Questa settimana è stata pubblicata la sessione “Query Tuning Mastery: Zen and the Art of Workspace Memory” tenuta da Adam Machanic.

Abstract

As SQL Server professionals, we often think of memory in vague, instance-level terms: buffer pool, procedure cache, Virtual Address Space, and so on. But certain tasks require a more in-depth focus, and query tuning is one of them. Large, complex queries need memory in which to work –workspace memory– and understanding the how’s, when’s, and why’s of this memory can help you create queries that run in seconds rather than minutes. This session will teach you how to guide the query processor to grant enough memory for top performance, while also keeping things balanced for the sake of concurrency. You will learn advanced monitoring techniques, expert-level application of specialized query hints, and the memory internals needed to put it all together. If you work with large queries and are serious about achieving scalability and consistently great performance, you owe it to yourself to attend this session.

Sul canale SQLPASS TV, continua la pubblicazione delle sessioni erogate al PASS Summit 2011. Questa settimana è stata pubblicata la sessione No More Bad Dates: Best Practices for Working with Dates and Times tenuta da Kendra Little (Managing Director, Brent Ozar Unlimited).

Abstract

Dates and times seem simple at first. Kendra Little will show you there’s more to it than you think. She’ll give you five best practices that will help you select the right temporal data type, avoid common issues, and use the most effective techniques to aggregate data. She’ll also explain painful problems with query performance and how to avoid them. Choose wisely: the correct types and high performing data access logic will scale like magic.

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: