SQLSaturday #73 - Orange County 2011
Event Date: 04/09/2011 00:00:00
Event Location:
- Golden West College
- 15744 Goldenwest St
- Orange County, 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: (SSIS, TSQL) - Record Linkage(Fuzzy Match)
Abstract: We will implement several code samples based on a series of articles amd posts identifying similar records between two different sources or grouping of records from a single source, based on existing column string of values. We will define an approach, review actual implementations with various SQL tools(TSQL, VB,SSS). Although we are discussing matching, we need to address several steps prior to getting to the actual use of matching algorithms.The steps are as follows: 1. Cleansing and standardization 2. Group records 3. Split records 4. Compare records and determine scores 5. Split into separate match categories 6. Analyze results of matches 7. Evaluate using match tools to determine if best algorithms have been combined.
Speaker(s):
- Joseph Verftido
Track and Room: Tech 118 - N/A
Title: DBA as Protector of the Data: Notes from the Field
Abstract: The DBA can be the last line of defense guarding the integrity of their company’s data. Taking this responsibility seriously will make you more successful in your job. This session will discuss how the DBA can proactively ensure the data in their transactional system is clean and correct. The presenter will take a comprehensive view of this crucial aspect of the DBA’s job, drawing on many real-life examples. The topics covered will include table design, transactions, change management, and coding standards. She will explain how these distinct topics are actually part of an integrated approach to data protection. The presenter will also describe how pessimism and vigilance can be valuable traits for a DBA.
Speaker(s):
- Denise McInerney
Track and Room: Tech 101 - N/A
Title: Test Driven Development in SQL Server
Abstract: In the words of Brent Ozar (www.BrentOzar.com), “You can’t be a great SQL developer without using Test Driven Development. In the words of Grant Fritchey (www.ScaryDBA.com), “Test Driven Development with SQL Server made me want to tear my hair out.” Testing in T-SQL may be more cumbersome than in other development languages, but eventually all software must be tested. How can you thoroughly test a data-dependent application without testing the data pieces that drive the application components? If the database has problems, they will eventually affect the rest of the application. This session explores the basics of Test-Driven Development: unit tests; setting up test data; and automating your tests.
Speaker(s):
- David Moutray
Track and Room: Tech 116 - N/A
Title: Women in Tech: Encouraging the Next Generation
Abstract: Everyone has heard that the number of women in technology is declining. How can all of us, women and men, encourage more girls and young women to consider a career in technology? Join a panel of dynamic Women in Technology including Meredith Ryan Smith, Lynn Langit, Denise McInerney and others to discuss this important topic. Attendees are encouraged to ask questions, make suggestions, and share their experiences as well. Everyone is welcome, male and female.
Speaker(s):
- Denise McInerney
Track and Room: Rustler Hangout - N/A
Title: Partitioned Tables: Management Query Processing
Abstract: You are implementing partitioning because you want easier management for very large tables and indexes and want to improve your data loading, deletion and archival operations. But you also need to know the query processing implications and understand how partitioning will impact your existing queries. On the other side, many developers believe that the primary purpose of partitioning is to make your queries run faster. This session will show you the reality and will focus on both how to implement partitioning to achieve better maintenance and data availability and how it will impact query processing, including potential issues, benefits and recommendations.
Speaker(s):
- Benjamin Nevarez
Track and Room: Tech 100 - N/A
Title: Microsoft Business Intelligence All Up
Abstract: This session is almost all demonstration of the Full Microsoft Business Intelligence stack. We will show off all of the latest RTM product sets. Scorecards and Dashboards in SharePoint 2010 and Performance Point Services. SharePoint 2010 Collaboration Integration, Reporting Services Integration into Dashboards, and SharePoint. Data Visualizations using Bing Maps, Reporting Services, and PivotViewer, and finally Managed Self Service Business Intelligence with PowerPivot and Excel 2010. Several demos specific to a Telecommunications provider, a Financial Services provider, and other industry examples.
Speaker(s):
- Matt Hollingsworth
Track and Room: Rustler Hangout - N/A
Title: The Data Mining Lifecycle
Abstract: Take this opportunity to see the development of a real-world data mining model from inception to deployment. The Business Intelligence components of SQL Server make it possible to create powerful predictive models that can easily be incorporated into our applications. In this presentation Carlos Bossy will demonstrate how to develop a data mining model using Analysis Services through the entire lifecycle. You will learn how to choose a meaningful project with a high likelihood for success, including setting a prediction target, selecting the appropriate data, and adapting it for maximum results.
Speaker(s):
- Carlos Bossy
Track and Room: Tech 117 - N/A
Title: Index Internals
Abstract: During this session we will be digging into the internals of SQL Server indexes.
Speaker(s):
- Denny Cherry
Track and Room: Rustler Hangout - N/A
Title: SSIS Development: Improving package reliability
Abstract: This session will provide techniques on how to make SSIS packages more reliable and robust in production.
Topics to cover:
- Transactions
- Error Handling
- Logging
- Package Configurations
We’ll get to do some development, move a lot of data around and have some fun.
Speaker(s):
- Reagan Williams
Track and Room: Tech 118 - N/A
Title: SQL Server Agent Powershell Jobs 101
Abstract: Many SQL Server Database Administrators or T-SQL developers have not had the chance to learn about Powershell scripting. This presentation introduces Powershell scripting within SQL Server Agent jobs, explaining the critical basics you’ll need to get started. You’ll see examples of SQL jobs that use Powershell scripts to manage files, to control other jobs, and to create and mail simple reports. By the end, you’ll be ready to create your first SQL Server Agent job with a Powershell job step.
Speaker(s):
- Peter Kral
Track and Room: Tech 101 - N/A
Title: SQL Server Panel Discussion
Abstract: In this session SQL Server experts/users will talk about several SQL Server topics.
Speaker(s):
- Thomas Mueller
Track and Room: Rustler Hangout - N/A
Title: Become Bilingual! Oracle for the SQL Server DBA
Abstract: In today’s enterprise environments, it is becoming increasingly necessary to integrate data from a variety of sources. As SQL Server continues its march into the enterprise, the days of focusing 100% on one platform are over. At a bare minimum, we need to be able to communicate with DBA’s for other platforms. Terminology as simple as Instance and Database mean very different things in Oracle than they do in SQL Server. In this session, we will compare and contrast the two platforms in terms of features and terminology. We will also discuss some of the best practices and pitfalls when integrating the two.
Speaker(s):
- Randy Knight
Track and Room: Tech 101 - N/A
Title: Help Desk to DBA in 60 Minutes
Abstract: Most accidental DBAs’ start their foray in to database administration in a similar way. You start with little knowledge of SQL server and maybe even little knowledge of system administration basics at all. I will share some tips and tricks that I have picked up over the years to help you get on your feet as a DBA, by showing you how to find out where your instances of SQL are, what business processes depend on them, what their current states are and how to learn the skills you need to keep your databases safe and available.
Speaker(s):
- Meredith Ryan-Smith
Track and Room: Tech 118 - N/A
Title: Delivering BI Solutions with SQL and SharePoint
Abstract: Microsoft provides a well-integrated set of components that leverage SQL data to deliver compelling BI solutions. In this intermediate-level session we’ll pull back the covers from the SharePoint 2010, Analysis Services, PowerPivot and SQL architectures to demonstrate best practices and real-world demos showing how to integrate these technologies into a seamless end-user experience. The session will focus on SharePoint 2010 BI features, security, Analysis Services, Reporting Services Integrated mode, PowerPivot, Excel Services and mobile device integration.
Speaker(s):
- Rob Kerr
Track and Room: Tech 117 - N/A
Title: The Largest SQL Server Projects in the World
Abstract: What are the largest SQL Server projects in the world and how do they scale? Come to this session and find out. Based on the work of Microsoft’s SQL Server Customer Advisory Team (SQL CAT). SQL CAT represents the customer-facing resources from the SQL Server Product Group. SQL CAT is comprised of product and solution experts that regularly engage in the largest, most complex, and most unique customer deployments worldwide.
Speaker(s):
- Matt Hollingsworth
Track and Room: Rustler Hangout - N/A
Title: Visual Studio 2010 Database Projects
Abstract: Managing DDL scripts has always been one of the biggest challenges facing Database Developers. How do you keep your Development, Test, Stage, and Production Environments in sync? Why aren’t databases tightly integrated into source control systems like application code is? Visual Studio 2010 Database projects solve all these problems and more. In this session, we will learn how to use Visual Studio to treat database objects as the first-class citizens they have always been.
Speaker(s):
- Randy Knight
Track and Room: Tech 101 - N/A
Title: Designing Re-Startable SSIS Packages
Abstract: SSIS provides the Checkpoint functionality for recovery after a package failure, but many experienced SSIS developers eschew it because of its lack of granularity when restarting a failed package. Sometimes the restarted package will execute tasks that had partially succeeded previously, causing data consistency issues or outright data destruction! In this session, you will see SSIS package design that allows predictable, scalable recovery after a partial or complete failure during execution. Intended for experienced SSIS developers with knowledge of SSIS Expressions and T-SQL.
Speaker(s):
- Peter Kral
Track and Room: Tech 100 - 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: Rustler Hangout - N/A
Title: Using SQL Server Denali’s Always On (HADR)
Abstract: In this session we will look at the features which are provided with Microsoft SQL Server “Denali” as part of the “Always On” features including site to site configurations to allow of a large scale high availability solution without the need for any high end SAN storage solution.
Additionally we will be looking at the ability to have redundant servers which can be used for reporting or for taking your backups reducing the load from the production database.
Speaker(s):
- Denny Cherry
Track and Room: Tech 100 - N/A
Title: Access with SQL Server Express - Perfect!
Abstract: SQL Server Express was the best thing to ever happen to Microsoft Access, it provides security, multi-user service, and processing power beyond what Jet could ever provide. Now you can migrate small databases to a environment that can meet corporate IT policies and enjoy it without paying for a server license. We will discuss migration strategies to SQL Server Express, backup and maintenance, and optimizing the relationship between the two. We will also cover avoiding road blocks and what every SQL Server table should have when working with Access.
Speaker(s):
- Juan Soto
Track and Room: Tech 116 - N/A
Title: Business Intelligence for Managers/Decision Makers
Abstract: Business Intelligence is an essential component for any business today and a successful BI implementation has the power to change the way your organization functions. In this non-technical session Carlos Bossy will show you what a BI project looks like and how it is different from other IT projects, how to determine the ROI of a BI project, the makeup of a good BI team, how to define the success of a BI implementation, and how to fix a BI project gone bad. You will also learn how to evaluate your BI Analytical Strategy and you should leave this session with better knowledge of how to plan, build and deploy effective Business Intelligence solutions.
Speaker(s):
- Carlos Bossy
Track and Room: Tech 117 - N/A
Title: My Co-workers Are 9000 Miles Away!
Abstract: How to Succeed on a Distributed Team More and more technology professionals work with colleagues who are based all over the world. Being part of a distributed team means dealing with differences in communication style, work culture and time zones. Based in the U.S., Denise McInerney works on a team that has more than 50% of its members in India. In this session Denise will share her tips and techniques for how to be successful when working with people around the globe.
Speaker(s):
- Denise McInerney
Track and Room: Tech 117 - N/A
Title: Building nTier Applications with Entity Framework
Abstract: Learn how to build real world nTier applications with the Entity Framework and related services. With this new technology built into .NET, you can easily wrap an object model around your database and have all the data access automatically generated or use your own stored procedures and views. Then learn how to easily and securely expose your object model using WCF with just a few line of code using ADO.NET Data Services. The session will demonstrate how to create and consume these new technologies from the ground up.
Speaker(s):
- David McCarter
Track and Room: Tech 116 - N/A
Title: SQL Server Reporting Services Map Visualizations
Abstract: SQL Server 2008 R2 Reporting Services provides a new map visualziation that allows you place your data in customized map reports. In this session we will review how to get your data onto the map!
Speaker(s):
- Bret Stateham
Track and Room: Tech 118 - N/A
Title: To the power of Transact SQL
Abstract: Let’s put to the test TSQL and see how far the SQL Server engine goes. To attend you need to understand execution plans and SQL Server engine concepts, otherwise it would be fun.
Speaker(s):
- Jose Pons
Track and Room: Tech 101 - N/A
Title: What’s New in SQL Azure?
Abstract: Using mostly demos, Lynn will show you how to work with SQL Azure using tools and techniques. She will cover migrating data, feature compatibility and futures.
Speaker(s):
- Lynn Langit
Track and Room: Tech 118 - N/A
Title: Developing on SQL Azure
Abstract: Learn what SQL Azure means to the developer and the DBA. We’ll discuss key differences, gotchas, and performance tuning methods. If we have time, we’ll cover SQL Reporting Services in the cloud and SQL Azure Data Sync Services. Lynn Langit and Ike Ellis will be speaking.
Speaker(s):
- Ike Ellis
Track and Room: Tech 118 - 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: Rustler Hangout - N/A
Title: Reporting Services - Charts and more.
Abstract: In this session we will explore the 2008R2 chart types along with the Data Bar, Sparkline and Indicator data regions. We will take a simple table report and enhance it by adding these graphic elements
Speaker(s):
- Phil Robinson
Track and Room: Tech 117 - N/A
Title: Intro to T-SQL
Abstract: This is a 100 level session on T-SQL for beginners
Speaker(s):
- Mark Rosenberg
Track and Room: Tech 116 - 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 • What are the entities? (Top-down design) • Table connectivity (one-to-many or many-to-many) • What are the attributes? (Bottom-up design) • Normalization
Speaker(s):
- Diana Dee
Track and Room: Tech 100 - N/A
Title: Parallel Data Warehouse - Architecture Overview
Abstract: In Nov.2010, Microsoft officially released SQL Server 2008 R2 PDW Edition. Parallel Data Warehouse is a true MPP (massive parallel processing) platform featuring an ultra shared nothing architecture. PDW is capable of delivering very fast query performance and can house up to 500 TB of data. This session will overview both the HW and SW architecture of the PDW appliance. It will explain how Microsoft and HP have engineered a solution using commodity HW and SW that can compete with more expensive platforms like TeraData and ExaData. Additionally, SQL DBAs will see where their current skillset is applicable to managing a PDW appliance.
Speaker(s):
- Ted Tasker
Track and Room: Tech 100 - N/A
Title: MS Access with SQL Server Strategies and Tips
Abstract: Access can be a rapid development UI for small SQL Server databases, saving you time and money over .Net, IF you follow the right strategies and avoid the pitfalls. We will discuss how to fine tune the relationship between the two, strategies on importing data, how to minimize connections to SQL Server and touch on Access Data Projects. We will also discuss where Access as the presentation layer makes sense and DBA strategies in working with Access developers. At the end you will walk away with a better sense of managing the Access/SQL Server relationship.
Speaker(s):
- Juan Soto
Track and Room: Tech 116 - N/A
Title: Powershell for the DBA
Abstract: This is a level 100 session going over the basics of powershell. The second half of the session will be seeing powershell in action and some cool scripts for the DBA to help wet the appetite. Powershell is a great tool in the DBA toolbelt that will make you a more valuable assett to your company. I will go over the basics and show you some things that will allow you to do just about anything you want with Powershell..
Speaker(s):
- Colin Smith
Track and Room: Tech 101 - N/A
Title: SSIS - a real life sample
Abstract: Check out SSIS capabilities and see the diference from DTS technology.
Speaker(s):
- Jose Pons
Track and Room: Tech 117 - N/A
Title: Opening Session
Abstract: Opening Session
Speaker(s):
- Andrew Karcher
Track and Room: Registration Area - N/A
Title: Real World API Design Using The Entity Framework
Abstract: In this session I will show you how I used the Entity Framework Services to design and create an API servicing layer to expose back end data to partners. We will dive into using the Entity Framework (data layer), WCF Data Services (service layer), T4 templates (business entities), WCF Message Inspectors (security) and more.
Speaker(s):
- David McCarter
Track and Room: Tech 116 - N/A
Title: Virtualization Basics for the SQL Guru
Abstract: This session will cover Microsoft Virtualization technologies in Windows 7 and Windows Server 2008 R2 (Hyper-V). I will cover how to use the tools in both environments to create and manage Virtual Machines (VMs) and explain when to use Windows 7 versus Server 2008 R2. Lastly, I will show how to configure your system for multi-boot using Boot to VHD. If you have a USB hard drive with 10 GB of free space, I will also give you an unactivated VHD with Server 2008 R2 installed and ready to go with Hyper-V.
Speaker(s):
- Harold Wong
Track and Room: Tech 100 - 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.
Reagan Williams
Contact: http://www.rwsql.com
Reagan Williams is an SQL Developer Administrator with almost 10 years of software development experience. Starting out with writing custom CGI web components in C++ SQL Server 2000, he currently works on a BI team at a Southern California insurance firm, specializing in moderately sized DBs (>1b records, >2 TBs).
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).
Andrew Karcher
Twitter: - @akarcher
Contact: http://www.andrewkarcher.com
Andrew is a Data Professional that is super passionate about the ability of data to drive change in our world, work, and personal lives. He has over 15 years of experience across multiple roles, companies and technologies. A passion for learning is core to how I approach life. Over 10+ years I have spoken at User Groups, Code Camps, SQLSaturdays and Conferences along with supporting my local community as a SQLSaturday Organizer, User Group leader, and advocate for community involvement for all technology professionals. I was also recognized by Microsoft as a four-time SQL Server MVP for my technical community contributions.
Randy Knight
Twitter: - randy_knight
LinkedIn: Randy Knight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
Benjamin Nevarez
Twitter: - @BenjaminNevarez
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server 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 amp; Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals.quot; Benjamin has also been a speaker at many SQL Server conferences, including PASS Summit, SQL Server Connections, and SQLBits. His blog can be found at http://www.benjaminnevarez.com.
Harold Wong
Contact: http://blogs.technet.com/b/haroldwong
I am an IT Pro Evangelist who absolutely loves technology. I have been working with computers since the early 80’s (TRS80 and Commodore C64). I am fortunate enough to be in a role where I get to spend time with the community to talk about Microsoft technologies and not have to worry about a sales quota. This allows me to share my opinions (good and bad) about the state of our platform.
Bret Stateham
Contact: http://BretStateham.com
My name is Bret Stateham, and I’m a Microsoft Technical Evangelist based in San Diego, CA. As an Evangelist for Microsoft I am passionate about Microsoft technologies like Windows 8, Windows Phone, Windows Azure and my long term favorite Microsoft SQL Server. However, I am a lover of technology in general, and the impact that it can have on peoples lives. if you would like to learn more about me, you can read my blog at http://BretStateham.com
Denise McInerney
Twitter: - @denisemc06
LinkedIn: Denise McInerney
Contact: http://weblogs.sqlteam.com/denisem/default.aspx
Denise McInerney is a data professional with over 20 years of experience. She began her career as a database administrator and has worked as a data analyst and data engineer. She now works as a data architect at Intuit, where she designs and implements analytics solutions with a focus on enabling the work of analysts, data scientists, and business users. Denise is active in technical community organizations and has spoken at user groups and conferences over two dozen times. She served on the PASS Board of Directors for six years.
Juan Soto
Contact: http://www.AccessExperts.net
Juan Soto is a Senior Access Developer at IT Impact Inc., where he specializes in Access with SQL Server databases. His passion for Access is second to none in helping a wide range of businesses and leveraging both technologies in a secure, stable and efficient environment. He’s a frequent speaker at Access user groups nationwide and recently spoke at Chicago’s SQL Server User Group in December. To learn more about Juan, please visit his site: AccessExperts.net or blog: AccessExperts.net/blog
Randy Knight
Twitter: - randy_knight
LinkedIn: Randy Knight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
Benjamin Nevarez
Twitter: - @BenjaminNevarez
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server 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 amp; Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals.quot; Benjamin has also been a speaker at many SQL Server conferences, including PASS Summit, SQL Server Connections, and SQLBits. His blog can be found at http://www.benjaminnevarez.com.
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.
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.
Peter Kral
Twitter: - https://twitter.com/pkral
LinkedIn: Peter Kral
Peter Kral is a Premier Field Engineer (Data AI) at Microsoft. He holds SQL Server MCSA 2012/2014/2016 and Data Platform MCSE certifications, and was the winner of the Speaker Idol Award at PASS Summit 2016. Peter lives in the San Diego area where he is an active member of the local PASS chapter. He has spoken at many SQLSaturdays, SoCal Code Camps, and at PASS Summit 2017 and 2018.
Colin Smith
Contact: http://itknowledgeexchange.techtarget.com/dba/
I have worked in IT for just over 7 years. I have worked my way through the Help Desk, Workstation Technician, Windows Server Admin, and now at the DBA stop. As a DBA I have worked with MSSQL, Sybase, and Oracle. I have pretty much settled down and work mostly with MSSQL now.
Carlos Bossy
Twitter: - @carlosbossy
LinkedIn: Carlos Bossy
Contact: http://www.carlosbossy.com
Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.
Denny Cherry
Twitter: - mrdenny
LinkedIn: Denny Cherry
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
Matt Hollingsworth
Matt Hollingsworth has spent over twenty years in various roles in the database industry and is currently a Microsoft data platform architect covering the Microsoft South West district including Hawaii. Prior to his current role Matt spent over ten years in the Microsoft SQL Server development team in Redmond as a Program Manager for Always On, Replication, Log Shipping, Mirroring and the annual Oracle competitive review. Matt got married a week ago, so go easy on him.
Carlos Bossy
Twitter: - @carlosbossy
LinkedIn: Carlos Bossy
Contact: http://www.carlosbossy.com
Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.
Denny Cherry
Twitter: - mrdenny
LinkedIn: Denny Cherry
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
Ted Tasker
Ted Tasker joined Microsoft in 2008 as a Technology Solution Professional – and now focused on SQL Parallel Data Warehouse. Ted has over 17 years of experience with SQL Server going back to version 4.2.1. Prior to joining Microsoft, he spent 10 years leading DW and BI groups in financial and Internet entertainment companies. In his current role, Ted provides technical guidance and support in evaluation and implementation planning of very large SQL Server Data Warehouses for customers in the U.S. In the last 6 months Ted has personally worked on 5 PDW proof of concepts and can speak directly to the capabilities of the product.
Phil Robinson
Phil Robinson is an independent consultant focused on developing Business Intelligence solutions using Microsoft Reporting Services and Power BI. He is founder of the San Diego SQL Business Intelligence Group and co-founder of SQLSaturday – San Diego.
Mark Rosenberg
Mark Rosenberg has been writing software with Microsoft technologies for the last 10 years. He has been speaking to user groups and at code camps for the last 2 years and been a certified trainer for the last year.
Mark likes to talk to developers and has been talking to anyone who will listen. He is very active in the community, both speaking at user groups and running 2 user groups in Southern California.
Jose Pons
SQL Server veteran: 6/7/2000/2005 and 2008 Back-end developer: 7+ years Database Administrators: 7+ years Web Developer: C#/VB.NET.ASP/VB-COM/JavaScript: 10+ years
Denise McInerney
Twitter: - @denisemc06
LinkedIn: Denise McInerney
Contact: http://weblogs.sqlteam.com/denisem/default.aspx
Denise McInerney is a data professional with over 20 years of experience. She began her career as a database administrator and has worked as a data analyst and data engineer. She now works as a data architect at Intuit, where she designs and implements analytics solutions with a focus on enabling the work of analysts, data scientists, and business users. Denise is active in technical community organizations and has spoken at user groups and conferences over two dozen times. She served on the PASS Board of Directors for six years.
Matt Hollingsworth
Matt Hollingsworth has spent over twenty years in various roles in the database industry and is currently a Microsoft data platform architect covering the Microsoft South West district including Hawaii. Prior to his current role Matt spent over ten years in the Microsoft SQL Server development team in Redmond as a Program Manager for Always On, Replication, Log Shipping, Mirroring and the annual Oracle competitive review. Matt got married a week ago, so go easy on him.
Peter Kral
Twitter: - https://twitter.com/pkral
LinkedIn: Peter Kral
Peter Kral is a Premier Field Engineer (Data AI) at Microsoft. He holds SQL Server MCSA 2012/2014/2016 and Data Platform MCSE certifications, and was the winner of the Speaker Idol Award at PASS Summit 2016. Peter lives in the San Diego area where he is an active member of the local PASS chapter. He has spoken at many SQLSaturdays, SoCal Code Camps, and at PASS Summit 2017 and 2018.
Meredith Ryan-Smith
Twitter: - @coffegrl
Contact: http://meredithryansmith.wordpress.com
Meredith is the database administrator for The Bell Group. With more than 10 years of experience in IT, Meredith’s responsibilities have included everything from manning the Help Desk to VAX/VMS cluster administration. Most recently she has served as the production database administrator specializing in cluster administration and performance. Meredith has attended seven PASS Summits, and had volunteered with the WIT Virtual Chapter since early 2009. Most recently Meredith became the chapter leader for the Women In Technology Virtual Chapter, and has kept busy speaking at SQLSaturday events in the western half of the US.
Joseph Verftido
Twitter: - /melissadata
LinkedIn: Joseph Verftido
Contact: http://blog.melissadata.com/data-quality-authority/
A Data Quality Analyst at Melissa Data, Joseph has worked with numerous clients in understanding their business needs for data quality, analyzing their architecture and environment, and recommending strategic solutions to successfully integrate data quality within their infrastructure. He gives frequent webinars for implementing different techniques for data quality and also manages the MVP Program – a network that provides resources to community leaders, speakers, consultants and other experts.
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)
Juan Soto
Twitter: - jsoto22
LinkedIn: Juan Soto
Contact: https://accessexperts.com/blog/
I’m the President of IT Impact, a Microsoft Access MVP and a frequent author on the official Microsoft Access blog as well as the first Access developer to be profiled on their site. I’m also a frequent speaker at Access User Groups throughout the USA, covering subjects such as SQL Server with Access as well as providing tools and resources for Access developers on the web. My expertise is optimizing Access with SQL Server and helping SQL Server DBAs understand how to design tables for Access.
Rob Kerr
Twitter: - @robkerrbi
LinkedIn: Rob Kerr
Contact: http://www.robkerr.com
Rob is CTO with BlueGranite, is a Microsoft SQL Server MVP and holds top Microsoft certifications in both SQL Server Database Administration and BI Development. Rob has implemented data warehouse and business analytics systems for many Fortune 500 companies, and focuses on large-scale data warehousing, geospatial data analysis and mobile solutions. Rob is the lead contributor to msbiacademy.com, a site providing free on-demand training covering a variety of Microsoft BI topics.
David Moutray
Database Administrator with five years experience in database design, business intelligence, application development, performance tuning and day-to-day administration with SQL Server. Experience covers administration of both transactional and data-warehouse databases, application development and database design for business applications. Certifications include MCITP Database Administrator and Developer. Passionate about database security and promoting data integrity through rock-solid database design and good development practices.
Lynn Langit
Contact: http://blogs.msdn.com/SoCalDevGal
Lynn is a Sr. Developer Evangelist. She has been working with SQL Server since 6.5. Prior to joining Microsoft, she did production work with SQL Server, Analysis Services and more. Her blog is http://blogs.msdn.com/SoCalDevGal
Thomas Mueller
Contact: http://www.tmspecial.com
Thomas Mueller has been working with databases for almost 15 years. He is the Implementation/Database Administration Manager at HMS, a healthcare company in Santa Ana. Thomas got his BS in Digital Media Computer Science in 1999 and received his MS in Information Systems from Claremont Graduate University in 2004. In addition to databases, his interests include data mining, knowledge management and LEGO®.
Jose Pons
SQL Server veteran: 6/7/2000/2005 and 2008 Back-end developer: 7+ years Database Administrators: 7+ years Web Developer: C#/VB.NET.ASP/VB-COM/JavaScript: 10+ years
Denise McInerney
Twitter: - @denisemc06
LinkedIn: Denise McInerney
Contact: http://weblogs.sqlteam.com/denisem/default.aspx
Denise McInerney is a data professional with over 20 years of experience. She began her career as a database administrator and has worked as a data analyst and data engineer. She now works as a data architect at Intuit, where she designs and implements analytics solutions with a focus on enabling the work of analysts, data scientists, and business users. Denise is active in technical community organizations and has spoken at user groups and conferences over two dozen times. She served on the PASS Board of Directors for six years.
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)
Sponsors
The following is a list of sponsors that helped fund the event: