March 6, 2014 Presentation 12:00 CST
Stellato - Making the Leap from Profiler to
If you’re like
me, you’ve been using SQL Trace and Profiler since you started using SQL
Server. They’re like old friends, tried and true. You know how they work, you
know what you can capture, and you know how to find the data you need. But now
you’ve been told that your good friends have been deprecated in SQL Server
2012, and you need to become best friends with Extended Events. What is THAT
Really. In this session, we’ll look at Profiler and Extended Events side by
side to see how easy it is to transition to Extended Events. We’ll step through
real-world examples using Extended Events to do what you’re used to doing with
Trace, and more. If you’re not on SQL Server 2012 yet, that’s ok, this session
will help you get prepared, and you'll walk out with a set of scripts to get
you started. If you’ve been putting off learning Extended Events because you
just don’t think you have the time (even if you’ve never used Profiler), this
is the session for you.
About Erin Stellato
Erin Stellato is a Principal Consultant
with SQLskills and lives in Cleveland, OH. She has over 13 years of technology
experience and has worked with SQL Server since 2003. Her areas of interest
include internals, performance tuning, and high availability and disaster recovery.
Erin is a SQL Server MVP and an active member of the SQL Server community. She
is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.
Data Architecture underpins just about everything we do in IT. Without a clear understanding of how data is structured, there is no reliable way to derive meaning from it. Data Architecture drives the design and governance of data systems, and thus should be of interest to any data professional. Data Architecture provides the blue-prints that we all share, whether we be DBAs, data integration developers, database developers, data warehousing professionals, data presentation developers or client-side application developers persisting data for later retrieval.
The PASS Data Architecture Virtual Chapter will focus on data architecture concerns as they impact users, developers and DBAs on the Microsoft SQL Server platform. We want to make data architecture accessible to all data practitioners, and drive the point home that Data Architecture is a set of practices and a body of knowledge that overlaps almost all database professionals to some degree.
Email us at firstname.lastname@example.org or twitter is @DArchVC