SQLSaturday #95 - San Diego 2011

Event Date: 09/17/2011 00:00:00

Event Location:

UCSD Extension - University City Center
6256 Greenwich Dr.
San Diego, California

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

Sessions
Speakers
Sponsors

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

Sessions

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

Title: Unleash the Tablix

Abstract: Tablix = Table + Matrix. Got it? Good. But wait, what exactly is a Tablix good for then? And where is it in your SSRS Toolbox? Not to worry. Angel will show you how to wake up the Tablix control introduced in SQL Server 2008 R2 using some real-world examples. In this session, you’ll learn why the Tablix features help solve many common reporting scenarios such as Timelining, Summarizing, and Subtotaling. Important takeaways from this session are how to aggregate everywhere in your Tablix with single formulas and condensing very wide reports. We’ll also cover some visualization reporting techniques to help solve some pretty common reporting requests such as Exporting to Excel. Please welcome: Table, Matrix, and List.

Speaker(s):

Angel Abundez

Track and Room: Business Intelligence - N/A

Title: Virtualizing your SQL Server Environments

Abstract: If you are a DBA, and you are hearing from your management team “Everything else is being virtualized, when can we virtualize your SQL Servers?”, then you need to come to this session. In it we will discuss the concepts required to properly virtualize SQL Server. You can take control and lead the virtualization conversation by building a fact based plan for when to virtualize, and when to go with a physical infrastructure. You need ammunition and hard evidence to push the server and virtualization teams to consider your SQL Server environments in a different light. What metrics are important for you to capture before go live, and what metrics you must monitor proactively for success.

Speaker(s):

Matt Hollingsworth

Track and Room: Panels/Other - N/A

Title: SQL Server Denali BI Enhancements

Abstract: This session will cover coming enhancements in SSIS, SSAS, SSRS, PowerPivot, Business Intelligence Semantic Model (BISM), and Project Crescent. I will demo the new Project Crescent ad-hoc analysis tool, and show the capabilities within the new Business Intelligence Semantic Model BISM. There are also some nice visual enhancements coming into PowerPivot that you will not want to miss.

Speaker(s):

Matt Hollingsworth

Track and Room: Denali/Other - 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: Denali/Other - N/A

Title: Integration Services 101

Abstract: Whether you are new to SQL Server or you just haven’t had the opportunity to learn about it, Integration Services can be a powerful tool to have at your disposal. In this session, I’ll introduce you to the basic components of an Integration Services package as well as its most common applications. We’ll review best practices for setting up packages for file imports and exports as well as transferring data between servers and automation of packages. Finally, we’ll review more advanced processing techniques, deployment options, logging, and implementation of version history through source control.

Speaker(s):

Ben Bolte

Track and Room: Business Intelligence - N/A

Title: Building a SQL Listener Job Using Powershell

Abstract: In this session, you will be introduced to some simple PowerShell techniques, and see how to combine them to create an event-driven listener job running in SQL Server Agent service. Designed to be accessible to database administrators and database developers, you will see how easy it is to create useful scripts in PowerShell.

Speaker(s):

Peter Kral

Track and Room: DBA 2 - N/A

Title: Tips to be a better Ninja

Abstract: I will talk about software tools that improve my development process (like R#, slickrun, beyond compare,etc..) I will also cover personal workflow habits and tips on improving your workflow and moving more of your “life” to the cloud. I will talk about syncing your life to all machines. This includes notes, email, calendar, files etc.. Some of the products I will talke about are. OneNote, SlickRun, R#, Windows HomeServer, Live Mesh, Google Chrome Sync etc..

Speaker(s):

Brad Cunningham

Track and Room: Denali/Other - N/A

Title: Problem Solving with Common Table Expressions

Abstract: Are you looking for an easier way to de-duplicate your data? Do you need to join a SELECT statement to itself six ways to Sunday? Common Table Expressions (CTEs) can make these tasks (and many others) so much more manageable, you’ll wonder how you ever got along without them. CTEs are a very useful method for abstracting data access in most of the popular relational database platforms (MS SQL Server, Oracle, PostgreSQL, DB2). This session will walk through syntax and implementation of CTEs in MS SQL Server. We will then focus on their practical uses, including self-joins, taking advantage of windowing functions, removing duplicates from data sets, and recursion.

Speaker(s):

Phil Helmer

Track and Room: DBA 2 - N/A

Title: Reducing the impact of database changes on an app

Abstract: The session is about domain driven development. It seems most ORM frameworks being out there do not really solve the abstraction problem between the two as these are table centric. Do such really follow SOA principles when it comes to treating the db? Empower your next project with… server side ORM. I will let you deeply rethink what you’ve done so far. My approach let me save days or weeks of otherwise wasted development hours when it comes to “make a change”. You might feel ORM of your choice seem let you kickstart the project faster, but then… every major change and tweak here and there is a nightmare (refactor, recompile, retest, redeploy). Rewriting an app after every change is like working one step forward, two step backwards.

Speaker(s):

Rajmund Rzepecki

Track and Room: Development - N/A

Title: Backup Basics - Know your options

Abstract: Creating backups is one of the fundamental skills every DBA should know, but there are a plethora of choices when it comes to how you will back up your databases. Learn the options with SQL server, what each choice will do for you and when to use each one.

Speaker(s):

Meredith Ryan-Smith

Track and Room: DBA 1 - 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 WCF 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: Development - N/A

Title: Energizing the Next Generation

Abstract: The number of young women entering IT is declining. What can those of us in the industry do to encourage and inspire young women to seek out careers in technology? Mentoring programs, field trips and “Bring Your Daughters to Work” days all exist, but what more could we be doing to spark interest? Join us to hear from a panel of technical women talk about organized programs and individual endeavors designed to inspire the next generation of Women in Technology.

Speaker(s):

Meredith Ryan-Smith

Track and Room: Panels/Other - 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: Development - N/A

Title: Panel Discussion on Advanced SQL Certifications

Abstract: Join two Certified Masters as they discuss the Certified Masters and Certified Architect certifications for SQL Server. There will be a mixture of material to present and questions from attendees. Bring all of your questions!

Speaker(s):

Robert Davis

Track and Room: Panels/Other - N/A

Title: SQL Server Denali HA

Abstract: You will learn… What is SQL Server AlwaysOn/HardON What is AlwaysOn Availability Group WSFC changes for AlwaysOn FCI AlwaysON VS Clustering/Mirroring/Log Shipping Availability Group with WSFC Availability Group/ Virtual Name Failover Readable Multiple Secondary AlwaysOn implementation Demo (Availability Group/Virtual Name Failover/Readable Secondary)

Speaker(s):

Prakash Heda

Track and Room: Denali/Other - N/A

Title: Technical Debt with Woody Pewitt

Abstract: Technical debt is the cost of putting off good development practices. This debt must be paid back to avoid the “interest payments” becoming crippling. This presentation will focus on a number of common developer (and project) anti-patterns that can lead to the buildup of technical debt in a project and, having identified these behaviors, we’ll look at techniques to firstly quantify and then to mitigate against them.

Speaker(s):

Woody Pewitt

Track and Room: Development - N/A

Title: “BEGIN…COMMIT” is Not Enough

Abstract: Understanding Transactions Transactions are essential to maintaining data integrity. Getting transactions right means understanding both how they work and the business rules that govern your data. This session will explain the fundamentals of transactions and how they behave in SQL Server. It will delve into ACID properties, isolation levels and nested transactions. The session will also review how to structure transactions to satisfy business rules and ensure efficient performance.

Speaker(s):

Denise McInerney

Track and Room: DBA 2 - N/A

Title: T-SQL Tips and Tricks Part 2

Abstract: These are SQL tips for the YouTube generation. I have 20 SQL Server performance tuning and developer tips. They have little to do with each other, and we’ll spend about five minutes on each. Think of this as 20 different, five minute presentations.

Speaker(s):

Ike Ellis

Track and Room: DBA 2 - N/A

Title: Address Quality – What you don’t know can cost you

Abstract: Address data is one of the most common type of contact information found in databases. In this session, we will examine some underlying factors that affect address correctness and build the business case for having good address data. We will touch on how having correct addresses affects all aspects of data quality from matching to enrichment. Handling data is one thing, but knowing your data and understanding the risks are the first step to managing good quality data. Come hear about what you don’t know on Address and Data Quality – it might be costing you.

Speaker(s):

Joseph Verftido

Track and Room: Panels/Other - N/A

Title: SQL Azure: Tools and Frameworks for Developers

Abstract: Demos! See the tools you can use to explore, setup, migrate and maintain a cloud RDMS (SQL Azure). Includes free tools, such as SQL Server Migration Tools; DBA tools, such as SQL Server Management Studio; Developer tools, such as Visual Studio and SQL Server Developer Tools (“Juneau”) and more.

Speaker(s):

Lynn Langit

Track and Room: Panels/Other - N/A

Title: A Business Intelligence Walk-through in 48 Minutes

Abstract: This session was inspired by Brian Knight’s excellent book “Microsoft Business Intelligence 24-Hour Trainer” – with an agile notion to summarize each hour of it in two minutes.

Speaker(s):

Ben Aminnia

Track and Room: Business Intelligence - N/A

Title: 10 Things all BI Administrators Should Know

Abstract: Conversations about SQL Server administration tends to be all about administering OLTP systems. If you administrate BI systems, you can’t apply everything you know about administering OLTP systems to BI systems. BI systems usually end up being administered by OLTP DBAs or by BI developers and architects. Where does one even find a BI Administrator? Fortunately, I’ve been administering BI systems for several years, and I have learned the hard way the difference between administering OLTP and BI systems. This session will cover the top 10 things that I think an administrator of BI systems need to know.

Speaker(s):

Robert Davis

Track and Room: Business Intelligence - N/A

Title: Find Bad Queries: Profiler, DMVs, Extended Events

Abstract: Learn how I find high cost queries using the SQL Server 2008 tools. DMV’s are great for finding a lot of problems fast. But, sometimes you still need Profiler. I will discuss cases where the DMV’s are all you need. I will also discuss how to get information from Profiler that is missing from the DMV data. Extended Events are powerful and will be a major tool in the future of troubleshooting. I will explain why we need Extended Events to solve problems in addition to DMV’s and Profiler.

Speaker(s):

Chris Dickey

Track and Room: Performance/Other - N/A

Title: Avoid Errors on Errors

Abstract: Did you know that when SQL encounters an error of Severity 11 (or higher), there a 4 different ways it can react? Learn how to predict the Error Action or control it. This is possible with or without structured error handling. See both ways to control the outcome. This is a very common workplace faux pas and a Microsoft Certification topic for Dev and Admins. We will use lessons from SQL Programming Joes 2 Pros Vol4.

Speaker(s):

Rick Morelan

Track and Room: DBA 1 - N/A

Title: Basic Performance Tips and Gotchas

Abstract: Forget Profiler for a second, I have seen one poorly placed index bring an enterprise database to its knees. We will cover the basic tips of performance which always work and the ones which always fail. What can you do – and what should you do –when it comes to the most common types of indexes so you always make the right move. We will use lessons from SQL Architecture Joes 2 Pros Vol3.

Speaker(s):

Rick Morelan

Track and Room: Performance/Other - N/A

Title: Replication Magic: Initializing From Backups

Abstract: If you work with very large databases (VLDBs) that must be replicated, you should be using initialization from backup. There are a some misconceptions the have caused DBAs to assume that they could not use initialization from backup. In this session I will explore those misconceptions and prove that they are incorrect.

Demos will include initializing a subscriber from a transaction log backup and performing a partial restore of a database and initializing the subscriber from the partial backup.

Speaker(s):

Robert Davis

Track and Room: DBA 1 - N/A

Title: Understanding Parameter Sniffing

Abstract: Parameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well. The session will also include details on how the Query Optimizer uses the histogram and density components of the statistics object and some other advanced topics.

Speaker(s):

Benjamin Nevarez

Track and Room: DBA 1 - N/A

Title: Inside the SQL Server Query Optimizer

Abstract: The SQL Server Query Optimizer is a cost-based optimizer: it analyzes a number of candidate execution plans for a given query, estimates the cost of each of these plans, and selects the plan with the lowest cost. In this session I will go into the internals of the Query Optimizer and will show you the steps that it performs in the background covering everything from the time a query is submitted to SQL Server until an execution plan is generated. Why query optimization is an inherently complex problem and why challenges in some of its most fundamental areas are still being addressed today will be covered as well.

Speaker(s):

Benjamin Nevarez

Track and Room: Performance/Other - N/A

Title: SQL Server Clustering 101

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

Track and Room: DBA 1 - N/A

Title: Fast Track Data Warehouse project experience

Abstract: I’ll share my project experience implementing Fast Track data warehouse. This session will cover- Fast Track Architecture Overview- Considerations in selecting Fast Track- Why is Fast track a “recipe” based approach? - Key principles of Fast Track architecture

Speaker(s):

Lakshmi Randall

Track and Room: Performance/Other - N/A

Title: Ask the Experts - SQL Server QA Session

Abstract: “Ask the experts” will be an interactive QA session where you can ask veterans anything SQL related. The following experts will answer your questions:

Andrew Karcher
Ben Aminnia
Benjamin Nevarez
Bret Stateham
Denise McInerney
Denny Cherry
Ike Ellis
Lynn Langit

Speaker(s):

Thomas Mueller

Track and Room: Panels/Other - N/A

Title: Working with spatial data in SQL Server

Abstract: Lots of devices can give positions and instead of just storing those in a Latitude and Longitude fields in your database you could be using the Geography data type that SQL Server provides. You can even store more complex shapes like zip code boundaries. We will learn how to fill these, how to work with them, how to index these with spatial indexes and how to use the spatial indexes effectively.

Speaker(s):

Paul Mendoza

Track and Room: DBA 2 - N/A

Title: SQL Server Analysis Services: a 10,000-foot view

Abstract: SQL Server Analysis Services (SSAS) began life as OLAP Services in SQL Server 7, over a decade ago. Since then there have been major architectural enhancements and SSAS now plays a central role in Micorosoft’s Business Intelligence (BI) platform.

This session will describe major SSAS functionality, with demos to illustrate key features. We’ll also examine the new SSAS features in SQL Server 2008 R2 and preview the SSAS Business Intelligence Semantic Model (BISM) being introduced in “Denali”, the next version of SQL Server.

Speaker(s):

Deepak Puri

Track and Room: Performance/Other - N/A

Title: Aspect EntityFramework for SqlAzure best practices

Abstract: When talking to Sql Azure there are some best practices you are supposed to follow. Things like batching and retrying on connection failure. There are well documented ways to do this using ADO.NET. However more and more applications are being written using Entity Framework rather than ADO.NET. If we are using Entity Framework how do we follow those best practices?

Speaker(s):

Scott Reed

Track and Room: Development - N/A

Title: Indexing Internals

Abstract: In this session we’ll dig into the internal structors of indexes. We will explore the differences between clustered and non-clustered indexes, what’s layed out within each page of the indexes and how the SQL Server uses the data within the indexes to find rows quickly.

Speaker(s):

Denny Cherry

Track and Room: DBA 1 - N/A

Title: SQL Server on VMware, what a DBA should know

Abstract: Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.

Speaker(s):

Kathy Gibbs

Track and Room: Panels/Other - 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: Development - N/A

Title: Introduction to Agile

Abstract: Introduction to Agile

Speaker(s):

Llewellyn Falco

Track and Room: Performance/Other - N/A

Title: Business Intelligence with SRS Report Builder

Abstract: Learn how easy it is to utilize the free download from Microsoft that allows users to create charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio.

Speaker(s):

David Eichner

Track and Room: Business Intelligence - N/A

Title: T-SQL Tips and Tricks Part 1

Speaker(s):

Ike Ellis

Track and Room: DBA 2 - N/A

Title: What is “Project Apollo”?

Abstract: Project Apollo introduces Columnstore index in Denali. Columnstore index can potentially improve data warehouse query performance on large fact tables (star joins and aggregation) by creating a highly compressed architecture. It utilizes the same vertipaq algorithm used by Powerpivot. Only the data for the columns selected in the query is brought into memory. Columnstore index is recommended primarily for read-only workloads.The demo will include scenarios which will benefit from using columnstore index and will highlight best practices for using columnstore index.

Speaker(s):

Lakshmi Randall

Track and Room: Denali/Other - N/A

Title: SSIS in Denali

Abstract: In this session we will cover new features of SSIS in Denali in three main areas: the development experience, the deployment experience and the maintenance experience. We will show the results of migrating an existing 2008 SSIS solution that uses package configurations, parent/child package execution and custom logging to Denali. I will compare the new tools to 2008 and will also throw in useful tidbits of SSIS knowledge that I have. If you develop, deploy or maintain SSIS packages then you will take away something positive from the presentation

Speaker(s):

Creighton Kagey

Track and Room: Denali/Other - N/A

Title: So you want to be a BI Developer?

Abstract: Are you just getting into Business Intelligence? Are you a SQL Developer or a DBA that wants to learn more about the skills required to be a BI Professional? If you answered yes to one of those questions, then this is the session for you. This session will take you through the whole Microsoft stack and talk about some of the key areas of knowledge that are needed to call yourself a BI professional at either a beginner, intermediate or advanced level. We will also talk about the various Microsoft Certifications and where they fit. I guarantee you will leave this session with some to-dos and knowledge that you will want to brush up on.

Speaker(s):

Andrew Karcher

Track and Room: Business Intelligence - 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.

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.

Robert Davis

Twitter: - @SQLSoldier

LinkedIn: Robert Davis

Contact: http://www.sqlsoldier.com

Robert is a SQL Server Certified Master, MVP, and has spent 17+ years honing his skills in security, performance tuning, SQL development, high availability, and disaster recovery. He served as PM for the SQL Server Certified Master Program at Microsoft Learning, and in various roles at Microsoft specializing in SQL Server administration, development, and architecture. He currently works as a Database Engineer at BlueMountain Capital Management where he spends a vast majority of his time tuning massively parallel queries. Robert feeds his passion for security by acting as co-leader of the PASS Security Virtual Chapter.

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

Ben Bolte

Ben Bolte began his career developing and administering SQL Server in 1997. Over the last 14 years, he been involved primarily in developing and administering internal SQL Server-based applications, ranging from retail product management to direct marketing tracking systems. Currently, Ben is a Senior Business Intelligence Analyst for Stamps.com. He holds a MCDBA certification.

Creighton Kagey

I have been working with SQL Server versions 6.5, 7.0, 2000, 2005, 2008 for the past 12 years developing data warehouses and ETL processes for a myriad of applications. I currently manage of team of 12 database engineers at CareFusion where we develop data warehouses for external facing dashboarding solutions.

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)

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.

Rick Morelan

Rick has worked more than 12 years at Microsoft and has attained over 30 Microsoft technical including certifications in applications, networking, databases and .NET development (MCDBA, MCTS, MCITP, MCAD, MOE, MCSE, MCSE+I). He has also provided training for NW University, Volt Technical Education, The DigiGirlz, and Microsoft. Rick is the Author of the 5 volume SQL Joes 2 Pros book series.

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.

Chris Dickey

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

Rajmund Rzepecki

Rajmund’s brain always molds and adapts all ideas/concepts that he encounters into new inventions/approaches. Had never written same line of code twice. Worked on creating million dollar technologies instantly adopted and reused across entire company and product line. Had experience with real time market data and trading client as well as government and banking. Enjoys a unique capability of seeing things what others can’t really see such as adopting new technologies in solving problems in IT.

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.

Ike Ellis

Twitter: - @ike_ellis

Contact: http://ellisteam.blogspot.com

Robert Davis

Twitter: - @SQLSoldier

LinkedIn: Robert Davis

Contact: http://www.sqlsoldier.com

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®.

Benjamin Nevarez

Twitter: - @BenjaminNevarez

Contact: http://www.benjaminnevarez.com/

Lakshmi Randall

Lakshmi Randall of La Jolla Data Corp has 13 years experience in database design, development, tuning, and administration including a focus on building and supporting data warehouse and data mart initiatives during the past 6 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.

Lakshmi Randall

Lakshmi Randall is Enterprise Data Warehouse Engineer at Mitchell International and President of La Jolla Data Corp. She has 13 years experience in SQL Server database design, development, tuning, and administration including a focus on building and supporting data warehouse and data mart iniatives during the past 6 years. She is PMP (Project Management Institute) and MCITP 2008 certified.

Industry expertise includes Mortgage, Healthcare Staffing, Pharmaceutical, e-commerce, Toll Collection Retail, Medical, and Auto Claims.

Recent experience includes partnering with HP to build FastTrack architecture proof-of-concept on 3 PAR storage, and introducing PowerPivot for Excel and SharePoint to a Medical and Auto Claims product development corporation.

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.

Brad Cunningham

Contact: http://blog.bradcunningham.net

bio

Rick Morelan

Meredith Ryan-Smith

Twitter: - @coffegrl

Contact: http://meredithryansmith.wordpress.com

Woody Pewitt

Contact: http://blog.pewitt.org

Woody Pewitt is the Director of Software Development at King Schools where he is responsible for all software development and maintenance at King Schools the world´s leading producer of aviation training. Prior to joining King Schools, Woody was an Evangelist at Microsoft in Southern California, driving the awareness and advocating Microsoft development technologies. He is an experienced developer, teacher/trainer and is a part-time instructor at University of California San Diego.

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.

Phil Helmer

Twitter: - @philhelmer

LinkedIn: Phil Helmer

Contact: http://www.philhelmer.com

Phil has been designing and building relational databases in a variety of industries ever since he first realized how many people don’t understand the limitations of Excel and sticky notes as databases. When he was a poor college student, that meant teaching himself MS Access. After moving to SQL Server 13 years ago, he found out about the PASS community and never looked back. He now spends his days developing databases using T-SQL, exploring data management tools techniques and trying to make sense of Microsoft’s marketing.

Prakash Heda

Twitter: - @prakashheda

LinkedIn: Prakash Heda

Contact: http://www.sqlfeatures.com/

Prakash Heda works as Manager (Data-IT) at SSC Advent. His expertise encompasses the work of automation, performance tuning/troubleshooting, high availability, san configuration and windows administration. Heda has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Heda holds certifications for MCDBA and MCITP. His background includes administration development using VB/ASP/SSIS with SQL server 2000 to 2017. He is an active member of PASS, SQLSaturday, and as well a frequent presenter at user groups, SQLSaturdays, and other community events. He is also an avid tweeter, blogger and runner.

Denise McInerney

Twitter: - @denisemc06

LinkedIn: Denise McInerney

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

Kathy Gibbs

Twitter: - KGdba

LinkedIn: Kathy Gibbs

Kathy has over 19 years of IT work experience and over 13 years of DBA experience including architecting, design, development, implementation, monitoring, and disaster recovery of databases. Before starting with Confio, Kathy worked in the financial, retail, and telecom industries working with critical OLTP and OLAP databases. Kathy excels in being a liaison between technical and the end-users or management teams to provide solutions

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

Scott Reed

Contact: http://www.brainhzconsulting.com

Scott’s career in software began in 1993 at IBM. Along the way he developed enterprise solutions for both Microsoft and Cardinal Health. He currently is an independent consultant, as well as a DevelopMentor instructor.

Llewellyn Falco

Llewellyn Falco

Denny Cherry

Twitter: - mrdenny

LinkedIn: Denny Cherry

Contact: https://www.dcac.com

Denny Cherry

Twitter: - mrdenny

LinkedIn: Denny Cherry

Contact: https://www.dcac.com

Paul Mendoza

Contact: http://www.pauldmendoza.com

Paul Mendoza is a software engineer working in the utility data analysis space building tools for finding energy theft and billing problems. He works with SQL Server, ASP.NET, C#, and VB.NET.

Robert Davis

Twitter: - @SQLSoldier

LinkedIn: Robert Davis

Contact: http://www.sqlsoldier.com

Deepak Puri

Deepak is a SQL Server MVP and a Business Intelligence Consultant who has been working with SQL Server Analysis Services since 2000. He’s an active contributor to the MSDN Analysis Services Forum and a regular presenter at Ohio North SQL Server User Group meetings.

Angel Abundez

Contact: http://rdpstreamline.com/category/rdp-streamline-blog/

Principal BI consultant of RDP Streamline Solutions delivering BI solutions with SQL Server, SharePoint, and ASP.NET throughout Northern California. Prior to consulting, I worked 10 years as a Project Engineer doing design, manufacturing, and quality for defense and industrial controls companies. After fixing some PM reports, I quickly found my passion in BI and was promoted to BI Architect and DBA. As a consultant, I enjoy networking with other BI devs and learning about new company processes.

David Eichner

Twitter: - @ICANSoftware

LinkedIn: David Eichner

David Eichner is a licensed CPA and is also CEO of ICAN Software Corporation, a Microsoft Dynamics amp; Acumatica ERP partner firm that sell and implements ERP and CRM software, develops software solutions and provides technology consulting. He is the host of a radio show called Business In The Cloud that airs weekly on KLAY 1180AM. He is skilled in building integrated cloud app solutions. His career spans more than 20 years in various technical/managerial positions within industries as diverse as military service, engineering/construction, municipal government, consulting and certified public accounting. Additionally, he holds various national certificates in technology (MCDBA, MCSE, CNE, CITP, Dynamics CRM and ERP, Acumatica CRM and ERP)

Ben Aminnia

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.

David McCarter

Contact: http://dotnettips.com

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.

SQLSaturday #95 - San Diego 2011

Sessions

Title: Unleash the Tablix

Title: Virtualizing your SQL Server Environments

Title: SQL Server Denali BI Enhancements

Title: My Co-workers Are 9000 Miles Away!

Title: Integration Services 101

Title: Building a SQL Listener Job Using Powershell

Title: Tips to be a better Ninja

Title: Problem Solving with Common Table Expressions

Title: Reducing the impact of database changes on an app

Title: Backup Basics - Know your options

Title: Building nTier Applications with Entity Framework

Title: Energizing the Next Generation

Title: Real World API Design Using The Entity Framework

Title: Panel Discussion on Advanced SQL Certifications

Title: SQL Server Denali HA

Title: Technical Debt with Woody Pewitt

Title: “BEGIN…COMMIT” is Not Enough

Title: T-SQL Tips and Tricks Part 2

Title: Address Quality – What you don’t know can cost you

Title: SQL Azure: Tools and Frameworks for Developers

Title: A Business Intelligence Walk-through in 48 Minutes

Title: 10 Things all BI Administrators Should Know

Title: Find Bad Queries: Profiler, DMVs, Extended Events

Title: Avoid Errors on Errors

Title: Basic Performance Tips and Gotchas

Title: Replication Magic: Initializing From Backups

Title: Understanding Parameter Sniffing

Title: Inside the SQL Server Query Optimizer

Title: SQL Server Clustering 101

Title: Fast Track Data Warehouse project experience

Title: Ask the Experts - SQL Server QA Session

Title: Working with spatial data in SQL Server

Title: SQL Server Analysis Services: a 10,000-foot view

Title: Aspect EntityFramework for SqlAzure best practices

Title: Indexing Internals

Title: SQL Server on VMware, what a DBA should know

Title: Table Indexing for the .NET Developer

Title: Introduction to Agile

Title: Business Intelligence with SRS Report Builder

Title: T-SQL Tips and Tricks Part 1

Title: What is “Project Apollo”?

Title: SSIS in Denali

Title: So you want to be a BI Developer?

Speakers

Sponsors