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 REGISTER
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.