SQLSaturday #159 - Kansas City 2012

Event Date: 08/04/2012 00:00:00

Event Location:

Cerner Corporation’s Riverport Campus
6711 NE Birmingham Rd
Kansas City, Missouri

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: “What is the Best Disaster Recovery Solution?”

Abstract: It depends, every situation is different. The question is often asked of DBA’s to provide a solution to very open ended requirements. However, the best solution can only be provided if the database professional is getting all the answers. This session is a case study into many of Disaster Recovery options that we as database professionals have. Understand the answers to the important questions that we should be asking to provide the best solution not only for the database but for the business as well. As an attendee you will learn how to change an answer from it depends into a solid solution that can be built upon. We will take examples from experiences and as a group determine what the best solution is.

Speaker(s):

Chris Shaw

Track and Room: 3 Columbia - N/A

Title: Devs are from Mars, Report Servers are from Venus

Abstract: At first, you loved working with Reporting Services, but now the honeymoon’s over. What good are charts and tables when Reporting Services won’t tell you what’s wrong, renders too slow, and messes up your layout? You may be thinking about seeing other reporting products, but don’t give up.

In this couples therapy for you and SSRS, rekindle your love by reviewing how reports perform best, seeing what RS has been trying to tell you (but you haven’t been listening), and discovering new and simple tricks you never knew reports could do. You’ll learn about:

• Dealing with blank extra pages • Designing reports for high performance • Powerful properties for precise layout and appearance • Troubleshooting using the execution log • ..a

Speaker(s):

Doug Lane

Track and Room: 2 Danube - N/A

Title: So you want to be a computer consultant?

Abstract: Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn’t start earlier? (and walk away from a cushy job).

I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I’ve learned the hard way. In this session you will lean sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out.

Speaker(s):

Juan Soto

Track and Room: 6 Missouri - N/A

Title: Introduction to Master Data Services 2012

Abstract: Businesses depend on reliable data that can be managed effectively and shared through-out the enterprise. In this session we will look at the how Master Data Services 2012 can provide a solid platform for your organization’s master data management implementation. We will spend a majority of the session building a model, loading it with data and then refining it to highlight the features and capabilities that are available both out-of-the-box and through the excel plug-in.

Speaker(s):

Christopher Price

Track and Room: 4 Seine - N/A

Title: SQL Server 2012 Column Store Index

Abstract: Take your relational data warehouse query performance all the way to ELEVEN!! The Column Store Index is a new feature that allows for stunning performance. We will cover how it works, why it is so fast as well as the v1.0 limitations and gotchas.

Speaker(s):

Kevin Boles

Track and Room: 3 Columbia - N/A

Title: The Accidental Programmer

Abstract: Most people in the database world have heard of the term, “The Accidental DBA”, those programmers who out of nowhere get thrown into working with databases. Well what about the other side of the coin? What about those DB Developers and DBA’s who have to write code? This presentation is a best practices guide for working with SQL Server in a .Net environment. It covers optimizing your code to reduce database requests, standard object oriented concepts such as data abstraction and encapsulation, tier architecture, security, and translating SQL data result sets into strongly typed class objects in .Net.

Speaker(s):

Jason Kassay

Track and Room: 2 Danube - N/A

Abstract: Social Networking is all over the news today. Did you see that on Facebook? Johnny 5 said what on Twitter?? Can you believe Susie moved to that company?? Do any of those sound familiar? No? Never heard of Twitter? Don’t have any fear as this session is for you! Social networking can be a very confusing place and when you don’t know where to start, that makes it even worse. In this session, we will go over different facets of Social Networking and how you can use them to enhance not only your personal lives but just as importantly, your professional one. We’ll be covering Facebook, LinkedIn and Twitter.

Speaker(s):

John Morehouse

Track and Room: 6 Missouri - N/A

Title: Building your first PowerView report

Abstract: So have you heard about this new fangled BI tool called PowerView from Microsoft? Well if you haven’t then this is the session for you. During this session we will take a look at PowerView and discuss all the cool things it can do. Once we get all the talk’n out of the way, we walk through building your first PowerView report.

Speaker(s):

Frank Kearney

Track and Room: 3 Columbia - N/A

Title: 10 Things That Every DBA Should Know!

Abstract: Are you just starting out in the DB world? Are you unsure of things that you should know? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered ‘Yes’ to any of those question, then this is the session for you! John will be talk about things that he’s seen in the trenches that every DBA should know and understand.

Speaker(s):

John Morehouse

Track and Room: 0 Sports Bar - N/A

Title: Freaky Fast Database Development Tips

Abstract: Join Rick and Dave on this most excellent adventure as they teach you how to get more work done in less time. Leave your checkbook at home, because this is all about maximum productivity with minimum budget. Leave with Visual Studio and SQL Server Management Studio shortcut keys, extensions, macros, and add-ins. We guarantee you will see something you haven’t seen before, or your money back.

Co-Presenter: Dave Valentine (@IngeniousSQL)

Speaker(s):

Rick Krueger

Track and Room: 0 Sports Bar - N/A

Title: Storage Design and SQL Server Performance

Abstract: This discussion will be about storage design and how it affects SQL Server’s performance. Topic will include Solid State Drives (SSDs), SAN and Direct Attached Storage (DAS) and how the perform using RAID 5,RAID 6 and RAID 10. We will also cover File Groups, Files and entry level Table Partitioning.

Speaker(s):

Rowland Gosling

Track and Room: 0 Sports Bar - N/A

Title: SSIS 2012 Management Considerations and Best Pract

Abstract: SQL Server 2012 introduces a number of exciting new features that will change the way we design, deploy and manage SSIS packages. We will explore the new features, understand how to take advantage of them and formulate some best practices for efficient management of these packages

Speaker(s):

Rushabh Mehta

Track and Room: 4 Seine - N/A

Title: Integrating DQS, MDS and Your Data Warehouse

Abstract: With SQL Server 2012 it has never been easier to empower your data stewards and give them greater control over the data management process. Dive in as we integrate Master Data Services and Data Quality Services into a data warehouse. We will explore how Master Data Services and the new plugins available in 2012 can facilitate the management of your organization’s master data. A look at Data Quality Services will highlight how it can be leveraged to provide value to the data management process through its cleansing and matching capabilities. Finally, we evaluate the options available to integrate back into the data warehouse.

Speaker(s):

Christopher Price

Track and Room: 4 Seine - N/A

Title: SSIS 2012: More Than Just a Pretty UI

Abstract: SSIS 2012 added rounded corners and Undo/Redo to the designer, but what else was added to make this worth the upgrade? In this session there will be as many demos of the new features as can be fit into the time provided. Along with the rounded corners, you will also see the changes to deployment, SSIS catalog database, metadata/XML updates, Parameters, logging updates, Data Taps, ODBC support, script debugging, PowerShell interface and as many others as we can get through. If you haven’t seen what has been updated in SSIS 2012, this will be the session to cover the most!

Speaker(s):

Steve Wake

Track and Room: 2 Danube - N/A

Title: 45 Minutes to Build Your First Reporting Services

Abstract: Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you’re a DBA and could use a daily report. Either way, I’ve got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2008 R2 and go interstellar with some space data!

Speaker(s):

Tamera Clark

Track and Room: 1 Amazon - N/A

Title: Model-Driven Database Design

Abstract: Model-Driven Database Development: Myths, Magic and Methods. In this presentation, Karen discusses data model-driven database development from the point of view of the Data Architect, the DBA, and the Developer. She will cover topics such as “Who does what?”, “Why are we doing this?”, “Do I have to Use a GUI?” and “Just who do you think you are?”. Demos, too. Finally, 10 tips for making model-driven database development successful in your organization’s culture and environment.

Speaker(s):

Karen Lopez

Track and Room: 2 Danube - N/A

Title: Discovering the Plan Cache

Abstract: Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery.

Speaker(s):

Jason Strate

Track and Room: 4 Seine - N/A

Title: Parallel Query Execution Deep Dive

Abstract: What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? What can prevent it’s use by the engine? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine.

Speaker(s):

Kevin Boles

Track and Room: 3 Columbia - N/A

Title: Virtualizing Business Critical SQL Servers

Abstract: Everyone knows that SQL Server can be virtualized, but most are only virtualizing development and testing environments. Top-tier production workloads can be virtualized too, and this session will provide valuable insight into how to properly prepare for and implement a successful virtualization campaign for ALL of your SQL Server environments and prepare your organization for the change. Practical tips, tricks, and gotchya’s will be discussed in this dynamic dialog session.

Speaker(s):

David Klee

Track and Room: 5 Hudson - N/A

Title: Extended Events, Work Smarter Not Harder

Abstract: There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.

Speaker(s):

Jason Strate

Track and Room: 2 Danube - N/A

Title: Database Health and Performance

Abstract: Sure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? This dynamic dialog session will present a solid process for checking your environment’s overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO.

Speaker(s):

David Klee

Track and Room: 0 Sports Bar - N/A

Title: Reporting Services tips for the Stephen Few fan

Abstract: Do you opt for bullet charts over big, round gauges? Do 3-D pie charts make you sad? Have you ever redesigned a graph to get a better data-to-ink ratio? Whether you answered yes to all of these questions or you are unfamiliar with all of the above terms, come to this session to learn about helpful features and tools available when using Reporting Services to visually represent data in an efficient and effective manner. We will also discuss common challenges faced in the workplace when trying to implement the ideals in real life.

Speaker(s):

Meagan Longoria

Track and Room: 1 Amazon - N/A

Title: Database Design Throwdown

Abstract: A highly interactive debate between Thomas LaRock and Karen Lopez about options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys *NULL vs NOT NULL * Quality vs Performance…and others. Bring your votes, your debates, and your opinions.

Speaker(s):

Karen Lopez

Track and Room: 1 Amazon - N/A

Title: Maintain Your DBs with Help from Ola Hallengren

Abstract: One of the most widely respected and recommended free tools for SQL Server is Ola Hallengren’s MaintenanceSolution.sql. It is a one-stop package to backup your databases, maintain your indexes and statistics, and validate the integrity of databases. Come learn about the solution and how it can help you escape the world of canned maintenance plans as well as the importance of performing the various maintenance tasks.

Speaker(s):

Andy Galbraith

Track and Room: 5 Hudson - N/A

Title: SQL Azure Data Sync and What’s New

Abstract: In this session, you will get introduced to SQL Azure Data Sync and learn how to get started. We will explore how to migrate data from an existing on-premise SQL Server database to SQL Azure and bi-directional data synchronization and data management capabilities allowing data to be easily shared across SQL Azure databases across multiple data centers. What you will learn: • Overview of SQL Azure • How to Get Started with SQL Azure Data Sync • Cloud to cloud synchronization • Enterprise (on-premises) to cloud • Cloud to on-premises. • Bi-directional or sync-to-hub or sync-from-hub synchronization

Speaker(s):

Andy Thiru

Track and Room: 5 Hudson - N/A

Title: 2012 TSQL Sweets

Abstract: The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you’ll have a taste for all the sweets they’ve packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences.

Speaker(s):

Bill Fellows

Track and Room: 1 Amazon - N/A

Title: SQL Azure Intro and What’s New

Abstract: In this session, you will get introduced to SQL Azure and learn how to get started. We will explore how to migrate an existing on-premise SQL Server database to SQL Azure. We will then walkthrough how to manage and administer your SQL Azure servers and databases. We will take a look at how to connect and build applications using SQL Azure. Next, we will look at more advanced scenarios using new capabilities like reporting with SQL Azure Reporting, synchronizing data with SQL Azure Data Sync for hybrid scenarios and global reach. Finally, we will explore some of the things you should consider when using SQL Azure

Speaker(s):

Andy Thiru

Track and Room: 5 Hudson - N/A

Title: Introduction to Execution Plans

Abstract: Ever wonder what happens when a query is processed? Got a process that is running slow at the office and your boss in looking at you for answers? Want to look like a hero to your boss for fixing something that no one else could figure out? Then you might want to consider this session. Execution plans tell you what steps were taken to generate the results sets you did. In analyzing these plans, you can figure out what you are doing that is not efficient, so you can fix it. This session will give you the foundation you will need to do analysis so you can write better code and help your company with their performance issues.

Speaker(s):

Nathan Heaivilin

Track and Room: 3 Columbia - N/A

Title: Introduction to Data Quality Services

Abstract: Data Quality Services (DQS) has been introduced as part of the Microsoft SQL Server 2012 stack. In this session, we will take a first look at DQS and how it can transform the way we enable and set data quality standards to ensure clean data.

Speaker(s):

Rushabh Mehta

Track and Room: 4 Seine - N/A

Title: Choose Your Own Adventure: Performance Tuning

Abstract: Life is all about choices, and when it comes to SQL Server it is no different. If you don’t have a methodology for researching questions and resolving issues then you need to get one, and soon. Join Microsoft MVP Thomas LaRock from Confio Software as he helps guide you while YOU make the choices in this interactive performance tuning adventure.

Speaker(s):

Thomas LaRock

Track and Room: 0 Sports Bar - N/A

Title: SSRS: Reporting on Reports

Abstract: Business Intelligence gets a lot of press these days, but do you often wonder to yourself as you are writing a report, ‘Who is going to use this’? Learn about the rich information that SSRS is already capturing for you about your reports: who is running them and how often, how long do they take to execute, how much time is spent in data retrieval vs rendering, which parameters were passed in, and more… Co-Presenter: Rick Krueger (@DataOgre)

Speaker(s):

David Valentine

Track and Room: 1 Amazon - 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.

Jason Strate

Twitter: - @stratesql

LinkedIn: Jason Strate

Contact: http://www.jasonstrate.com/

Jason Strate is a SQL Server Solutions Architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. Jason writes, blogs, and presents on SQL Server.

David Klee

Contact: http://davidklee.net

David Klee is a SQL Server performance and virtualization expert, and has been working with the product since version 2000. With over fifteen years of IT experience, David spends his days virtualizing mission critical SQL Servers as a Solutions Architect for House of Brick Technologies. His areas of expertise are virtualization and performance, datacenter architecture, software engineering, security, and business process analysis.

Steve Wake

Twitter: - stevewake

LinkedIn: Steve Wake

Contact: http://blog.wakebi.com

Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in consulting, advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full on-premises Microsoft BI stack. Recent experience with the Azure services: Analysis Services, Logic Apps, Data Factory, Databricks, Snowflake and Power BI. Steve is also very involved in the SQL community, speaking at events around the world.

Jason Strate

Twitter: - @stratesql

LinkedIn: Jason Strate

Contact: http://www.jasonstrate.com/

Rick Krueger

Contact: http://www.premierapps.com

Rick Krueger is a SQL Server indie based in the Twin Cities with 17 years of software and database development experience, working with SQL Server since 1998 (6.5). Don’t let his developer credentials (MCPD) and background fool you, he knows a thing or two about SQL, and is currently focusing on Development DBA work. Rick has recently started tweeting as @DataOgre to get more involved in the SQL Community.

Tamera Clark

Twitter: - https://twitter.com/tameraclark

LinkedIn: Tamera Clark

Contact: http://tameraclark.com

Tamera Clark has been involved in the IT industry for greater than ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter, Co-leading the Nashville BI Chapter, assisting the Nashville PASS Chapter and serving as a Regional Mentor. Tamera is also the event chair of SQLSaturday Nashville.

Andy Thiru

Andy aka Abhi has several years of BI experience including planning, design, development and implementation in business database applications.Andy has worked primarily as a consultant holding positions primarily in the Energy,Banking,Media,Consulting. Currently Working on Cloud development Project.

Frank Kearney

Contact: http://frankkearney.wordpress.com/

Frank Kearney is the BI Team Lead for Valorem Consulting. He has over 15 years experience in IT with over 12 years experience working with SQL Server and the business intelligence stack across several industries including Healthcare, Telecommunications and Manufacturing. He can often be found atop his business intelligence soapbox or coaching his daughters softball team.

John Morehouse

Contact: http://sqlrus.com

John Morehouse is currently a Database Architect/Engineer with Farm Credit Services of America in Omaha, Nebraska. He is one of the leaders of the Omaha SQL/BI User group and and a frequent speaker at SQLSaturday’s as well as other conferences. In his spare time, you can find John running after one of his two sons or working on his 113 year old house.

Rushabh Mehta

Twitter: - @rushabhmehta

LinkedIn: Rushabh Mehta

Contact: http://blogs.solidq.com/RushabhMehta

Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.

Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data

Andy Thiru

John Morehouse

Contact: http://sqlrus.com

Chris Shaw

Twitter: - @SQLShaw

LinkedIn: Chris Shaw

Contact: http://chrisshaw.wordpress.com/

Chris Shaw started his database career in 1993. Following the Marines, Chris continued working with databases for companies such as Wells Fargo, Pulte Mortgage, and Yellow Pages Inc. Chris has been writing and speaking about SQL Server for over 15 years at events such as SQL Connections, PASS Summit, and SSWUG Ultimate conferences. Chris received his 5th Microsoft MVP award.

Rowland Gosling

Twitter: - @BigSQL

LinkedIn: Rowland Gosling

I’ve worked on a variety of data platforms including SQL Server, Oracle, DB 2 and Hadoop. SQL Server has been my choice OLTP/Data Warehouse platform for many business needs. These days I’m working almost exclusively in the cloud using Microsoft’s Azure and a variety of new products like Azure Data Warehouse, Azure Cosmos DB and Data Factory. As a Microsoft employee, my focus is working on our data platform for our financial services customers.

Meagan Longoria

Twitter: - mmarie

LinkedIn: Meagan Longoria

Contact: http://datasavvy.me

Meagan Longoria is a business intelligence consultant with Denny Cherry Associates, and lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).

David Klee

Twitter: - kleegeek

LinkedIn: David Klee

Contact: http://davidklee.net

David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.

Karen Lopez

Twitter: - @datachick

LinkedIn: Karen Lopez

Contact: http://datamodel.com

Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.

Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Nathan Heaivilin

Just a DBA who wants to give back to the community who gave so much to me.

Christopher Price

Contact: http://bluewatersql.wordpress.com/

Chris Price is a Sr. BI Consultant with Pragmatic Works based in Tampa, FL. He has a B.S. in MIS and a MBA, both from the Univ. of South Florida. He previously worked as a software architect before being bitten by the BI bug. His current focus is on ETL and Data Integration, Data Quality and MDM, SSAS, SharePoint and Big Data. He regularly speaks at SQLSaturdays, Code Camps and other community events. He has authored multiple whitepapers and books and served as technical editor.

Jason Kassay

Twitter: - @jasonkassay

LinkedIn: Jason Kassay

Contact: http://www.JasonKassay.com

Jason Kassay is a database administrator, software engineer amp; speaker from Colorado with over 12 years of experience. He is passionate about SQL Server, programming, release process, automation amp; performance tuning. Jason is an active member of the SQL Server community amp; volunteers/presents at events such as Colorado User Groups, SQLSaturday amp; Colorado GiveCamp. When not tuning databases or coding, Jason will most likely be found spending time with his family, playing hockey or running.

Rushabh Mehta

Twitter: - @rushabhmehta

LinkedIn: Rushabh Mehta

Contact: http://blogs.solidq.com/RushabhMehta

Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.

Christopher Price

Contact: http://bluewatersql.wordpress.com/

Doug Lane

Contact: http://www.douglane.net

Doug Lane (MCITP, MCTS) is a consultant with Brent Ozar Unlimited and has over 14 years’ experience with SQL Server. He blogs about SQL Server with emphasis on Reporting Services and professional development.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

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.

Andy Galbraith

Twitter: - https://twitter.com/DBA_ANDY

LinkedIn: Andy Galbraith

Contact: http://nebraskasql.blogspot.com/

I’m a forty-something Microsoft SQL Server DBA of 18+ years, a devoted husband, and a father of three young boys (all aged eight and under!) I have been a DBA at a public university, at a major bank, at a healthcare system, and I now work as a consultant with customers across the United States. I write and speak primarily about the tips and tricks that I discover along my SQL Server journey.

Bill Fellows

Twitter: - @billinkc

LinkedIn: Bill Fellows

Contact: http://blog.billfellows.net

Bill Fellows is a SQL Server MVP and has been a database developer for most of his career, with the past 15 years focused on ETL. He is the organizer of Kansas City’s eight SQLSaturdays and a speaker at many other SQLSaturdays, User Groups and the PASS Summit. Bill is the owner of Sterling Data Consulting where he gets to solve interesting data problems.

Thomas LaRock

Twitter: - @SQLRockstar

LinkedIn: Thomas LaRock

Contact: http://thomaslarock.com

Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.

Karen Lopez

Twitter: - @datachick

LinkedIn: Karen Lopez

Contact: http://datamodel.com

Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”

David Valentine

Twitter: - https://twitter.com/IngeniousSQL

LinkedIn: David Valentine

Contact: http://www.ingenioussql.com

Dave Valentine is a Development DBA with over 15 years of experience with SQL Server and development technologies, specializing in Business Intelligence and ingenious solutions. Dave has also been an Adjunct Professor at Metropolitan State University for the past 15 years educating students in Database Management and Application Development. Dave started giving back to the SQL community a few years ago by presenting at Local PASS Chapters, SQLSaturday Events, and blogging at IngeniousSQL.com.

SQLSaturday #159 - Kansas City 2012

Sessions

Title: “What is the Best Disaster Recovery Solution?”

Title: Devs are from Mars, Report Servers are from Venus

Title: So you want to be a computer consultant?

Title: Introduction to Master Data Services 2012

Title: SQL Server 2012 Column Store Index

Title: The Accidental Programmer

Title: Social Networking Is Alive!

Title: Building your first PowerView report

Title: 10 Things That Every DBA Should Know!

Title: Freaky Fast Database Development Tips

Title: Storage Design and SQL Server Performance

Title: SSIS 2012 Management Considerations and Best Pract

Title: Integrating DQS, MDS and Your Data Warehouse

Title: SSIS 2012: More Than Just a Pretty UI

Title: 45 Minutes to Build Your First Reporting Services

Title: Model-Driven Database Design

Title: Discovering the Plan Cache

Title: Parallel Query Execution Deep Dive

Title: Virtualizing Business Critical SQL Servers

Title: Extended Events, Work Smarter Not Harder

Title: Database Health and Performance

Title: Reporting Services tips for the Stephen Few fan

Title: Database Design Throwdown

Title: Maintain Your DBs with Help from Ola Hallengren

Title: SQL Azure Data Sync and What’s New

Title: 2012 TSQL Sweets

Title: SQL Azure Intro and What’s New

Title: Introduction to Execution Plans

Title: Introduction to Data Quality Services

Title: Choose Your Own Adventure: Performance Tuning

Title: SSRS: Reporting on Reports

Speakers

Sponsors