Event Location:
Goldenwest College
15744 Goldenwest Street
Huntington Beach, California
Abstract:
Modern day computing power along with SQL Server makes it possible to add sophisticated data mining models to our applications that forecast and predict, perform anomaly detection, and classify data. This presentation will demonstrate how to use Analysis Services to incorporate these complex algorithms seamlessly into your databases, from transactional processing to integration, data analysis and performance management. Attendees will be shown how to create a data mining model using SSAS, how to use SSIS to query and load mining forecasts, and a sample application that seamlessly uses the mining model. Take a step forward towards making BI pervasive in your organization by integrating data mining into your company’s applications.
Speaker(s): Carlos Bossy,
Abstract:
Solid-state technologies are changing the way that MS SQL users run their databases. DBA’s are achieving significant TCO savings through performance enhancements, reliability improvements, and reduced energy and real estate costs using solid-state technologies. Solid state is changing the way datacenters look and how MS SQL Servers perform. This session will address: 1) On overview of solid state technology options for SQL Server 2) Why solid state makes a difference? 3) An comparison of the different types of NAND Flash-based products and the advantages and disadvantages of each: a. Disk-based SSDs b. Onboard/Embedded PCI Express devices c. Host-based PCI Express devices 4) Customer proof: Wine.com case study
Speaker(s): Sumeet Bansal,
Abstract:
Darrell will be describing an import classification application initially developed entirely in Access and then converted to SQL Server 2008, leaving the Access UI intact. Darrell will demonstrate both the before and after versions, showing how he migrated the Access macros and VBA code to SQL stored procedures, and what he learned along the way. This topic should be of particular interest to: Database designers, Access developers, SQLServer application developers, and anybody considering an Access-to-SQLServer migration. Some of the key points of interest: Data-driven application design, SQLServer vs Access performance advantages, How to use pass-through SQL, Leveraging the power of SQLServer, Access design considerations.
Speaker(s): Darrell Burns,
Abstract:
The Query Optimizer is the component of SQL Server that attempts to determine the best way to execute a query by finding an efficient execution plan. This session will show you how a better understanding on how the Query Optimizer works can help you to improve the performance of your databases. See how you can provide SQL Server with appropriate statistics and indexes so it can perform better cardinality estimation and produce an efficient execution plan. Learn how you can troubleshoot problems if you are not getting an efficient execution plan and how you can use other alternatives like hints or plan guides to help the query optimizer to produce a better plan.
Speaker(s): Benjamin Nevarez,
Abstract:
In this tough job market, it is more important than ever that you present yourself in the best possible light when searching for your next opportunity. The interview plays a crucial role in determining if you are the one that lands the job. In this hands-on session, you will learn what the interviewer is looking for from you and how to supply it. This is a must for job seekers.
Speaker(s): Steve Hendricks,
Abstract:
I will discuss tricky tuning issues that I have encountered during my years speeding up SQL Server. Simple rules often don't apply to complex problems. SQL Server queries can have a wide variety of complexities. Slow queries are caused by these issues: 1. data might be retrieved from disk or RAM 2. row estimates are too high or too low 3. functions are zero costed 4. the optimizer doesn't know the value of a local variable 5. a query is too complex for the optimizer to do a great job 6. indexes compete for RAM 7. optional parameters 8. a high cost query only using 1 cpu 9. table variables 10. the optimizer isn't perfect
Speaker(s): Chris Dickey,
Abstract:
Opening Remarks for the Event
Speaker(s): Andrew Karcher,
Abstract:
This presentation covers SharePoint 2010 Business Intelligence related technologies including the Chart Web Part, Business Intelligence Center, PerformancePoint, Reporting Services, Report Builder, PowerPivot and Business Connectivity Services.
Speaker(s): Jen Underwood,
Abstract:
Raffle Prizes
Speaker(s): Andrew Karcher,
Abstract:
Clustered and nonclustered index structure and operation are explained and demonstrated. Use of query plans, plus Management Studio and dynamic management view methods for determining index structure and fragmentation are shown.
Speaker(s): Diana Dee,
Abstract:
Patterns emerge as both templated solutions to recurring problems and designs, as well as provide useful ways to encapsulate complex ideas into smaller, friendlier terms. Patterns gained popularity in the object-orientated community since the Fowler and the Gang Of Four, but declarative languages, like SQL, have had little-to-no coverage of how these patterns can be applied. Understanding SQL design patterns is a crucial skill every SQL developer must learn and use in their career. SQL patterns can be applied to small projects or large, multi-million dollar systems, to provide common solutions to complex problems. Patterns create a foundation for "best practices" for SQL, Database Architecture, managers.
Speaker(s): Jim Bears,
Abstract:
Would you like your SQL to run faster and better? Then attend this session, we will talk about Temp Tables and Table Variables as well as tips and tricks to make your SQL run better
Speaker(s): Mark Rosenberg,
Abstract:
We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea. Like all problems in the database world there are no hard set answers as to if virtualization is a good idea, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money. There are some other times when you will be shooting yourself in the foot and shouldn’t. We’ll be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision.
Speaker(s): Denny Cherry,
Abstract:
Concurrency management is a fundamental function of RDBMs. In this session, you will learn how SQL Server uses locking to manage the conflicting goals of concurrency and ACID compliance. You will learn about the different lockable resource types, lock granularities and modes, and how the selection of transaction isolation levels modulates locking behavior. A novel locking pattern used at MySpace called READ UNTIL will be described. You will also be given a demonstration of troubleshooting techniques using documented and undocumented features, along with a research technique to help further your own locking knowledge.
Speaker(s): Kevin Stephenson,
Abstract:
A survey of the various types of joins available at the T-SQL coding level (logical), how the optimizer implements them (physical) and the tools you can use to assure that the best execution plan is being selected.
Speaker(s): Steve Hendricks,
Abstract:
Slowly Changing Dimension or SCD is a common problem to data warehousing. This session will provide an overview of SCD problem and present several solutions to this particular problem implemented with Microsoft SQL Server Integration Services
Speaker(s): Ravi Bodla,
Abstract:
This presentation walks through building reports in Reporting Services 2008 and Excel 2007 that query data from Analysis Services Cubes. It will also explain a variety of reporting solution architecture options using Microsoft's Business Intelligence technologies.
Speaker(s): Jen Underwood,
Abstract:
We have a great SQL community here in Southern California. But, there are always things that we could do better. Do you have ideas or feedback on the community and things that you would like to see? Come to the session and talk with User Group and Community Leaders about User Group and Community Wide Events. Also, get information about how you can get involved.
Speaker(s): Andrew Karcher,
Abstract:
SQL Server Reporting Services 2008 is an enterprise reporting platform included with SQL Server. While it is included with SQL Server, it is a great solution for reporting on any data in your organization whether the data is in SQL Server or not. In this session, I’ll introduce you to SQL Server Reporting Services, it’s architecture, and tools you can use to develop and deliver high quality reports to your users. Topics covered in this session include, SSRS Architecture, Using Business Intelligence Development Studio (BIDS) to develop reports, using Report Builder to develop reports, report deployment and delivery
Speaker(s): Bret Stateham,
Abstract:
Tip for targeting your job search. Using technology and online resources.
Speaker(s): Stacey Braodwell,
Abstract:
If you are new to server virtualization, this is the perfect session to get familiar with the components and features of Microsoft’s Hyper-V R2 (Windows Server 2008 R2). Once we get the basics out of the way, I will walk through some key items in configuring your own Hyper-V environment for testing as well as key factors for using Hyper-V in a production environment. I will briefly discuss virtualization factors for SQL in preparation for Denny’s session.
Speaker(s): Harold Wong,
Abstract:
Want to learn how to write a basic SQL query? Then this session is for you, I will go over how to write a basic SQL query including joins.
Speaker(s): Mark Rosenberg,
Abstract:
In this session we will look at the available techniques for consolidating a SQL Server database, and when to use each technique to help reduce capital expenses. Most importantly we will talk about how to decide when not to consolidate your databases.
Speaker(s): Denny Cherry,
Abstract:
With introduction of XML in Word 2003 and XML column data type in SQL Server 2005, there's a tremendous opportunity to put both technologies together. I presented my vision of this technical symbiosis about two years ago and now it's time to take it to the next level.
Speaker(s): Ben Aminnia,
Abstract:
This session will focus on Microsoft and partner technologies that enable high performance, efficient and real-time data integration using SQL Server Integration Services (SSIS), and that work with data from Oracle, Teradata, and other heterogeneous sources. You will learn how Microsoft high-speed Connectors by Attunity can be leveraged with change-data-capture (CDC) technologies integrated with SSIS to enable data replication. Use cases highlighting real-time data warehousing and operational reporting, as well as maintenance of data consistency between operational databases and applications will also be outlined.
Speaker(s): Doug Wheaton,
Abstract:
SQL Server 2008 R2 Parallel Data Warehouse - An Unofficial Early Look at the Possibilities for Fast, Large Scale Data Warehouses In this session, we will review some of the information that Microsoft has released about the exciting new SQL Server 2008 R2 Parallel Data Warehouse. We will consider the product's origins, the opportunities it will present, and some predictions about what might be possible in the future with the combination of a whole new generation of technology (including solid state drives, faster networking, and more).
Speaker(s): Jon Saltzman,
Abstract:
Business Intelligence or BI has recently become the focus of a lot of organizations. Microsoft SQL technologies (SQL, SSAS, SSIS, SSRS, etc…) provide a comprehensive backend support for implementing BI. This session will provide a high-level overview of BI architectures and roles that Microsoft SQL technologies play in the BI world.
Speaker(s): Ravi Bodla,
Abstract:
This session will be very interactive. The discussion will include resources such as - websites - magazines - associations - conventions - people - 3rd party companies Attendees are encouraged to voice their opinions about the resources and mention ones that didn’t make the list.
Speaker(s): Thomas Mueller,
Abstract:
In this demo-filled session, Lynn will explain the differences between Windows Azure storage and SQL Azure. She wil demonstrate working with SQL Azure storage in your application and discuss the option to connect a non-cloud hosted front end and/or a cloud-hosted front end to a SQL Azure back end solution. Lynn will also talk about migration strategies and best practices. In her talk, you wil also learn recommended business scenarios for cloud-based storage. Finally, she will cover in detail features of SQL Server RDMS which are and are not supported in SQL Azure.
Speaker(s): Lynn Langit,
Abstract:
In this session we will cover the basics and delve into the advanced techniques which can be used to cluster Windows servers using the Windows Cluster Service, what sort of protection this provides you, and how to properly set up your clusters for a rock solid environment which will last you for many years to come. We will start with planning our cluster configuration, selecting our software, and walk through the process of clustering two servers together into an active passive cluster. We will cover the differences between a standalone machine and clusters with regard to licensing and multiple instance configurations.
Speaker(s): Denny Cherry,
Abstract:
Data Visualization for the SQL Server Enterprise: Key Principles for Deploying Front-End Visual Analytics Tools Starting with a quick overview of why the human brain responds more effectively to visual information and ending with recommendations for successful interface design, this topic will help you understand how the addition of visual analysis in your application can increase your users’ satisfaction levels with your SQL Server solution. Jesse will demonstrate the importance of visual analysis – including the iterative process of asking questions, creating pictures, discovering new hypothesis, and foraging for data.
Speaker(s): Jesse Gebhardt,
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://www.frontlineda.com
Darrell has been developing customized database applications since 1988. His most recent achievement was a system for classifying imported goods against the US Harmonized Tariff Schedule and determining eligibility for special trade preferences. During his career he has designed apps for database marketing, case management, metadata management, geo-demographics, locational analysis, watch-list screening, and asset management. He served as CIO for marketing information company Nielsen/Claritas.
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.
LinkedIn: http://www.linkedin/in/carlosbossy
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.
Contact: http://www.linkedin.com/pub/ravi-bodla/0/586/96b
Ravi Bodla is a senior architect with Hitachi Consulting. He has more than ten years of professional experience in the manufacturing, high-tech, financial, and aerospace and defense sectors. His major areas of expertise are in business intelligence, data warehousing, data quality, business analysis, client-server application development and data modeling.
Contact: http://blogs.claritycon.com/blogs/andrew_karcher
As a Senior Database Consultant with Clarity Consulting (http://www.claritycon.com), for over 10 years, Andrew's duties include architecting and developing solutions, for a variety of clients in diverse fields on the Microsoft platform including SQL Server, .Net, and Business Intelligence. Andrew is a 3-Time Microsoft MVP for SQL Server. He serves the community in multiple roles including the organizer of SQLSaturday in Orange County.
Contact: http://www.hackingsqlserver.com/
Kevin Stephenson has been with MySpace, headquartered out of Beverly Hills, since June, 2008. He came to MySpace after many years contracting in the entertainment and internet startup space all over the LA basin. He has been working on Microsoft SQL Server products since version 4.2 and has over 15 years experience in data architecture and development, focusing on very large databases with high volumes of transactions.
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.
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.
Contact: http://sqlblog.com/blogs/ben_nevarez
Benjamin Nevarez has more than 15 years of experience with relational databases and has worked with SQL Server since version 6.5. He has been the technical editor of the two latest Kalen Delaney’s books including 'SQL Server 2008 Internals'. Benjamin holds a Master’s Degree in Computer Science and has been a speaker at several technology conferences, including the PASS Community Summit. Benjamin blogs at http://sqlblog.com/blogs/ben_nevarez.
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://blogs.claritycon.com/blogs/andrew_karcher
As a Senior Database Consultant with Clarity Consulting (http://www.claritycon.com), for over 10 years, Andrew's duties include architecting and developing solutions, for a variety of clients in diverse fields on the Microsoft platform including SQL Server, .Net, and Business Intelligence. Andrew is a 3-Time Microsoft MVP for SQL Server. He serves the community in multiple roles including the organizer of SQLSaturday in Orange County.
Contact: http://www.FastSqlServer.com
Chris has worked for over 12 years as an independent consultant solving SQL Server performance problems. He started working with SQL Server in 1989. After all those years, he is still finding better ways to solve performance problems faster. There might be new surprises popping up during the next consulting job. It is best to be prepared. So, Chris just finished attending 5 days of advanced SQL Server performance training taught by the people at SQLSkills. Chris is a graduate of UCSD
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.
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://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
Contact: http://www.linkedin.com/pub/ravi-bodla/0/586/96b
Ravi Bodla is a senior architect with Hitachi Consulting. He has more than ten years of professional experience in the manufacturing, high-tech, financial, and aerospace and defense sectors. His major areas of expertise are in business intelligence, data warehousing, data quality, business analysis, client-server application development and data modeling.
Contact: http://blogs.claritycon.com/blogs/andrew_karcher
As a Senior Database Consultant with Clarity Consulting (http://www.claritycon.com), for over 10 years, Andrew's duties include architecting and developing solutions, for a variety of clients in diverse fields on the Microsoft platform including SQL Server, .Net, and Business Intelligence. Andrew is a 3-Time Microsoft MVP for SQL Server. He serves the community in multiple roles including the organizer of SQLSaturday in Orange County.
Sumeet Bansal is Principal Solutions Architect for Fusion-io. He designs architectural solutions with Fusion-io products that deliver unprecedented levels of scalability, performance and simplicity. Sumeet has more than 11 years IT and database-infrastructure experience, including work as vice-president of information technology at MS SQL-based Internet retailer Wine.com, senior database architect for MS SQL-based eVineyard inc., and systems analyst for Akiba Bank Limited.
LinkedIn: https://www.linkedin.com/in/jenunderwood
Contact: http://www.impactanalytix.com/
Jen Underwood, a Senior Director at DataRobot, has held worldwide analytics product management roles at Microsoft and served as a technical lead for system implementation firms. She has over 20 years of experience launching new products and turning around failed projects in enterprise data warehousing, reporting, and advanced analytics. Today she designs product and helps analytics professionals learn how to solve complex problems with machine learning in the emerging citizen data science segment. Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego.
Jon Saltzman has over 10 years of pleasant and exciting experience working with a variety of databases, including multi-value legacy databases such as Pick/D3 and MUMPs, and relational databases such as MySQL, PostgreSQL, SQLLite and SQL Server (since SQL Server 2000). He has been an application developer specializing in data-driven web applications, a database developer/analyst/administrator, and is currently wearing many hats, including some from the business side of operations.
Steve Hendricks is a sought after speaker and consultant on database and job search topics. Having been a Database Administrator since 1997 and Microsoft certified since 2000, he has seen and heard it all. His sessions are always well attended and highly anticipated.
Contact: http://www.pointercorp.com
Ben Aminnia is a database architect / .NET developer / consultant at Pointer Corporation with over 25 years of experience in developing database systems and managing a team of SQL Server developers and DBAs. He's also the architect of Virtual Information Portal (VIP) System and the past-president of Los Angeles SQL Server Professionals Group.
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
Contact: http://ittalentsearch.com/
Stacey founded IT Talent Search in 2009 representing marketing Top Technology Talent to companies throughout Los Angeles on a contract, contract-to-hire fulltime basis. We employ the most sophisticated software developed by industry leaders/researchers and engage a remarkable team of recruiters. We are the resource that enables companies to stay current and competitive.
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®.
For over 18 years, repeatedly recognized for developing innovative solutions for multi-million dollar, globally deployed software and systems. Jim Bears is a frequent speaker in Southern California user groups and Code Camps, and also serves as a Director for the San Diego .NET Developers Group, mentor at the San Diego .NET Tech Immersion Group, and Co-Founder of SQLSaturday San Diego. He also currently serves as Chief Technology Officer for Computer Market Research, Ltd
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.
LinkedIn: https://www.linkedin.com/in/jenunderwood
Contact: http://www.impactanalytix.com/
Jen Underwood, a Senior Director at DataRobot, has held worldwide analytics product management roles at Microsoft and served as a technical lead for system implementation firms. She has over 20 years of experience launching new products and turning around failed projects in enterprise data warehousing, reporting, and advanced analytics. Today she designs product and helps analytics professionals learn how to solve complex problems with machine learning in the emerging citizen data science segment. Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego.
Doug Wheaton is a CDC expert and has over 20 years of experience in the content, workflow management and data integration space. He has written numerous related articles and has presented at many Microsoft conferences, SQLSaturdays and user groups throughout the US on the topics of BI and data integration using Microsoft SSIS.
Steve Hendricks is a sought after speaker and consultant on database and job search topics. Having been a Database Administrator since 1997 and Microsoft certified since 2000, he has seen and heard it all. His sessions are always well attended and highly anticipated.
Contact: http://www.tableausoftware.com
Jesse Gebhardt is a technical resource for our Sales Team. He is presented with hundreds of different business problems from every type of industry each month, which makes him well-equipped to answer questions on the fly. Jesse is an East-Coaster living on the West Coast. He studied Physics and Computer Science at the University of Southern California. His family owns a restaurant in New Jersey, so food is his life (along with analysis).
The following is a list of sponsors that helped fund the event.