SQLSaturday #437 - Boston - BI Edition 2015
Event Date: 10/17/2015 00:00:00
Event Location:
- Microsoft Conference Center, Kendall Square
- 1 Cambridge Center
- Cambridge, Massachusetts
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: Building a Big Data Solution
Abstract: As a follow-on to the presentation “Building an Effective Data Warehouse Architecture”, this vendor-free presentation will explain exactly what Big Data is and its benefits, including use cases. We will discuss how Hadoop, the cloud and massively parallel processing (MPP) is changing the way data warehouses are being built. We will talk about hybrid architectures that combine on-premise data with data in the cloud as well as relational data and non-relational (unstructured) data. We will look at the benefits of MPP over SMP and how to integrate data from Internet of Things (IoT) devices. You will learn what a modern data warehouse should look like and how the role of a Data Lake and Hadoop fit in. The Big Data boom brings new challenges to those of you who define the architectures to create and consume business-critical data. You will need guidance on the best solution for your data warehouse going forward. This presentation will help to give you that guidance!
Speaker(s):
- James Serra
Track and Room: Strategy and Architecture - Bunker Hill (2006)
Title: SQL Server Reporting Services 2014 on Steroids!!
Abstract: Reporting requests that are required ‘yesterday or sooner’, oft times necessitate working more efficiently and effectively. We have all been through this at one time or another. In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.
Speaker(s):
- Steve Simon
Track and Room: BI Information Delivery - Longfellow (4028)
Title: Self-Service ETL with Power Query
Abstract: Before any significant data analysis can take place the data often needs to be transformed, aggregated, and combined. This is often referred to as the ETL (Extraction, Transfer, and Load) process. Power Query is an excellent tool in the Microsoft self-service BI stack that allows business users to discover, combine, and refine data before loading it into a Power Pivot model for further analysis. In addition Microsoft has made connecting to a wide variety of sources including relational, structured, and semi structured data a consistent intuitive experience. This session guides you through using Power Query to extract, transform, and load data from various sources into a Power Pivot model. In addition we will look at the M language created by the tool and look at some advanced queries you can create using M.
Speaker(s):
- Dan Clark
Track and Room: Self Service BI - Hawthorne (4018)
Title: SSIS 2012/2014: The Quiet Revolution
Abstract: The SQL Server 2012 release of SSIS was a complete game changer. Using sample packages, we’ll show you how to deploy projects to the new SSIS catalog. You will see how project level parameters and connection managers can make your life easier. You will learn how to configure packages using the new configuration editor in SSMS. We’ll show you how to define a collection of configuration settings called an Environment which can automatically configure packages deployed to a server. Find out why SQL Agent no longer captures SSIS errors in the log and how you can get information about failed packages. Get up to speed on using the latest features of SSIS to make you job easier.
Speaker(s):
- Bryan Cafferky
Track and Room: Application Database Development - Bunker Hill (2006)
Title: Leadership Without Borders: Working with Global Teams
Abstract: As companies become more global, IT teams need to adapt. This often means having resources in locations outside our home countries as well as hiring outside parties for staff augmentation. As we place people in locations outside our own walls, processes and practices need to keep up with this shift.
Whether your people are in Boston, Berlin, Bangalore, or Beijing, they all need to work together. We look at the challenges of having a globally diverse team, including collaboration, feedback, work assignments, and performance evaluations. We also look at outsourcing, offshoring, and a combination of the two. And we look at one of the greatest benefits: follow-the-sun support.
In this session, we demonstrate how a language barrier isn’t usually the biggest challenge and how cultural differences make the most impact.
Speaker(s):
- Mike Hillwig
Track and Room: Professional Development - Hawthorne (4018)
Title: Handling Data Error in a Data Flow
Abstract: It can be frustrating to build an SSIS package with a data flow task and have data related errors where you can’t identify the row or column that caused the error because of the cryptic or generic error messages presented to you by SSIS and the driver. How do you find out what caused error? Is there a way to get a better error message? Can I identify the rows? We’ll go over a method I developed to handle error rows using a script task (at one time upgraded to a custom component) so the offending data can be identified and corrected. We will discuss ways to correct the problems in an automated fashion. We will discuss other options in addition to my solution.
Prerequisites:
Experience developing SSIS packages T-SQL Experience Basic .NET knowledge
Speaker(s):
- Jack Corbett
Track and Room: Strategy and Architecture - Concord (2018)
Title: Create a Power BI Dashboard in 90 Minutes or LESS
Abstract: Power BI is quickly outpacing Excel as the one tool needed for self-service Business Intelligence. In this session we’ll walk through Microsoft’s exciting new Power BI SaaS offering, creating some Reports and Dashboards along the way. We’ll explore some of the ready-made content packs for major SaaS providers such as Salesforce or Google Analytics, then create our own based on an Azure SQL Database. Next, we’ll explore Power BI Desktop, a powerful new tool for creating advanced analytic data models and authoring reports using familiar experiences from the best of Excel’s BI components. Finally, we’ll deploy the reports to Power BI, extend and share our Dashboard, and configure Automatic Data Refresh. All inside 90 minutes! Don’t miss this session on the cutting edge of Microsoft’s self-service Business Intelligence offering.
Speaker(s):
- Todd Chittenden
Track and Room: BI Information Delivery - Longfellow (4028)
Title: Introduction to Biml
Abstract: Have you ever needed to generate dozens (or even hundreds) of similar SSIS packages? Do you ever find yourself needing to regenerate a lot of packages when some piece of the upstream data format changes? Using native SSIS, this can be a tedious and error prone exercise. However, using Biml (Business Intelligence Markup Language) can greatly increase your productivity as an ETL developer.
In this session, we’ll cover the essentials of Biml. I’ll discuss what it is and what it can do for SSIS, demonstrating how it can easily generate dozens or even hundreds of packages in just a few minutes. I’ll also demonstrate some realistic examples and discuss how Biml fits into the enterprise ETL picture.
Speaker(s):
- Tim Mitchell
Track and Room: BI Platform Architecture, Development Administration - Longfellow (4028)
Title: Azure SQL Data Warehouse Overview
Abstract: Microsoft recently announced the SQL Data Warehouse Platform as a Service (PaaS) feature for Microsoft Azure. This platform provides an on-demand Massively Parallel Processing (MPP) platform for build data warehouses that can handle from 10s of TBs of data up to PBs. This session will provide an overview of SQL Data Warehouse with a discussion on the value that Massively Parallel Processing (MPP) brings to your data warehouse and why the cloud may be the best platform for your solution. In this session, we’ll also dig into the capabilities of SQL Data Warehouse and compare those to other offerings. • Scale from terabytes to petabytes • Save on costs through on-demand scale • Take advantage of architecture designed for scalable performance • Gain a cloud integrated data warehouse solution
Speaker(s):
- Jason Strate
Track and Room: BI Platform Architecture, Development Administration - Thoreau (4038)
Title: 100 Times Faster: Experiences making SQL Server go fast
Abstract: How do you go about making a program run a lot faster! Like 100 times faster? It’s difficult. Microsoft tried in the Hekaton project, its in-memory tables feature of SQL 2014, and they got close. Inspired by that effort, this presentation looks at some recent cases where I’ve been able to achieve huge performance improvements in SQL Server code and how that happens.
When I work on SQL Server performance I emphasize that the first thing to think about is how to accomplish the task in a different way that will be much faster”. Sometimes there’s a better algorithm. Sometimes a different technology is more appropriate. Sometimes it’s a combination of many changes that combine to create the desired outcome much, much faster.
This presentation is illustrated with examples from my work and we’ll look for common threads that might help us all.
Speaker(s):
- Andrew Novick
Track and Room: Application Database Development - Thoreau (4038)
Title: Unleashing SSIS with expressions, configurable properties, and parameters
Abstract: Have you struggled to build SSIS packages? You are starting to get the hang of it, but many things more than basic data movement remain a frustrating challenge. The SSIS expression language is an incredible source of power within SSIS but a profound challenge to many. Another area of power and flexibility in SSIS is its very broadly scoped configurability. This presentation will walk through the basics of the SSIS expression language including the whys and wherefores of a few expression peculiarities. Then we will review how you can use those expressions to configure so many of the properties in SSIS that you might barely recognize what your package can do when you are finished. Finally we will review input parameters and how to further influence the behavior of your packages at run time. Download includes slide deck, expression samples, and some packages.
Speaker(s):
- Daniel Bowlin
Track and Room: Strategy and Architecture - Hawthorne (4018)
Title: Transitioning to a BI role
Abstract: Business Intelligence is an extremely hot career. If you are a DBA or have another IT position, how can you transition to a BI role? I will describe what exactly BI is, what encompasses the Microsoft BI stack, why it is so popular, and why a BI career pays so much. Then I will delve into the steps to take to become a BI expert and how I made the transition, going from a salaried DBA to a high-in-demand and high-income BI consultant. If I can go from a complete unknown to building a personal brand that allowed me to present at the PASS Business Analytics conference in just two years, so can you!
Speaker(s):
- James Serra
Track and Room: Professional Development - Concord (2018)
Title: You Can Still Analyze Data with T-SQL … No Really
Abstract: This session will look at a variety of T-SQL functions and techniques that can be used to analyze data. Including demos of CUBE, ROLLUP and the various “window” functions which use the OVER function. These are not the new functions, but they are often underused. With in-memory OLTP on the horizon, relational queries will perform even better. This is the time to brush up on or learn about analyzing data with T-SQL.
Speaker(s):
- Steve Hughes
Track and Room: Application Database Development - Bunker Hill (2006)
Title: Extending Your Data Warehouse With PolyBase and Hadoop
Abstract: Introduced with Microsoft’s Analytics Platform System (APS), PolyBase provides first tier support for accessing and incorporating data from Hadoop platforms in APS. But, what does that mean to the data warehouse? What changes because you can easily integrate APS into a Hadoop environment? Join me in this session to look at the ways data warehouses evolve when you extend your solutions into PolyBase and Hadoop. • Extend your data warehouse to Hadoop and the Azure cloud • Save of costs and efforts when archiving data warehouse data • Leverage new technologies with existing solutions
Speaker(s):
- Jason Strate
Track and Room: BI Platform Architecture, Development Administration - Concord (2018)
Title: 15 Quick Tips for SSIS Performance
Abstract: When reviewing your ETL processes, the No. 1 question is always, “Does it work as expected?” Closely following that question is the ubiquitous, “How fast does it run?” This session’s tips are targeted at improve the latter.
In this session, we’ll focus on SSIS package performance, quickly reviewing 15 common hotspots for performance issues as well as recommended methods for maximizing throughput. You’ll walk away with some key design patterns and recommendations that you can use today to improve SSIS package performance.
Speaker(s):
- Tim Mitchell
Track and Room: BI Information Delivery - Longfellow (4028)
Title: Advanced SQL Server Analysis Services
Abstract: This session will go well beyond creating SSAS cubes with the cube wizard. I’ll cover topics such as the pros and cons of ROLAP, XMLA Processing options, Many to Many Bridge Tables and the use of the DefaultMember and IsAggregatable properties, SSAS Report Actions, Dynamic SSAS Roles with custom MDX code, Advanced MDX in SSRS, Partitioning and Aggregations, Data Driven KPIs, and Dimension Attribute Discretization.
Speaker(s):
- Kevin Goff
Track and Room: Application Database Development - Hawthorne (4018)
Title: Big Data querying with HDInsight and Hadoop with Excel
Abstract: More and more companies are tackling big data to gain business insight. In this presentation, we will learn how to process Big Data in Azure using HDInsight, Microsoft’s implementation of Hadoop. It is oriented towards non-traditional data querying. We will go through how to set up an HDInsight cluster, load data, query it, and then use Power Query to pull the data into Excel for visualization. If you’ve been wondering what all the Big Data hype is about or how you can solve it with the Microsoft stack, this is the presentation for you.
Speaker(s):
- George Walters
Track and Room: BI Information Delivery - Longfellow (4028)
Title: Delivering Agile Analytics with Azure Machine Learning
Abstract: If you can build SSIS packages or reports, you can do machine learning. Are you being asked to do more advanced analysis with existing tools? Come learn how to take your predictive capabilities to the next level with new azure technologies. This new technology provides new opportunities to build and deploy machine learning algorithms in minutes instead of weeks. Come learn hands on as we deploy these together in this session!
Speaker(s):
- Adam Jorgensen
Track and Room: Advanced Analysis Techniques - Thoreau (4038)
Title: SQL Server Compression - Getting More Out of Less
Abstract: We are storing more information then we ever have before and we need to retain this information for longer periods of time. Do we keep adding more and more disk space? What about performance? What about cost? Is there some way we can use the existing space more efficiently? With data compression we can tackle these issues and do it with minimal or even no changes to our existing code.
Speaker(s):
- Michael Nowill
Track and Room: BI Platform Architecture, Development Administration - Concord (2018)
Title: The future of the data professional
Abstract: The world of data is changing rapidly. Come learn what this means for your role as a data professional and what you can do to make sure you stay at the front of your field. What does the future look like for DBA’s, BI Developers, and Architects? Come get the lay of the land and guidance on keeping your career and learning on the right path. I will go through the updated landscape and decisions facing data professionals today and help you chart a course to make sure your plans are right for you and your organization.
Speaker(s):
- Adam Jorgensen
Track and Room: Professional Development - Thoreau (4038)
Title: T-SQL for Application Developers - Attendees chose
Abstract: That’s right, attendees choose! I’ll show 30 possible topics on the screen, and the attendees vote on which topics I’ll cover. Everything from isolation levels to ranking…everything from GUIDs to table-valued functions….everything from querying temporal data to instances where subqueries are necessary….everything from update triggers to reading execution plans. The good news is that you’ll walk away with 30 code samples, even though we’ll only cover a portion of them in the presentation. This has always been a very popular session.
Speaker(s):
- Kevin Goff
Track and Room: Application Database Development - Hawthorne (4018)
Title: Processing Temporal Telemetry Data -aka- Storing BigData in a Small Space
Abstract: Thomas will share his experience in collecting billions of temporal data points from various sources and how to store them in a data warehouse with the right balance between space and query performance. The session will also cover how to deal with missing data points, duplicates and how to aggregate and groom the data over time. The know how of this session can be applied to all data that is collected over time and needs to be very precise for a few months and than can be aggregated into a more trend like data. Schema, ETL, Aggregation, Querying and grooming will be covered.
Speaker(s):
- Thomas Grohser
Track and Room: Analytics and Visualization - Bunker Hill (2006)
Title: Managing Copy Data for BI
Abstract: As BI professionals we are straddled with multiple issues pertaining to Copy Data. We will discuss what ‘Copy Data’ is along with various terminologies that go with it.
The common issues are:
- Space
- Network Bandwidth
- Time
- Security
- Obfuscation/Masking
- Which Server does this go to?
- Onward protection of Copy Data
In this session we will study the issues above and see how we can avoid these issues. We will examine what technologies/products are available that help us mitigate such a massive problem.
Speaker(s):
- Paresh Motiwala
Track and Room: BI Platform Architecture, Development Administration - Concord (2018)
Title: Dashboards, KPIs and Maps for any Device
Abstract: Would you like to design and publish stunning, interactive and easy to use Dashboards, KPIs and Maps? Do it once? View and interact with them on any device; laptop, tablet and phone running iOS, Android or Windows? This is possible using Datazen technology, one of the newest additions to Microsoft Business Intelligence offerings.
In this session come to learn the power and ease of how you can make this possible.
Speaker(s):
- Sunil Kadimdiwan
Track and Room: BI Information Delivery - Bunker Hill (2006)
Title: Scratching the Surface: Designing your first Power View Report
Abstract: Dashboards have quickly become a cornerstone for decision-making by managers and business leaders in all facets of corporate operations. Microsoft Power View has enabled drastic improvements in the development of dynamic and interactive dashboards within the Microsoft SQL Stack. In this session, we will cover areas such as: Data Considerations; Deployment Options; Building your first report; and using some of the interactive features of Power View.
Speaker(s):
- Chris Seferlis
Track and Room: Self Service BI - Thoreau (4038)
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 Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
James Serra
Twitter: - www.twitter.com/JamesSerra
LinkedIn: James Serra
Contact: http://www.JamesSerra.com
James Serra is a big data and data warehousing solution architect at Microsoft. He is a thought leader in the use and application of Big Data and advanced analytics. Previously, James was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 35 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker. He is the author of the book “Reporting with Microsoft SQL Server 2012”.
Tim Mitchell
Twitter: - @Tim_Mitchell
LinkedIn: Tim Mitchell
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.
Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
George Walters
Twitter: - https://twitter.com/geo_walters
LinkedIn: George Walters
Contact: https://georgewalters.wordpress.com/
Currently a partner technical strategist, George has been solving customer needs and issues. He can translate customer pain into potential solutions.
A seasoned Microsoft SQL and Azure expert, with over 20 years of experience with Microsoft SQL Server, Sybase, Oracle, and other relational databases.
Specialties: Partner strategy, PreSales Engineering, Cloud Architecture, Enterprise Scalability, SQL Server performance, Business Intelligence, High Availability, Scale. I volunteer and present relevant topics at SQLSaturday and internal Microsoft events
Jack Corbett
Twitter: - http://twitter.com/unclebiguns
LinkedIn: Jack Corbett
Contact: http://www.wisemanorwiseguy.com
JJack Corbett began working with SQL Server, Access, and VB in 1999, when he served an apprenticeship with a good friend who was the software development manager at the local paper mill. He found his niche and has concentrated on SQL Server development and administration since late 2000. He has worked with SQL Server through version 2017 and was a Microsoft Data Plaform MVP from October 2011 to October 2016.
Jack is passionate about helping companies architect, design, and develop high performance applications based on the Microsoft Data Platform. He also has a passion for seeing database developers get the core application code (the database) protected under source control.
Jack has presented at many user groups and SQLSaturday even
Todd Chittenden
Twitter: - @toddchitt
LinkedIn: Todd Chittenden
Contact: http://blog.blumshapiro.com/blog/author/toddc/
Todd started working with Microsoft’s SSRS in 2004. When Microsoft released its rebuild of SQL Server in 2005, he quickly added the full BI Stack to his repertoire. He became a MCTS in SQL Server 2005. Today, Todd works for Blum Shapiro as a Business Intelligence Architect on various BI Projects across a wide range of company sizes and product combinations. He is a Microsoft Certified Solutions Expert in SQL Server Business Intelligence and a frequent speaker at local User Groups and SQLSaturday events. He Started working with Power BI in its early development time before General Availability in July of 2015.
Dan Clark
LinkedIn: Dan Clark
Contact: http://drclarkblog.wordpress.com/
Dan Clark is a senior data analytics consultant. He is focused on all things data analytics and training others how to get value from their data. Dan has published several books and numerous articles on .NET programming and data analytics. He is a regular speaker at various developer and database conferences and user group meetings and enjoys interacting with the Microsoft developer and database communities. His latest book Beginning Power BI published by Apress is a will get you up and running with self-service data analytics on the Power BI platform in no time.
Jason Strate
Twitter: - @stratesql
LinkedIn: Jason Strate
Contact: http://www.jasonstrate.com/
Jason Strate is a SQL Server Solutions Architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. Jason writes, blogs, and presents on SQL Server.
Chris Seferlis
Twitter: - bizdataviz
LinkedIn: Chris Seferlis
Contact: http://blog.bizdataviz.com
Chris Seferlis is a Sr Cloud Solution Architect at Microsoft. He has 20+ years’ experience working in IT and solving technical challenges from a business perspective. Chris is a former CIO with an MBA from UMass, bringing a mix of business acumen and practical technology solutions, primarily focusing on Data and AI within the Microsoft Data Platform, including MCSA and MCT designations.
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.
Michael Nowill
Mike has worked with SQL Server for over 10 years focusing mainly on data warehousing and business intelligence. He is currently a Manager of Production Services Enhancements at Farm Credit Financial Partners, Inc. Mike specializes in data warehouse design and performance tuning. He holds a masters degree in Information Technology from Bentley University. When not working with SQL Mike enjoys photography, American History, brewing beer and snowboarding.
Kevin Goff
Twitter: - @KevinSGoff
Contact: http://www.KevinSGoff.net
Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP
Database architect/developer/speaker/author
Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics
Frequent speaker at community events in the Mid-Atlantic region.
Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics
Mike Hillwig
Twitter: - @mikehillwig
LinkedIn: Mike Hillwig
Contact: http://www.mikehillwig.com
Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.
Thomas Grohser
LinkedIn: Thomas Grohser
Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.
Adam Jorgensen
Twitter: - wadamj
LinkedIn: Adam Jorgensen
Contact: http://www.pragmaticworks.com
As President of Pragmatic Works Consulting Adam drives market strategy, sales, partnerships, implementation and thought leadership. He has over 15 years of experience helping companies use their data to fuel their growth. Adam has been wowing audiences around the world for over a decade. He has delivered hundreds of sessions, published over a dozen books and hundreds of online videos and webinars on data and cloud topics. His passion is growing companies and mentoring leaders and companies to help them achieve their dreams.
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
Andrew Novick
LinkedIn: Andrew Novick
Contact: http://www.NovickSoftware.com
Andy Novick is a SQL Server MVP and consultant building business solutions with SQL Server. He has expertise in database design, T-SQL coding, SQL Server security, database performance tuning, partitioning, service broker, and database administration. Andy is a frequent speaker at local user group meetings and an author of two books on SQL Server.
Chris Seferlis
Twitter: - bizdataviz
LinkedIn: Chris Seferlis
Contact: http://blog.bizdataviz.com
Chris Seferlis is a Sr Cloud Solution Architect at Microsoft. He has 20+ years’ experience working in IT and solving technical challenges from a business perspective. Chris is a former CIO with an MBA from UMass, bringing a mix of business acumen and practical technology solutions, primarily focusing on Data and AI within the Microsoft Data Platform, including MCSA and MCT designations.
Paresh Motiwala
Twitter: - pareshmotiwala
LinkedIn: Paresh Motiwala
Paresh Motiwala a Azure/Big Data enthusiast, Manager of Database Platform teams has led several large SQL implementations, migrations and upgrades. He has managed multi terabyte OLTP databases. He has also been a Sr. SQL DBA and a Solutions Architect in Fortune 100 companies. He helps/organizes and speaks at many SQLSaturdays, Azure Bootcamp, Azure Datafests and User Groups(Boston BI UG, NESQL, PASS PD VG and PASS DBA VG).
He is certified in Big Data Analytics, FinTech, PMP, Public Speaking, Business Communications. He is a avid singer, cook, open networker, and stand-up comedian. He teaches public speaking, debating, interviewing and group discussion skills and mentors children around the globe via www.circlesofgrowth.com
Tim Mitchell
Twitter: - @Tim_Mitchell
LinkedIn: Tim Mitchell
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.
Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
Adam Jorgensen
Twitter: - wadamj
LinkedIn: Adam Jorgensen
Contact: http://www.pragmaticworks.com
As President of Pragmatic Works Consulting Adam drives market strategy, sales, partnerships, implementation and thought leadership. He has over 15 years of experience helping companies use their data to fuel their growth. Adam has been wowing audiences around the world for over a decade. He has delivered hundreds of sessions, published over a dozen books and hundreds of online videos and webinars on data and cloud topics. His passion is growing companies and mentoring leaders and companies to help them achieve their dreams.
Sunil Kadimdiwan
Twitter: - @skadimdiwan
LinkedIn: Sunil Kadimdiwan
Contact: http://www.infotrove.com/events.html
Sunil Kadimdiwan Sunil Kadimdiwan has 25+ years’ experience in architecting and implementing database solutions. He has deep knowledge of the Microsoft SQL Server and Business Intelligence technology stack. He is a frequent speaker at SQLSaturdays, Code Camps, User Group meetings
Bryan Cafferky
LinkedIn: Bryan Cafferky
Contact: https://www.youtube.com/user/Bryancutube256123
Bryan Cafferky is a Big Data and AI consultant. Bryan was previously a Senior Data Science Training Content Developer for Microsoft Worldwide Learning. Prior to this he was a Microsoft Data and AI Enabler for healthcare customers. He is a Microsoft 2017 Data Platform MVP and a 2016 Cloud and Data Center Management MVP. Bryan is the author of Pro PowerShell for Database Developers by Apress, available on Amazon. He leads The RI Microsoft BI User Group, and The Greater Boston Area Data Science Group. He has been working with the SQL Server stack since 1997 and implemented projects in the banking, insurance, e-commerce, utility, and health care industries. He holds a bachelor of science in computer information systems and an MBA.
Jason Strate
Twitter: - @stratesql
LinkedIn: Jason Strate
Contact: http://www.jasonstrate.com/
Jason Strate is a SQL Server Solutions Architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. Jason writes, blogs, and presents on SQL Server.
Kevin Goff
Twitter: - @KevinSGoff
Contact: http://www.KevinSGoff.net
Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP
Database architect/developer/speaker/author
Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics
Frequent speaker at community events in the Mid-Atlantic region.
Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics
James Serra
Twitter: - www.twitter.com/JamesSerra
LinkedIn: James Serra
Contact: http://www.JamesSerra.com
James Serra is a big data and data warehousing solution architect at Microsoft. He is a thought leader in the use and application of Big Data and advanced analytics. Previously, James was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 35 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker. He is the author of the book “Reporting with Microsoft SQL Server 2012”.
Daniel Bowlin
Twitter: - @SQLBI_Dan
LinkedIn: Daniel Bowlin
Contact: http://www.danielbowlin.com/
I am a data integration developer at Time Warner Cable. I have been working with SQL Server technologies since the late 90s. About 6 years ago I specialized in the SQL Server BI stack. Lately I have been almost exclusively working in SSIS.
Sponsors
The following is a list of sponsors that helped fund the event: