SQLSaturday 294

Philadelphia, United States

PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. This event will be held on Jun 07 2014 at 45 Liberty Blvd., Malvern, Pennsylvania, 19355, United States

Register Now


Welcome to SQLSaturday #294 Philadelphia 2014

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. The Philadelphia SQL Server User's Group is extremely proud to be presenting SQL Saturday #294. The event will be held June 7th 2014 at Microsoft 45 Liberty Blvd., Suite 210 Malvern, PA 19355.   Admittance to this event is free, but we do charge a lunch fee of $10.00 so that we can provide a lunch. Please register soon as seating is limited, and let friends and colleagues know about the event.

Two Pre-Cons Now Available

Session 1 -- Allan Hirt, MVP 
The Good, Bad, and Ugly of AlwaysOn Availability Groups  REGISTER

Ever since it was introduced in SQL Server 2012, availability groups (AGs) have been a source of interest, curiosity, and confusion. We've hit a point where many are seriously evaluating and looking to deploy AGs, but they are deceptively easy to deploy. While AGs share some common traits with both database mirroring and clustered instances of SQL Server (FCIs), the feature is its own entity. This full day pre-conference session will focus on getting you up to speed with AGs in SQL Server 2012 and 2014. Some of the major topics include:
  • The real difference between FCIs and AGs - one of the sources of confusion since they both use an underlying Windows Server failover cluster (WSFC)
  • Planning a WSFC for an AG deployment, including things like networking and hybrid scenarios that involve the cloud.
  • WSFC quorum for AGs.
  • Failure scenarios and how to recover from them.
  • Tips, tricks, and best practices for deploying AGs and their administration
To reinforce the concepts, there will also be a lab component to the day. You will need to bring your own device. Details will be sent after you register.

Session 2 -- Joseph D'Antoni and Stacia Misner 
Analytics Without Limits: The Modern BI Architecture Story

The traditional enterprise data warehouse has been around a long time, and it isn’t going away anytime soon. However, the influence of big data, cloud computing, and in-memory analytics have changed the scale and approach to business analytics. Microsoft is heavily invested in Big Data through its partnership with Hadoop vendor HortonWorks, HDInsight (its Hadoop as a Service offering in Azure) and the Power BI stack which integrates tightly to provide rich visualization and analysis from an array of data sources.

In this preconference workshop, you will learn the basics of Hadoop, both with MapReduce and Yarn (Hadoop 2.0). In addition to learning the architecture of these solutions, you will gain understanding of how to interact with them by using a variety of tools, such as Pig, Hive, and Sqoop. You will learn to refine data from a variety of data sources, and gain an understanding of modern data analytic architectures such as columnstore indexes and In-Memory tables, that allow for near real-time analytics of very large volumes of data.

Also in this workshop, you will learn core analytical techniques using statistics, distributions, and correlations. In addition, you will learn techniques for using data visualizations as part of the analytical process, and specifically how to create rich visualizations using the Power BI toolset. Last you will see how results can be shared across your organization by using Office 365 SharePoint Online, and explored with Power Q&A.

Event Location

Event news

No Event News entered. Please come back later and check again


Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us

What is a PASS SQLSaturday?

PASS SQLSaturdays are local events organized by PASS community members around the world. PASS is a not-for-profit association for data professionals who leverage the Microsoft Data Platform, offering interactive learning built by community and guided by trusted data experts.

Back to Top cage-aids