SQLSaturday #395 - Baltimore - BI Edition 2015
Event Date: 05/09/2015 00:00:00
Event Location:
- Loyola University
- 8890 McGaw Road
- Columbia, Maryland
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: Creating solid Power Pivot data models
Abstract: Self-service business intelligence is rapidly gaining popularity among business analysts today. It greatly relieves the problems created by traditional data warehouse implementations, which typically require a long formal development cycle. Using tools such as Microsoft’s Power Pivot, Power Query and Power View alters the process significantly. These tools transform the BI analysis cycle into an agile process that will empower and excite your business analysts.
At the core of every successful data analysis project is a robust data model. In this session, Dan will take you through the process of creating a solid data model in Power Pivot. You will learn how to import data from various sources, combine these in a scalable data model. In addition, you will discover how you can set various properties in the Power Pivot model to enhance the user experience when they create interactive visualisations of the data in Power View.
Speaker(s):
- Dan Clark
Track and Room: BI 1 - BI 1 - Room 359
Title: Normalize because you need it
Abstract: When you design a Transactional System, learn to make decisions on what to normalize based on business rules, not just on the basis of the 1NF through 6NF (nothing wrong with the rules, but I do encourage that you understand your data as well as the rules).
For example, do you need to which of the two addresses and order was shipped to? Which credit card out of the three that you have on file was used on the 106th order for this customer?
My talk is based on breaking out a different table because you need to keep track of the data - when, as a part of your design or maintenance, it dawns on you that this particular piece of data is relevant to the present, and to past events, and needs to be kept track of.
I back my suggestions with experience from designing Transactional Database Systems with 600+ tables used to keep track of multiple threads of information, passing relevant information on to efficient reporting structures.
Speaker(s):
- Raj More
Track and Room: DEV - DEV - Room 360
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 3 - BI 3 - Room 363
Title: Automating Your SSIS Design Pattern for Faster Development
Abstract: Once you finish designing the SSIS packages needed for your project, the process of creating those packages is mostly redundant and time-consuming. As the source or target systems go through changes (even as small as a column rename), you’re forced to modify the packages.
BI Markup Language (BIML), which is a free plugin, removes the pain-points involved in manual development by programmatically generating packages. In this session, you’ll learn the basics of BIML and see how you can use it along with metadata to create packages automatically. You’ll also see how easy it is to regenerate the packages when the system changes. You’ll leave the session with knowledge of BIML’s building blocks and a principle I call “D[ee]MOB” that helps you automate SSIS development in your environment.
Speaker(s):
- Samuel Vanga
Track and Room: BI 3 - BI 3 - Room 363
Title: Automated SQL Server installation and configuration using PowerShell
Abstract: Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process. PowerShell scripts can greatly reduce the time required to complete the process. They can also ensure build standardization throughout your SQL environment. In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of a SQL Server.
Speaker(s):
- Jamie Wick
Track and Room: DBA - DBA - Room 362
Title: Lights, Camera, Action: Introduction to Creating and Delivering Presentations
Abstract: Sharing your technical knowledge can be a gift for both you and others. But how would you share your knowledge through a presentation? There are so many things to consider: what topic to discuss, where should you present, and should you really imagine the audience naked. This presentation covers these topics, along with much more. Before long, you too can share the gift of presenting!
Speaker(s):
- Jessica Moss
Track and Room: PRO - PRO - Room 304
Title: Using Common Table Expressions (CTE)
Abstract: Common Table Expressions (CTE) are a temporary result set used within an SQL statement, such as SELECT, INSERT, UPDATE, or DELETE, that can be used in place of a subquery and can help simplify more complex queries such as when joining to the same result set multiple times.
We’ll begin with an overview of how a Common Table Expression is constructed. Then we’ll build some queries using derived tables, and as the queries we build get more unwieldy, demonstrate how the query can be simplified by the use of a CTE.
Speaker(s):
- Ben Galluzzo
Track and Room: DEV - DEV - Room 360
Title: Cisco: Optimize Your SQL Server 2014 Workloads with Cisco UCS
Abstract: Eric Simpson, Cisco
Learn about Cisco Unified Computing System (UCS) and why it is an optimal platform for Microsoft SQL Server. During this session we’ll discuss key differentiators that place Cisco well ahead of the competition. Learn about UCS’ management model, Service Profiles, Virtual Interface Adapters, and how they help to simplify and standardize SQL Server deployments. We will also discuss how these differentiators drastically reduce deployment and recovery times, and how UCS provides the best of class hardware platform that can help to achieve the highest levels of consolidation and performance for both virtual and bare metal SQL Server implementations.
Speaker(s):
- Event Sponsor
Track and Room: Reserved - DBA - Room 362
Title: SQL Server Internals Party: Storage, Memory and the Query Life-cycle
Abstract: Come meet the Internals of SQL Server at this special get-together! In this presentation we will cover the basics of data storage and querying with SQL Server. We will cover how data is stored in pages and extents and how that translates to data reads/writes with the storage system. Additionally, we will explore how different queries are processed by SQL Server and how the query life cycle works in general. Finally we will cover disk storage and memory and tie it all together. This session is intended to be broad and to give a general overview of how a query is processed in SQL Server and how storage and memory play a part in that. Everyone is invited to this introductory level presentation and should be appealing to DBAs, DB BI Developers and System Administrators. Party hats not included, rated G for Geeks.
Speaker(s):
- Ayman El-Ghazali
Track and Room: DEV - DEV - Room 360
Title: A “101” Overview of Microsoft Power BI for Office 365
Abstract: In this session we will do a demo-driven “101” level tour of Microsoft Power BI for Office 365, a solution hosted in the Microsoft Enterprise Cloud. We will take a look at the rich set of PowerBI capabilities, particularly the self-service BI solutions offered through Excel and Office 365. We will also take a look at ways to present levels of data analysis and data visualizations which can bring together deep levels of data insight . We will also discuss a “how to” list to get started as well as the Power BI for Office 365. This session if perfect for business / data analysts, data professionals whom are looking for a session to cover the fundamentals and take away enough information to get you jump started into the right direction.
Speaker(s):
- Timothy McAliley
Track and Room: BI 1 - BI 1 - Room 359
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 3 - PRO - Room 304
Title: 3 Ways for Getting Data from SharePoint : SSIS, Excel and Access
Abstract: Need to report on some data from SharePoint? We’ll look at three different techniques to pull data from a SharePoint Server. We’ll start with SSIS and the SharePoint List Source and Destinations. Next, we’ll use Excel to connect to various SharePoint lists (both online and on premise), and finally we’ll use Microsoft Access to do the same thing (and throw in the capability to do updates as well). At the end of the talk, we’ll have three different ways to get data from SharePoint.
Speaker(s):
- David Patrick
Track and Room: BI 2 - BI 2 - Room 361
Title: Analysis Services: Multidimensional vs Tabular
Abstract: The difference between Analysis Services Multidimensional versus Analysis Service Tabular can be difficult to understand for both new and seasoned Microsoft business intelligence developers. However, this understanding helps you to pick the model type that will provide the best possible solution for your end users. This session will describe each model type, list the pros and cons of each model type, and show developer and end user functionality for both model types. After this session, you will be able to successfully pick the right Analysis Services model type for you.
Speaker(s):
- Jessica Moss
Track and Room: BI 1 - BI 1 - Room 359
Title: ETL Design - Staging
Abstract: The staging area of the data warehouse is an often under-utilized tool in the ETL developers tool belt. It can be used to optimize ETL performance while limiting impact on source systems. It can be used to identify data quality concerns before they hit the target load process. It can be used as a supplemental repository for unintegrated data. This discussion will cover several common and some not-so-common patterns in the design and use of the stage environment within the ETL process. The audience will come away with new ideas and core concepts to put to immediate use.
Speaker(s):
- Philip Noakes
Track and Room: BI 3 - BI 3 - Room 363
Title: Hacking Expos#233; - Using SSL to Protect SQL Connections
Abstract: Are you someone (A DBA, Developer, etc) that connects to SQL Server to use data? You probably hear a lot about how protected your database can be when at rest. But what about when you connect to SQL and start running some queries? Using a simple hacking technique we will dig into some packets on our network and see what’s in them. You may be shocked! Then we will create a self-signed SSL certificate, use it to encrypt our connections on the SQL Server, and see the actual changes in the packet as hackers would. *Warning - do not try some of these demos at work without proper permissions as hacking techniques are used.
Speaker(s):
- Chris Bell
Track and Room: DBA - DBA - Room 362
Title: Micron Presenting
Abstract: Sponsor Session
Speaker(s):
- Event Sponsor
Track and Room: Reserved - BI 2 - Room 361
Title: SQL Clinic Part 2
Abstract: SQL Clinic is an open board discussion lead by couple of Microsoft field engineers. If you have any SQL related problem or question, you can go there and ask and get an answer for free.
If you do not have problems or questions you can just stay there and learn what kind of problems other people have in their environments.
Speaker(s):
- Harsh Deep Singh
Track and Room: PRO - PRO - Room 304
Title: Intro to Power BI
Abstract: In this session, we’ll review PowerQuery, PowerPivot, PowerMap and PowerView, and see how to get started developing with these tools. Microsoft is betting on these Self Service BI tools - and rightly so. We’ll see how it can help you automate even the mundane things that you do at work, and expand on this foundation towards more advanced development using DAX.
Speaker(s):
- Azhagappan Arunachalam
Track and Room: BI 1 - BI 1 - Room 359
Title: MDM with Profisee. Usage, Value and First Steps
Abstract: Overview of MDM, Profisee, value of our solution, how organizations are using MDM, and how you can get started with an MDM project
Speaker(s):
- Event Sponsor
Track and Room: Reserved - BI 1 - Room 359
Title: Optimizing your data warehouse for OLAP Processing
Abstract: Analysis Services have become a major part of upper management daily decision making activities. However, with our DW sizes reaching multiple terabytes minimizing time required to process our data has become our top priority. In this session, we will cover the options we have as DBA’s to improve the performance of our DW processing time. We will look at features and general best practices available to us within SSAS as well as enterprise level features within the database engine itself and how aligning them to work side by side would yield us at least 200% improvement in our processing time.
Speaker(s):
- Konstantin Melamud
Track and Room: DBA - DBA - Room 362
Title: SQL Clinic Part 3
Abstract: SQL Clinic is an open board discussion lead by couple of Microsoft field engineers. If you have any SQL related problem or question, you can go there and ask and get an answer for free.
If you do not have problems or questions you can just stay there and learn what kind of problems other people have in their environments.
Speaker(s):
- Harsh Deep Singh
Track and Room: PRO - PRO - Room 304
Title: The Quest for the Golden Record: MDM Best Practices
Abstract: In this session, we will focus on how to formulate a Master Data Management (MDM) strategy and build a solution to find the single version of the truth, aka the Golden Record. While these techniques can apply to any domain, we will demonstrate building a sample customer domain in this session, showing how to leverage SQL Server Master Data Services(MDS) and other tools for data quality, matching, and de-duplication across multiple data sources.
Speaker(s):
- Brian Benzel
Track and Room: BI 1 - BI 1 - Room 359
Title: Windowing Functions in SQL Server 2012
Abstract: SQL Server 2012 brings with it nearly full ANSI compliance with the windowing functions. Come to this code filled session to learn about all of the windowing functions in SQL Server 2012: Ranking functions, changes for windowing in the Aggregate functions and the new Analytic functions. We’ll examine how this latest implementation of the windowing functions allows us to perform running and sliding aggregations; retrieve data from adjacent rows in the partition, and much more – all without self-joins back to the source table.
Speaker(s):
- Wayne Sheffield
Track and Room: DEV - DEV - Room 360
Title: Modeling For Tableau
Abstract: Business Intelligence tools make it easy to create reports that let your users absorb information quickly and easily, but what can you do to make it easy for the BI tools, and their developers, process information from your data warehouse quickly and easily? Learn about how to shape your data to work with Tableau’s Measures.
Speaker(s):
- Jennifer Kenney
Track and Room: BI 2 - BI 2 - Room 361
Title: Introduction to APS
Abstract: We will have a conversation of what is APS and specifically how it differs from the normal SQL Server instances we work with daily. By the end of this talk, you will have a very good understanding of the differences between the APS’ MPP architecture compared to SMP SQL Server. We will cover the topic of Polybase and what Hadoop Components are supported by Polybase.
Speaker(s):
- Warren Sifre
Track and Room: BI 2 - BI 2 - Room 361
Title: Securing Multi-Database Reports
Abstract: It is difficult enough to implement database security when dealing with only a single database. If multiple databases are involved, the task of providing a security model that follows industry best practices seems insurmountable.
In this session, we will do a quick review of access security best practices and then dive into the four different methods a DBA can use to tighten cross database access security. For each one we will walk through a demo and talk about how to implement it in your own environment. We will close the session with a discussion about the advantages and disadvantages of the four methods.
Speaker(s):
- Sebastian Meine
Track and Room: DBA - DBA - Room 362
Title: Tips and Tricks for Managing SharePoint Databases
Abstract: SharePoint, the 800-pound gorilla that has probably eaten a great deal of space on your SQL Server, has certain consistent idiosyncrasies that can make trouble for a DBA. This session will go over some of the problems SharePoint frequently causes, or that you may encounter in managing databases for it.
Speaker(s):
- Alara Rogers
Track and Room: BI 2 - BI 2 - Room 361
Title: SSRS 101 to 301: Learn how to build Simple and Intermediate level SSRS Report
Abstract: We will start with basic reporting services report and work up to intermediate level. If time allows, we will cover some advance feature. We will also cover some “Gotchas” as we move along. The session will be heavily demo based.
Speaker(s):
- Ravi Kumar
Track and Room: BI 2 - BI 2 - Room 361
Title: Execution Plans 101
Abstract: Do you have a query that you want to tune, but don’t know where to start? Execution plans can be a great starting point for understanding what your query is doing under the hood. This course covers the bare bones basics: what an execution plan is, how to run them, how to read them, 5 common troublemakers, and where to learn more. If an execution plan looks like hieroglyphics, this course is for you!
Speaker(s):
- Eugene Meidinger
Track and Room: DBA - DBA - Room 362
Title: MongoDB for SQL Developers and Accessing MongoDB with SSIS
Abstract: Just because NoSQL is taking off doesn’t mean that SQL developers are left behind. We’ll begin with an overview of what MongoDB and NoSQL is and how it relates to our existing world of SQL. Then, we’ll go over some of terminology in MongoDB and how these terms map to the SQL world. Lastly, we’ll demonstrate how we can work with MongoDB from SSIS.
Speaker(s):
- Ben Galluzzo
Track and Room: BI 3 - BI 3 - Room 363
Title: Microsoft Presenting
Abstract: Sponsor Session
Speaker(s):
- Event Sponsor
Track and Room: Reserved - DEV - Room 360
Title: Getting in Sync With The Developer Next To You
Abstract: Using everyday tools, some free and some paid, you and the developers working with you might begin to feel out of sync in your efforts, over time. In this session, we’ll review both tools and some suggested guidelines to help close the gap between today and where you want to be with the developers around you, whether that’s immediate and technical or longer term and relational, or both.
Speaker(s):
- Brad McKuhen
Track and Room: DEV - DEV - Room 360
Title: SQL Clinic Part 1
Abstract: SQL Clinic is an open board discussion lead by couple of Microsoft field engineers. If you have any SQL related problem or question, you can go there and ask and get an answer for free.
If you do not have problems or questions you can just stay there and learn what kind of problems other people have in their environments.
Speaker(s):
- Harsh Deep Singh
Track and Room: PRO - PRO - Room 304
Title: ETL not ELT! Common mistakes and misconceptions about SSIS
Abstract: Explore some of the mistakes and misconceptions DBAs tend to have about SSIS. Also look at the performance and scalability of ETL vs ELT with real world examples and sample code.
Speaker(s):
- Paul Rizza
Track and Room: BI 3 - BI 3 - Room 363
Title: Dealing With Difficult People
Abstract: John knows everything and goes out of his way to correct you at every turn. Mary is agreeable to a fault and just placates everyone. Mike is full of doom and gloom and whines constantly. Are these your co-workers? Relatives? Frenemies? You? Learn two golden rules to reduce the stress produced by the difficult people in your life.
Speaker(s):
- Gigi Bell
Track and Room: PRO - PRO - Room 304
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
David Patrick
Twitter: - DavidEPatrick
LinkedIn: David Patrick
Contact: http://www.madsharepoint.com
Dave has been developing database applications for over 25 years. An MCT since 2001, he has taught many classes from Intro to Visual Interdev to Advanced SharePoint Development. Dave runs two user groups, the Maryland and Pennsylvania Microsoft Developers User Group, www.mapamdug.com, and MAD SharePoint, www.madsharepoint.com. Dave does SharePoint training and development for DSA, Inc., a DoD contractor that does great work for the Army over at Aberdeen Proving Ground. Dave is also an MVP.
Alara Rogers
Contact: http://www.liquidmercurysolutions.com
Principal Analyst | Liquid Mercury Solutions Alara Rogers is commonly believed to be a brain in a tank, but this is in fact not true; she is a space alien. Alara entered the world of IT via database marketing and analytics on consumer demographic databases stored on mainframes, but soon discovered the joy of SQL Server, and has focused on BI, SQL development, and SharePoint as a platform for BI ever since.
Paul Rizza
Twitter: - @PaulRizzaSQL
LinkedIn: Paul Rizza
Contact: http://blogs.msdn.com/b/paulrizza/
Paul Rizza is a Senior Consultant at Microsoft Consulting Services (MCS), Lead on the MCS SQL Hiring Team, and has over 25 years’ experience consulting, teaching and developing on SQL Server platforms. Paul’s expertise includes ETLs, Dimensional modeling, architecting highly available SQL environments and performance tuning. Paul has an Undergraduate degree from UMBC and a Master’s degree both in Computer Science with a concentration in Database Theory from Johns Hopkins University.
Harsh Deep Singh
Twitter: - @harshdeepsingh
LinkedIn: Harsh Deep Singh
Contact: http://blogs.msdn.com/b/sqljourney/
HarshDeep Singh is a SQL Server Premier Field Engineer for Microsoft in the North America region. He has worked extensively on SQL Server with various Microsoft customers. He contributes to the community by speaking at technical events, as well as through his blog (http://blogs.msdn.com/b/sqljourney/).
Ben Galluzzo
Twitter: - BenGalluzzo
LinkedIn: Ben Galluzzo
Contact: http://www.bengalluzzo.com/
I#39;m a software developer with a passion for anything that beeps and blinks. I first delved into databases on an Atari 800XL, and I never stopped looking forward since. I often have my hands in everything from databases and software to circuits and embedded systems. When I#39;m not beeping or blinking, I#39;m often spending time with my family, woodworking, building things, or outdoors.
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.
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.
Brad McKuhen
Contact: http://www.bradmckuhen.com
Brad McKuhen is a SQL Server Architect for Microtech Technologies, in the Washington, DC area. He has been working with SQL Server in some form or another since SQL Server 2000, and has been in IT for over 20 years. In his spare time, you#39;ll find him devoted to his family#39;s activities, and studying for the next certification.
Samuel Vanga
Twitter: - https://twitter.com/SamuelVanga
LinkedIn: Samuel Vanga
Contact: http://SamuelVanga.com
Sam Vanga helps business people solve their data problems and enables them make data-driven-decisions. His specialties include data integration, data warehouse and database development, and BI design. Sam blogs at http://SamuelVanga.com.
Chris Bell
Twitter: - @cbelldba
LinkedIn: Chris Bell
Contact: https://www.wateroxconsulting.com/
Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do ‘Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris’ thoughts and technical community activities at WaterOxConsulting.com.
Ben Galluzzo
Twitter: - BenGalluzzo
LinkedIn: Ben Galluzzo
Contact: http://www.bengalluzzo.com/
I#39;m a software developer with a passion for anything that beeps and blinks. I first delved into databases on an Atari 800XL, and I never stopped looking forward since. I often have my hands in everything from databases and software to circuits and embedded systems. When I#39;m not beeping or blinking, I#39;m often spending time with my family, woodworking, building things, or outdoors.
Gigi Bell
Twitter: - @sqlspouse
LinkedIn: Gigi Bell
Known across the country as the SQL Registration Princess, Gigi Bell actually has vast experience in training and development. Being married to a SQL DBA, she knows enough about SQL to be dangerous, but her real passion is helping people learn and achieve their true potential. She has spoken at SQLSaturdays across the country since 2014.
Event Sponsor
Created to speak for sponsor#39;s at the event in Baltimore
Azhagappan Arunachalam
Az Arunachalam has been working with SQL server since v4.21/SQLNT. He started his career with troubleshooting at chip level, worked as a network engineer managing Novell NetWare networks, graduated into managing Windows NT, moved onto development, administered databases, and is currently working as a database architect. He#39;s excited about all the cloud offerings that Microsoft and others have made possible, and in sharing his findings with aspiring data enthusiasts.
Jamie Wick
Twitter: - Jamie_Wick
LinkedIn: Jamie Wick
Contact: http://blog.wicktech.net
Jamie Wick is the Systems Database Engineer for The College of William Mary and has been working with SQL databases for the past 10+ years. His background includes working for several years as a SQL SysAdmin for the University of Queensland (Australia), a Masters degree in Computer Information Systems from Boston University, and assorted Microsoft SQL certifications. He is the Chapter Leader of the Richmond SQL Server Users Group, a volunteer and speaker at regional SQL events (User Groups/SQLSaturdays), helps run the SQLSaturday RVA events, and is an avid photographer.
Event Sponsor
Created to speak for sponsor#39;s at the event in Baltimore
Ravi Kumar
Twitter: - @sqlravi
I have over 12 years of experience working with SQL Server and Business Intelligence Technology. My current focus is cloud technologies: Power BI, Azure Analysis Services, Azure SQL Data Warehouse, Azure Data Factory. As a PFE at Microsoft, I regularly deliver 2 - 4 day training workshops.
Jennifer Kenney
Jennifer Kenney has been with CapTech Consulting for two years, specializing in Data Architecture with Microsoft SQL Server. She has fifteen years of experience with SQL Server. During that time, she’s worked with querying transactional databases, modeling both transactional databases and data warehouses, data integration into both transactional databases and data warehouses, change management, and administration.
Jennifer lives in Goochland, VA with her husband Brian and their beagles.
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.
Harsh Deep Singh
Twitter: - @harshdeepsingh
LinkedIn: Harsh Deep Singh
Contact: http://blogs.msdn.com/b/sqljourney/
HarshDeep Singh is a SQL Server Premier Field Engineer for Microsoft in the North America region. He has worked extensively on SQL Server with various Microsoft customers. He contributes to the community by speaking at technical events, as well as through his blog (http://blogs.msdn.com/b/sqljourney/).
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.
Event Sponsor
Created to speak for sponsor#39;s at the event in Baltimore
Brian Benzel
Brian is Regional Sales Director responsible for driving sales and onboarding new customers in PA, NJ, NY, DE, MD, and DC for Profisee. Profisee is the successor to the company Stratature that built the SQL Server Master Data Services (MDS) product which Microsoft acquired in 2007. Profisee focuses on Master Data Management (MDM) and is a Microsoft Gold ISV Partner providing solutions built on MDS. Brian was formerly with Microsoft Corporation as a Senior Account Manager for 7 years.
Konstantin Melamud
Twitter: - @kmelamud
Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQLSaturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.
Philip Noakes
Contact: http://www.captechconsulting.com/
Philip Noakes is a data integration specialist with experience in all facets of SQL Server. He has been with CapTech Consulting for the last nine years and is an MCITP in SQL Server Business Intelligence. Philip hails from the Short Pump area where he lives with his wife and 2 daughters.
Wayne Sheffield
Twitter: - @DBAWayne
LinkedIn: Wayne Sheffield
Contact: http://blog.waynesheffield.com/wayne
Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne
Eugene Meidinger
Twitter: - @sqlgene
Contact: http://www.sqlgene.com
Eugene Meidinger works as a BI consultant and full time Pluralsight author. He currently focuses on content on Power BI and related products. He also leads the Pittsburgh Power BI User Group. He is certified in querying and administering SQL Server.
Event Sponsor
Created to speak for sponsor#39;s at the event in Baltimore
Ayman El-Ghazali
Twitter: - thesqlpro
LinkedIn: Ayman El-Ghazali
Contact: http://www.thesqlpro.com
Ayman is a passionate SQL Server DBA, Developer, and BI Developer. His passion for technology started when he was a young boy playing DOS games on his father’s computer. He can be reached via his blog or twitter handle and is looking forward to connecting with other SQL Geeks.
Timothy McAliley
Twitter: - sysframeworks
LinkedIn: Timothy McAliley
I am currently a Microsoft Cloud Solutions Architect in the Washington, DC area. Previously, I was a Microsoft Technology Solutions Professional (TSP), a Microsoft Account Technology Strategist and a SQL Server Premier Field Engineer. Prior to Microsoft, I was a Technical Trainer and DBA in the Enterprise Security Group at Symantec . I have been in IT for over 20 years. My particular interests are IT operations, IT auditing, IT audit frameworks, IT service management (ITSM), ITIL, information security, project management, and database/application tier high availability solutions. I also co-run the Northern Virginia SQL Server User Group ( @novasl) and also co-run the Azure Datafest events.
Harsh Deep Singh
Twitter: - @harshdeepsingh
LinkedIn: Harsh Deep Singh
Contact: http://blogs.msdn.com/b/sqljourney/
HarshDeep Singh is a SQL Server Premier Field Engineer for Microsoft in the North America region. He has worked extensively on SQL Server with various Microsoft customers. He contributes to the community by speaking at technical events, as well as through his blog (http://blogs.msdn.com/b/sqljourney/).
Raj More
I am a Business Intelligence developer, having transitioned over from transactional systems a few years ago. I find business use of data extremely fascinating. I have recently moved to Baltimore, and I love life here.
Sebastian Meine
Twitter: - @sqlity
LinkedIn: Sebastian Meine
Contact: http://sqlity.net/en/blog/
Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.
Warren Sifre
Twitter: - WAS_SQL
LinkedIn: Warren Sifre
Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com
Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.
Sponsors
The following is a list of sponsors that helped fund the event: