Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources – including an archive of past presentations, and special training events.
HASSUG & H-BI Monthly Meeting - June 11, 2013
In-Person & Online Event
Language: English
Date: Tuesday, June 11, 2013
Time: 12:30 pm - 3:30 pm (Mountain Time)
Cost: Free
Featured Presentation
Extend Your Knowledge with Extended Events!
Speaker: Janis Griffin, Senior DBA Confio Software, Inc.
Summary: SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server. Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data alongside of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies in 2012.
About Janis: Janis Griffin has over 25 years of DBA experience including design, development and implementation of many critical database instances. Her primary focus has always been database performance. Before coming to Confio, she held many DBA positions, primarily in the Telecom/Network Industry, working with real-time network / OLTP databases. At Confio, her primary focus is assisting customers in finding and fixing database performance issues.
Introduction to Big Data
Speaker: Tyler Chessman
Summary: Tyler will answer the question: What is Big Data? Then, he will give a DBA's perspective of Big Data. Finally, he will discuss Microsoft's approach to Big Data via Data Management, Data Enrichment, and Insight.
Virtualization - "Monitoring Virtual SQL Servers"
Professional Development - Online Event
Language: English
Date: Wednesday, June 12, 2013
Time: 10:00 am - 11:00 am (Mountain Time)
Cost: Free
Speakers: Jes Borland & Grant Fritchey
Summary: Many of the metrics used to monitor performance on SQL Server are completely unaffected by whether or not you’re running on a virtual machine. Some of those metrics are seriously impacted. Knowing which metrics are impacted and, more importantly, why, is the purpose of this session. We’ll spend time outlining what you can monitor normally in SQL Server, and we’ll show what parts of monitoring require you to do things differently because of the nature of virtual servers. You will be able to gather meaningful metrics from your own systems using the information presented in this session.
BI Implementation for Healthcare Surveillance
Business Intelligence - Virtual Chapters - Online Event
Language: English
Date: Wednesday, June 19, 2013
Time: 8:00 am - 9:00 am PDT
Overview: Business Intelligence (BI) systems are collections of tools that provide the ability to transform huge amount of data into Knowledge and, eventually, informed decisions. BI systems are nowadays are among the essential tools in many industries, such as banking and marketing. Many BI implementations have also been conducted in healthcare, and many of them have already shown significant positive results. This session will highlight the utilization of BI in the healthcare surveillance field. It will focus on a BI implementation that took place in one of the heath councils in the state of Florida. The speaker will start by covering the Information Technology (IT) infrastructure of the council prior to the project initial. He will then walk through the different project phases until the system development completion. The speaker will also highlight the key system components and provide a number of demonstrations to illustrate their functionality and benefits.
Speaker: Raed AlHazme
About Raed: Raed AlHazme holds a master’s degree in biomedical informatics. He is also an MCTS in the Development and Implementation of Microsoft Business Intelligence, HL7 certified, and Lean Six Sigma Green Belt certified. Raed is currently pursuing his PhD in biomedical informatics at the University of Medicine and Dentistry/Rutgers University.Recently, Raed was the key designer, developer and implementer of a complete BI system for Broward Health Planning Council (BRHPC) at the state of Florida. The system included an Extraction Transformation and Loading (ETL), data cubes, analytical reports, analytical maps, and a SharePoint 2010 solution to deploy the BI components. Raed is currently working on expanding the BI system to cover the other health planning councils at the state of Florida.
Cost: Free
DArch - Challenge Designing Finance DW
Language: English
Date: Thursday, June 20, 2013
Time: 12:00 pm - 1:00 pm (Central Time)
Cost: Free
Summary: Challenges to designing financial warehouses, lessons learnt In today’s rapidly changing financial world, designing robust and durable data warehouses can be a challenge that does not always stand the test of time. In this presentation, we shall look at some of the challenges and design issues that were encountered whilst designing two custom warehouses and the steps that were required to cope with ongoing requirement changes, indecision from management, and shrinking budgets; all of which affected the progress of moving these projects from the design board to a profitable production stage.
Speaker: Steve Simon, Senior Business Intelligence Development Engineer Atrion Networking Corporation
About Steve Simon: Steve Simon is a SQL Server MVP and a senior BI Development Engineer with Atrion Networking. He has been involved with database design and analysis for over 25 years. Steve has presented papers at eight PASS Summits and one at PASS Europe 2009 and 2010. He has just recently presented a Data Quality Services presentation at the PASS Nordic Rally in Copenhagen. Steve has also presented 5 papers at the Information Builders' (IBI) International Summits. He is a PASS regional mentor & chair of the Oracle/SQL Server VC.
PowerPivot and Complex DAX Expressions
BI Virtual Chapter
Language: English
Date: Wednesday, June 26, 2013
Time: 9:00 am - 10:00 pm (PDT)
Cost: Free
Summary: PowerPivot is a powerful new tool able to slice and dice data in memory very fast. In this session you will learn how to build complex situations like, parent child hierarchies, Many to Many, and using inactive Relationships and learn some string manipulations. Come see these complex DAX functions and leave with some great DAX knowledge. Key takeaways: Learn DAX expressions like parent child hierarchies and Many to Many.
Speaker: Mike Davis
About Mike Davis: Mike Davis, MCITP, is a Managing Project Lead and BI Architect at Pragmatic Works. He is an author with books covering Business Intelligence and SSIS. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, SQL Saturday, and SQL Rally. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.
Summer Performance Palooza 2013
Performance Virtual Chapter
Language: English
Date: Tuesday, June 27, 2013
Time: 9:00 am - 5:00 pm (Mountain Time)
Cost: Free
Featured Presentations
9:00 - How the SQL Server Engine Thinks
Speaker: Brent Ozar
RSVP: https://attendee.gotowebinar.com/register/3571390038980185344
Abstract: When you pass in a query, how does SQL Server build the results? We'll role play: Brent Ozar will be an end user sending in queries, and you'll be the SQL Server engine. Using simple spreadsheets as your tables, you'll learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This session is for DBAs and developers who are comfortable writing queries, but not so comfortable when it comes to explaining nonclustered indexes, lookups, and sargability.
About Brent: Brent Ozar specializes in making SQL Server faster and more reliable. He's a Microsoft Certified Master of SQL Server and MVP, and he has over a decade of experience. He coauthored Professional SQL Server 2008 Internals and Troubleshooting, and he loves sharing knowledge at BrentOzar.com.
10:00 - Updates to Statistics and the Effect on Query Performance
Speaker: Erin Stellato, Senior Consultant SQLskills.com
RSVP: https://attendee.gotowebinar.com/register/8095340527805459712
Abstract: Someone comes up to you and says “my query is slow.” Where do you begin? Do you start with the query itself? The query plan? SQL Server DMVs? There are many areas to investigate and one common area of focus is statistics. Statistics are an easy target for blame when performance is poor, and updating statistics without sufficient background information is a popular response as a “quick fix”. But what does updating statistics really do to your query plans? And is that the right solution? While updating statistics may solve your problem in the short-term, it may bury the true root cause. If you’re not familiar with what happens to query plans when you update statistics, then don’t miss this session. We’ll set the stage with a review of what statistics are, how the optimizer uses them, and discuss the various ways you can update them. Then we’ll explore what happens to plans when you do update statistics, and you’ll see why that might not always be the right long-term solution.
About Erin: Erin Stellato is a senior consultant with SQLskills and lives in Cleveland, OH. She has over 12 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.
11:00 - 10 Bad Habits that can Kill Performance
Speaker: Aaron Bertrand, Senior Consultant SQL Sentry, Inc.
RSVP: https://attendee.gotowebinar.com/register/5110462226512473088
Abstract: Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them.
About Aaron: Aaron Bertrand is a senior consultant for SQL Sentry, makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He blogs at sqlperformance.com and sqlblog.com, has been an MVP since 1997, will soon be a three-time SQL Cruiser, and speaks frequently at various community events. You can find his MVP profile at https://mvp.support.microsoft.com/profile/Aaron.
12:00 - Using Performance Monitor for your Virtual Servers
Speaker: Wendy Pastrick, Consultant BlueGranite
RSVP: https://attendee.gotowebinar.com/register/641338885939701248
Abstract: Your SQL Servers have now been virtualized, and you are monitoring them successfully. Do you know what the performance is like on the host, though? Using Performance Monitor (perfmon) we will look at the counters you need to have in place to know if your host is performing well. Set up the counters, collect the data and have meaningful conversations with your Virtualization or Infrastructure team.
About Wendy: Wendy Pastrick is a consultant in Chicago with BlueGranite, a Business Intelligence firm. She has been working with SQL Server since 2001 and specializes in server maintenance, migration and upgrades as well as architecting for high availability and disaster recovery. Wendy is an active member of the PASS organization, currently serving on the Board of Directors and often speaks at local user groups and SQL Saturday events. She has recently been awarded an MVP from Microsoft for SQL Server.
13:00 - Looney Tuner? No, there IS a method to my madness!
Speaker: Janis Griffin, Senior DBA Confio Software, Inc.
RSVP: https://attendee.gotowebinar.com/register/2019100622824750592
Abstract: SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL Diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
About Janis: Janis Griffin has over 25 years of DBA experience including design, development and implementation of many critical database instances. Her primary focus has always been database performance. Before coming to Confio, she held many DBA positions, primarily in the Telecom/Network Industry, working with real-time network / OLTP databases. At Confio, her primary focus is assisting customers in finding and fixing database performance issues.
14:00 - Pivoting Performance Data & Pinpointing Problems
Speaker: Brian Flynn
RSVP: https://attendee.gotowebinar.com/register/2073955257666587136
Abstract: Got performance problems? Struggling crack the case? Whether the problem is SQL Server, Windows, IIS or anything else. I've got a technique for logging and analyzing performance data using tools you probably have. Using these tools I have been able to find needles in haystacks and effectively communicate the nature of the problems to people at all levels. You don't need an expensive 3rd party product if you've got elbow grease and the code I'll give you. In this session, I'll demonstrate how I capture and analyze DMV and WMI counters. I'll tell some stories how this helped me solve some mysteries. You could use this pattern for any counters you can get your hands on. Join me for some mystery SQL theatre!
About Brian: Brian Flynn has been working in IT since his college days in 1995, beginning as a desktop support technician. Since graduating with a Computer Science & Mathematics degree from SLU in 1999, he has served in many roles such as web and database development, administration and system engineering of multiple disciplines including web, database, mail and networking. He has been functioning in management capacities since 2008 and enjoys promoting social interaction and team building among I.T. pros.
15:00 - Index Methods You’re Not Using
Speaker: Jes Borland, Consultant Brent Ozar Unlimited
RSVP: https://attendee.gotowebinar.com/register/8999427157149141248
Abstract: There are index methods in SQL Server that can enhance the performance of your queries - but most likely, you aren't using them! Using examples, I'll show you how indexed views, filtered indexes, and compressed indexes work; how they can improve performance; and what situations each is best used in. If you have a solid knowledge of index basics and want to add to your collection, this is the session for you!
About Jes: Jes Schultz Borland is a consultant with Brent Ozar Unlimited and a Microsoft SQL Server MVP. She holds an AAS - Programmer / Analyst degree and has worked with SQL Server as a developer, report writer, DBA, and consultant. She is an active member of PASS, President of FoxPASS in northeast Wisconsin, founder of Tech on Tap, and a LessThanDot.com blogger. Jes frequently presents at user groups, SQLSaturdays, and other community events. She is also an avid runner and chef.
16:00 - How to Build an Affordable SQL Server Lab
Speaker: Todd Kleinhas, Senior SQL Server DBA consultant Datavail
RSVP: https://attendee.gotowebinar.com/register/5686199500230306048
Abstract: Do you have an affordable lab set-up running SQL Server 2012 on Windows 2012 to learn and play with? In the 70-462 Administering Microsoft SQL Server 2012 Databases Training Kit, you will need six (!) machines on their own domain to complete the exercises. Using VMWare Workstation 9 ($250), Todd will show how to set up your lab environment on a ~$500 laptop running Windows 7 64-bit, 8GB of RAM, and an SSD drive using less than 40GB of space for the six virtual machines! Using free iso(s), we will run through several of the set-up exercises from the 70-462 Training Kit in order to build out the training lab. Participants will leave with enough knowledge and links to resources to build their own affordable SQL Server 2012 lab.
About Todd: Todd Kleinhans has been working with SQL Server since 1999. He has worked as a dba, developer, data architect, manager, and consultant. He is currently a Senior SQL Server DBA consultant at Datavail. Todd is also the current VP of Marketing for the Denver SQL Server User Group. He has presented at user groups, SQL Saturdays, and the Rocky Mountain Trifecta.
