SQLSaturday #177 - Silicon Valley 2013

Event Date: 02/23/2013 00:00:00

Event Location:

Microsoft Technology Center
1065 La Avenida
Mountain View, California

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: So Many BI Tools, So Little Time

Abstract: Microsoft has a broad range of tools that can be used to create a BI application: Power View, Reporting Services, and Excel (Pivot Tables Power View) on the presentation side and SQL, Analysis Services (MOLAP Tabular), PowerPivot, and Excel models on the data side. Which ones should you use when? Should an application mix and match or should an application focus on a limited set of tools? While the technologies in each class have similarities (Power View, Reporting Services, and Pivot Tables all have bar charts), they are fundamentally different and should be used in different circumstances. Compare the tools and learn nuances of each of them by seeing them in the context of real world examples. See how choosing different tool str

Speaker(s):

Dan Bulos

Track and Room: Track 2 - Mercury - N/A

Title: Big Data for the SQL Server DBA

Abstract: If you’re like most Database Administrators then you already work with data that is big, so what is this big data thing all about? This session will cover the significance of big data by comparing and contrasting it to the SQL Server relational database environment. It will also demonstrate the value a big data ecosystem can provide to your technology infrastructure organization by using it to complement your existing data architecture, and by having it co-exist in effective ways with your SQL Server databases. Live demonstrations will show how you to get maximum value out of big data with tools such as Sqoop, Hive and Pig so that you can perform bulk data transfers, queries, and ETL using SQL Server and HDFS, the Hadoop file system.

Speaker(s):

Carlos Bossy

Track and Room: Track 1 - Galileo - N/A

Title: What is the Best Disaster Recovery Solution?

Abstract: It depends, every situation is different. The question is often asked of DBA’s to provide a solution to very open ended requirements. However, the best solution can only be provided if the database professional is getting all the answers. This session is a case study into many of Disaster Recovery options that we as database professionals have. Understand the answers to the important questions that we should be asking to provide the best solution not only for the database but for the business as well. As an attendee you will learn how to change an answer from it depends into a solid solution that can be built upon. We will take examples from experiences and as a group determine what the best solution is.

Speaker(s):

Chris Shaw

Track and Room: Track 5 - Computer Training Room - N/A

Title: Top 10 Admininistrator Mistakes on SQL Server

Abstract: SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy, nor does it mean is problem free. After all, many apps are growing from small, home-grown applications every year, with green IT professionals encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. There is a short list of mistakes that, if you know of them in advance, will make your life much easier. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.

Speaker(s):

Kevin Kline

Track and Room: Track 1 - Galileo - N/A

Title: Stop Bad Data in its OLTP Tracks

Abstract: Incorrect, inaccurate and misleading data can get into a database in a variety of ways. It causes bugs, impacts customers and hurts business. This session will explain how DBAs and developers can proactively ensure the data coming into a transactional system is clean and correct. The topics covered will include table design, the pitfalls of NULL, “garbage in”, transactions, change management, and coding standards.

The presentation will draw on the speaker’s years of personal experience managing busy e-commerce databases supporting multi-million dollar businesses. The speaker will use real-life examples and demos to illustrate the many ways that OLTP data quality can be compromised.

Speaker(s):

Denise McInerney

Track and Room: Track 3 - Jupiter - N/A

Title: Master Data and Data Quality in SQL Server 2012

Abstract: A recent survey by Information Week found that data quality is the greatest barrier to BI adoption in enterprises. MDS addresses this challenge with modeling, validation, alerting and security capabilities. In this presentation, you will learn how to use MDS to model your data to ensure correctness, update it with changes from your ERP, and alert users to data conditions that require attention. Next you will learn the capabilities of DQS and see how it addresses data standardization, completeness and uniqueness challenges. You will then see how to use them together to enable Enterprise Information Management. BI professionals will come away with knowledge on how to use tools that address the greatest risk to success for BI projects - d

Speaker(s):

Mark Gschwind

Track and Room: Track 2 - Mercury - N/A

Title: PowerShell for Data Professionals

Abstract: You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.

Speaker(s):

Aaron Nelson

Track and Room: Track 4 - Saturn - N/A

Title: Get TurnedOn with AlwaysOn

Abstract: Once upon a time, there were 2 SQL Solutions named High Availability and Disaster Recovery. They had a love hate relationship and could never find a common ground. That is, until SQL Server 2012 brought them together in a love story built for the ages. When the dust settled, a beautiful new feature was born. It was called AlwaysON and brought with it new technologies like availability groups, read-only mirrors and listeners. It was a perfect blend of both HA and DR all wrapped up in one bundle of joy. SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server 2012. Come see and learn some of the new features associated with it, how they work and why this new feature of SQL Server 2012 is so wonderfu

Speaker(s):

Mitchell Bottel

Track and Room: Track 5 - Computer Training Room - N/A

Title: Analytic Cartography: Master geospatial reporting

Abstract: One of the hottest trends in analytics right now is geospatial reporting. Long gone are the days of viewing region based data in a grid. Now it is possible to provide users with additional insight on the regional performance of business.

In this session, Julie will show you three options for creating and delivering these analytics. First SQL Server Reporting Services 2012 will be presented to show how we can create custom shape objects to conform with business defined regions. Secondly, using the power of Excel 2013, Bing Maps and GeoFlow, learn how to build captivating visualizations directly in Excel. Finally, we’ll show how easy it is to build interactive maps using Power View.

Speaker(s):

Julie Koesmarno

Track and Room: Track 2 - Mercury - N/A

Title: SQL Server Table Partitioning from the Ground Up

Abstract: In this session we will be looking at the SQL Server table partitioning features which were introduced in SQL Server 2008. We will look at how to create partitioned tables and indexes as well as the internals of the table. We will also look at how to move data from one partition to another and from one table to another with minimal to no impact to the users.

Using these techniques we will be able to improve query performance and reduce downtime when loading and pruning data.

Speaker(s):

Denny Cherry

Track and Room: Track 1 - Galileo - N/A

Title: Where Are My (Primary) Keys?

Abstract: In this session, we revisit some of the fundamental design principals of relational databases—normalization rules, key selection, and the controversies associated with these issues—from a very hands-on, practical perspective. We also consider the benefits and challenges of using different types of keys (natural, surrogates, artificial, others) from multiple aspects, including data consistency, application development, maintenance, portability, and performance.

Speaker(s):

Ami Levin

Track and Room: Track 6 - ECR - N/A

Title: Don’t Panic, DBAs! Databases on VMware made easy.

Abstract: More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment.

Speaker(s):

Janis Griffin

Track and Room: Track 4 - Saturn - N/A

Title: Demystifying Clustering for the DBA

Abstract: The word cluster is used a lot in the IT world, especially when it comes to SQL Server. We have clustered instances of SQL Server, availability groups that require Windows failover clustering … but how does a DBA make sense of it all? Wonder no more! This session will explain all the forms of clustering as they relate to SQL Server (including how Windows fits into the picture) and give you some of the top keys to success whether you are using an older version of Windows and SQL Server, or you’re looking to deploy the latest and greatest.

Speaker(s):

Allan Hirt

Track and Room: Track 5 - Computer Training Room - N/A

Title: Lean and Mean: Running SQL on Windows Server Core

Abstract: Do you consider the Windows GUI to be a waste of resources? Starting with SQL Server 2012, you can run on top of Windows Server Core 2008 R2 or 2012. In this session we will discuss installation and management of SQL Server on Windows Server Core, along with lots of tips and tricks.

Speaker(s):

Argenis Fernandez

Track and Room: Track 4 - Saturn - N/A

Title: SQL Azure- What is it and why do you need it?

Abstract: This session will take an exploratory look at Microsoft’s cloud-based relational database offering. We’ll lift the hood and look at its many benefits and features, and how it easily fills the need for a highly available and scalable database service in the cloud. We’ll discuss how SQL Azure helps ease provisioning and deployment, and how Microsoft takes care of the physical administration so that developers and DBA’s alike can focus on the aspects of their job they really care about.

Speaker(s):

Scott Klein

Track and Room: Track 4 - Saturn - N/A

Title: Hadoop on WindowsAzure in Action

Abstract: Web 2.0 companies have been fully taking advantage of Hadoop based open source tools to tackle Big Data needs. Microsoft now offers the best of both worlds with its own Hadoop solution on Windows Azure with full compatibility and additional rich toolsets. This session is a “getting-started” tutorial on developing Big Data applications on Windows Azure. We cover application scenarios, Hadoop on Azure, tools, and applied data analytics. More importantly, we show you how to put everything together with a couple of sample applications.

Speaker(s):

Wenming Ye

Track and Room: Track 1 - Galileo - N/A

Title: Designing a SQL 2012 BI Architecture

Abstract: Learn how to combine SQL Server and SharePoint technologies to deliver compelling insights and rich data exploration. This session covers architecture and deployment planning for BI solutions using SQL Server, Analysis Services, PowerPivot, Power View, Excel Services and related technologies.

Speaker(s):

Rob Kerr

Track and Room: Track 2 - Mercury - N/A

Title: Understanding Transaction Isolation Levels

Abstract: SQL Server offers several isolation levels beyond the default “READ COMMITTED”. But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.

Speaker(s):

Randy Knight

Track and Room: Track 6 - ECR - N/A

Title: Business Intelligence with SharePoint 2013

Abstract: Details to follow shortly

Speaker(s):

Angel Abundez

Track and Room: Track 2 - Mercury - N/A

Title: Dimensional Modeling: Beyond the Basics

Abstract: In this session, we will dive deeper into the art of dimensional modeling. We will identify the different types of fact tables and dimension tables and discuss how and when to use each type. We will also review approaches to creating rich hierarchies that simplify complex reporting. This session will be very interactive–bring your toughest dimensional modeling quandaries!

Speaker(s):

Jason Horner

Track and Room: Track 3 - Jupiter - N/A

Title: Introductions and Keynote

Abstract: Greetings from Mark Ginnebaugh and Keynote with Ross Mistry

Speaker(s):

Mark Ginnebaugh

Track and Room: Track 6 - ECR - N/A

Title: Secrets of Enterprise Data Mining

Abstract: If you have a SQL Server license (Standard or higher) then you already have the ability to start data mining. In this new presentation, you will see how to scale up data mining from the free Excel 2013 add-in to production use. Aimed at beginning to intermediate data miners, this presentation will show how mining models move from development to production. We will use SQL Server 2012 tools including SSMS, SSIS, and SSDT.

Speaker(s):

Mark Tabladillo

Track and Room: Track 3 - Jupiter - N/A

Title: EMC Vendor Session

Abstract: Details coming soon!

Speaker(s):

Mark Ginnebaugh

Track and Room: Track 6 - ECR - N/A

Title: Analytics on Azure

Abstract: Speaker Lakshmi Randall will walk us through analytics on Azure.

Speaker(s):

Lakshmi Randall

Track and Room: Track 3 - Jupiter - N/A

Title: NetApp Vendor Session

Abstract:

Speaker(s):

Mark Ginnebaugh

Track and Room: Track 4 - Saturn - N/A

Title: Dimensional Modeling and OLAP

Abstract:

Speaker(s):

Joy Mundy

Track and Room: Track 1 - Galileo - N/A

Title: Parallel Data Warehouse 2.0

Abstract: Come learn about the latest features in the just-released PDW 2.0!

Speaker(s):

Mark Ginnebaugh

Track and Room: Track 5 - Computer Training Room - N/A

Title: TempDB Performance Troubleshooting and Optimizing

Abstract: Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. After this session, you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.

Speaker(s):

Eddie Wuerch

Track and Room: Track 6 - ECR - N/A

Title: Matching and Survivorship

Abstract: The spectrum of Contact Data Quality covers numerous interrelated aspects such as parsing, standardization, correction, verification, enrichment and matching. But one crucial concept that is quite commonly overlooked in the field of data quality is the implementation of an intelligent and automatable process for the creation of the “golden record” through the consolidation of data within the matching process; a technique also known as Survivorship.

Speaker(s):

Joseph Verftido

Track and Room: Track 3 - Jupiter - N/A

Title: Nimble Storage Vendor Presentation

Abstract: Details Coming Soon

Speaker(s):

Mark Ginnebaugh

Track and Room: Track 7 - 2036 - N/A

Title: Query Tuning in the Clouds

Abstract: Just because you’re using an Azure SQL database does not mean you can avoid tuning queries. Microsoft has throttling in place that could seriously impact your systems if your queries are using up lots of resources. This session will introduce you to the tools you have available to identify poor performing queries, such as dynamic management objects and others. You’ll learn how to understand why a query is running slow using the Azure Portal execution plans. This understanding will enable you to fix your poorly performing queries. All in the cloud.

Speaker(s):

Grant Fritchey

Track and Room: Track 4 - Saturn - N/A

Title: SQL Server, HyperV, Virtual SAN Switches

Abstract: SQL Server, HyperV, Virtual SAN Switches - Virtual Reality! Details coming soon…

Speaker(s):

Phil Hummel

Track and Room: Track 5 - Computer Training Room - N/A

Title: SQL Server 2012 over NAS Storage

Abstract: Microsoft SQL Server is one of the most commonly virtualized applications environments. With the release of SQL Server 2012, Microsoft introduces full support for SMB. Now you can install SQL Server 2012 with both system and user databases on SMB file shares. This allows you to build end-to-end NAS solutions where the data management capabilities of NAS, such as volume auto grow and shrink. This session will demonstrate how to install and run SQL Server over SMB and VMware NFS on NetApp storage as well as best practices, caveats, and performance of SQL Server database over NAS storage.

Speaker(s):

Pat Sinthusan

Track and Room: Track 7 - 2036 - N/A

Title: Nimble Storage Vendor Session

Abstract: Details coming soon!

Speaker(s):

Mark Ginnebaugh

Track and Room: Track 5 - Computer Training Room - N/A

Title: Tablix - The Rubik Cube of Reporting Services

Abstract: Did you know that the Table, Matrix, and List controls are all based on the highly flexible Tablix Data Region Grid? So really, they are all one control that can be morphed into each other.

Learn how to get the most out of the Tablix controls in this demo-heavy session. We’ll go through how to best layout data using multiple Tablix controls. We’ll use parameters to change the layout of the data in these controls to minimize the number of reports that need to be maintained. We’ll create a columnar report that grows vertically as well as horizontally, and we’ll find out about other exciting uses of this highly flexible control.

Speaker(s):

Mickey Stuewe

Track and Room: Track 7 - 2036 - N/A

Title: Windowing Functions: THE Reason to Upgrade to 2012

Abstract: For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour’s time, and you can take the demo code back home with you to review at your leisure!

Speaker(s):

Kevin Boles

Track and Room: Track 6 - ECR - N/A

Title: WIT - Encouraging Enabling Women in Technology

Abstract: Women make up only about 25% of the computing workforce. The number of women majoring in Computer Science in the U.S. has declined significantly over the past 25 years. Yet today technology companies can’t find enough talented engineers and the demand is only going to increase. Come hear from a people who are actively working to encourage and enable more girls and women to pursue technology careers. Our panel will include Kimberly Bryant, Founder Black Girls CODE, Ayna Agarwal and Ellora Israni, co-founders of She++ at Stanford and more.

Speaker(s):

Denise McInerney

Track and Room: Track 1 - Galileo - N/A

Title: Troubleshooting Query Plan Quality Issues

Abstract: When the query optimizer inaccurately estimates the number of rows for query execution plan iterators, performance can suffer due to the generation and use of a suboptimal plan. Fixing cardinality estimate issues will help the query optimizer generate a higher quality plan. This session will teach you how to identify cardinality estimate issues in your query execution plan and also cover various ways in which cardinality estimate issues can be addressed.

Speaker(s):

Joe Sack

Track and Room: Track 6 - ECR - N/A

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Jason Horner

Twitter: - jasonhorner

LinkedIn: Jason Horner

Contact: http://blog.jasonhorner.com

Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.

I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.

In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games

Joseph Verftido

Twitter: - /melissadata

LinkedIn: Joseph Verftido

Contact: http://blog.melissadata.com/data-quality-authority/

A Data Quality Analyst at Melissa Data, Joseph has worked with numerous clients in understanding their business needs for data quality, analyzing their architecture and environment, and recommending strategic solutions to successfully integrate data quality within their infrastructure. He gives frequent webinars for implementing different techniques for data quality and also manages the MVP Program – a network that provides resources to community leaders, speakers, consultants and other experts.

Denise McInerney

Contact: https://twitter.com/denisemc06

Our panel will include Kimberly Bryant, Founder Black Girls CODE, Ayna Agarwal and Ellora Israni, co-founders of She++ at Stanford, Kourtney Andrada, Program Manager, Girls Inc. of Alameda County, and Valerie Fenwick, Software Development Manager at Oracle. Our moderator is Denise McInerney of Intuit. Denise is a PASS Director and founder of the PASS Women in Technology Virtual Chapter.

Chris Shaw

Twitter: - @SQLShaw

LinkedIn: Chris Shaw

Contact: http://chrisshaw.wordpress.com/

Chris Shaw started his database career in 1993. Following the Marines, Chris continued working with databases for companies such as Wells Fargo, Pulte Mortgage, and Yellow Pages Inc. Chris has been writing and speaking about SQL Server for over 15 years at events such as SQL Connections, PASS Summit, and SSWUG Ultimate conferences. Chris received his 5th Microsoft MVP award.

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

Contact: http://www.sqlsolutionsgroup.com/blog

Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.

Lakshmi Randall

Contact: http://www.microsoft.com

Lakshmi is a member of Microsoft’s Big Data COE Team.

Joy Mundy

Joy Mundy has focused on data warehousing and business intelligence since the early 1990s, specializing in business requirements analysis, dimensional modeling, and business intelligence systems architecture. Joy began her career as a business analyst in banking and finance. Her first DW/BI project was as an employee of Stanford University, building an enterprise-wide Decision Support System (as DW/BI systems were called in those days). Joy left Stanford to co-found InfoDynamics LLC, a data warehouse consulting firm (doing business as the Kimball Group), then joined Microsoft WebTV to develop closed-loop analytic applications and a packaged data warehouse. Joy worked in Microsoft SQL Server product development, managing a team that developed the best practices for building business intelligence systems on the Microsoft platform. She returned to consulting and Kimball Group in 2004. Joy graduated from Tufts University with a BA in Economics, and from Stanford with an MS in Engineering Economic Systems.

Allan Hirt

Twitter: - SQLHA

LinkedIn: Allan Hirt

Contact: http://www.sqlha.com/blog

SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Mitchell Bottel

Twitter: - @SacSQLDude

Contact: http://www.mitchespitch.com

Mitchell Bottel is a senior database administrator with Sutter Physician Services, owner of Innovative IT Consulting and President of the Sacramento SQL Sevrer User Group. He has 14 years of IT experience, focusing on SQL Server for the last ten years with an emphasis on database administration and high availability solutions. He has authored blog posts on the SQLServerPerformance website and written White Papers on using Dynamic Management Views.

Mark Ginnebaugh

Twitter: - @markginnebaugh

LinkedIn: Mark Ginnebaugh

Contact: http://www.designmind.com/blog

I am the CEO of DesignMind, a San Francisco-based consulting firm providing data-related services to enterprises and hyper-growth companies. We consult and develop across the entire data life cycle, including Database Applications, Mobile and web Apps, Data Warehousing and Business Intelligence, Big Data, and Data Science.

I am a Microsoft Regional Director and have been a Data Platform MVP since 2011. I lead three PASS Chapters. I served on the PASS Board of Directors in 2011, and am the main organizer for SQLSaturday Silicon Valley.

Rob Kerr

Twitter: - @robkerrbi

LinkedIn: Rob Kerr

Contact: http://www.robkerr.com

Rob is CTO with BlueGranite, is a Microsoft SQL Server MVP and holds top Microsoft certifications in both SQL Server Database Administration and BI Development. Rob has implemented data warehouse and business analytics systems for many Fortune 500 companies, and focuses on large-scale data warehousing, geospatial data analysis and mobile solutions. Rob is the lead contributor to msbiacademy.com, a site providing free on-demand training covering a variety of Microsoft BI topics.

Kevin Kline

Twitter: - kekline

LinkedIn: Kevin Kline

Contact: http://blogs.sentryone.com/author/kevinkline

Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.

Mark Ginnebaugh

Twitter: - @markginnebaugh

LinkedIn: Mark Ginnebaugh

Contact: http://www.designmind.com/blog

Carlos Bossy

Twitter: - @carlosbossy

LinkedIn: Carlos Bossy

Contact: http://www.carlosbossy.com

Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.

Denny Cherry

Twitter: - mrdenny

LinkedIn: Denny Cherry

Contact: https://www.dcac.com

Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.

Mark Ginnebaugh

Twitter: - @markginnebaugh

LinkedIn: Mark Ginnebaugh

Contact: http://www.designmind.com/blog

Mark Ginnebaugh

Twitter: - @markginnebaugh

LinkedIn: Mark Ginnebaugh

Contact: http://www.designmind.com/blog

Wenming Ye

Contact: http://blogs.msdn.com/hpctrekker/

Sr. Technical Evangelist on Big Data and HPC Applications on Windows Azure.

Mark Gschwind

Mark Gschwind is VP of Business Intelligence at DesignMind, a Microsoft Gold consulting partner based in San Francisco. He has been a BI Consultant since 1995, implementing Data Warehousing, OLAP, Reporting and Data Mining solutions to over 46 clients. He is an MCP and is certified in Oracle Essbase. He has presented MDS to other SQLSaturday events, as well as local PASS chapters. He has been using MDS since 2008 and has also used DQS on numerous client engagements.

Scott Klein

Twitter: - SQLScott

Contact: http://aka.ms/sqlscott

Scott Klein is a senior consultant with SQL Solutions Group with over two decades of experience working with Microsoft SQL Server. Prior to SSG, Scott spent almost 10 years at Microsoft, traveling the globe as a technical evangelist training and speaking about SQL Server and Microsoft’s Azure data services. Scott’s recent focus has been on advanced analytics, including big data and IoT, providing real-world training to help bring intelligence to your data. Scott has authored several books focusing on data and data analytics. Scott is continuously striving and looking for ways to help developers and companies grok the wonderful world of data.

Julie Koesmarno

Twitter: - @mssqlgirl

LinkedIn: Julie Koesmarno

Contact: http://www.mssqlgirl.com

Julie Koesmarno, MCSE Data Platform, and MCSE Business Intelligence, MCT, is a Senior Program Manager at Microsoft, with a Bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her past projects include delivering a SQL Server 2012 data warehouse and BI solutions in the US and Australia. She now works with hybrid, cloud and on-prem SQL projects.

Denise McInerney

Twitter: - @denisemc06

LinkedIn: Denise McInerney

Contact: http://weblogs.sqlteam.com/denisem/default.aspx

Denise McInerney is a data professional with over 20 years of experience. She began her career as a database administrator and has worked as a data analyst and data engineer. She now works as a data architect at Intuit, where she designs and implements analytics solutions with a focus on enabling the work of analysts, data scientists, and business users. Denise is active in technical community organizations and has spoken at user groups and conferences over two dozen times. She served on the PASS Board of Directors for six years.

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.

Mark Tabladillo

Twitter: - https://twitter.com/MarkTabNet

LinkedIn: Mark Tabladillo

Contact: http://marktab.net

Mark Tabladillo Ph.D. works for Microsoft as a Cloud Solution Architect for the US CTO Customer Success Team. He has a science doctorate from Georgia Tech. Based in Atlanta, GA, Mark provides cloud enterprise solutions for companies in the US for Microsoft’s strategic clients. He is a chapter leader for the PASS Data Science virtual chapter.

Phil Hummel

Contact: http://www.emc.com

Phil Hummel is a Senior Technology Consultant with EMC

Mickey Stuewe

Twitter: - @SQLMickey

LinkedIn: Mickey Stuewe

Contact: http://www.MickeyStuewe.com

Mickey Stuewe has been working with SQL Server since 6.5. That gives her over 20 years of experience. She has not only been a database developer, but also an application developer, even before Visual Studio existed. She is now thankful to be focusing on database design, t-SQL development, and query optimization. She also has a habit of enjoying SSIS and data warehouse design.

She blogs regularly on her website mickeystuewe.com and contributes to sites such as SQL Server Central and SQL Server Pro. She enjoys presenting at PASS Summit, SQLSaturdays, User Groups and other events.

When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often…just ask her children.

Ami Levin

Contact: http://www.dbsophic.com/EasyBlog.html

Ami Levin is a Microsoft SQL Server MVP since 2006, with over 20 years of experience in development and IT. For the past 14 years, he has been consulting, teaching, writing, and speaking about SQL Server worldwide. Ami’s areas of expertise are data modeling, database design, T-SQL, and performance tuning.

Argenis Fernandez

Twitter: - DBArgenis

LinkedIn: Argenis Fernandez

Contact: http://blog.purestorage.com/author/argenisfernandez/

Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.

Dan Bulos

Twitter: - @DanBulos

Dan Bulos is president and founder of Symmetry Corporation, a leading BI consulting firm and Microsoft Gold Certified Partner. He has over 25 years of experience consulting with Fortune 500 companies on using analytical systems and has provided strategic consulting on new product features and directions to leading software vendors. A featured speaker at BI and data warehouse conferences in the US and Europe, Dan is a recognized authority on multidimensional database technology.

Pat Sinthusan

Contact: https://communities.netapp.com/

Pat Sinthusan is currently working for NetApp as a Reference Architect responsible for validating new SQL Server Solutions on the NetApp storage platform. In the past, he worked as a Sr. Database Administrator for 15 years with Hasbro and the City of Seattle. Pat has designed and implemented database infrastructures for the entire range of environments (development and production) using various storage technologies, and he#39;s been working with SQL Server since 4.21B.

Joe Sack

Twitter: - @JoeSackMSFT

LinkedIn: Joe Sack

Joe Sack is a Principal Program Manager in the SQL Server product team at Microsoft, with a focus on the Query Optimizer. Joe is an author and speaker with over 18 years of experience in the industry, specializing in performance tuning, high availability and disaster recovery.

Angel Abundez

Twitter: - AngelStreamline

LinkedIn: Angel Abundez

Contact: http://angelstreamline.com

Angel leads the Solutions Architecture team at DesignMind, helping design and build world class data-related systems. His expertise includes Microsoft SQL Server BI tools, Power BI, Azure-based database services, and Tableau. His team develops Proofs of Concept, Pilots, and highly scalable production systems. Angel co-leads the Bay Area Microsoft Business Intelligence User Group and the San Francisco Power BI User Group. He speaks at Data Analytics events throughout the U.S. and writes for SQL Server Central. He is a graduate of Cal Poly SLO with a BS in Mechanical Engineering.

Mark Ginnebaugh

Twitter: - @markginnebaugh

LinkedIn: Mark Ginnebaugh

Contact: http://www.designmind.com/blog

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.

Eddie Wuerch

Twitter: - @EddieW

LinkedIn: Eddie Wuerch

Contact: http://www.indydba.com

Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.

Mark Ginnebaugh

Twitter: - @markginnebaugh

LinkedIn: Mark Ginnebaugh

Contact: http://www.designmind.com/blog

Aaron Nelson

Twitter: - SQLvariant

LinkedIn: Aaron Nelson

Contact: http://sqlvariant.com/

Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award.

Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.

SQLSaturday #177 - Silicon Valley 2013

Sessions

Title: So Many BI Tools, So Little Time

Title: Big Data for the SQL Server DBA

Title: What is the Best Disaster Recovery Solution?

Title: Top 10 Admininistrator Mistakes on SQL Server

Title: Stop Bad Data in its OLTP Tracks

Title: Master Data and Data Quality in SQL Server 2012

Title: PowerShell for Data Professionals

Title: Get TurnedOn with AlwaysOn

Title: Analytic Cartography: Master geospatial reporting

Title: SQL Server Table Partitioning from the Ground Up

Title: Where Are My (Primary) Keys?

Title: Don’t Panic, DBAs! Databases on VMware made easy.

Title: Demystifying Clustering for the DBA

Title: Lean and Mean: Running SQL on Windows Server Core

Title: SQL Azure- What is it and why do you need it?

Title: Hadoop on WindowsAzure in Action

Title: Designing a SQL 2012 BI Architecture

Title: Understanding Transaction Isolation Levels

Title: Business Intelligence with SharePoint 2013

Title: Dimensional Modeling: Beyond the Basics

Title: Introductions and Keynote

Title: Secrets of Enterprise Data Mining

Title: EMC Vendor Session

Title: Analytics on Azure

Title: NetApp Vendor Session

Title: Dimensional Modeling and OLAP

Title: Parallel Data Warehouse 2.0

Title: TempDB Performance Troubleshooting and Optimizing

Title: Matching and Survivorship

Title: Nimble Storage Vendor Presentation

Title: Query Tuning in the Clouds

Title: SQL Server, HyperV, Virtual SAN Switches

Title: SQL Server 2012 over NAS Storage

Title: Nimble Storage Vendor Session

Title: Tablix - The Rubik Cube of Reporting Services

Title: Windowing Functions: THE Reason to Upgrade to 2012

Title: WIT - Encouraging Enabling Women in Technology

Title: Troubleshooting Query Plan Quality Issues

Speakers

Sponsors