Event Location:
UCSD Extension - University City Center
6256 Greenwich Dr.
San Diego, California
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
LinkedIn: http://www.linkedin.com/in/sqlrockstar/
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.
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/.
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.
LinkedIn: https://www.linkedin.com/in/philhelmer
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.
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.
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.
LinkedIn: http://www.linkedin.com/pub/lynn-langit/1/621/b40
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).
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.
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.
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
LinkedIn: http://linkedIn.com/in/angelstreamline
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.
LinkedIn: https://www.linkedin.com/in/rushabhbmehta
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
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.
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)
LinkedIn: https://www.linkedin.com/in/rushabhbmehta
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 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).
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.
LinkedIn: http://www.linkedin.com/in/karenlopez
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!”
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.
LinkedIn: https://www.linkedin.com/in/mrdenny
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.
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)
LinkedIn: http://www.linkedin.com/in/jasonstrate/
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.
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.
Contact: http://www.nimblestorage.com/
tbd
LinkedIn: http://www.linkedin.com/pub/lynn-langit/1/621/b40
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).
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.
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.
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.
LinkedIn: http://www.linkedin.com/in/kendalvandyke
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.
LinkedIn: http://www.linkedin.com/in/karenlopez
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!”
LinkedIn: https://www.linkedin.com/in/ericlfreeman
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.
LinkedIn: http://www.linkedin.com/in/kendalvandyke
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.
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.
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.
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 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.
LinkedIn: http://www.linkedin.com/in/jasonstrate/
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.
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.
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.
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.
LinkedIn: http://linkedIn.com/in/angelstreamline
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.
LinkedIn: https://www.linkedin.com/in/mrdenny
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.
The following is a list of sponsors that helped fund the event.