SQLSaturday #518 - Maine 2016
Event Date: 06/04/2016 00:00:00
Event Location:
- USM Wishcamper Center
- 34 Bedford Street
- Portland, Maine
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: Azure Machine Learning – Bringing Advanced Analytics to the Masses
Abstract: While Machine Learning is not new, it has never been easy to implement. Azure Machine Learning (AML) aims to provide a set of tools that are easier to use and once a model is created easier to consume by client applications. At the core of AML is ML Studio. ML Studio provides an easy to use graphical tool that allows you to control the process from pre-processing the data, to applying learning algorithms, testing the model, and finally deploying the model for use by client applications. This session guides you through the process of creating and deploying a ML model. In addition it will demonstrate how client applications can easily use the model once it is deployed.
Speaker(s):
- Dan Clark
Track and Room: Cloud Application Development Deployment - 103
Title: Organizational Security Compliance with SQL 2012 through 2016
Abstract: You need to deal with more security requirements in your role. How can SQL Server features help you comply? We will delve into Audit, Compliance, and Encryption. New 2016 features like Always Encrypted will be detailed at the end.
Speaker(s):
- George Walters
Track and Room: Enterprise Database Administration Deployment - 113
Title: Be Friendly to SQL Server with TSQL Best Practices
Abstract: TSQL is a necessity when interacting with SQL Server so knowing can be half the battle. Performance is always good as the database starts to grow, but building in resilience when you begin is a greater advantage than refactoring. I will go over 5 key things to know when you write TSQL, use DataTypes and/or variables in comparisons and you will also learn about the procedure cache and how to avoid pitfalls there. This is a beginners session but the concepts in this session are a great foundation to begin with. If you are looking for a solid foundation to build on and need the basics to start, this session is definitely for you.
Speaker(s):
- Ben Miller
Track and Room: Application Database Development - 211
Title: Maintenance Plans: Planning to Fail
Abstract: SQL Server MVP Mike Hillwig hates using maintenance plans. He believes they don’t scale well and frequently lack flexibility. Maintenance plans are easy to set up and deploy. Deploying them to many servers is cumbersome. Modifying them on multiple servers at once is an exercise in futility.
The dirty little secret is that anything you can do with a maintenance plan can be done with T-SQL. And by leveraging several community-based solutions, you can accomplish anything without maintenance plans.
Speaker(s):
- Mike Hillwig
Track and Room: Enterprise Database Administration Deployment - 205
Title: SQL Server 2016 R Integration - how do I do it and why would I want to??
Abstract: In SQL Server 2016 we introduce language extension so that you can execute R scripts from within the SQL Server database engine. In this session I will go over the basics of setting up and executing this functionality, discuss the types of problems that you can solve with it, and when you might want to avoid it.
Speaker(s):
- Andy Roberts
Track and Room: Advanced Analysis Techniques - 113
Title: SQL 2016 Upgrade as a Project
Abstract: As DBAs we are often stuck at the mercy of higher ups and Project Managers for completion of our assigned tasks/ projects. In this session we wil actually take an arbitrary application and its affiliated databases and go throught the tasks/resources needed to accomplish the task. We will think and act like a Project Manager and DBA rolled into one. This will surely help you advance your career within organization and help you think ahead of time. We will use the PMI’s approach to a project. We will examine ways to break down the large project into smaller Agile segments. We will look at various documents/forms/reports/steps and phases.
This presentation will lay out this rather complex project into a simple laid out plan.
Speaker(s):
- Paresh Motiwala
Track and Room: BI Platform Architecture, Development Administration - 103
Title: Efficient and Effective coding of Stored Procedures
Abstract: Data does not become information until decision makers are able to view it and make those decisions that affect the enterprise as a whole. Stored procedures are one means of getting the data from the database tables to the reports in an effective and efficient manner. In this hands-on presentation, we shall be looking at best practices with regards to creating and tuning stored procedures. We shall also be discussing parameter sniffing and other gotcha’s that affect us in our daily lives.
Speaker(s):
- Steve Simon
Track and Room: Application Database Development - 211
Title: Taking the pain out of database migrations
Abstract: Database migrations are scary. The migration of a database has many moving pieces and things to think about. Some of those things have nothing to do with the DBA and are outside of their control. However, if these items are not taken into account, it is the DBA that management will hold responsible for the failure.
This session will discuss what you need to take into account to ensure a successful pain free database migration. These steps can be used for a single database, multiple databases, or an entire server. By the end of the session, you will have a checklist of the items you need to consider for a database migration.
Speaker(s):
- Chris Lumnah
Track and Room: Enterprise Database Administration Deployment - 103
Title: Unseen Minions: Improving Parallel Processing in SSIS
Abstract: Some SQL Server Integration Services use cases are too complicated to simply read data from a source and write it to a destination. You could try looking for a third-party framework or components to help, but then again, you might just need to add some knowledge. This session is designed to help you maximize the parallel processing capabilities of SSIS.
We’ll cover in detail alternative methods of managing large workloads by using traditional programming methods, including named pipes, queues, and producers/consumer architecture – all from within SSIS itself. We’ll then cover methods of dividing workloads and preventing bottlenecks, as well as techniques to improve the resource efficiency of SSIS.
Speaker(s):
- Josef Richberg
Track and Room: BI Platform Architecture, Development Administration - 103
Title: Using Powershell to Document SQL Server
Abstract: Most DBAs need to use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects. Even using Visual Studio and Database Projects, not all objects are exportable and live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for moving or recovering a SQL server instance for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, and Server Triggers
Speaker(s):
- George Walkey
Track and Room: Enterprise Database Administration Deployment - 203
Title: An Introduction To Big Data For The SQL Server DBA
Abstract: The boss comes to you and says that he wants to implement big data technologies into your environment. Is this the end of your career with SQL Server? Where do you start learning about this rapidly changing world of big data?
This presentation will answer all those questions, and will introduce you to the concepts that are the driving force behind a move to utilize “big data” technologies. It will introduce you to some of the key vendors and tools that are the most recognized today, which can help get a SQL Server DBA working on these systems very quickly. During the presentation we will cover those scenarios where big data technologies can be helpful, where they really just don’t fit, and why.
Finally, there will be an introduction on how Azure is playing a significant role in this move, and how this could potentially benefit you in your environment.
So, come with an open mind, and be prepared to get excited about what a future with big data might hold for you!
Speaker(s):
- David Benoit
Track and Room: Strategy and Architecture - 203
Title: Database Design: Solving Problems Before they Start!
Abstract: The most effective form of performance optimization is to design your database correctly the first time around. Explore the most important topics in database design and discuss examples of where design mistakes can lead to bad data, poor performance, and other headaches that your future self would love to avoid!
Speaker(s):
- Edward Pollack
Track and Room: Performance - 211
Title: PoshDBA: Practical PowerShell for the DBA
Abstract: Think of all the tools you use in managing your SQL Servers. All those SQL Servers being managed by tools and man that is a lot of clicks. We will show practical scripts and techniques to help you get a handle on all those clicks. Whether you are gathering data or statistics from your SQL Servers or deploying an object to all of them. Configuration items are not excluded from the need for good tools. PowerShell is that tool that will let you get away from all those clicks. Reusable scripts that let you manage all those instances with ease. This session will give you a great start on how to think about admin tasks using PowerShell scripts or modules. Many items are already out there to help you and we will take a good look.
Speaker(s):
- Ben Miller
Track and Room: Enterprise Database Administration Deployment - 205
Title: The Business Intelligence Side of SQL Server
Abstract: This session focuses on Microsoft’s BI capabilities within SQL Server and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. Through several releases, Microsoft dramatically enhanced the Microsoft BI platform. During this session Plus Consulting, one of Microsoft’s top global BI partners, will explore the improvements to SQL Server self-service reporting and talk about creating blended value from your BI platform. We’ll show you why the combination of Microsoft Office, PowerBI and SQL Server are an excellent solution for creating self-service dashboards, scorecards, KPIs, pivots, data exploration and discovery.
Speaker(s):
- Sayed Saeed
Track and Room: BI Information Delivery - 102
Title: Refresh a 1TB+ database in under 10 seconds
Abstract: The presentation covers recoverability options in SQL Server over time. It will take us through many different ways of recovering a large 1TB+ database. It will also walk us through many different options for creating development/test/uat environments. It will highlight the benefits and shortcomings of these options while delivering a business value of each. It will also evaluate a high level ROI of each of these options. Finally, the presentation will focus on an architecture based on SAN technologies with respect to SQL Server. I will demonstrate an architecture put in place resolving many business needs in a financial trading environment, working with large data sets and many different environments. This section will highlight the benefits of using SQL Server together with newer SAN solutions and show the potential for reliability, scalability, and the delivery of a high quality HA/DR solution. That is where things get interesting…
Speaker(s):
- Andrzej Pilacik
Track and Room: Enterprise Database Administration Deployment - 203
Title: The Art of War with Bad Code
Abstract: Let’s face it, many of us are at war with poorly written or poorly tuned queries and processes. There is usually just one of you who has been tasked with managing one or more SQL Server instances while there are hundreds or even thousands of users of which a certain percentage will inevitably write poor code. So you must battle it out to identify the culprits before they wreak too much havoc on your systems. We will see several fairly straightforward techniques to positively identify the culprits and allow you to prioritize your efforts in tuning them to give you the biggest ROI for your time. TSQL and Extended Events code examples will be provided that you can use immediately in your environment to become more productive.
Speaker(s):
- Andrew Kelly
Track and Room: Performance - 211
Title: Virtual SQL Servers. Actual Performance.
Abstract: Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance. This session is packed with many tips and tricks gained from years of experience for getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.
Speaker(s):
- David Klee
Track and Room: Enterprise Database Administration Deployment - 203
Title: Introduction to SQL Server Encryption
Abstract: High-profile attacks by hackers have made the news more and more the past few years, and your database is a prized target! Fortunately SQL Server offers many possible layers of protection, one of which is encryption. This session will cover SQL Server’s encryption capabilities, how they work, and what they have to offer. Topics discussed will include certificates, encryption algorithms, backup encryption, transparent database encryption, and column-level encryption. Attend this session and learn how SQL Server can help you hide your data in plain sight!
Speaker(s):
- Bob Pusateri
Track and Room: Enterprise Database Administration Deployment - 205
Title: APPLY Yourself
Abstract: Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.
Speaker(s):
- Kevin Feasel
Track and Room: Application Database Development - 211
Title: SSRS 2016 - End-to-end Mobile BI on any device
Abstract: Significant enhancements have been made to mobile BI reporting in SSRS 2016. We can now enable users to get business insights, anyway, anywhere and from any device. Your device could be a tablet, smartphone or laptop, which could be running under iOS, Android or Windows. Come to this interactive session and learn how you can do it.
Speaker(s):
- Sunil Kadimdiwan
Track and Room: BI Information Delivery - 113
Title: Beginning Azure
Abstract: The cloud is here! Are you ready? Microsoft, Amazon and others are all vying for your cloud attention. In this session, we will review the different types of cloud platforms available and what they mean to you. We will pay close attention to Microsoft’s Azure platform that offers two hosting solutions. What are these hosting options and what are the differences between them? Most importantly, how do I get started with all of this cloud business? Let’s put SQL Server into the cloud!
Speaker(s):
- Thomas Norman
Track and Room: Cloud Application Development Deployment - 205
Title: New T-SQL Capabilities in SQL Server 2016 and Azure SQL Database
Abstract: Discover the ins and outs of some of the newest capabilities of our favorite data language. From JSON to COMPRESS / DECOMPRESS, from AT TIME ZONE to DATEDIFF_BIG(), and from SESSION_CONTEXT() to new query hints like NO_PERFORMANCE_SPOOL and MIN / MAX_GRANT_PERCENT, as well as some other surprises, you’ll walk away with a long list of reasons to consider upgrading to the latest version or finally trying out Azure SQL Database.
Speaker(s):
- Aaron Bertrand
Track and Room: Application Database Development - 211
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: BI Platform Architecture, Development Administration - 203
Title: Introduction to R Programming
Abstract: In this session you will learn the basics of the R programming language. We will cover R syntax and constructs while demonstrating why R is an ideal language for analytics. Then we will delve into the amazing presentation features of R and how easy it is to visualize your data. R is here to stay and growing. Microsoft is adding R support to SQL Server 2016 so don’t miss this chance to see why R has become such a phenomena.
Speaker(s):
- Bryan Cafferky
Track and Room: Analytics and Visualization - 205
Title: Optimizing SQL Server and Databases for large Fact Tables
Abstract: A session full of demos demonstrating how SQL Server startup parameters, trace flags and the create database and alter database command when used correctly for the underlying hardware can make scanning your fact tables much faster.
We will also as a side effect explore the Mary Go Round query feature and find ways to bulk load data faster and how to load from an OLTP system with zero impact to it.
Speaker(s):
- Thomas Grohser
Track and Room: Enterprise Database Administration Deployment - 113
Title: SQL Server and Pure Storage: Redefining Database Engineering
Abstract: Please join SQL Server MVP and MCM Argenis Fernandez for an eye-opening session on how the innovative, industry-disruptive tech in the Pure Storage FlashArray helps your business do everything faster, easier. Faster transactional workloads, analytics, backups and maintenance, all without the pain of having to tweak a thousand knobs to get things to work. Finally a storage array you can love to use, and be proud to own! Come see what the fuss is all about.
Speaker(s):
- Argenis Fernandez
Track and Room: Strategy and Architecture - 211
Title: What Makes SSIS Tick? A Look at Internals for Performance
Abstract: You can build basic SSIS packages, or you can build packages that perform. In this session, you’ll learn about the internals of Integration Services. Using this knowledge, we’ll review the DOs and DON’Ts that lead to improved ETL performance. (This session applies to SSIS versions from 2008, 2012, 2014 and 2016.)
Speaker(s):
- Ravi Kumar
Track and Room: BI Platform Architecture, Development Administration - 113
Title: Building your ETL Framework with Biml
Abstract: Biml makes SSIS development faster and creates reusable modules that help you apply a consistent ETL framework across solutions. In this session, we will review some Biml basics and how to use it to build an SSIS package. You’ll see how Biml allows you to avoid corrupted metadata and the tedious repetition of implementing simple SSIS patterns, freeing you up to take on new and interesting ETL challenges. Then we will review how to use it to create a consistent and extensible ETL framework that benefits everyone who creates or supports your SSIS projects.
Speaker(s):
- Meagan Longoria
Track and Room: BI Platform Architecture, Development Administration - 203
Title: Putting the Squeeze on Large Tables: Improve Performance and Save Space with Data Compression
Abstract: Your databases are growing faster than your servers. Large tables consume ever-increasing amounts of storage while putting a drag on query response time. What’s a DBA to do? The data compression feature of SQL Server is one tool DBAs can use to save storage space and improve performance. In this presentation you will learn about the types of data compression, how to determine when compression is the right option, and how to make the magic happen
Speaker(s):
- Justin Randall
Track and Room: Enterprise Database Administration Deployment - 103
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
Kevin Feasel
Twitter: - feaselkl
LinkedIn: Kevin Feasel
Contact: http://www.catallaxyservices.com
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.
Aaron Bertrand
Twitter: - @AaronBertrand
Contact: https://blogs.sentryone.com/author/AaronBertrand
Aaron, Product Manager at SentryOne, produces performance and optimization tools for the entire Microsoft data platform, as well as Plan Explorer, a free tool for SQL Server execution plan analysis. In his spare time, he is either playing volleyball, curling, blogging at sqlperformance.com and blogs.sentryone.com, or contributing to SQL Server conversations on Twitter and dba.stackexchange.com. He has worked with SQL Server since 6.5 and has been an MVP since 1997.
Meagan Longoria
Twitter: - mmarie
LinkedIn: Meagan Longoria
Contact: http://datasavvy.me
Meagan Longoria is a business intelligence consultant with Denny Cherry Associates, and lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).
Bob Pusateri
Twitter: - @SQLBob
LinkedIn: Bob Pusateri
Contact: http://www.BobPusateri.com
Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years of experience on SQL Server. His interests involve internals, performance optimization, and cloud technologies. He is an active member of two Chicago-area PASS Local Groups, a community speaker, and maintains a web presence through both Twitter (@SQLBob) and his blog (bobpusateri.com).
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.
Andrew Kelly
Twitter: - gunneyk
Contact: http://sqlblog.com/blogs/andrew_kelly/default.aspx
Andrew J. Kelly is a Senior Technical Subject Matter Expert with B3 Group Inc. and lives in Clarkdale, AZ. He has over 20 years experience with relational databases and application development, but his main focus now is SQL Server. In addition to general SQL Server training and mentoring, he specializes in performance, scalability, and maintainability of large-scale SQL Servers. He is a regular speaker at conferences and user groups and was a SQL Server / Data Platform MVP for 18 years.
Justin Randall
Twitter: - jh_randall
LinkedIn: Justin Randall
Contact: http://blogs.sqlsentry.com/justinrandall
Justin Randall is a Senior Consultant at SQL Sentry, LLC. He has over 30 years of data management experience in a variety of roles from Enterprise Data Modeler to DBA, supporting development in DB2, Sybase, and SQL Server. Justin frequently speaks at SQL Server User Group meetings and SQLSaturdays, and has presented at several SQLintersection conferences. His current professional interests are SQL Server performance monitoring and tuning, and career development.
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
David Klee
Twitter: - kleegeek
LinkedIn: David Klee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.
Edward Pollack
Twitter: - EdwardPollack
LinkedIn: Edward Pollack
Contact: https://www.sqlshack.com/author/edward-pollack/
Ed Pollack has over 20 years of experience in database and systems administration, which has developed his passion for performance optimization, database design, and making things go faster. He has spoken at many SQLSaturdays, 24 Hours of PASS, and PASS Summit. This led him to organize SQLSaturday Albany, which has become an annual event for New York’s Capital Region. Sharing these experiences with the community is a top priority, and encouraging everyone to take the leap into public speaking and engaging others, a passion. In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.
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
David Benoit
Twitter: - SQLTentmaker
LinkedIn: David Benoit
David Benoit (@SQLTentmaker) leads a team of data platform architects at a large financial tech company. He has developed teams that have transitioned from standard on-prem operations to engineering teams supporting scale out platforms in the cloud.
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
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.
Andy Roberts
LinkedIn: Andy Roberts
Contact: http://blogs.msdn.com/andyroberts
Andy Roberts is a currently a Data Platform Specialist for Microsoft in the Northeast district and has spent 12 years as a consultant for Microsoft Consulting Services. As a consultant Andy assisted customers in implementing mission critical OLTP and DW/BI solutions on SQL Server. Andy wore many hats as a consultant including application developer, solution architect, mentor to development teams, mentor to DBAs, BI lead, SCRUM Master, and the guy-that-knows-a-bunch-of-stuff-about Microsoft.
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.
Sayed Saeed
LinkedIn: Sayed Saeed
Contact: http://www.plusconsulting.com/blog/
Sayed Saeed is the Business Intelligence Practice Director at Plus Consulting. He is highly proficient in developing targeted BI solutions for clients and offers solid knowledge and experience in BI products that help organizations better leverage information to effectively manage business. He is a Microsoft Certified Solutions Expert in Business Intelligence as well as Oracle Certified Professional.
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
Chris Lumnah
Twitter: - @lumnah
LinkedIn: Chris Lumnah
Chris Lumnah began working in the IT as a programmer in 1996. He ended up becoming a SQL DBA out of necessity 15 years ago. He has worked on SQL Server version 2000 thru 2017. He likes to continue to use his knowledge of programming to create more automated solutions to assist him and his team to be more proactive. Chris lives in Providence, RI and is currently a SQL Server Solutions Architect at Rubrik Inc.
Andrzej Pilacik
Twitter: - cypisek77
LinkedIn: Andrzej Pilacik
Database Manger / Solution Architect at BraceBridge Capital 15 years of experience in Database Platforms, SQL Server 7.0 - 2019, PostgreSQL, Redis, Oracle Microsoft Certified Professional - SQL Server Working with large data in Healthcare, Insurance, and Financial Sectors Architecting HA/DR solutions Developing frameworks around DEVOPS Working with DW, SSIS, SSRS
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.
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.
Ben Miller
Twitter: - DBAduck
LinkedIn: Ben Miller
Contact: https://dbaduck.com
Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.
Argenis Fernandez
Twitter: - DBArgenis
LinkedIn: Argenis Fernandez
Contact: http://blog.purestorage.com/author/argenisfernandez/
Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.
Ben Miller
Twitter: - DBAduck
LinkedIn: Ben Miller
Contact: https://dbaduck.com
Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.
Thomas Norman
Twitter: - ArmorDba
LinkedIn: Thomas Norman
Contact: https://armordba.com/
Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.
George Walkey
Twitter: - sqlbytehd
Contact: http://insyncva.com
SQL Server DBA, Developer, IT Manager, Business Owner from the Richmond, VA USA Area Interested in pushing the limits of both hardware software and my own brain
Josef Richberg
Twitter: - sqlrunner
LinkedIn: Josef Richberg
Contact: http://josefrichberg.com
I have over 29 years in the world of RDBMS. I have in-depth knowledge of Microsoft SQL Server and the Azure platform (Data Factories, Logic Apps, Functions,Event Grids…) . I am fiercely passionate about my work.
I am currently developing a new Azure ecosystem for Penguin Random House. This includes moving load processes to Azure Logic Apps and Data Factory pipelines, leveraging Azure Functions, and pushing the new SQL Services to the limit.
I am the creator of the Enhanced Threading Framework (ETF) for SSIS. I presented at PASS 2013 on advanced SSIS techniques: http://www.sqlpass.org/summit/2013/Sessions/SessionDetails.aspx?sid=4845 and was awarded ‘2009 Exceptional DBA of the Year’, by RedGate and my peers.
Sponsors
The following is a list of sponsors that helped fund the event: