SQLSaturday #99 - Minnesota 2011
Event Date: 11/11/2011 00:00:00
Event Location:
- Grace Church Eden Prairie
- 9301 Eden Prairie Road
- Eden Prairie, Minnesota
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: Custom assemblies for Reporting Services
Abstract: With SSRS we can quickly generate reports that can be exported to multiple formats. What happens when you want to extend your report with custom code? Perhaps you need a custom authentication layer, custom access to data requiring .Net code, or you want to extend some of the controls that come out of the box with SSRS. In this session we will see an example of extending SSRS to use a .Net library for a data provider allowing us to use a custom .Net business layer for our report. We will also show an example extension to the SSRS graph control allowing us to make design graphs for SSRS. Custom code is a great alternative for those considering using toolkits like Nevron or Dundas toolkits to extend their SSRS graphing capabilities
Speaker(s):
- Jeff Krebsbach
Track and Room: DEV-1 - N/A
Title: Analysis Services vs. PowerPivot Denali
Abstract: This session is a primer to understanding the differences and advantages between Analysis Services and PowerPivot; which scenarios to use analysis services vs. PowerPivot and how both serve to provide a perfect BI platform addressing short term vs. long term BI needs of organizations. We will focus on the differences between the two storage methods that are available for creating a BI Semantic Model, OLAP and Tabular, including a deep-dive into comparing Analysis Services vs. PowerPivot on topics such as security, hierarchies, KPIs and scalability. Understand when you should use PowerPivot in comparison with SQL Services Analysis Services (OLAP) so you are equipped to create robust Self Service BI applications in your organization.
Speaker(s):
- Paul Doyle
Track and Room: BI-2 - N/A
Title: Merge Replication for Offline Data Mobility
Abstract: How many times have you been sitting in a meeting and you hear, “We want all our users to have access to the data, 24/7. That includes when they are offline and on a client location”. At this point you may start letting out a large sigh because you are thinking, “How could the user get to the data if there is no connection?” This isn’t as hard as you may think and this session will show how to use SQL Servers Merge Replication in order to accomplish the task. Merge replication offers a scalable option for data mobility. This session will go over how Merge Replication can be used to replicate data to users that spend many hours offline.
Speaker(s):
- Ted Krueger
Track and Room: DBA-2 - N/A
Title: TSQL Tips and Tricks
Abstract: This session will demonstrate tips and tricks that will help you complete tasks fast and efficient using TSQL. This session is targeted at TSQL beginners to SQL Server experts looking to add to their TSQL bag of tricks. The focus of this session will be on leveraging builtin functions, scripts to create scripts, troubleshooting procedures and other uses.
Speaker(s):
- Andy Lohn
Track and Room: DEV-1 - N/A
Title: High-Availability and DR Options for SQL Server
Abstract: A comparison of SQL HA DR options, by a practitioner who has implemented managed all the SQL HA and DR approaches ( various combinations thereof). Tim is an operational SQL DBA, who keeps SQL servers up running optimized for managed-services customers. We will compare trade-offs between the various SQL HA DR options: for complexity, usability, hardware, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc. And we’ll briefly cover some of the upcoming SQL Denali HA / DR features.
Speaker(s):
- Tim Plas
Track and Room: DBA-1 - N/A
Title: Introduction to Project Crescent
Abstract: Project Crescent is the new self-service BI tool that will ship with SQL Server Denali. This session will cover what you need to know to install, configure and secure your new Project Crescent environment. It will also provide an overview of the features of Project Crescent and demonstrations of it’s powerful yet simple reporting capabilites.
Speaker(s):
- Natalie Wood
Track and Room: BI-1 - N/A
Title: Uniting Free Government Data using PowerPivot
Abstract: In recent years, governments throughout the world have made large volumes of data available for public use. Vast data with detailed insights into verticals such as healthcare, census, weather, natural resources, land use, financial markets, and economics are available to be extracted, transformed, joined and unleashed. In this session PowerPivot will be used to tie data together for analysis. Examples include uniting commodity prices with weather patterns, integrating free healthcare data with economic data, and integrating US economic data with that of other countries.
Speaker(s):
- Greg Beaumont
Track and Room: BI-2 - N/A
Title: Inside PerformancePoint
Abstract: This session will provide an overview of what PerformancePoint is, where it came from, and how do you get it. We will also discuss what’s changed in the 2010 release (including with the latest SP1 update). Along with this we will go over the Dashboard Designer tool showing you how to install it and explain what it is used for. Then hold on to your seats, I will build out and deploy a fully functional and interactive dashboard. Along the way I will provide insight from the trenches including tips and tricks along with experience from client deployments.
Speaker(s):
- Dan English
Track and Room: BI-1 - N/A
Title: Minimal Processing for Large Cubes
Abstract: Processing large cubes can consume vast amounts of IO, and create lengthy response times. This presentation will demo how to process dimensions and dynamically create, process, and delete measure group partitions to minimize IO. By taking control of cube processing through a SSIS package you are able to process only the bare minimum in order to bring a cube current while keeping response times acceptable. Additional areas to cover will include the support tables to control cubes, and a review of the XMLA for creating, processing, and deleting.
Speaker(s):
- Ross McNeely
Track and Room: BI-1 - N/A
Title: Introduction to Data Warehousing
Abstract: Just starting or thinking of starting a data warehousing project but not sure where to begin. Or still not sure if your organization needs a data warehouse. This discussion is geared towards answering the what and why (or why not) of data warehousing.
Speaker(s):
- Marc Beacom
Track and Room: BI-2 - N/A
Title: SQL Denali - What’s new for PowerPivot and SSAS!
Abstract: The presentation will consist of slides to lay out the approach/strategy for Microsoft’s single BI semantic model (BISM). Also, demonstration of the new capabilities in SQL Server Denali CTP3 for PowerPivot and BISM.
Speaker(s):
- Jin Cho
Track and Room: BI-1 - 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: DBA-1 - N/A
Title: Diving into the Cloud with SQL Azure
Abstract: Working with data is core to what we do as developers. With the release of the Microsoft SQL Azure Database cloud offering, developers have a new set of options and features that make it possible to take full advantage of the scalability and availability of this platform. In this webcast, we take a look at what SQL Azure means for developers and show how to create and manage a database in the cloud. We also explore the tools and the practices for using the tools.
Speaker(s):
- Mike Benkovich
Track and Room: DEV-2 - N/A
Title: Loading a Data Warehouse with SSIS
Abstract: You’ve just been assigned a data warehouse project. Maybe you’ve figured out what tables you want to work with, but outside of that you don’t really know how to get started. In this session you’ll learn how to load a data warehouse using SSIS, as well as techniques that you can use for any platform.
Speaker(s):
- Robert Biddle
Track and Room: DEV-1 - N/A
Title: Introduction to Integration Services
Abstract: Just getting started with SQL Server Integration Services (SSIS)? Not sure where to start? Or have you been using SSIS for a little while now and are still trying to figure out the basics. The biggest barrier to learning something new is figuring out the first few steps. We will discuss what SSIS is and a few lessons learned.
Speaker(s):
- Marc Beacom
Track and Room: DEV-2 - N/A
Title: SQL Server Service Broker – An Overview
Abstract: Service Broker can be used to simplify messaging between applications and assist in asynchronous programming by queuing messages and/or events. This presentation will explain how to use the Service Broker services, discuss its many components and show why you’ll benefit from using it. Several case studies will illustrate an elegant way to maintain data across multiple servers and show how to reduce dependencies between related programs and/or data structures.
Speaker(s):
- Janis Griffin
Track and Room: DEV-2 - N/A
Title: SSRS Multi-language Dynamic DB Connections
Abstract: Speaker Hans Johnson will entertain and educate attendees with a lesson on how to set up a dynamic database connection for an external application to call the web report server and render a .pdf for read only viewing. Hans will also show how to set up the same report with multi-language capabilities based on the end users browser language setting. Prizes will be given away based on a few different criteria that Hans will make fun, thought provoking and participant centered.
Speaker(s):
- Hans Johnson
Track and Room: DEV-2 - N/A
Title: Database Restores - Lessons from the Real World
Abstract: Having consistent, regular, verified backups are only a starting point. When failures happen - and they will happen - can you recover your database? In this presentation we will dive into the mechanics of database restores and discuss how choices made previously in database/server/backup design can have profound effects on how ( what) you can recover. We will also discuss spectacular ways to fail miserably… all in the hopes of preventing those same failures in the future.
Speaker(s):
- Bill Preachuk
Track and Room: DBA-2 - N/A
Title: Beyond Rounded Corners - SSIS Changes in Denali
Abstract: Unlike SSIS 2008, there are a number of developer improvements in SSIS Denali, beyond the rounded corners and new icons. This session will explore the changes and how they improve the developer experience.
Speaker(s):
- Steve Hughes
Track and Room: DEV-1 - N/A
Title: Geographic Visualizations Using Maps in SSRS
Abstract: This session will explore the many and varied uses of the map report item in Reporting Services. From providing geographic analytics to diagramming locations on a warehouse floorplan, the map report item – when combined with SQL Server spatial data types - can be used in a variety of ways to create spatial representations of your data. We may even look at a game or two created using the map report item.
Speaker(s):
- Brian Larson
Track and Room: Prof Develop - N/A
Title: Securing an SSAS, SSRS, and SharePoint BI Solution
Abstract: Security is a vital part of any business intelligence solution. Unfortunately, creating a solution that presents users only with the information they should see can be a challenge. In this session we’ll look at how the various security pieces come together to make the solution work. We’ll cover configuring Kerberos for securing SSRS, SSAS, and SharePoint; Scripting permissions in SSAS using MDX, Active Directory groups, and SSIS; and finally, configuring SharePoint, PerformancePoint services, and Power Pivot services to access user’s data by passing Windows credentials and/or the use of data sources with execution accounts.
Speaker(s):
- Dan Lewendowski, Aaron Bangasser
Track and Room: BI-2 - N/A
Title: Entity Strategies: Structuring Your Consultancy
Abstract: Independent BI consultant, MSSQL Server MVP, and practicing CPA Bill Pearson examines the various options available for organizing and protecting your consulting business. In this section, he covers C Corp, S Corp, LLC, Partnership, and Sole Proprietorship (“Schedule C”) options, as well as other practical advice (trademarks, etc.) useful in forming your business entity.
Speaker(s):
- William E Pearson III
Track and Room: Prof Develop - N/A
Title: Powershell and Perfmon - A performance story
Abstract: It turns out there might be something better than the combination of beer and peanuts (at work anyway); using Powershell to gather Performance Monitor (perfmon) metrics! In this session we will tackle gathering all the perfmon counters, storing them and alerting when they reach a defined level. This will be a demo intensive session that will also use SQL and XML components of Powershell. Attendees will leave this session with ideas and examples that they can implement in their jobs immediately. A basic working knowledge of Powershell syntax and commandlets will be assumed.
Speaker(s):
- Zach Mattson
Track and Room: DBA-2 - N/A
Title: Performance, Scalability and Efficiency
Abstract: Improving Response Times, Reduce Workload, Enhance Reliability, and Save Money with IOMemory Solutions• Improve performance and scalability• Provide High Availability• Empower data warehouses• Improve ROI
Speaker(s):
- Gus Siefker
Track and Room: DBA-1 - N/A
Title: Introduction to Data Mining in SQL Server
Abstract: Data mining provides a powerful tool for predictive analysis. These capabilities are available free as part of your SQL Server license. Unlock this powerful analytical tool to assist with decision making, cross-selling, and data analysis, and other areas within your organization.
Speaker(s):
- Brian Larson
Track and Room: BI-1 - N/A
Title: Converged SQL Server Solutions from HP Microsoft
Abstract: .
Speaker(s):
- Ajay Nangia
Track and Room: DBA-1 - N/A
Title: Don’t Panic, DBAs! Databases on VMware made easy.
Abstract: More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment.
Speaker(s):
- Janis Griffin
Track and Room: DBA-1 - N/A
Title: Baselining for SQL Server
Abstract: Why creating SQL Server performance baselines is important. Methods and approaches for baselining. How you can make use of baselines. Tools and applications that can help.
Speaker(s):
- Trent Mera
Track and Room: BI-1 - N/A
Title: Do SQL Server Certifications Really Matter?
Abstract: Microsoft has a number of certifications for SQL Server. They cover the DBA, developer and business intelligence skills. But, does anyone take them seriously? In this session, see the tracks for SQL Server certifications and discover what you need to know about the exams. Which track will be right for you? What steps should you take? How do you get going? And what value will they bring to your career?
Speaker(s):
- Jason Strate
Track and Room: Prof Develop - N/A
Title: PowerShell for the Reluctant DBA
Abstract: This presentation will provide a brief overview of how to get started with powershell and will be demo intensive. Demo topics will include common challenges that database professionals face including: basic code generation, deployment automation, and database discovery. We will also attempt to touch on automation and general script development best practices.
Speaker(s):
- Jason Horner
Track and Room: DBA-2 - N/A
Title: SQL Denali - An Open Window To T-SQL Enhancements
Abstract: The upcoming release of SQL Server is full of new features to help everyone from DBAs to developers. In this session, we’ll examine some of the new features that are being added to the T-SQL language. From error handling to windowing functions, we’ll look at the new flexibility and power available within the T-SQL language.
Speaker(s):
- Jason Strate
Track and Room: DEV-2 - N/A
Title: A Beginners Guide to Execution Plans
Abstract: This session is geared for people who write SQL and have little to no experience with Execution Plans; we will go over how to read an execution plan, how to improve server performance based on the results and common things to watch out for.
Speaker(s):
- Eric Zierdt
Track and Room: DBA-1 - N/A
Title: Building a SQL Listener Job Using Powershell
Abstract: In this session, you will be introduced to some simple PowerShell techniques, and see how to combine them to create an event-driven listener job running in SQL Server Agent service. Designed to be accessible to database administrators and database developers, you will see how easy it is to create useful scripts in PowerShell.
Speaker(s):
- Peter Kral
Track and Room: DEV-1 - N/A
Title: Intro to Locking and Blocking
Abstract: Understand the basics of SQL Server locking including lock modes, lock granularity and lock escalation. Also what is blocking, why should you be concerned and what you can do about it.
Speaker(s):
- Kirby Richter
Track and Room: DBA-2 - N/A
Title: Becoming DAX: An Introduction …
Abstract: The Data Analysis Expressions (DAX) language is a library of operators and constants that we can combine to craft formulas and expressions in PowerPivot Client. In this introductory session Microsoft BI Architect and SQL Server MVP Bill Pearson will concentrate upon crafting simple DAX expressions whose purposes, for the most part, are to return a set of data. He’ll overview a simple data source structure, outline the components of simple DAX syntax, and get you started understanding basic expressions.
Speaker(s):
- William E Pearson III
Track and Room: BI-2 - 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.
Robert Biddle
Twitter: - @robert_biddle
LinkedIn: Robert Biddle
Contact: http://robert-biddle.com
Robert Biddle is a Data Architect for Hilton Grand Vacations in Orlando, Florida. He has over a decade of experience working with SQL Server in a variety of roles. He has a Bachelor’s degree in Computer Science from the University of Delaware and also has MCITP certifications for Database Administration and Database Development. In recent years, Robert has specialized himself working with data integration, ETL, and data warehousing. He is a frequent speaker at SQLSaturday and Code Camp events.
Ajay Nangia
Contact: http://www.microsoft.com
Ajay Nangia is a Data Platform Technology Specialist at Microsoft. In this role, Ajay enables customers and partners to develop, deploy, and support solutions based on Microsoft’s Database Technologies. Ajay has a long history of working with SQL Server - from its internals to application and BI development on the platform.
Brian Larson
Twitter: - @Brian_Larson
LinkedIn: Brian Larson
Contact: http://sqlmag.com/author/brian-larson
Brian Larson is Chief Creative Officer/Partner at Superior Consulting Services and has presented at SQL Server Connections, PASS Summit, and the Microsoft BI Conference. As a consultant to Microsoft, Brian contributed to the original code base of Reporting Services. Brian is the author of “Microsoft SQL Server 2016 Reporting Services: 5th Edition” and “Delivering Business Intelligence with SQL Server 2016: 4th Edition”, as well as the forthcoming “Data Analysis with Microsoft Power BI.”
Marc Beacom
Contact: http://dawabi.com/blog.aspx
Marc Beacom is President 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. He has earned several industry certifications and degrees. Marc is an active member of the community and has volunteered for many organizations such as PASS, Denver SQL, Colorado GiveCamp, Camp To Belong, to name a few.
Dan English
Twitter: - @denglishbi
LinkedIn: Dan English
Contact: http://denglishbi.wordpress.com
Dan is a Microsoft Data Platform MVP, author, technical editor, and community leader. He has been developing with Microsoft technologies for over 20 years, and over 15 years with Data Warehousing and Business Intelligence. He has been working with SQL Server since version 6.5 and now using 2017 and in Azure. Dan is the chapter leader for the PASS Business Analytics virtual group and on the executive leadership team for the MN Microsoft BI user group.
Kirby Richter
Twitter: - @sqlkirby
LinkedIn: Kirby Richter
Kirby Richter is a Minnesota SQL Server Professional with 20 years’ experience. Currently Principal Database Architect at Dell Storage, specializing in Database Administration, large databases and Performance Tuning. Working with all versions of SQL Server since 6.5 Enjoys Development, Database Administration and Business Intelligence. Presents periodically at local events. Hobbies include kayaking, camping and amateur Astronomy.
Andy Lohn
Contact: http://sqlfeatherandquill.com
Andy Lohn works as a SQL Server Development DBA for Medtronic. He has been working with SQL Server since 1998. Since that time, he has had many titles, ranging from Operational DBA to Special Projects Lead. His specialties include TSQL, Performance tuning, working with very large databases and creating repeatable, scalable solutions.
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.
Jason Strate
Contact: http://www.jasonstrate.com
Jason Strate, Digineer Inc, has been a Database Architect for over ten years. His experiences include designing and implementing both OLAP and OLTP solutions involving clustering servers, database monitoring and tuning, analysis services, DTS/Integration Services, Reporting Services, and Notification Services. Jason is actively involved with the local PASS chapter (SQL Server User Group); he is currently serving on the Executive Board and has presented at monthly meetings. Jason contributed to M
Hans Johnson
Hans Johnson is has over 13 years of industry experience working in all facets of database development including conceptual design and architecture to development to QA to implementation and support. Hans has been a successful speaker at past PASS events and has also presented at Microsoft on “Big Data”. Hans’ strong experience in Toastmasters and very energetic and fun presentation style will also play a key role in keeping his audience captivated, educated and entertained.
Dan Lewendowski, Aaron Bangasser
Contact: http://www.rbaconsulting.com
Aaron Bangasser is a consultant with RBA Consulting, one of the fastest growing Microsoft Partners. Aaron has over 15 years of experience delivering business solutions. His latest projects have leveraged SQL and SharePoint for delivering business intelligence.Dan Lewendowski has been in the IT industry since 1995. Roles spanning the gambit from politics to telecom mixing in 2 stints as an educator he has built a solid foundation of IT experiences to draw from.
Brian Larson
Twitter: - @Brian_Larson
LinkedIn: Brian Larson
Contact: http://sqlmag.com/author/brian-larson
Brian Larson is Chief Creative Officer/Partner at Superior Consulting Services and has presented at SQL Server Connections, PASS Summit, and the Microsoft BI Conference. As a consultant to Microsoft, Brian contributed to the original code base of Reporting Services. Brian is the author of “Microsoft SQL Server 2016 Reporting Services: 5th Edition” and “Delivering Business Intelligence with SQL Server 2016: 4th Edition”, as well as the forthcoming “Data Analysis with Microsoft Power BI.”
Marc Beacom
Contact: http://dawabi.com/blog.aspx
Marc Beacom is President 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. He has earned several industry certifications and degrees. Marc is an active member of the community and has volunteered for many organizations such as PASS, Denver SQL, Colorado GiveCamp, Camp To Belong, to name a few.
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Steve Hughes
Twitter: - dataonwheels
LinkedIn: Steve Hughes
Contact: http://www.dataonwheels.com
Steve Hughes is the Director of Consulting at Pragmatic Works. In his current role, Steve manages the consultant team at Pragmatic Works and directs implementation of our cloud practices for customers. He focuses on team development and company growth with this role. In his previous role as a Principal Consultant Lead, he focused designing solutions for customers on Microsoft technologies including SQL Server, Power BI, and Azure. He has been working with technology for over 20 years with much of that time spent on creating business intelligence solutions and helping customers implement leading BI and cloud solutions. He is passionate about using data effectively and helping customers understand that data is valuable and profitable.
Greg Beaumont
Contact: http://blog.gnetgroup.com
Greg Beaumont is a Business Intelligence Consultant at GNet Group. He joined GNet Group in 2009, and has industry vertical experience including healthcare, manufacturing, logistics, retail, and public/government data. His professional focus is upon building industry standard reporting methodologies into BI solutions. He enjoys staying up-to-date with technology related to his career within the world of Microsoft BI.
Zach Mattson
Twitter: - @WIDBA
Contact: http://widba.blogspot.com
Zach Mattson is a reformed DBA turned BI Developer for Trek Bicycle Company in Waterloo, WI. Zach has spoken at multiple community events and been published several times on using Powershell for SQL Server monitoring. He now works from home full time, guarded full time by his yellow labs while developing solutions utilizing the full BI stack of Microsoft tools.
Bill Preachuk
Bill Preachuk, for one, welcomes the advances of our Hadoop Overlords. He is a SQL Server MCTS, and is employed as a DBA/Data Warehouse Designer at Emergent Networks. Bill has been in IT since 1991 and has presented at prior SQLSaturday events in the Twin Cities and Iowa.
Ted Krueger
Contact: http://blogs.lessthandot.com/index.php/All/?disp=authdirauthor=68
Ted Krueger has been working in development and database administration for over a decade. Ted currently works for a respected consulting company, Magenic Technologies as a valued Database Professional resource. He is a PASS Region Mentor, Friends of Red Gate member, SQL Server MVP and community mentor. Ted blogs and is also one of the founders of LessThanDot Technical Community
Peter Kral
Twitter: - https://twitter.com/pkral
LinkedIn: Peter Kral
Peter Kral is a Premier Field Engineer (Data AI) at Microsoft. He holds SQL Server MCSA 2012/2014/2016 and Data Platform MCSE certifications, and was the winner of the Speaker Idol Award at PASS Summit 2016. Peter lives in the San Diego area where he is an active member of the local PASS chapter. He has spoken at many SQLSaturdays, SoCal Code Camps, and at PASS Summit 2017 and 2018.
Jason Horner
Twitter: - jasonhorner
LinkedIn: Jason Horner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.
I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.
In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
Paul Doyle
Paul Doyle is a BI Consultant with GNet Group, where he has helped customers in manufacturing, retail and insurance industries successfully implement enterprise data warehouse solutions and self-service BI. With 11+ years of development experience with SQL Server and PerformancePoint. He was a contributing author of the Microsoft white paper, “Empowering Enterprise Solutions with SQL Server 2008 Enterprise Edition” AppDev courseware “Microsoft SQL Server 2005 Integration Services “
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Ross McNeely
Contact: http://mcneelydwbi.wordpress.com
Ross McNeely, BI Practice Manager, C2 IT Solutions
Ross has presented at several SQLSaturday events in Minnesota, Wisconsin, and Iowa. Recently, Ross adds real-world examples from the Financial Services, Logistics, and Retail industries in his presentations. Regardless if you have a beginner, intermediate, or advanced skill set, Ross will provide a solid foundation for each topic he presents. Please join Ross McNeely for a fun and informative meeting.
Jason Strate
Contact: http://www.jasonstrate.com
Jason Strate, Digineer Inc, has been a Database Architect for over ten years. His experiences include designing and implementing both OLAP and OLTP solutions involving clustering servers, database monitoring and tuning, analysis services, DTS/Integration Services, Reporting Services, and Notification Services. Jason is actively involved with the local PASS chapter (SQL Server User Group); he is currently serving on the Executive Board and has presented at monthly meetings. Jason contributed to M
Natalie Wood
Natalie Wood is a SQL Server Database Consultant for RBA Consulting. She has been in IT for the last 10 years and is a Certified IT Professional for SQL Server.
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Mike Benkovich
Contact: http://www.benkotips.com
Mike Benkovich delivers technical presentations around the U.S. as a developer evangelist on the Microsoft Developers Network (MSDN) team at Microsoft. He has worked in a variety of professional roles, including architect, project manager, developer, and technical writer. Mike is also an author of two books, published by WROX Press and APress, that show developers how to get the most from their SQL databases.
Eric Zierdt
Twitter: - @EricZierdt
LinkedIn: Eric Zierdt
Contact: http://ericemployed.blogspot.com
Eric is a level 70 Data Slayer, who has worked with SQL Server since 2000. Eric has worked with benefit systems, real estate data, marketing, game data, and medical device data. Eric enjoys performance tuning, T-SQL programming, and SQL Server Administration.
Gus Siefker
Account Executive, Fusion-io
Jeff Krebsbach
Contact: http://geekswithblogs.net/jkrebsbach/Default.aspx
Jeff Krebsbach is an MCPD for ASP.Net 4.0 and a Senior Consultant with Superior Consulting Services based in Burnsville, Minnesota. With extensive experience throughout the Microsoft BI stack, Jeff has worked on several applications requiring real time data delivery for financial institutions and billing offices, and helped many companies meet their Business Intelligence needs with Microsoft technologies throughout the twin cities area and across the country.
Trent Mera
Trent Mera has been a database performance Systems Consultant with Quest Software for 11 years. He specializes in showing customers how to identify and resolve performance bottlenecks in their SQL Server systems. His experience prior to Quest includes 7 years as a Database Developer and Administrator in the Real Estate, Finance and Defense Industries.
Tim Plas
Twitter: - tjplas
LinkedIn: Tim Plas
Tim is a Principal Consultant at Virteva, in Mpls MN. His current focus areas are cloud architecture / engineering / migration, operational-DBA services (esp. HA/DR), server migrations, server virtualization, and storage. His experience over the past 25+ years has been primarily with server / data-center infrastructure, including being CTO / co-founder of a successful hosting company. Tim has held a variety of MS certifications since 1994.
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Jin Cho
Contact: http://www.microsoft.com/bi
Jin Cho (Microsoft Business Intelligence Technology Specialist) evangelizes on Business Intelligence capabilities for suite of Microsoft products. Jin has proven ability to deliver Business intelligence solutions utilizing leading market BI technologies. Prior to becoming a Microsoft employee, Jin spent 11 years at Allina Health System. He led the Business Intelligence/Data Warehouse effort to provide clinical, financial, and operational BI solutions.
Sponsors
The following is a list of sponsors that helped fund the event: