SQLSaturday #157 - San Diego 2012
Event Date: 09/15/2012 00:00:00
Event Location:
- UCSD Extension - University City Center
- 6256 Greenwich Dr.
- San Diego, California
This event has completed. All data shown below is from the historical XML public data available.
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: Advancing Data Storage: How Flash-Optimized Storag
Abstract: Advancing Data Storage: How Flash-Optimized Storage Architectures Accelerate Performance and Simplify Storage Management
This presentation will explore the evolution of storage architectures over the past 25 years, reviewing the technology inflection points and core business drivers that have propelled the transitions from direct attached to monolithic to modular storage solutions.
We are at the beginning of the next major technology inflection driving enterprise storage. Solid state drives (SSDs) promise to solve the performance challenges inherent in spinning disks, rendering traditional storage architectures obsolete.
But SSDs by themselves are not the solution. The next decade will be dominated by storage architectures
Speaker(s):
- Arvind Rayasam
Track and Room: DBA - N/A
Title: Dive into the Query Optimizer-Undocumented Insight
Abstract: This 400 (or maybe 500) level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.
Speaker(s):
- Benjamin Nevarez
Track and Room: Performance - N/A
Title: Introduction to SSIS with a Real-World Example
Abstract: SSIS is a powerful and east to use data Extract, Transform, Load (ETL) tool SSIS providing a rich set of components to perform the most common ETL tasks with “drag-and-drop” ease. Packages can be constructed with rigorous error and exception handling as well as verbose logging allowing deployment of robust ETL processes.. This session will demonstrate a process for loading a comma-delimited data file into a staging table for further processing then validating the data and moving specific data into host tables using a a thorough example of a non-trivial ETL project with “real” data. The intended audience includes beginning SSIS developers, DBAs, and anyone with a desire to experience the magic of data management with this remarkable tool.
Speaker(s):
- Ron Johnson
Track and Room: Business Intelligence 2 - N/A
Title: Chart Anatomy 101
Abstract: SSRS Charts are the next common report item you will use in designing business reports after the Tablix. In this session, we’ll deep dive together into the anatomy of a chart: chart elements, properties, and areas. We’ll review the drastic improvements Microsoft has made to chart visualization and mimick some of the awesome features found in Power View, Microsoft’s new reporting client in SQL Server 2012. Based on visualization fundamentals by renowned data viz expert Stephen Few, I will share with you some ground rules and how to apply them when designing reports in SSRS 2008 R2.
Speaker(s):
- Angel Abundez
Track and Room: Business Intelligence 2 - N/A
Title: Bulletproof: Hardening your SQL Server from Attack
Abstract: Recent major security breaches have not only exposed customer data, but also the system vulnerabilities DBAs must overcome daily. As data protection is a DBA’s primary responsibility, establishing an impenetrable environment to host the data is the first step towards risk-free security. How can DBAs ensure SQL Servers are fortified against the latest threats and vulnerabilities? In this session, we will go through the process of hardening your SQL Server from attack from Windows Server to the database level step-by-step. I will share will share with you how establish security baselines and monitor for changes to your security foundation. This session will provide specific actions for you to take back and apply to your servers.
Speaker(s):
- Sarah Barela
Track and Room: DBA - N/A
Title: Mobile BI with SSRS and SharePoint
Abstract: Today’s executives and information workers want to use mobile devices to get at their business information, make critical decisions, and thrive. Let’s help them get there with SQL Server Reporting Services and SharePoint. Tablets are common place now, and smart phones have been in place for years, but have we devoted enough attention to make effective use of the new form factors? Let’s discuss how our design approach changes when we want to launch mission-critical dashboards and reports on smaller screen sizes using touch-screen technology. We’ll look at iPad and other mobile devices, SSRS and SharePoint, BI Developer and Business User, with emphasis on data visualization best practices.
Speaker(s):
- Angel Abundez
Track and Room: Business Intelligence 2 - N/A
Title: Private Clouds with SQL Server 2012
Abstract: The recent growth of cloud computing has companies evaluating when how, not if, they will move their data offsite. Despite the benefits that the cloud, many DBAs are leery of jumping into the cloud, fearful that their sensitive data will become vulnerable. The goal of this session is to provide you a blueprint to design build your own SQL Server cloud, where you can control the server availability performance reliability, yet still take advantage of the resource elasticity and hardware flexibility of the cloud. In this session, I will demonstrate how to use features like always on, resource governor, policy based management PowerShell scripts to automate your servers behavior to achieve the benefits of the cloud without the risks
Speaker(s):
- Sarah Barela
Track and Room: SQL Dev 3 - N/A
Title: 11 Reasons Why You Want Developers Using Entity Fr
Abstract: Can your DAL do this? I’ll show you eleven ways Entity Framework is better than the average data access layer. I’ll show demos on compile-time errors, change tracking, portability, easy maintanence, and lazy-loading.
Speaker(s):
- Ike Ellis
Track and Room: SQL Dev 1 - 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: SQL Dev 2 - N/A
Title: SQL Server 2012 PowerView - What’s missing?
Abstract: As part of the new SQL 2012 release there is a powerful tool called Power View. lt integrates with SharePoint 2010 to provide a easy to use tool to manipulate SQL Server Analysis Services data into beautiful charts and graphs. There’s one problem… it’s missing a few things that our client (and probably many others) needed.
ln this session I will show how we utilized custom development, Open XML 2.0. and a few other tools to remedy the problem.
Speaker(s):
- Ken Mears
Track and Room: SQL Dev 3 - N/A
Title: Scalling your cloud database with SQL Federation
Abstract: With more and more companies moving to a cloud solution, the necessity to easily and efficiently scale their database solution is critical. This session will discuss how to scale SQL Azure using SQL Azure Federations, a recent addition to SQL Azure that provides the ability to build scalable, elastic, and multi-tenant solutions in SQL Azure. SQL Azzure Federations bring the sharding pattern into SQL Azure as a first class citizen as a way to achieve greater scalability and performance from the database tier of your application through horizontal partitioning at the database level. This session will look at Federations from a real-world point of view, by applying Federations to a real-life database. We will also look at performance benefits.
Speaker(s):
- Scott Klein
Track and Room: SQL Dev 2 - N/A
Title: Proactive Administration with Ring Buffers.
Abstract: Ring buffers were added in SQL Server 2005. They provide diagnostic data that can be used to troubleshoot server issues such as memory and CPU pressure. By storing this wealth of information in SQL Server, we can spot problems/trends and even resolve problems automatically without having to page the on-call DBA to fix it. In this session, we’ll take a look at what ring buffers provides and also what we can do with the data. I’ll show you a scenario that recently occurred in my environment and what I did to correct the problem before customers were even aware of it. The tool that I wrote can easily be placed in your environment and adapted to your needs.
Speaker(s):
- Tara Kizer
Track and Room: DBA - N/A
Title: Working With XML In SQL Server
Abstract: XML is a technology that Developers and DBAs alike share a love-hate relationship with; it’s powerful and flexible yet it can be bloated and difficult to work with at the same time. Regardless, XML has found a home in many applications - including SQL Server (e.g. execution plans) - so it’s important to understand how to work with it in your databases. This session will show you how to use the XML data type, perform basic operations on XML data, and how to use FOR XML to create XML from relational data. This isn’t a session to convince you to use XML, but to show you what you can do with XML when you do need to use it!
Speaker(s):
- Kendal Van Dyke
Track and Room: SQL Dev 3 - N/A
Title: Table Indexing for the .NET Developer
Abstract: In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2008 databases. We will also be looking into the new indexing features that are available in SQL Server 2008 (and SQL Server 2005) and how you the .NET developer can make the best use of them to get your code running its best.
Speaker(s):
- Denny Cherry
Track and Room: SQL Dev 1 - N/A
Title: How To Survive The Technical Interview
Abstract: Have you ever not gotten a job due to not being prepared for the technical interview? I’ve have interviewed 100’s of software developers and will share my knowledge on how to survive, what we look for and even divulge some of the secrets we use during the process. This session will include advice from hiring managers and even recruiters!
Speaker(s):
- David McCarter
Track and Room: Career / Other - N/A
Title: Geeks Anonymous
Abstract: What do programmers really want? Do you work at a great or bad company? Are you frustrated with your job? Are you stressed out to the point your head wants to explode? What can be done about this and more subjects? Attend this session and find out the answers from your fellow geeks. This will be a highly collaborative session and you are guaranteed to learn a lot!
Speaker(s):
- David McCarter
Track and Room: Career / Other - N/A
Title: Introduction to SSAS 2012
Abstract: SSAS 2012 will revolutionize BI on the Microsoft platform. What is so good about it? What are the design goals? What’s the difference between DAX and MDX? This session compares Multidimensional with Tabular and discusses strengths and weaknesses. We explain why this release is the next generation of the product. Focus on the new Tabular model.
Speaker(s):
- Christian Wade
Track and Room: Business Intelligence 1 - N/A
Title: Building Your Own SQL Server Virtual Playground
Abstract: As the number of SQL Server versions and features grow over time so does the the difficulty in maintaining a set of tools for working with all of them on your local machine. Add in that some features require multiple physical instances and suddenly a single installation isn’t enough. Need to quickly switch between versions and editions of SQL Server? Want to learn how to set up a cluster? Or maybe you want to try out the latest features in SQL 2012…virtualization offers a convenient way to do any or all of these. In this session we’ll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual playground on your own machine.
Speaker(s):
- Kendal Van Dyke
Track and Room: SQL Dev 3 - N/A
Title: SQL Server Performance Baselining
Abstract: • Why you need to go beyond just watching standard thresholds • Sources of base lining data • Timing and granularity in baselining • When and how to use baselines • Quest tools that make baselining easier
Speaker(s):
- Trent Mera
Track and Room: Business Intelligence 2 - N/A
Title: Extended Events, Work Smarter Not Harder
Abstract: There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.
Speaker(s):
- Jason Strate
Track and Room: DBA - N/A
Title: Career Management for Data Professionals
Abstract: Career Success in Data Management during Turbulent Timesa; A workshop on issues and ideas that today’s data professionals can do to build their careers and networking skills with other data management professionals. Workshop topics will include:
• Demonstrating your expertise • Building a portfolio of your success stories • Getting others to sell your skills and business value • Building extending your data management skill set • 10 Steps to highlighting you and your work
Bring your thoughts, ideas, and experiences.
Speaker(s):
- Karen Lopez
Track and Room: Career / Other - N/A
Title: Agile Data Warehousing with WhereScape
Abstract: This is introduction to WhereScape RED, an agile development environment – building high quality data warehouses native to SQL 2008, R2, 2012 quickly. No other toolset can beat the productivity which results in a consistent, scalable, supportable and fully documented data warehouse. Better than that though is engagement with business units during development, ensuring that the data warehouse development is correctly prioritized, relevant and up to date.
Speaker(s):
- Doug Barrett
Track and Room: SQL Dev 3 - N/A
Title: SQL Server 2008 T-SQL For Your Daily Use Part 1
Abstract: This session is to address the need for fast information retrieval and use. Topics are presented in a task-based format. Each topic provides the necessary background to get you started, presents one or more examples, and then concisely explains how it all works. Whether you are a novice, part-time, or seasoned SQL Server professional, this session will provide you with the fast facts needed to help you get the job done. Session Topics: How to create CLR Custom Types, How to create DML Triggers, How to use Error Handling, How to use IF..ELSE
Speaker(s):
- Rick Martinez
Track and Room: SQL Dev 2 - N/A
Title: Data Warehouse Best Practices
Abstract: This session will describe the best practises for designing a data warehouse to get the most out of SQL Server. Doug has worked in data warehousing for 12 years and will blend experience, with best practises and recommendations from Microsoft’s Fast Track program. Each version of SQL Server introduces new features specifically for data warehousing - by applying the correct technique, feature, hint, modelling approach and layout the data warehouse will be faster and more scalable.
Speaker(s):
- Doug Barrett
Track and Room: Business Intelligence 1 - N/A
Title: SQL Server 2008 T-SQL For Your Daily Use Part 2
Abstract: This session is to address the need for fast information retrieval and use. Topics are presented in a task-based format. Each topic provides the necessary background to get you started, presents one or more examples, and then concisely explains how it all works. Whether you are a novice, part-time, or seasoned SQL Server professional, this session will provide you with the fast facts needed to help you get the job done. Session Topics: How to create a multi statement UDF, How to use the ROW_NUMBER() function, How to create a stored procedure, How to use the while loop
Speaker(s):
- Rick Martinez
Track and Room: SQL Dev 2 - N/A
Title: Top Query Optimizer Topics for Better Performance
Abstract: This session will show you how a better understanding of how the Query Optimizer works can help you to improve the performance of your queries. I will show you the top 10 Query Optimizer topics that can give you the most benefit by focusing both on concepts and practical solutions. Several areas of the query processor will be covered, everything from troubleshooting query performance problems and identifying what information the Query Optimizer needs to do a better job to the extreme cases where, because of the its limitations, the Query Optimizer may not give you a good plan and you may need to take a different approach.
Speaker(s):
- Benjamin Nevarez
Track and Room: Performance - N/A
Title: Creating a Performance Baseline for SQL Server
Abstract: Creating a performance baseline for a SQL Server instance provides many benefits including defining a starting point for optimization efforts, documenting the server, a reference point for capacity planning, and providing a reference for ongoing performance comparison. This session will provide a detailed presentation of an approach for collecting, storing, and presenting performance metrics for use in developing a baseline performance assessment of a SQL Server instance.
Speaker(s):
- Ron Johnson
Track and Room: Performance - N/A
Title: Discovering the Plan Cache
Abstract: Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery.
Speaker(s):
- Jason Strate
Track and Room: Performance - N/A
Title: Database Design Throw Down
Abstract: Karen and Tom debate about the options and best practices of common and advanced design issues, such as:
- Natural vs. Surrogate keys
- NULL vs NOT NULL
- Datatypes
- Agile Database Design
- Database Refactoring
- Identity Crisis ? …and others.
Bring your votes, your debates, and your opinions. Help us figure out who’s right and who wrong…or less right.
Speaker(s):
- Karen Lopez
Track and Room: SQL Dev 1 - N/A
Title: Introduction to Data Quality Services
Abstract: Data Quality Services (DQS) has been introduced as part of the Microsoft SQL Server 2012 stack. In this session, we will take a first look at DQS and how it can transform the way we enable and set data quality standards to ensure clean data.
Speaker(s):
- Rushabh Mehta
Track and Room: Business Intelligence 1 - N/A
Title: Using Amazon’s Cloud for the SQL Server Profession
Abstract: Azure isn’t the only (cloud) game in town for SQL Server pros. Learn what Amazon Web Services (AWS) has to offer for virtualization, development, training environments, and more. In this session, featuring real-world examples and demos galore, you’ll see how to go from zero to virtualized SQL Server in minutes. I have been using AWS for virtualization, testing, training, and development for SQL Server for several years and am excited to share the practical tips I’ve learned.
Speaker(s):
- Lynn Langit
Track and Room: SQL Dev 2 - N/A
Title: Managing Your Technical Career
Abstract: You’ve got some decisions to make. Should you stay where you are or should you explore new opportunities? Contract or permanent job? Management or individual contributor role?
Bring your questions and be sure to sign up for the free resume critique.
Speaker(s):
- Kim Smith-Rohlfs
Track and Room: Career / Other - N/A
Title: Parallel Query Plans - Good and Bad
Abstract: I will review the basics of Parallel Query Plans and discuss a variety of issues. Single CPU query plans can be very complicated. Multi CPU plans add another layer of complexity. There are benefits to using more than 1 CPU to run a query faster but there are also pitfalls. Why do some high cost queries only use 1 CPU? What about CXPACKET? Why can a parallel plan query run slower than the same query using only 1 CPU? All new computers have multiple CPU cores. This has increased the relevance of parallel plan query execution.If you have questions or stories of parallel plan issues, please share your questions and experiences during this talk.
Speaker(s):
- Chris Dickey
Track and Room: Performance - N/A
Title: Choose Your Own Adventure: Performance Tuning
Abstract: Life is all about choices, and when it comes to SQL Server it is no different. If you don’t have a methodology for researching questions and resolving issues then you need to get one, and soon. Join Microsoft MVP Thomas LaRock from Confio Software as he helps guide you while YOU make the choices in this interactive performance tuning adventure.
Speaker(s):
- Thomas LaRock
Track and Room: Performance - N/A
Title: From T-SQL Turtle to T-SQL Rabbit: Macro Scripting
Abstract: Do you ever find yourself frustrated writing query, after query, after query? In this session we will go over two fairly simple methods to write fast(er) and reliable T-SQL code. What is macro scripting? Come find out how you can spend a little bit of time today and how it can save you a lot of time in the future. We will also go “over” some of the new features in SQL 2012 window functions and how to save time using them. Yes, there will be a live demo.
Speaker(s):
- Eric Freeman
Track and Room: SQL Dev 3 - N/A
Title: Exploring SQL Server Data Tools
Abstract: With the release of SQL Server 2012, Microsoft released a new tool called SQL Server Data Tools. Now you are probably thinking at this point, another tool, why would I need this. If that is you then you should probably come to this session. SQL Server Data Tools has a number of great features that not only make your SQL Server code development easier such as easier code navigation, intellisense and debugging. In addition, the tool allows you to target multiple versions of SQL Server including cloud based instances. Lastly, the use of projects can enable you store your database schema in source control and migrate to generating builds.
Speaker(s):
- Wil Sisney
Track and Room: DBA - N/A
Title: SSIS 2012 Management Considerations and Best Pract
Abstract: SQL Server 2012 introduces a number of exciting new features that will change the way we design, deploy and manage SSIS packages. We will explore the new features, understand how to take advantage of them and formulate some best practices for efficient management of these packages
Speaker(s):
- Rushabh Mehta
Track and Room: Business Intelligence 1 - N/A
Title: Dundas Dashboard - Visualize with Agility
Abstract: A SharePoint enabled enterprise business intelligence environment has several options including PerformancePoint, Reporting Services and PowerView. Dundas Dashboard can integrate and complement these tools to allow organizations to tune their online resources according to their needs. This overview will demonstrate leveraging SSAS cubes in a dashboard environment from creation of a data connection to creation of an interactive dashboard.
Speaker(s):
- Matthew Warren
Track and Room: Business Intelligence 1 - N/A
Title: Relational Database Design 101
Abstract: Would you like to understand the basic structure of relational databases?
Have you ever wondered how you can flawlessly decide whether two tables have a one-to-many, many-to-many, or one-to-one relationship?
Do you want to understand the basics of top-down and bottom-up database design?
Do you want to be able to explain normalization to third normal form?
Then this presentation is for you!
Content: • Keys and dependencies / determinants • Top-down design (What are the entities?) • Table connectivity (one-to-many or many-to-many) • Bottom-up design (What are the attributes?) • Normalization
Speaker(s):
- Diana Dee
Track and Room: SQL Dev 1 - 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.
Speaker(s):
- Denny Cherry
Track and Room: DBA - N/A
Title: Up Your Game With OUTPUT
Abstract: There are some classic database programming tasks that rely on answering the question “What did I just change?” Prior to SQL Server 2005, we had to use functions like SCOPE_IDENTITY() and some extra tricks for handling multiple rows. Some people even had to resort to triggers. Yikes!! This session focuses on the practical use cases for the T-SQL OUTPUT clause. More importantly, you will find out how you can ditch the tricks of the past for a simpler solution that will help keep you sane.
Speaker(s):
- Phil Helmer
Track and Room: SQL Dev 1 - N/A
Title: Implementing Tabular Data Models and PowerView
Abstract: This session is intended for professionals who need to understand the new SQL Server 2012 Business Intelligence features including Excel PowerPivot, Analysis Services tabular models and PowerView. We will also take a look at SQL 2012 BI integration with SharePoint 2010.
Speaker(s):
- Arman Saffarnia
Track and Room: SQL Dev 3 - N/A
Title: NoSQL - for the SQL Server Developer
Abstract: Are you confused (and concerned) by all the talk about noSQL solutions? Are you uncertain as to whether a noSQL solution is right for your project? If using noSQL, do you know which ‘flavor’ to use, i.e. Graph, Key-Volume, Column or other some type? Join me to understand the noSQL landscape. Presentation includes info about cloud-based storage from all of the big vendors, i.e. Amazon, Google, Microsoft. The talk also includes info about Hadoop and other open source databases, such as MongoDB.
Speaker(s):
- Lynn Langit
Track and Room: SQL Dev 2 - 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.
Ron Johnson
Contact: http://rjssqlservernotes.wordpress.com/
A 20 year veteran of the IT industry with over 10 years experience as a software engineer Ron is a seasoned SQL Server performance optimization professional.Ron is currently supporting various clients as a consulting DBA specializing in PTO,Replication,HA/DR,and Security with Xtivia, Inc. a full-service IT company with offices in Dallas,TX, Colorado Springs,CO,and Edison,NJ.Ron earned a M.Sc. in Computer Science and a B.Sc. in Physics.Ron has 10 years of experience as an adjunct faculty member.
Thomas LaRock
Twitter: - @SQLRockstar
LinkedIn: Thomas LaRock
Contact: http://thomaslarock.com
Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.
Christian Wade
Twitter: - @_christianwade
Contact: https://christianwade.wordpress.com/
Christian Wade is a Senior Program Manager for Analysis Services. His consulting experience includes data-warehousing, BI and application-development projects for numerous enterprise customers. Christian is the creator of the BISM Normalizer, which is a database comparison tool for Analysis Services tabular models. He is a frequent presenter at Microsoft conferences. You can find his blog at https://christianwade.wordpress.com/.
Ron Johnson
Contact: http://rjssqlservernotes.wordpress.com/
A 20 year veteran of the IT industry with over 10 years experience as a software engineer Ron is a seasoned SQL Server performance optimization professional.Ron is currently supporting various clients as a consulting DBA specializing in PTO,Replication,HA/DR,and Security with Xtivia, Inc. a full-service IT company with offices in Dallas,TX, Colorado Springs,CO,and Edison,NJ.Ron earned a M.Sc. in Computer Science and a B.Sc. in Physics.Ron has 10 years of experience as an adjunct faculty member.
Phil Helmer
Twitter: - @philhelmer
LinkedIn: Phil Helmer
Contact: http://www.philhelmer.com
Phil has been designing and building relational databases in a variety of industries ever since he first realized how many people don’t understand the limitations of Excel and sticky notes as databases. When he was a poor college student, that meant teaching himself MS Access. After moving to SQL Server 13 years ago, he found out about the PASS community and never looked back. He now spends his days developing databases using T-SQL, exploring data management tools techniques and trying to make sense of Microsoft’s marketing.
Kim Smith-Rohlfs
Contact: http://www.socaltechrecruiter.com
Kim Smith-Rohlfs is technical recruiter with 14 years of full lifecycle recruiting experience. She has worked for a wide range companies, placing IT professionals and engineers nationwide. Her latest project, www.socaltechrecruiter.com , involves placing software engineering professionals with leading companies throughout California.
Tara Kizer
Contact: http://weblogs.sqlteam.com/tarad
Tara Kizer has 16 years of experience with SQL Server, 13 of it as a DBA. She currently works at Qualcomm, where she is a DBA supporting mission critical systems with high performance and high availability requirements. She has been a Microsoft SQL Server Most Valuable Professional (MVP) since July of 2007. She is one of the top contributors (34k+ posts) in the SQLTeam.com forums and posts under the username tkizer.
Lynn Langit
Twitter: - @lynnlangit
LinkedIn: Lynn Langit
Contact: http://www.lynnlangit.com
Lynn Langit is a Cloud and Big Data Architect. She’s been working with a team on an AWS IoT project this year. Lynn speaks, blogs and creates courses on technical topics for LinkedIn/Lynda.com.
She holds a number of partner awards - Microsoft MVP for Data Platform, AWS Community Hero, Google Developer Expert (Cloud). Her blog is at www.LynnLangit.com. She is also director of the non-profit Teaching Kids Programming (www.TeachingKidsProgramming.org).
Doug Barrett
Douglas Barrett draws on 15 years of data warehouse experience, including 10 years as a Consultant and solution specialist for Microsoft and WhereScape, delivering data warehouse projects using agile tools and techniques. Major data warehouse projects have included Basel II Credit Risk for a Retail Bank, Airline Travel Agent, Hospital Episode of Care, Hotel Occupancy and Utility companies.
Rick Martinez
Contact: http://itknowledgeexchange.techtarget.com/martinez-sql-server/
Rick Martinez is a developer for a medical company. Rick is experienced with SQL SERVER and .NET Framework-Application Development.
Wil Sisney
Twitter: - @HanSQL
Contact: http://www.wilsisney.com
Wil Sisney is a senior database administrator for a large health insurance company, managing business-critical databases. Wil is a Microsoft Certified Professional, holding MCITP certifications in Administration and Development in SQL Server 2008. When Wil isn’t speaking about SQL Server, he’s saving the world from zombies with his website www.zombieprep.net. Find Wil online at: http://www.wilsisney.com
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.
Rushabh Mehta
Twitter: - @rushabhmehta
LinkedIn: Rushabh Mehta
Contact: http://blogs.solidq.com/RushabhMehta
Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.
Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data
Benjamin Nevarez
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning Optimization”, “Inside the SQL Server Query Optimizer” and has contributed to other SQL Server books including “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits.
David McCarter
Contact: http://dotnettips.com
David McCarter is a Microsoft MVP and a principal software engineer/architect in San Diego. He is the editor-in-chief of dotNetTips.com… a web site dedicated to helping programmers in all aspects of programming. David has written for programming magazines and has published three books (the latest is quot;David McCarter#39;s .NET Coding Standardsquot;). He is one of the founders and directors of the 20 year old San Diego .NET Developers Group (www.sddotnetdg.org)
Rushabh Mehta
Twitter: - @rushabhmehta
LinkedIn: Rushabh Mehta
Contact: http://blogs.solidq.com/RushabhMehta
Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.
Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data
Diana Dee
Diana Dee has been a Microsoft Certified Trainer since 1996. Since 2005, she has specialized in training and consulting on SQL Server administration, Transact-SQL querying, and database design.
Diana lives in Huntington Beach with her husband and two Labrador retrievers. Diana is one of the authors of TribalSQL (tribalsql.com).
Arman Saffarnia
Contact: http://neudesic.com
Arman Saffarnia is a Principal Consultant SQL\Business Intelligence Practice at Neudesic and Microsoft Certified Business Intelligence Technology Specialist\Developer. Arman has over 15 years of experience with SQL Server\SQL Business Intelligence. He is truly an evangelist when it comes to SQL Server and provides the technical leadership required for delivering successful SQL server and SQL Business Intelligence projects.
Karen Lopez
Twitter: - @datachick
LinkedIn: Karen Lopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.
Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
Matthew Warren
Matt has been in the business intelligence world since the late ’90s, having started with early versions of Crystal Reports. Matt has worked with the entire BI stack (SSIS/SSAS/SSRS) as well as PerformancePoint and SAP. Matt is a Microsoft Certified MCTS. Matt has led multiple enterprise-level BI projects as both a Director of a billion dollar corporation as well as a principal consultant at Neudesic.
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.
David McCarter
Contact: http://dotnettips.com
David McCarter is a Microsoft MVP and a principal software engineer/architect in San Diego. He is the editor-in-chief of dotNetTips.com… a web site dedicated to helping programmers in all aspects of programming. David has written for programming magazines and has published three books (the latest is quot;David McCarter#39;s .NET Coding Standardsquot;). He is one of the founders and directors of the 20 year old San Diego .NET Developers Group (www.sddotnetdg.org)
Jason Strate
Twitter: - @stratesql
LinkedIn: Jason Strate
Contact: http://www.jasonstrate.com/
Jason Strate is a SQL Server Solutions Architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. Jason writes, blogs, and presents on SQL Server.
Sarah Barela
Twitter: - @sarahspace
Contact: http://www.sqlsarah.net
Sarah Barela is a Senior Manager at CBeyond Cloud Services, formerly MaximumASP. She has a Master’s degree in Information Science from the University of Texas, where she specialized in Database Management Systems. Sarah has spent over 15 years focusing on the administration of enterprise environments with large numbers of SQL Servers. Sarah is currently responsible for a rapidly growing environment with more than 2000 SQL Server instances. Her latest interests are in applying cloud technologies to SQL Server environments. Sarah has been a guest speaker at a number of PASS Chapter meetings, SSWUG Virtual Conferences, SQL Connections, SQLSaturday events, and the 2007, 2009, and 2010 PASS Summits.
Arvind Rayasam
Contact: http://www.nimblestorage.com/
tbd
Lynn Langit
Twitter: - @lynnlangit
LinkedIn: Lynn Langit
Contact: http://www.lynnlangit.com
Lynn Langit is a Cloud and Big Data Architect. She’s been working with a team on an AWS IoT project this year. Lynn speaks, blogs and creates courses on technical topics for LinkedIn/Lynda.com.
She holds a number of partner awards - Microsoft MVP for Data Platform, AWS Community Hero, Google Developer Expert (Cloud). Her blog is at www.LynnLangit.com. She is also director of the non-profit Teaching Kids Programming (www.TeachingKidsProgramming.org).
Doug Barrett
Douglas Barrett draws on 15 years of data warehouse experience, including 10 years as a Consultant and solution specialist for Microsoft and WhereScape, delivering data warehouse projects using agile tools and techniques. Major data warehouse projects have included Basel II Credit Risk for a Retail Bank, Airline Travel Agent, Hospital Episode of Care, Hotel Occupancy and Utility companies.
Ken Mears
Contact: http://krdmtech.wordpress.com/
Ken is a Senior Consultant at Neudesic for the portals and collaboration practice, which includes SharePoint. He has been a SharePoint developer, administrator, evangelist and defender since SharePoint Portal Server 2003. Since his endeavor with Neudesic began, Ken has found renewed energy and focus for the SharePoint platform and its integration with other Microsoft products. He holds a Microsoft certification in applications development.
Ike Ellis
Twitter: - @ike_ellis
Contact: http://ellisteam.blogspot.com
Ike Ellis is a Senior Data Architect and partner for Crafting Bytes. He has designed and implemented data solutions for many well-known organizations. He has been a Microsoft Data Platform MVP since 2011. He co-authored the book “Developing Azure Solutions,” now in its second edition. He is a popular speaker at SQLBits, PASS Summit, and SQL in the City. He speaks at user groups, code camps, and SQLSaturdays. He has written courses on SQL Server for developers, Power BI, SSRS, SSIS, and SSAS for Wintellect. He has an upcoming course on CosmosDB. He founded the San Diego Tech Immersion Group, a technical book club based in San Diego and is the co-chair of the San Diego Software Architecture Group.
Kendal Van Dyke
Twitter: - SQLDBA
LinkedIn: Kendal Van Dyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
Karen Lopez
Twitter: - @datachick
LinkedIn: Karen Lopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.
Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
Eric Freeman
Twitter: - sqlelf
LinkedIn: Eric Freeman
Contact: http://sqlelf.blogspot.com/
Eric Freeman works as a Lead Business Intelligence Architect at John Burns Real Estate Consulting. He has 15+ years of experience working with Microsoft SQL Server and holds an MCTS in Business Intelligence with a strong emphasis on Performance Tuning, ETL and Data Warehousing. Former President of the Sacramento SQL Server User Group, and actively speaks at SQL Server events.
Kendal Van Dyke
Twitter: - SQLDBA
LinkedIn: Kendal Van Dyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
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.
Chris Dickey
Contact: http://www.FastSqlServer.com
Chris Dickey has been an independent consultant specializing in SQL Server performance tuning for the last 14 years. I first started using SQL Server back in 1989. I also have a strong background in applications built using C++, C# and .NET. Recently I have been working with parallel and async features in C# 5 and .NET.Chris is a graduate of UC SanDiego.
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.
Trent Mera
Trent Mera has been a database performance Systems Consultant with Quest Software for 11 years. He specializes in showing customers how to identify and resolve performance bottlenecks in their SQL Server systems. His experience prior to Quest includes 7 years as a Database Developer and Administrator in the Real Estate, Finance and Defense Industries.
Jason Strate
Twitter: - @stratesql
LinkedIn: Jason Strate
Contact: http://www.jasonstrate.com/
Jason Strate is a SQL Server Solutions Architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. Jason writes, blogs, and presents on SQL Server.
Sarah Barela
Twitter: - @sarahspace
Contact: http://www.sqlsarah.net
Sarah Barela is a Senior Manager at CBeyond Cloud Services, formerly MaximumASP. She has a Master’s degree in Information Science from the University of Texas, where she specialized in Database Management Systems. Sarah has spent over 15 years focusing on the administration of enterprise environments with large numbers of SQL Servers. Sarah is currently responsible for a rapidly growing environment with more than 2000 SQL Server instances. Her latest interests are in applying cloud technologies to SQL Server environments. Sarah has been a guest speaker at a number of PASS Chapter meetings, SSWUG Virtual Conferences, SQL Connections, SQLSaturday events, and the 2007, 2009, and 2010 PASS Summits.
Rick Martinez
Contact: http://itknowledgeexchange.techtarget.com/martinez-sql-server/
Rick Martinez is a developer for a medical company. Rick is experienced with SQL SERVER and .NET Framework-Application Development.
Benjamin Nevarez
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning Optimization”, “Inside the SQL Server Query Optimizer” and has contributed to other SQL Server books including “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits.
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.
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.
Sponsors
The following is a list of sponsors that helped fund the event: