|Several SolidQ mentors are part of an elite group of SQL Server and business intelligence (BI) experts who will share their skills and knowledge at PASS Summit 2013 in Charlotte, NC. SolidQ mentors Nabeel Derhem, Itzik Ben-Gan, Allan Hirt, Andrew Kelly, Dejan Sarka, James Serra and Paul Turley will present both pre-conference and conference sessions. The daylong pre-conference sessions will be held on October 14 and 15. The conference starts the evening of October 15 and runs through October 18.
PASS Summit 2013, Charlotte NC
Nabeel Derhem is a solutions and database architect, an MCT,
MCITP, MCSD, has a BA in Computer Science and an MBA. Widely recognized for his expertise in SQL
Server and Microsoft cloud technologies, he is a frequent speaker in many
communities and worldwide events. In his session “Moving Your Database to the
Cloud – What You Need to Know,” Nabeel explores the challenges and differences
between on-premise and the cloud, reviews advantages and disadvantages of
hosting, and discusses possible tools. In his second session, “NoSQL: An
Introduction,” the SQL Server professional will hear the history, needs,
strengths and weaknesses surrounding NoSQL.
Itzik Ben-Gan, co-founder of SolidQ and a Microsoft SQL
Server MVP since 1999, provides T-SQL training around the world. Whether he's
in the United States or abroad, he has found that T-SQL solutions written to
perform common tasks aren't always efficient. During his pre-conference session
"Practical T-SQL – Efficient Solutions," Itzik will walk through
several examples of inefficient T-SQL solutions, explain the reasons for the
inefficiencies, and provide optimized solutions that use T-SQL's powerful
features, such as window functions and sequences.
Allan Hirt, a Microsoft Cluster MVP since 2009, will share
his expertise on SQL Server clustered solutions in two sessions. In the
pre-conference session "Plan
and Deploy Successful Clustered Solutions for SQL Server," he'll cover
how to plan, deploy, and manage failover cluster instances and availability
groups in a Windows Server Failover Clustering environment. To make sure
conference attendees are prepared in case something goes awry when they're
deploying or using failover cluster instances or availability groups, Allan will
Clusters." In this session, he'll show attendees how to diagnose what
went wrong and demonstrate how to fix commonly encountered problems.Andrew Kelly, a SQL Server MVP since 2001, will bring to
light the value of several underestimated and underutilized features in SQL
Server in two conference sessions. While providing training and mentoring on the
performance, scalability, and maintainability of large-scale SQL Server
environments, Andrew discovered that organizations often underestimate the
importance of reusing previously compiled query plans to improve SQL Server
performance. People who attend Andrew’s "Maximizing Plan Reuse" session will learn how to avoid this performance pitfall.
They'll learn how to properly issue calls to SQL Server to ensure plan reuse, how
to identify existing plans that aren't being reused, and how to remedy those
situations. Andrew has also discovered that the Policy-Based Management and
Central Management Server features in SQL Server are underutilized. In the
Management and Central Management Server," he'll show attendees how to
use these two features to save time and simplify database administration.
A SQL Server MVP since 2002, Dejan Sarka is a consultant,
trainer, and developer who specializes in the BI areas of data quality, data
modeling, and data mining. In his work, he has found that one of the most
popular uses of data mining is fraud detection. In the session "Fraud
Detection: Notes from the Field," Dejan will show attendees how to implement
a fraud-detection solution, including how to prepare the data, how to determine
which algorithms to use, and how to measure results. In his work, Dejan has
also found that Excel 2013 has become “the” analytical tool in Microsoft’s
suite for advanced analytics because of features such as PowerPivot, Power
View, and the ability to use big data and data from the Windows Azure
Marketplace DataMarket. In the session "Advanced
Analytics in Excel 2013," Dejan will go far beyond introducing these
cool new features and focus on how to use them for analyzing data and solving
For more than a decade, James Serra has been a database
administrator, the last seven years of which he has worked extensively with BI
using the SQL Server BI stack. In the session "Building
an Effective Data Warehouse Architecture," James will answer commonly
asked questions on implementing a warehouse, such as "What’s the best
methodology to use when creating a data warehouse?" and "Should I use
a normalized or dimensional approach?" By knowing the answers to these
questions, attendees can build a data warehouse that will add value to their
A Microsoft SQL Server MVP, Paul Turley consults, writes,
speaks, teaches and blogs about business intelligence and reporting solutions.
He is the lead author of “Professional SQL Server 2012 Reporting Services” and
11 other titles from Wrox and Microsoft Press.
In the session “NY, London, Paris, Munich… Everybody’s talkin’ ‘bout
Mobile BI,” Paul explores the exciting new mobile BI capabilities that can put
on-the-go business leaders and information workers in the driver seat. Attendees
will learn to design the semantic model layer and security to make all the
magic happen for your business.
If you're interested in attending any of these conference or
pre-conference sessions, visit the Sessions web page
for more information. If you decide to attend the conference, be sure to look
for a discount code on the SolidQ
landing page to receive $150 off the registration fee for the three-day conference.
And while you're at PASS Summit 2013, be sure to check out SolidQ's exhibit!