SQLSaturday #53 - Kansas City 2010

Event Date: 10/02/2010 00:00:00

Event Location:

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

PDF of Schedule

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

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


Sessions

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


Title: Essentials of a Business Intelligence Architecture

Abstract: SQL Server allows you to construct an analytic organization by creating a bona fide Business Intelligence foundation, giving you more insight into the status of the business, powerful ad-hoc reporting capabilities, dynamic analytical capabilities, and forecasts that make your psychic jealous. It’s an understatement to say this requires really good data and terrific data structures. In this session, Carlos Bossy will discuss how to use SSIS to implement integration, metadata and transformations, SSAS for ad-hoc and predictive analytics, and SSRS to provide users the ability to develop their own reports. You will leave this session with a firm grasp to building a robust data architecture that achieves successful Business Intelligence.

Speaker(s):

  • Carlos Bossy

Track and Room: Bonus - N/A


Title: SQL Server Security - All Things Considered

Abstract: Join me for a discussion of security risks in SQL Server and the tools and processes we have to mitigate those risks. The relationship of security to authentication, encryption, SQL Injection, SQL Browser, backups, auditing, compliance, data access layers, and more will be covered in brief. Attendees will leave this session knowing the pros and cons of different logon methods, and hopefully new techniques to reduce the attack surface of the SQL Servers they manage.

Speaker(s):

  • Rob Kraft

Track and Room: DBA 101 - N/A


Title: Partition management in Analysis Services

Abstract: This session will demonstrate a basic framework using SQL Server, SSIS and AMO to help manage your Analysis Services partitions. During this session we will show you how to automate the creation, processing and even deleting of your partitions all based on a simple metadata table stored in SQL Server.

Speaker(s):

  • Frank Kearney

Track and Room: BI - N/A


Title: Reporting against data other than databases

Abstract: Reporting against non-traditional data: CPU usage, IIS, web site activity, Active Directory, file stores, data warehouses, machine specification and others if there is time.

Speaker(s):

  • Dennis Graham

Track and Room: Bonus - N/A


Title: Going Spatial!

Abstract: Spatial data is being pushed more and more into the forefront of our application universe. With the advent of MapPoint and Google Maps companies are consistently pushing the boundaries of what traditional databases can do. Now with SQL Server 2008 we have built in spatial data types that will make your life a little easier in the days to come. This session will focus on utilizing these native types to store, analyze, and retrieve spatial data as well as tools such as SSRS’s integrating geospatial mapping to make you the company geospatial hero. Geospatial awesomeness fro everyone!

Speaker(s):

  • Arie Jones

Track and Room: Developer - N/A


Title: SQL Server 2008 R2 Parallel Data Warehouse

Abstract: We will cover an overview of the functionality of SQL PDW

Speaker(s):

  • Brian Mitchell

Track and Room: Special Topic - N/A


Title: Managing a 0 Downtime Shop

Abstract: Data is becoming more and more critical with the needs of business every day. Technology has enabled businesses to have a global reach much easier than ever before. With the growing needs to increase revenue every avenue will be explored. The outcome of this growth is the need for your database to be online with no downtime if any at all. This session is designed to visit the issues of managing a database that is online around the clock and maintenance time is scarce. We will talk about the challenges you could face each and every day, the maintenance issues such as when, where and how to trim it.

Speaker(s):

  • Chris Shaw

Track and Room: DBA Beyond 101 - N/A


Title: Incremental ETL Processes with SSIS

Abstract: Do you truncate and load your data every time you run your ETL processes? Do you want better performance out of your ETL processes? If you answered yes to either of those questions, this is your session. We’ll be discussing some of the evils and gotchas of the “trunc and load” ETL process, why incremental ETL processes are better overall, and we’ll take a look at several different implementations of incremental ETL processes using SSIS both from a data quality and a performance perspective.

Speaker(s):

  • Brett Flippin

Track and Room: BI - N/A


Title: SQL Server and SANs

Abstract: Lets dig into both the fundamentals as well as some details of how SANs work and how we can best utilize them to improve SQL Server’s IO performance and reliability.

Speaker(s):

  • Kevin Boles

Track and Room: Bonus - N/A


Title: What Are You Waiting For?

Abstract: It’s a simple question, right? But how often do you have the answer, especially for your SQL statements? Thomas LaRock from Confio Software will teach you how proper response time analysis plays a key part in the overall performance tuning process. You will learn how to define, measure, and analyze performance issues as well as implementing changes and how to make sure those changes continue to have the desired effects.

Speaker(s):

  • Thomas LaRock

Track and Room: DBA Beyond 101 - N/A


Title: Strategies for Maximum Concurrency and Performance

Abstract: This session discusses in depth the concurrency model in SQL Server and how concurrency issues can cause performance related problems. I will discuss and demo the concurrency models in SQL Server, the concurrency challenges and Lock Escalation issues and how to diagnose, troubleshoot and remedy those, leading to much better scalability and performance.

Speaker(s):

  • Sudhir Gajre

Track and Room: DBA Beyond 101 - N/A


Title: SQL Server in Healthcare - Healthy Relationship?

Abstract: This session discusses the challenges and opportunities for DBAs supporting SQL in the IT Healthcare environment

Speaker(s):

  • Scott Shaw

Track and Room: Special Topic - N/A


Title: Start Using MDX with SSAS 2008

Abstract: MDX is difficult to learn for many reasons. One reasons is that most training starts with SELECT queries without adequately developing a fundamental understanding of the coordinate system being used. Learners are left to fill in the blank in a way that is not comprehensive, consistant or comfortable. This presentation will give beginners (and those beyond) a more comfortable grasp of how to write queries.

Speaker(s):

  • Joe Ferry

Track and Room: BI - N/A


Title: Stored procedure tracing using the xml datatype

Abstract: When running a stored procedure it is difficult to record what is happening. In this session we will develop logger code in T-SQL to add to your stored procedures. We will use the xml datatype to record parameter values, variable values and debug statements. We will look at the “For xml” statement as well as the xml datatype methods. Finally we will look at how to read the logs when finished.

Speaker(s):

  • Russel Loski

Track and Room: Developer - N/A


Title: Take Control with Resource Governor

Abstract: A large majority of a modern DBA’s workload consists of managing the resources on their systems in order to ensure that they are being followed and resources are accessible when needed. SQL Server 2008 provides Resource Governor, which allows the DBA to discretely manage system resources in a very structured or not so structured way(Its your choice!). In this session, we will show you how to configure, monitor, and administer these features to help lower your anxiety levels while increasing your system’s availability.

Speaker(s):

  • Arie Jones

Track and Room: DBA Beyond 101 - N/A


Title: Advanced TSQL Solutions

Abstract: The range of real-world queries that can be performed using set-based TSQL solutions is astounding, but many of these are not well known and if you haven’t been shown the light you might never realize what is possible. Come and join me as we delve into the inner recesses and corners of the TSQL envelope using a wide variety of expressions, clauses and techniques.

Speaker(s):

  • Kevin Boles

Track and Room: Developer - N/A


Title: SharePoint SQL Server - Marriage made in heaven

Abstract: The new release of SharePoint 2010 is a giant leap forward and has addressed several scalabilty issues in earlier versions of the product. Come and learn how SharePoint leverages SQL Server and enhancements made to SQL Server which made SharePoint a tremendous value proposition. Topics discussed will include High level overview of SharePoint capabilities, role of SQL Server, database overview, differences between SharePoint list and SQL Server tables and much much more… Don’t miss it!!!

Speaker(s):

  • Sandeep Khandelwal

Track and Room: DBA 101 - N/A


Title: CLR in SQL Server: A love story in 5 parts

Abstract: This session will provide an overview of the five SQL CLR objects available for SQL Server 2005-2008 and demonstrate how to create, deploy and use these objects for fun and profit.

Speaker(s):

  • Bill Fellows

Track and Room: Developer - N/A


Title: Introduction to Analysis Services

Abstract: By now you have probably already heard about Analysis Services. Maybe you’ve even said to yourself that you were going to learn more about it but just haven’t found the time. The biggest barrier to learning something new is figuring out the first few steps. But where do you begin? Come learn those first few steps by attending this presentation. We will discuss what Analysis Services is, where it shines and more importantly, how to get started.

Speaker(s):

  • Marc Beacom

Track and Room: BI - N/A


Title: Transactional Replication 101

Abstract: Replication simplified! Learn the basic parts that make up replication, what tools are included to help you along plus a look into monitoring.

We will cover the players in the game: Pubishers, Subscribers and Distributors, then delve into the data delivery process with Publications, Subscriptions and Articles, finishing up with the Log Reader and how to make sure everything is working and running smoothly.

Speaker(s):

  • Wendy Pastrick

Track and Room: DBA 101 - N/A


Title: Open Networking

Abstract: Brain full? Take this time to meet with fellow professionals, swap war stories, praise or slam features and trade tips. Come and go as you please

Speaker(s):

  • Bill Fellows

Track and Room: Professional Development - N/A


Title: Integrate LOB SQL Data into my portal

Abstract: Ok so you have created a Portal. Now you are ready to get your LOB data into the portal. Not sure how???? This session explains how you can integrate your external SQL data into your SharePoint portal

Speaker(s):

  • Ameet Phadnis

Track and Room: Special Topic - N/A


Title: The Benefits of SQL Azure

Abstract: This talk will focus on the benefits, features, and ease of use of SQL Azure. Learn how your projects can benefit from a hosted data storage and query processing service. See by example how to design your program to use SQL Azure. Real world topics and use cases will be covered including data sync and staying vendor independent while hosting your data in the cloud.

Speaker(s):

  • Aaron King

Track and Room: Special Topic - N/A


Title: Report Model a solution for ad-hoc reporting

Abstract: Non technical data consumers usually require and request results of ad hoc queries against enterprise databases. Let’s look at how report model can be a solution to providing ad hoc reporting while giving the non technical user the ability to use this model and create their ad hoc reports.

Speaker(s):

  • Kushal Lal

Track and Room: BI - N/A


Title: SQL Server Administration for new DBAs and non-DBA

Abstract: This session walks through a SQL Server installation, the post setup configuration, a basic security review, configuring a maintenance plan and basic performance monitoring. All with no PowerPoint slides. Instead we’ll walk through our SQL Server setup and configuration checklist and demonstrate everything we talk about. This session is great for new database administrators or part-time DBAs or anyone looking for a refresher. Experienced DBA’s will learn something too! You’ll get a copy of the checklist during the session and you’ll get a link to download a copy for later.

Speaker(s):

  • Bill Graziano

Track and Room: DBA 101 - N/A


Title: Open Networking

Abstract: Brain full? Take this time to meet with fellow professionals, swap war stories, praise or slam features and trade tips. Come and go as you please

Speaker(s):

  • Bill Fellows

Track and Room: Professional Development - N/A


Title: Unleashing PowerShell to you SQL Environment.

Abstract: PowerShell is becoming the breath taking tool that helps unlock different Microsoft environments. Most people’s question is where do I start? In this session we will look into what PowerShell is, why it’s becoming a must have tool, what language it uses and how to do the real world stuff with it in your SQL environment.

Speaker(s):

  • Leonard Mwangi

Track and Room: DBA Beyond 101 - N/A


Title: Women in Technology Panel Discussion

Abstract: Interest in technology is decreasing among young people, yet technology is becoming ever more important in our world. How can we inspire the next generation to embrace science, engineering, and technology? Join SQL Server professionals Wendy Pastrick, Kim Tesereau, and Michelle Ufford as they discuss ways that we can encourage our kids to consider technology careers.

Speaker(s):

  • Kathi Kellenberger

Track and Room: Professional Development - N/A


Title: Data Mining with Analysis Services

Abstract: Modern day computing power and 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. 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 web application that seamlessly uses a mining model. Take a step forward towards making BI pervasive in your organization by integrating data mining into your company’s applications…and learn how to win your fantasy football league and beat the stock market too!

Speaker(s):

  • Carlos Bossy

Track and Room: BI - N/A


Title: Advanced topics in SSRS:

Abstract: Advanced topics in SSRS: Manage reporting, delivery options, control report execution, security, and deployment, email, and data driven headers, reporting from data warehouses, and overcoming Excels 65K wall.

Speaker(s):

  • Dennis Graham

Track and Room: Bonus - N/A


Title: Be in control - Policy Based Management

Abstract: Getting a bit weary of developers or DBA’s that cannot seem to follow well documented policies for naming conventions or server settings? Would you like to define these policies in a manner that allows SQL Server to ENFORCE them for you or, at the very least, monitor them? Policy-based management provides the ability to define policies that apply to servers, databases and other objects in your data environment. Well-defined policies can help you to control and manage change proactively.

Speaker(s):

  • Peter Trast

Track and Room: DBA 101 - N/A


Title: Database Design Contentious Issues

Abstract: A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as:

    * Implementing Party/party role
    * Natural vs. Surrogate keys
    * Today's vs. Tomorrow's Requirements
    *  SOAs, Ontologies, ESBs, New TLAs and Shoe Strings
    * What is Logical? What is Physical? Why Do We Care?
    * Who Calls the Shots and Who Does What?

…and others. Bring your votes, your debates, and your opinions.

Speaker(s):

  • Karen Lopez

Track and Room: Special Topic - N/A


Title: Common TSQL Programming Mistakes

Abstract: We are going to examine a variety of oopsies MANY developers fall prey to - some obvious, some fairly subtle and some down right sneaky! Lots of code examples with the bad AND good code presented.

Speaker(s):

  • Kevin Boles

Track and Room: Developer - N/A


Title: The Modern Resume: Building Your Brand

Abstract: Steve Jones, founder of SQL Server Central talks about how to update your resume to fit into today’s modern world, and take advantage of the tools offered by blogging, social networking, and more.

Speaker(s):

  • Steve Jones

Track and Room: Professional Development - N/A


Title: Open Networking

Abstract: Brain full? Take this time to meet with fellow professionals, swap war stories, praise or slam features and trade tips. Come and go as you please

Speaker(s):

  • Bill Fellows

Track and Room: Professional Development - N/A


Title: Database Mirroring

Abstract: Do you need a database available all the time? Then you need database mirroring. You can failover to the destination and back to the source at any time. If the source server crashed you can run a quick command on the destination server and you are back in business. You will become an expert in no time.

Speaker(s):

  • Jeff Hattendorf

Track and Room: DBA Beyond 101 - N/A


Title: What’s New with Reporting Services?

Abstract: Reporting Services has undergone many changes with the 2008 and 2008 R2 releases. Learn how to take advantage of these new features: a much better Report Builder, enhanced performance, cool new visual components, reusable report parts and more!

Speaker(s):

  • Kathi Kellenberger

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

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

Jeff Hattendorf

Jeff has been an Enterprise Network/Systems Architect and Engineer for over 12 year. He has worked on some of the biggest networks in Kansas and currently Manages and supports a Mission Critical 24x7x365 railroad transportation company across multiple data centers.

Dennis Graham

Dennis Graham has been working with SQL server since 1992 and working in SSRS since 2002. As an Oakwood consultant, he has built applications for investment firms, medical groups, insurance entities, and manufacturing, he is now in the Managed Services Group using SCOM to monitor SQL Server. He also has 16 years as a trainer.

Russel Loski

Twitter: - sqlmovers

LinkedIn: Russel Loski

Contact: http://www.sqlmovers.com

Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.

Ameet Phadnis

Contact: http://aaphadnis.spaces.live.com

Ameet Phadnis has over 14 years of IT industry experience in Microsoft technologies. Ameet is the president of e Tek Global a Microsoft Gold Partner. He concentrates mainly in Data Mangement Solutions and SharePoint Solutions. Ameet has worked with SQL for over 10 years and with SharePoint for over 5 years starting with SharePoint 2003. He has presented at SharePoint Connections and SharePoint Users Group in Kansas City. Ameet has written articles for SQL Server Central and ASPAlliance.

Leonard Mwangi

Twitter: - @lmundia

Contact: http://lmundia.com

Leonard Mwangi is a principal consultant with Armely concentrating mostly on Information Worker Solutions and applications Integration. Leonard has over 13 years of experience in IT Industry and has been working with SQL Server since SQL 7.0 and SharePoint since SPS days with end-to-end client solutions. Leonard is also a regular contributor for MS forums and a presenter at different Special Interest Groups regarding SQL Server and SharePoint

Frank Kearney

Contact: http://fkearney.spaces.live.com/default.aspx

Frank Kearney has been working in the IT world for the past 13 years and has experience across many verticals including HealthCare, Telecommunications and Wholesale Distributors. He is currently a Senior Business Intelligence developer for Aspect UC responsible for designing and delivering BI solutions using the Microsoft BI Stack.

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.

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.

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.

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!”

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.

Brian Mitchell

Twitter: - @brianwmitchell

LinkedIn: Brian Mitchell

Contact: http://brianwmitchell.com

Brian Mitchell, an MCM - SQL 2008 with a MBA from the University of Florida, is a Senior Consultant in the Microsoft Big Data Center of Expertise, where he focuses on SQL Server Parallel Data Warehouse, HDInsight, and Microsoft Business Intelligence. Brian has spent countless hours onsite at customer sites delivering Microsoft database and BI solutions. He has extensive experience creating and delivering advanced training for the full range of the Microsoft BI stack, with a particular passion for Analysis Services and Reporting Services.

Brian has presented at TechEd, PASS Summit, SQLRally, and several SQLSaturdays and SQL Server user groups. You can read more about his deep involvement in Microsoft data technologies at http://brianwmitchell.com.

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.

Carlos Bossy

Twitter: - @carlosbossy

LinkedIn: Carlos Bossy

Contact: http://www.carlosbossy.com

Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.

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.

Scott Shaw

Contact: http://www.blogofshaw.blogspot.com

Scott Shaw has been an IT professional since the late 90’s. He is currently employed by Mercy Technology Services in Saint Louis, MO as the Lead SQL Server DBA. Scott has presented at SQLSaturday as well as the first SQLRally in Orlando, FL. He currently is working with Kathi Kellenberger (@auntkathi) to revise the book Beginning T-SQL 2008 from Apress Publishing for SQL 2012.

Marc Beacom

Twitter: - http://www.twitter.com/MarcBeacom

LinkedIn: Marc Beacom

Contact: http://www.DawaBI.com/blog.aspx

Marc Beacom is Principal Architect of DawaBI, a Data Warehouse and Business Intelligence Consultancy firm focusing on Making Data-Driven Decisions Possible. He has been working with SQL Server for over a decade delivering scalable solutions for organizations of all sizes. . Marc is an active member of the community and has served 5 years on the board of two Colorado SQL Server UGs, 1 year as a Regional Mentor for PASS. Currently he is on the boards of CO GiveCamp and Camp To Belong CO.

Kathi Kellenberger

Contact: http://www.sqlservercentral.com/blogs/kathi_kellenberger/default.aspx

Kathi Kellenberger is a Data Technology Specialist with Microsoft in St. Louis, MO. Before joining Microsoft in 2010, she was a DBA and a SQL Server MVP. Kathi is author of “Beginning T-SQL 2008” and co-author of “Professional SQL Server 2005 Integration Services” and “SQL Server MVP Deep Dives.” In her spare time, Kathi enjoys singing (she is the original #sqlkaroke), cycling, playing with her 5 year old grandson, and climbing the stairs in very tall buildings.

Peter Trast

Peter has been an IT professional for 15 years. He worked his way from desktop and server support up to systems administration and engineering for the Navy-Marine Corps Intranet Project and for private clients, then delivered Windows services and SQL Server classes for Centriq Training in Leawood, Kansas, and is now a Microsoft Design Architect specializing in SQL Server design with Alexander Open Systems in Overland Park, Kansas.

He likes all music styles, heavy doses of science fiction and building expensive treehouses for his 9 children in Kansas City, Missouri, and does NOT, in fact, look like Mr. Clean.

Rob Kraft

Twitter: - @robkraft

LinkedIn: Rob Kraft

Contact: http://csharpdeveloper.wordpress.com

Rob Kraft is an independent software architect, project manager, and developer from Lee#39;s Summit, MO. He was a certified trainer on SQL Server and co-authored a few books about SQL Server and network security. He has been a full or part-time SQL Server DBA since version 4.2. He runs www.KansasCityUserGroups.com and he blogs occasionally at http://csharpdeveloper.wordpress.com/.

Kathi Kellenberger

Contact: http://www.sqlservercentral.com/blogs/kathi_kellenberger/default.aspx

Kathi Kellenberger is a Data Technology Specialist with Microsoft in St. Louis, MO. Before joining Microsoft in 2010, she was a DBA and a SQL Server MVP. Kathi is author of “Beginning T-SQL 2008” and co-author of “Professional SQL Server 2005 Integration Services” and “SQL Server MVP Deep Dives.” In her spare time, Kathi enjoys singing (she is the original #sqlkaroke), cycling, playing with her 5 year old grandson, and climbing the stairs in very tall buildings.

Bill Graziano

Contact: http://scalsql.com/

Bill Graziano is a SQL Server consultant specializing in high-throughput transaction environments using SQL Server. He spends his days counting the milliseconds behind credit card swipes. Bill is the former President of PASS and runs a web site for SQL Server developers and administrators at SQLTeam.com.

Carlos Bossy

Twitter: - @carlosbossy

LinkedIn: Carlos Bossy

Contact: http://www.carlosbossy.com

Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.

Sandeep Khandelwal

Contact: http://www.IntegrationNow.com

Sandeep has been working with SharePoint since early days of STS. He specializes in implementing medium to large scale SharePoint farm, creating custom solutions using InfoPath form Workflow, building BI dashboards using PerformancePoint Excel Services, integrating LOB applications with SharePoint and migrating Lotus Notes databases to SharePoint. Also, whenever time permits, Sandeep presents at SharePoint conferences and local SharePoint users group.

Dennis Graham

Dennis Graham has been working with SQL server since 1992 and working in SSRS since 2002. As an Oakwood consultant, he has built applications for investment firms, medical groups, insurance entities, and manufacturing, he is now in the Managed Services Group using SCOM to monitor SQL Server. He also has 16 years as a trainer.

Aaron King

Twitter: - trendoid

LinkedIn: Aaron King

Contact: http://www.aaronstanleyking.com

Aaron King is a application architect specializing in enterprise web applications and very large databases.

Arie Jones

Contact: http://www.programmersedge.com

Arie Jones ‘AJ’ is the Principal Technology Manager for Perpetual Technologies, Inc. in Indianapolis, IN. Arie leads PTI’s team of expert consultants in planning, design, development, deployment, and management of database environments and applications to achieve the best combination of tools and services for each client. Additionally, AJ is a community speaker, has written several books such as “Learn SQL in 24 Hours”, and blogs extensively at http://www.programmersedge.com

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.

Kushal Lal

Contact: http://www.hconn.com

Kushal is a MCTS in SQL Server 2008 BI and Dev. He is currently working for HCONN a Microsoft Gold Certified Partner as their designated BI Specialist and SharePoint Consultant. His roles include designing and implementing BI Solution either as a standalone solution or over the SharePoint Platform. He has extensive hands on experience working with Microsoft BI technologies over the past five years and has moderated on behalf of Microsoft at the Microsoft’s Kansas City BI Round Table event.

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.

Sudhir Gajre

Twitter: - @SudhirGajre

LinkedIn: Sudhir Gajre

Contact: http://www.dbbest.com/blog/author/sudhir/

Sudhir has over 20 years of experience in the Data Management and the Analytics field. He spent the last 14 years at Microsoft where he was a Data Architect and later a Principal Technologist. He has authored SQL Server performance tuning whitepapers, designed VLDB and Highly Scalable SQL Server Architectures, and led technical teams. He is a frequent speaker at conferences and SQLSaturdays and is a recognized expert in the Data Management field. He is a Director with DB Best Technologies.

Wendy Pastrick

Twitter: - @wendy_dance

Contact: http://wendyverse.blogspot.com

Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.

Brett Flippin

Contact: http://brettflippin.com

Brett has worked in many facets of IT and finally settled into database work specializing in delivering business intelligence and ETL processes. His experience ranges from system administration to DBA and BI work with SQL Server 2000 to SQL Server 2008. He’s currently the Data Warehouse and Business Intelligence developer at Children International.

Arie Jones

Contact: http://www.programmersedge.com

Arie Jones ‘AJ’ is the Principal Technology Manager for Perpetual Technologies, Inc. in Indianapolis, IN. Arie leads PTI’s team of expert consultants in planning, design, development, deployment, and management of database environments and applications to achieve the best combination of tools and services for each client. Additionally, AJ is a community speaker, has written several books such as “Learn SQL in 24 Hours”, and blogs extensively at http://www.programmersedge.com

Joe Ferry

I have been a Microsoft Premier Field Engineer for four years, assisting customers with SQL Server Analysis Services, SQL Server Integration Services and the SQL Server Relational Engine. I don’t have to find myself to be the smartest guy in the room to be helpful because I have seen more environments and issues than most dbas and can share my experiences that help others to focus in on what is important rather than what is more likely to be of academic interest.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page