SQLSaturday #63 - Dallas 2011

Event Date: 04/02/2011 00:00:00

Event Location:

  • Region 10 Education Service Center
  • 400 E. Spring Valley Rd
  • Richardson, Texas

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: Introducing Microsoft’s EDIM Products

Abstract: Starting in the SQL Server Denali release, data takes on a new life in the business intelligence world. Often forgotten, data management needs to be an integral part of your reporting systems. Learn how Microsoft has made your life easier by incorporating external parameters, environments, and groupings into Integration Services. They have also included impact analysis and data lineage, which can be tied to tables and SSIS packages. Two additional newcomer products, data quality services and master data services, complete the quartet. This session will use the first Community Technical Preview of SQL Server Denali to describe and demonstrate the enhancements to the four products that make up EDIM.

Speaker(s):

  • Jessica Moss

Track and Room: Futures - N/A


Title: ORM’s and the ugly truth

Abstract: In this session, we are going to take a surgical approach to why I as a DBA fear ugly ORM’s. Even though you can use views and stored procs as plastic surgery for an ugly case of ORM, there is only so much you can do if it is ugly on the inside. Slides generally bore me, so we will only be looking at a couple before we put on our scrubs and hit the OR(M) to perform an uglyectomy to create an ORM we can live with.

Technologies: I’ll be using Entity Framework 4, Linq, MVC2 and a variety of virtual surgical tools. I ranked this session as beginner with regards to the topic of ORM’s. My session makes assumptions you know about execution plans, traces, the optimizer and other non-beginner topics in SQL Server.

Speaker(s):

  • Rob Sullivan

Track and Room: Developer - N/A


Title: Troubleshooting Database availability and recovery

Abstract: Troubleshooting Database availability and recovery problems: Do you want to become proficient in troubleshooting some of the common database availability problems? Do you want to know what are the common causes of these problems? Do you want to understand some of the internals of how SQL Server generates these errors? Come and listen to this talk from Microsoft CSS team on how they troubleshoot and resolve these problems first hand. You can also learn about all the tools you need to keep ready when you need to use them for a disaster recovery situation. We will also cover best practices to avoid encountering these type of situations.

Speaker(s):

  • Suresh Kandoth

Track and Room: Advanced - 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, especially the modify method. Finally we will look at how to read the logs when finished.

Speaker(s):

  • Russel Loski

Track and Room: Developer - N/A


Title: Parallel Data Warehouse - Architecture Overview

Abstract: In Nov.2010, Microsoft officially released SQL Server 2008 R2 PDW Edition. Parallel Data Warehouse is a true MPP (massive parallel processing) platform featuring an ultra shared nothing architecture. PDW is capable of delivering very fast query performance and can house up to 500 TB of data. This session will overview both the HW and SW architecture of the PDW appliance. It will explain how Microsoft and HP have engineered a solution using commodity HW and SW that can compete with more expensive platforms like TeraData and ExaData. Additionally, SQL DBAs will see where their current skillset is applicable to managing a PDW appliance.

Speaker(s):

  • Ted Tasker

Track and Room: Futures - N/A


Title: SSRS data driven subscription using SSIS

Abstract: SQL Server Reporting Services provides a powerful tool to render report based on information in a database table. But in order to use this feature, you are required to purchase an Enterprise license of SQL Server. In this session, we will create an SSIS package that renders reports based on the results of a query.

Speaker(s):

  • Russel Loski

Track and Room: BI - N/A


Title: T-SQL Programming to Survive a Zombie Database

Abstract: Do you have a Zombie Database? Does your database suffer from roaming hordes of problems like the lack of primary and foreign keys, poor normalization, in place updates and deletes, and an insatiable drive to eat your braaaaaaaaaaaaaains (CPU cycles).

Fear not fellow survivor for in this session, I’ll show you how to fortify your code against zombie infestation. How to deal with the unknown (nulls), how to Restore Order by Joining together in Groups. Flak Jackets are Optional.

Speaker(s):

  • David Stein

Track and Room: Developer - N/A


Title: An Introduction to Profiler and SQL Trace

Abstract: Profiler (and its underlying subsystem, SQL Trace) is a tool for recording a SQL Server instance’s activity. This diagnostic and performance data is valuable for troubleshooting and characterizing a system’s workload. Like any powerful tool, misuse can be quite harmful, so great care must be exercised. This session will teach you how to efficiently configure, run, and analyze the data from traces, while minimizing the overhead of the data collection and avoiding common pitfalls.

Speaker(s):

  • Trevor Barkhouse

Track and Room: Beginner - N/A


Title: Analysis Services Security

Abstract: The purpose of this session is to review Analysis Service’s security model and explore ways it can be effectively used to deliver complex security requirements. Topics to be addressed include administrative security, dimension data security, cell-data security, and even dynamic security techniques.

Speaker(s):

  • Bryan Smith

Track and Room: Advanced - N/A


Title: An Intro to Replication Meta-Data

Abstract: We will cover some basics about setting up simple replication tests and dive into what happens to the underlying meta-data when changes are replicated. A good opporunity to see a demonstration style explanation of what goes on ‘under the hood’ during replication. Scripts will be provided.

Speaker(s):

  • Jonathan Clark

Track and Room: Advanced - N/A


Title: Building a Professional Development Plan

Abstract: A good professional development plan has to go far beyond ‘learning more technology’, it has to encompass the wide variety of skills you need to build the next step in your career, and it has to include a variety of learning methods. We’ll discuss how much time and money you should budget when building your plan, and how the distribution of time and money changes as your career evolves. We’ll look at the growth phases you’ll encounter, learning how you learn best, how to keep up with new technology without burning out, and even how things like blogging and Twitter can be an interesting part of your plan.

Speaker(s):

  • Andy Warren

Track and Room: Professional Development - N/A


Title: Mirroring: The Bear Necessities

Abstract: Mirroring can be an integral part of your high availability and disaster recovery planning. We’ll cover what mirroring is, how it can fit into an HA/DR plan, the rules surrounding its use, configuration via the GUI and T-SQL, as well as how to monitor mirroring. This presentation is designed to not only give you an overview of mirroring, but to also walk you through a basic implementation. At the end you will have learned what mirroring is, how it can fit into your environment, what business requirements it solves, and how to configure it.

Speaker(s):

  • Ryan Adams

Track and Room: Administrator - N/A


Title: Orientation: What is SQL Server,and what’s it for?

Abstract: What is SQL Server? It’s just software. What is SQL Server for? At its simplest, it lets you store data safely, and get it back out again. Is there a right way to say “SQL”? Yes, actually! In this session we will work with the tools to show you around SQL Server, and explore what it can do. If you’re looking to get into databases, this is your session.

Speaker(s):

  • Jennifer McCown

Track and Room: Beginner - N/A


Title: The Modern Resume - Building Your Brand

Abstract: Learn practical ways in this session that you can use to build your career brand and stand out from the crowd. Steve Jones, editor of SQLServerCentral, shares some of the ways in which he has successfully grown his career over the years. Steve will present tips and tricks for using social networking sites, blogging, volunteering, leadership, and more to your advantage. He also has a few resume hints to help you find a great job that fits you.

Speaker(s):

  • Steve Jones

Track and Room: Professional Development - N/A


Title: Dimensional design 101

Abstract: In this session we’ll cover all the pieces of a classic Kimball style data mart (Star schema, fact tables, dimension tables). We’ll talk about the data warehouse bus architecture and how it can be used to quickly create data marts with conformed dimensions. We’ll talk about what it means to have conformed dimensions and why it’s important.

Speaker(s):

  • Tim Costello

Track and Room: Beginner - N/A


Title: How to Master SQL Joins

Abstract: Quick - what’s the difference between LEFT and RIGHT OUTER JOINs? How do you know that a NULL in your result set is from the table data or is the result of the join? If you’ve ever struggled with the ins and outs of joins and join syntax then this presentation is perfect for you. This presentation presents a straight-forward and logical approach to understanding and visualizing joins and focuses heavily on the “how” and “why” of the various join types.

Speaker(s):

  • Scott Whigham

Track and Room: Developer - N/A


Title: Tableau: Delivering Self-Serve BI

Abstract: rapid-fire visual analysis. ad hoc query capability. easy interactive dashboard building. No, this insn’t going to be an hour of buzzword bingo. This time we will actually deliver on the promise of self service BI. Using SQL in conjunction with a visual analysis tool like Tableau we can help our users find the questions they didn’t know they wanted to answer. This session will be demo heavy and will highlight best practices in data visualization and dashboard design.

Speaker(s):

  • Tim Costello

Track and Room: Advanced - N/A


Title: SQL Server FastTrack Data Warehouse

Abstract: An overview of the FastTrack Data Warehouse Architecture. Learn about the storage design for FastTrack, and data loading an and operational requirements for a FastTrack implementation. When to use FastTrack vs custom storage designs vs Enterprise shared storage for SQL Server Data Warehouse and VLDB applications.

Speaker(s):

  • David Browne

Track and Room: Futures - N/A


Title: Adding SSRS Report Bells and Whistles

Abstract: Producing a good looking report will wow your business users even if your data isn’t all that impressive. If you’ve ever had trouble finding the best way to display that data or how to show trends appropriately, this is the session for you. We will review grouping logic, graphs, gauges, and more in Reporting Services 2008 R2. With the knowledge in this session, you won’t ever need to show a plain, boring report again!

Speaker(s):

  • Jessica Moss

Track and Room: BI - N/A


Title: SQL Server Denali High Availability

Abstract: Please attend to learn and understand next generation high availability and disaster recovery solution architectures from SQL Server. How it will help you in meeting the ever increasing goals to reduce Recovery Point and Recovery Time Options (RPO and RTO) while potentially reducing TCO. To fully benefit from this session it is assumed that you have a basic understanding of the current SQL Server HA/DR functionality.

Speaker(s):

  • Prem Mehra

Track and Room: Futures - N/A


Title: Data Mining in Action: A case study

Abstract: This session will introduce techniques of integrating algorithm output with production data. Example code and lab will use data sets beyond Adventureworks.Topics include: Applying multiple models Developing a scorecarding system Assessing the most effective model Track population stability and algorithm performance over time.

Speaker(s):

  • Drew Minkin

Track and Room: BI - N/A


Title: Introduction to SQL CLR

Abstract: Learn how, when and why you may want to incorporate CLR functionality into the database.

Speaker(s):

  • Paul Hunter

Track and Room: Developer - N/A


Title: Work past the SQL Connectivity Issues

Abstract: We will cover some basic and common scenarios of SQL Connectivity issues and how to MS Support troubleshoots and resolves the same

Speaker(s):

  • Aparna Vishwamitra

Track and Room: Administrator - N/A


Title: Parallel Query Execution

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: Developer - N/A


Title: SQL Server Tips and Tricks

Abstract: Learn tips and tricks to make more effective use of SSMS. Use portable applications to get your work done without installing applications on a server. Use free tools to simplify your life.

Speaker(s):

  • John Cook

Track and Room: Beginner - N/A


Title: Self-Service BI with PowerPivot

Abstract: In this session you’ll learn how to use PowerPivot to create self-service BI in your organization. We will learn how to combinie data from heterogenous data sources and then create reports/dashboardsfor end users to consume and collboarate in SharePoint 2010. We will also cover when you should use PowerPivot in comparison with SQl Server Analysis Services (OLAP) so you are equiped to create robust Self Service BI applications in your organization.

Speaker(s):

  • Anand Pandya

Track and Room: BI - N/A


Title: The BI DBA

Abstract: In this session, you will learn the differences between administering a data warehouse database, or a reporting database, versus a database meant for OLTP operations. This session will cover the basic administration tasks and how they can be different for DBAs working with data warehouse/reporting databases.

Speaker(s):

  • Randy Dyess

Track and Room: Advanced - N/A


Title: HELP! I need somebody, HELP me Please!

Abstract: There are times as a DBA that you need help from other DBA’s, especially if you’re the only DBA around. We will talk about the various ways of getting help (Twitter, SQL Server Central, StackOverflow). We will talk about how to ask for help (and the ways not to).

Speaker(s):

  • David Smithey

Track and Room: Professional Development - N/A


Title: Solid State Storage Deep Dive

Abstract: If you have ever wanted to know how SSD’s and Flash memory works this talk is for you. We will cover the fundamentals of Flash in detail. I will also highlight some of the specific vendor implementations and what makes a particular SSD “enterprise ready” vs “Consumer grade”. We will also cover SQL Server usage patterns what is a good fit for SSD’s and when it may be better to go with hard disks. Solid State Storage isn’t a cure-all for every situation, this presentation will give you the tools you need to make the right choice for your SQL Server environment.

Speaker(s):

  • Wesley Brown

Track and Room: Administrator - N/A


Title: Turbo charge your DBA career

Abstract: You have been a DBA for so many years and struggle to decide on what next. Attend this session and find ways to rejuvenate your career to the next step.

Speaker(s):

  • Sri Sridharan

Track and Room: Professional Development - N/A


Title: What is this cache and why is it so big?

Abstract: Ever wonder what’s in your SQL Plan cache? Wonder why or how it got so big? This session will cover what it is, how it’s used, how it can affect performance and how poor application and query design can make it worse. Rather than put participants to sleep with a slide deck we will get down and dirty with lots of demos.

Speaker(s):

  • Douglas Brendle

Track and Room: Advanced - N/A


Title: Whats new in SQL Server Denali

Abstract: SQL Server Denali is the code name for the next major release of SQL Server. This session wil cover the investments in this release specifically focusing on the following areas:

SQL Server AlwaysOn, Column-based Query Accelerator, Unified developer experience, Expanded BI with project crescent and enterprise information management

Speaker(s):

  • Sriram Ganapathy

Track and Room: Futures - N/A


Title: So What Can I Do With PowerShell?

Abstract: Want to automatically store your database schema in a version control system (VCS)? Want to make changes across your database or server with less labor? Want to compress your backups using 7zip and PowerShell. Figure out memory allocation on an active/active cluster? How about download many files in the background? Come learn what is possible with PowerShell.

Speaker(s):

  • Eric Humphrey

Track and Room: Beginner - N/A


Title: SANs and SQL Server

Abstract: Simple title says it all. Lets get down and dirty on some fundamentals and then numerous details of how SANs work and how we can best utilize and tune them to improve SQL Server’s IO performance and reliability.

Speaker(s):

  • Kevin Boles

Track and Room: Administrator - N/A


Title: Getting started with Reporting Services

Abstract: We will take a look at what needs to be done to get Reporting Services up and running and how the Server actually works. We will also look at what features the different designers provide and how to know which Viewer Control with your application.

Speaker(s):

  • Adam Saxton

Track and Room: Beginner - N/A


Title: Zero to cube in 1 hour

Abstract: In this session, we’ll walk through the steps for creating a multidimensional schema (star schema) for a subject area we’re all familiar with, load the tables we create via SSIS, and build an SSAS cube to facilitate analytical analysis. The session is almost completely demo-driven, and will hopefully inspire you to go home and build your first BI solution to facilitate your own analysis.

Speaker(s):

  • Erin Welker

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

Wesley Brown

Twitter: - @sqlserverio

LinkedIn: Wesley Brown

Contact: http://www.sqlserverio.com

Wesley Brown is a former SQL Server MVP and PASS Chapter Leader who loves to teach others about SQL Server.He maintains his technical blog at http://www.sqlserverio.com. Wes specializes in high availability, disaster recovery, and large-scale database performance tuning.

Tim Costello

Twitter: - timcost

LinkedIn: Tim Costello

Contact: http://www.timcost.com

Tim Costello is an MCITP, MCTS specializing in etl and data analytics for Interworks Inc. Tim is an international speaker that is always looking for opportunities to share his passion for SQL Server, Tableau and data visualization. Tim is active in the SQL community and leads a data visualization focused user group in the Dallas area.

Erin Welker

Twitter: - sqlbigirl

Erin Welker, a consulting professional whose passion is SQL Server, has worked with the product since version 1.11. She has served as the data warehouse architect on projects for several globally recognized companies. She has also presented on SQL Server topics at several conferences and is the author of various whitepapers, articles, and book chapters on SQL Server and data warehousing.

Prem Mehra

Mr. Mehra is a Program Manager with Microsoft Corporation in the SQL Server Development Organization. His expertise is in developing architectural solutions, which exploit technologies such as relational database, transaction and message servers, and connectivity products. Prior to joining Microsoft Corporation, Mr. Mehra was an Associate Partner at Andersen Consulting and a Senior Consultant at IBM. He has more than forty one years of experience in the IT industry and has helped in implementing leading edge applications at many of the top Fortune one hundred companies. Mr. Mehra has spoken on several IT topics in seminars and conferences across the world as keynote speaker and as an instructor. He holds Master of Electrical Engineering degree from University of Toronto.

Jennifer McCown

Twitter: - http://www.Twitter.com/MidnightDBA

LinkedIn: Jennifer McCown

Contact: http://www.MidnightDBA.com/Jen

Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.

Adam Saxton

Twitter: - @GuyInACube

LinkedIn: Adam Saxton

Contact: https://guyinacube.com

Adam Saxton is just a guy in a cube doing the work! He is on the Power BI CAT team at Microsoft, working with customers to help adopt Power BI. He is based in Texas and started with Microsoft supporting SQL Server connectivity and Reporting Services in 2005. Adam has worked with Power BI since the beginning, on the support side, and with documentation. In addition, he produces weekly videos for his Guy in a Cube YouTube channel.

David Browne

I’m a Technology Architect at the Microsoft Technology Center in Dallas. And my job is to help customers design and implement SQL Server solutions. As part of my job I get to talk to a lot of BI shops about what they’re doing, how they perceive the their role in Enterprise Business Intelligence, what they are being asked by their businesses, and how they are responding to new challenges.

Ryan Adams

Twitter: - @ryanjadams

LinkedIn: Ryan Adams

Contact: http://www.ryanjadams.com

Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.

Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.

Andy Warren

Twitter: - @sqlandy

Contact: https://sqlandy.com

Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.

Ted Tasker

Ted Tasker joined Microsoft in 2008 as a Technology Solution Professional – and now focused on SQL Parallel Data Warehouse. Ted has over 17 years of experience with SQL Server going back to version 4.2.1. Prior to joining Microsoft, he spent 10 years leading DW and BI groups in financial and Internet entertainment companies. In his current role, Ted provides technical guidance and support in evaluation and implementation planning of very large SQL Server Data Warehouses for customers in the U.S. In the last 6 months Ted has personally worked on 5 PDW proof of concepts and can speak directly to the capabilities of the product.

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.

Anand Pandya

Contact: http://gnetgroup.wordpress.com

Mr. Pandya is a BI Services Manager with GNet Group in Dallas, TX. Known for his expertise in Information Management strategy and architecture, Anand has managed high performing consulting teams in the acts of creating, selling and delivering market responsive information management solutions.

Suresh Kandoth

Suresh Kandoth has worked with Microsoft for more than 10 years. Suresh is currently with the SQL Server Escalation team in Las Colinas. Suresh has deep expertise with many components of the SQL Server Storage Engine and experience with solving some of the most challenging and complex problems in the SQL Server core engine area. Special interests include core debugging and database corruption.

Tim Costello

Twitter: - timcost

LinkedIn: Tim Costello

Contact: http://www.timcost.com

Tim Costello is an MCITP, MCTS specializing in etl and data analytics for Interworks Inc. Tim is an international speaker that is always looking for opportunities to share his passion for SQL Server, Tableau and data visualization. Tim is active in the SQL community and leads a data visualization focused user group in the Dallas area.

Eric Humphrey

Twitter: - @lotsahelp

Contact: http://www.erichumphrey.com

Eric Humphrey is a DBA at GameStop in the Dallas area. He earned his B.S. in Computer Science from Louisiana State University – Shreveport in 2004. He has been working in the tech industry since 2003 with companies big and small. His focus is on database development with SQL Server. Eric has a passion for improving his craft while contributing to the development community.

Paul Hunter

I have no bio

David Smithey

David has over thirty years of IT experience. He has worked with SQL Server since version 6.5. He has been a DBA for the last 7 years. His experience includes working in the Educational, Aerospace, Insurance, Medical and Financial Industries. He is currently the President for the PASS Virtualization Virtual Chapter and the DBA for Curves International.

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.

Drew Minkin

Contact: http://dataminkin.blogspot.com

Drew Minkin has been a speaker at the MS Business Intelligence Community, North Texas SQL Server User’s Group and SQLSaturday events across the country , for four years, He worked at Microsoft in SQL Support and in Premier Field Engineering for over six years. After leaving Microsoft, Drew has designed and supported cubes for dozens of Fortune 1000 companies. he has designed data mining models on pricing optimization, fraud detection, customer retention and marketing campaigns

Douglas Brendle

Doug is a Solution Architect with Scalability Experts and has worked with SQL Server for over 10 years covering 7.0 to 2008r2. In one capacity or another he’s been involved with one database platform or another for over 10 years (mostly SQL Server but MySQL and Oracle enough to be dangerous) either as a developer, DBA or a consultant. He has been a member of PASS since 2005 and been active with SQLSaturday events. He has recently discovered eerie similarities between tuning a query and a banjo.

Randy Dyess

Over the past 20 years, Randy has helped architect, tune, and manage many very large databases (VLDBs) for optimum performance and availability. As a SQL Server relational data management expert, he has worked in environments containing over 200 terabytes of SQL Server data to those that had more than 10,000 databases, with only a few megabytes of data in each.

Trevor Barkhouse

Trevor Barkhouse is Support Escalation Engineer for Microsoft Corporation, on the team that supports SQL Server. His passions are automation, performance tuning, and troubleshooting. Trevor has spoken at many user group meetings, seven SQLSaturday events, the 2010 Houston TechFest, CodeStock 2011, and two PASS Community Summits (North American).

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.

Sri Sridharan

Contact: http://sqlrocks.com/

Sri is the President of North Texas SQL Server User Group. Sri has been involved with SQL Server since version 4.2 and has held various roles developer/dba/ architect / pre-sales over the years. He is largely responsible for some of few features in SQL 2008 like TDE and tools like MAPS. Sri holds a Bachelor’s Degree in Physics , Masters in Computer Information Systems and an MBA in Finance. His wife Hema, made sure he got a 3rd Masters in parenting their 2 sons.

Scott Whigham

Contact: http://www.learnitfirst.com/About/Scott-Whigham/Instructor/3.aspx

Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott also founded LearnItFirst.com and has recorded more than 2,000 SQL Server and Visual Studio training videos.

Aparna Vishwamitra

Aparna is a Senior Support Escalation Engineer with the SQL Server Developer Support team based in Las Colinas, TX. She has 6 years of application development experience and 6 years of SQL Server developer support. Her current focus is SQL Server Reporting Services and database connectivity.

David Stein

Twitter: - @Made2Mentor

LinkedIn: David Stein

Contact: http://www.Made2Mentor.com

David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.

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.

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.

John Cook

Twitter: - johnpaulcook

LinkedIn: John Cook

Contact: https://www.red-gate.com/simple-talk/author/johnpaulcook-2/

John Paul Cook is a psychiatric nurse practitioner and instructor of psychiatric nursing. He is former Data Platform Solutions Architect for Microsoft and before that a 9 time Microsoft MVP. John understands both the clinical aspects of healthcare and the technical aspects. He provides a unique perspective in being able to explain clinical concerns and issues to technical people. John is passionate about improving mental health in the community, including in the technical community.

Bryan Smith

LinkedIn: Bryan Smith

Bryan is a Data Solution Specialist with Microsoft Las Colinas, focused on data-driven solutions in the Azure cloud. He also teaches analytics technologies within the MBA amp; MSBA programs at SMU Cox School of Business.

Jessica Moss

Twitter: - @jessicammoss

Contact: http://www.jessicammoss.com

Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.

Jonathan Clark

Jonathan Clark is part of the SQL escalation support team at Microsoft’s Las Colinas campus. He’s worked in SQL support since 2006, supporting a variety of SQL specializations including performance, setup, clustering, SSIS, and replication. Before joining Microsoft, he worked for a local ad agency as an analyst. A local graduate of Addison’s Trinity Christian Academy, Jonathan attended Baylor University and lived in France from 2001-2003.

Sriram Ganapathy

Contact: http://blogs.msdn.com/sriramg

Sriram has 14 years of experience in Design, Development, Support, Consulting and Technical Sales of SQL Server and related application platform technologies. Sriram has been with Microsoft for 12 + years.

Rob Sullivan

Contact: http://datachomp.com

Rob is a bona fide Alpha Nerd, SQL Server DBA by day and code slinger by night. He has been the token DBA on This Developers Life, SQL Dude for Tekpub, open source contributor to .NET Micro ORMS and speaker. He is an active member and speaker at various Oklahoma City User Groups as well as being a co-founder/officer of his beloved Oklahoma City SQL Server Developers Group.

Jessica Moss

Twitter: - @jessicammoss

Contact: http://www.jessicammoss.com

Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page