SQLSaturday #717 - Wheeling 2018
Event Date: 04/28/2018 00:00:00
Event Location:
- West Virginia Northern Community College
- 1704 Market Street
- Wheeling, West Virginia
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: Getting started with SQL Azure Database: What you need to know
Abstract: Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore. In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.
Speaker(s):
- Jim Donahoe
Track and Room: Cloud Development Implementation - Room 301
Title: SQL Server and PowerShell: Let’s Get Serious
Abstract: Whether you’ve dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell isn’t going away. It is definitely something worth learning to make your life as a SQL Server professional easier, and allow you to advance in your career as a DBA.
In this session, you’ll see practical, real-world examples of how you can blend SQL Server and PowerShell together. You’ll also get a look at the SQL Server PowerShell provider and how you can incorporate it into your automation scripts.
Instead of focusing on syntax, the session will plunge straight into examples and highlight various snippets of code and how they work. You can expect to see code examples on how PowerShell can do anything from comparing tables across servers, automating and centralizing your backups, and even doing in-depth security audits.
Speaker(s):
- Drew Furgiuele
Track and Room: Enterprise Database Administration Deployment - Room 303
Title: Infrastructure for the DBA: An Introduction
Abstract: It doesn’t matter if you are a Junior DBA, an accidental DBA or all the way up to a Senior DBA, the infrastructure your SQL Server environment runs on is important. Many among the DBA community came in as developers or perhaps directly into database administration roles it is equally possible that you have been out of the operations world long enough to have fallen out of the loop with what is happening. This session is intended to provide a full stack infrastructure overview so that you can talk shop with your cohorts in operations to resolve issues and maybe even be proactive. We will discuss, in an introductory fashion, hardware, network, storage, virtualization and operating system layers. Additionally, some suggestions as to where to find more information will be provided.
Speaker(s):
- Peter Shore
Track and Room: Enterprise Database Administration Deployment - Room 312
Title: Microsoft Machine Learning Services
Abstract: SQL Server 2017 Machine Learning Services is more than just R and Python language support for SQL Server. SQL Machine Learning Services provides analytics for any size of data, runs in SQL Server, or alongside Windows, Linux, HDInsight Spark or Hadoop clusters, is simple to administer and allows you to integrate and deploy simply. In this session, learn architecture and deployment options, stand-alone and in-database, along with some real-world use-cases. Learn how to leverage Machine Learning Services with new TSQL language support, training and deploying models, scaling beyond memory with RevoScaleR to generating millisecond predictions in-database. With any size data environment, SQL Machine Learning Services can provide analytics in both an operationally sound and easy to administer paradigm.
A beginner level understanding of Machine Learning and process is highly recommended but not required. Beyond SQL Machine Learning Services, an overview of all Microsoft Machine Learning
Speaker(s):
- Andrew Loree
Track and Room: Analytics and Visualization - Room 301
Title: 45 Minutes to Your First SSAS Tabular Model
Abstract: Have you been watching SSAS Tabular develop? What about the new Azure Analysis Services product? Or you’ve looked at these and like what they can add in Power BI or classic BI scenarios, but haven’t had a chance to dive in and figure all of this out? Now is the time! SSAS Tabular is a new-ish form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, in addition to the various options for deployment, before exploring the development process of creating a tabular model ready for ad-hoc querying through Excel or Power BI.
Speaker(s):
- Kerry Tyler
Track and Room: BI Information Delivery, Architecture, Development Administration - Room 313
Title: How can containers for my database help me?
Abstract: It seems like web apps are getting all the love and at first glance it may be hard to identify a good way to use the database in containers. This session will review the concept of containers and attempt to identify ways we might benefit from this new technology as we support our users.
Speaker(s):
- Carlos L Chacon
Track and Room: Application Database Development - Room 303
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, and additional features.
Speaker(s):
- Eugene Meidinger
Track and Room: Application Database Development - Room 312
Title: 45 min to build your first SSRS report
Abstract: Does this sound like you? You’ve been BI curious and now you’ve been given access to SSRS and you want to make a report. Or, you’re a DBA or DBA Dev and could use a report to reduce daily task. Either way, I’ve got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll use SSRS (SQL Server Reporting Services) 2016. The query makes no difference, this time it’s all about the output.
Speaker(s):
- Tamera Clark
Track and Room: BI Information Delivery, Architecture, Development Administration - Room 313
Title: What’s new in SQL Server 2017
Abstract: SQL Server 2017 has great new additions and features for everybody. If you are a developer, you want to learn about new Graph tables, new M.O.T enhancements, and new functions. If you are a BI developer, you want to learn about how to run R and Python in SQL Server. If you are a DBA, you might want to learn about new features like Resumable Online Indexes, Automatic Query Optimization and how to monitor R and Python scripts. This session will have overall information about new features of SQL Server 2017
Speaker(s):
- Hasan Savran
Track and Room: IT Professional or Professional Development - Room 301
Title: Eliminating the CRUD with Entity Framework Core
Abstract: Developers need to insert and query data stored in databases, but never want to enter the land of building SQL stored procedures for everything. I want to give an approach to CRUD without caring about the underlying database container. We’re .NET Developers, we like to write structures in a way that makes sense to us. In this case, Entity Framework Core is a brilliant option that layers on top of MySQL, Postgres SQL, and MS SQL, to name a few.
Speaker(s):
- Jeremy Sinclair
Track and Room: Application Database Development - Room 303
Title: Working Effectively With Legacy SQL
Abstract: A legacy code base can be a frightening thing. Between strict deadlines, ever-evolving requirements, differing skill levels of contributors over time, and historical circumstances, keeping database code clean and concise is difficult at best. This example- and demo-driven talk will help you build out a mental framework to prune those gnarled code bases. Much of this talk will be familiar to software developers who know of the “clean code” philosophy, but no knowledge of the topic is necessary. If you shudder whenever you look at your SQL code base, this talk may be for you.
Speaker(s):
- Kevin Feasel
Track and Room: Application Database Development - Room 312
Title: Stress testing SQL Server
Abstract: How high can we go? Frequently in your career as a DBA you will be asked how much load can your SQL Server support. In this session, Hilary Cotter, shows you how to Microsoft tools to stress test your application and determine what your bottlenecks are and how high you can ramp up your workload.
Speaker(s):
- Hilary Cotter
Track and Room: Enterprise Database Administration Deployment - Room 312
Title: What I wish I knew as a beginning DBA.
Abstract: This session will pull everything together about being a DBA. What steps to take to get hired as a DBA, , continuous learning ideas, and QA with a panel of experienced DBA’s
Speaker(s):
- Michael John
Track and Room: Enterprise Database Administration Deployment - Room 301
Title: How to get Microsoft Certified
Abstract: Microsoft has recently streamlined the certification process and this session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for success.
Speaker(s):
- John Deardurff
Track and Room: IT Professional or Professional Development - Room 301
Title: Know What Your Code is Doing to SQL Server!
Abstract: ORMs - oh how I LOVE them! As a consultant, when I see them in play at a client I go KACHIIINNNNGGGG!! :-D Seriously though, they can provide some substantial benefits for coding throughput. But if you don’t Read The Fine Manual and do some things right and avoid some major gotchas you will fall prey to one of my favorite Guruisms: “Anything that allows developers to slap code together more quickly is inversely proportional to the performance and concurrency you will get from that code”! Although this talk is based on Entity Framework, most ORMs suffer from a lot of the same flaws.
Speaker(s):
- Kevin Boles
Track and Room: Application Database Development - Room 312
Title: Linux for SQL Server
Abstract: SQL Server is now available on Linux but you only know Windows, now what? During this session we’ll introduce the Linux version of Windows commands you use on a daily basis for administering SQL Server. We’ll look at updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another. We’ll also look at default file locations for SQL Server and what can be moved and how to accomplish that.
Speaker(s):
- Jay Falck
Track and Room: Enterprise Database Administration Deployment - Room 313
Title: SSIS Incremental Loading: The Tortoise and The Hare
Abstract: Extracting, transforming and loading data has become a major component to satisfying business requirements and needs. Depending on the size of the data you are working with, the way you design your SSIS packages can have an impact on performance and run times.
In this session, we will cover a variety of incremental design approaches centered around large data sets using SSIS. We will look at the architecture of each ETL strategy to determine the pros and cons and generate specific use cases to decide which strategy yields optimal results.
Speaker(s):
- Jeremy Frye
Track and Room: BI Information Delivery, Architecture, Development Administration - Room 313
Title: Monitoring Availability Groups
Abstract: Once you have successfully configured Availability Groups, what comes next? In this session, we will go beyond setup and look at how to monitor your Availability Groups. We will define and cover important metrics and alerts you need to manage a database in an Availability Group.
You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.
Speaker(s):
- Tracy Boggiano
Track and Room: Enterprise Database Administration Deployment - Room 303
Title: Handcrafting Covering Indexes
Abstract: Do you have a need for speed but cannot change the code? Covering indexes might be your best friend. You might have heard about covering indexes, but what are they exactly and how do you design one? In this session, we explore what covering indexes are, why you might or might not need one, how to craft them, and how to test them for effectiveness. By the end of the session, you will be prepared to make effective indexing decisions while tuning individual queries.
Speaker(s):
- Devon Leann Ramirez
Track and Room: Application Database Development - Room 313
Title: Successfully Running SQL Server in AWS
Abstract: Amazon Web Services (AWS) is the world’s largest public cloud hosting provider, with many companies successfully running SQL server on AWS infrastructure, but trying to make sense of the available options can be daunting. In this session, we will explore the options available for running SQL server in AWS, either as a managed service or using dedicated EC2 instances. We will document the different storage options, High Availability strategies, as well as important security and maintenance caveats. We will also cover various licensing approaches available when running SQL server in AWS.
Speaker(s):
- Brian Carrig
Track and Room: Enterprise Database Administration Deployment - Room 303
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Jay Falck
Twitter: - @jayfalck
LinkedIn: Jay Falck
I started as a night shift computer operator out of high school. I moved to applications development after graduation from SAC. After a few years with the State as an applications developer, the manager of Systems Programming decided it would be better to have me on the inside looking out rather than on the outside trying to get in. I spent the next 14 years as a mainframe system programmer for two state agencies. In 1996 I moved to Healthcare IT and have been that ever since. I’ve spent most of the past 14 years doing ETL, performance and HIPAA security. In these various jobs, I’ve used all manner of databases including InfoTec IMP, IBM VSAM and DB2, Interbase, Informix, Universe, Oracle 9i and SQL Server from 6.0 to 2008 R2.
Tamera Clark
Twitter: - https://twitter.com/tameraclark
LinkedIn: Tamera Clark
Contact: http://tameraclark.com
Tamera Clark has been involved in the IT industry for greater than ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter, Co-leading the Nashville BI Chapter, assisting the Nashville PASS Chapter and serving as a Regional Mentor. Tamera is also the event chair of SQLSaturday Nashville.
Jeremy Frye
Twitter: - SQLBInstein
LinkedIn: Jeremy Frye
Contact: https://jeremyfrye.net
Jeremy Frye is the manager of the Business Intelligence and data warehousing team at RDX. He is a Business Intelligence architect and developer with a background in database administration as well. Jeremy has over 9 years of experience in SQL Server. He has spoken on BI topics at many SQLSaturday’s throughout the country, webinars, and local and remote SQL user groups. In his spare time, Jeremy often spends time trying to bridge the gap between keyboard strokes and workout reps.
John Deardurff
Twitter: - SQLMCT
LinkedIn: John Deardurff
Contact: https://www.sqlmct.com
John has been a Microsoft Certified Trainer (MCT) for over 20 years teaching Azure, SQL Server, Exchange Server, and Windows Server networking courses. He is currently a SQL Premier Field Engineer for Microsoft. He is an MCT Regional Lead for the Eastern United States and a former Data Platform MVP.
Hilary Cotter
Hilary Cotteris a 20 year IT veteran who has answered over 20,000 questions on the forums. Some of them correctly. He specializes in HA technologies, especially replication, performance tuning, full-text search, and SQL Server Service Broker.
Hilary is also an author, or contributor on a number of books on SQL Server.
Hasan Savran
Twitter: - Savranweb
LinkedIn: Hasan Savran
Contact: http://h-savran.blogspot.com/
Hasan Savran is a BI Architect at Progressive Insurance Company. He spends his days architecting cutting edge business solutions by using the latest Web and Database technologies. He is a Microsoft Data Platform MVP, Microsoft Certified Solutions Developer. Hasan has spoken at many SQLSaturdays, Code Camps and User groups. He is an active member of the HTML5 and WebAssembly W3C groups. He likes to write about SQL, CosmosDB, C#, and Front End development on his blog.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
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.
Michael John
Twitter: - #Progeek11
LinkedIn: Michael John
With 20 years experience in all aspects of development and administration of SQL Server, from version 6.5 to 2016, I have seen, broken, and fixed just about everything in SQL Server!
Andrew Loree
Twitter: - @LowOnDiskSpace
LinkedIn: Andrew Loree
Contact: http://www.andyloree.com
Andrew Loree has over nineteen years of database experience with roles in architecture, design, development, and implementation of enterprise-scale SQL Server data solutions, supporting industries from legal e-discovery to manufacturing. Areas of expertise since SQL Server 2000 include data migration and ETL/ELT solutions, disaster recovery planning, high availability service design, licensing and virtualization. Andrew holds fourteen Microsoft certifications, has both a Bachelor and Masters of Science in Computer Science from Wright State University and is a Columbus (Ohio) PASS board member.
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.
Drew Furgiuele
Twitter: - pittfurg
LinkedIn: Drew Furgiuele
Contact: http://www.port1433.com
Drew Furgiuele is a senior DBA that lives in Dublin, Ohio who is passionate about SQL Server and PowerShell. He’s been working with SQL Server since 2002. When he’s not accidentally dropping tables in production, he likes writing automation scripts, blogging about SQL Server Replication, wiring electronics, playing board games, and spending time with his dog. He’s also not embarrassed by his Spotify playlists.
Kerry Tyler
Twitter: - AirborneGeek
LinkedIn: Kerry Tyler
Contact: http://airbornegeek.com
Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.
Jeremy Sinclair
Twitter: - sinclairinator
LinkedIn: Jeremy Sinclair
Contact: https://www.sinclairinat0r.com
I’m an Enterprise .NET Developer with years of experience with PowerShell, SharePoint, Xamarin, Windows Phone/UWP Development. Finding interesting and awkward ways of achieving results are my specialty.
Tracy Boggiano
Twitter: - TracyBoggiano
LinkedIn: Tracy Boggiano
Contact: http://databasesuperhero.com
Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC.
Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com.
Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.
Jim Donahoe
Twitter: - SQLFlipFlopsDBA
Contact: http://www.sqlflipflopsdba.com
Jim is a Premier Field Engineer for Microsoft in the Data/AI space. He lives in Pittsburgh in a small suburb. He loves working with all things Azure(ARM templates, DBaaS, SQL on IaaS). He is an avid collector of retro video games! He is a member of the Idera ACE program for 2018.
Carlos L Chacon
Twitter: - @CarlosLChacon
LinkedIn: Carlos L Chacon
Contact: http://sqldatapartners.com/blog
Carlos Chacon is the managing partner of SQL Data Partners LLC and co-host of the popular SQL Data Partners Podcast. While getting his start as a typical accidental DBA, Carlos has sat on Microsoft exam review panels, served as regional mentor and chapter leader. He enjoys traveling and has been to four continents, speaks Spanish and can eat his weight in raspberries (not yet proven). He and his family live in Richmond, Virginia.
Devon Leann Ramirez
Twitter: - @RestinBeachFace
LinkedIn: Devon Leann Ramirez
Contact: https://blogs.sentryone.com/author/devon_ramirez/
Devon Leann Ramirez is a SQL Developer and PASS community volunteer with 7 years of SQL Server experience. She graduated with a degree in Actuarial Science from the University of Texas at Austin and has since worked on business intelligence projects, data governance, and data quality initiatives in the insurance sector. In her free time, she loves karaoke, bravo TV, and staring at puppies on Instagram.
Brian Carrig
Twitter: - @briancarrig
Brian Carrig is a Microsoft Certified Master of SQL Server and is currently a Senior Program Manager on the SQL Server Tiger Team at Microsoft focusing primarily on persistent memory technology and replication. In a previous life, Brian spent some time as an academic and holds a PhD in Computer Science. He is a native of Dublin, Ireland but now lives with his wife and two daughters in Redmond, Washington. If he is not talking about, thinking about or working with technology you will usually find him watching Chelsea FC.
Peter Shore
Twitter: - pshore73
LinkedIn: Peter Shore
Peter Shore is a seasoned IT professional with over 25 years of experience. He took the accidentally intentional DBA plunge in 2013 and has discovered that he loves to find the stories the data has to tell. Peter is comfortable working with both physical and virtual servers, where he tries to apply best practices to attain performance improvements. He is also adept at bridging the gap between technical and business language in order to bring technology solutions to business needs.
Sponsors
The following is a list of sponsors that helped fund the event: