Nr: 717
SQLSaturday #717 - Wheeling 2018
SessionID: 74035
Microsoft Machine Learning Services
Event Date: 28-04-2018 - Session time: 09:00:00 - Track: Analytics and Visualization
Speaker: Andrew Loree
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
SessionID: 74220
Eliminating the CRUD with Entity Framework Core
Event Date: 28-04-2018 - Session time: 09:00:00 - Track: Application Database Development
Speaker: Jeremy Sinclair
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.
SessionID: 74222
Handcrafting Covering Indexes
Event Date: 28-04-2018 - Session time: 09:00:00 - Track: Application Database Development
Speaker: Devon Leann Ramirez
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.
SessionID: 74284
Stress testing SQL Server
Event Date: 28-04-2018 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Hilary Cotter
Title: Stress testing SQL Server
Abstract:
SessionID: 71123
How to get Microsoft Certified
Event Date: 28-04-2018 - Session time: 10:15:00 - Track: IT Professional or Professional Development
Speaker: John Deardurff
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.
SessionID: 71176
Execution Plans 101
Event Date: 28-04-2018 - Session time: 10:15:00 - Track: Application Database Development
Speaker: Eugene Meidinger
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.
SessionID: 71715
SQL Server and PowerShell: Let's Get Serious
Event Date: 28-04-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Drew Furgiuele
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.
SessionID: 73943
SSIS Incremental Loading: The Tortoise and The Hare
Event Date: 28-04-2018 - Session time: 10:15:00 - Track: BI Information Delivery, Architecture, Development Administration
Speaker: Jeremy Frye
Title: SSIS Incremental Loading: The Tortoise and The Hare
Abstract:
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.
SessionID: 71217
Getting started with SQL Azure Database: What you need to know
Event Date: 28-04-2018 - Session time: 11:30:00 - Track: Cloud Development Implementation
Speaker: Jim Donahoe
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.
SessionID: 71378
Infrastructure for the DBA: An Introduction
Event Date: 28-04-2018 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Peter Shore
Title: Infrastructure for the DBA: An Introduction
Abstract:
SessionID: 73795
Linux for SQL Server
Event Date: 28-04-2018 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Jay Falck
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.
SessionID: 74229
Monitoring Availability Groups
Event Date: 28-04-2018 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Tracy Boggiano
Title: Monitoring Availability Groups
Abstract:
You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.
SessionID: 71198
Working Effectively With Legacy SQL
Event Date: 28-04-2018 - Session time: 13:45:00 - Track: Application Database Development
Speaker: Kevin Feasel
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.
SessionID: 72774
What's new in SQL Server 2017
Event Date: 28-04-2018 - Session time: 13:45:00 - Track: IT Professional or Professional Development
Speaker: Hasan Savran
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
SessionID: 74252
Successfully Running SQL Server in AWS
Event Date: 28-04-2018 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Brian Carrig
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.
SessionID: 74277
45 min to build your first SSRS report
Event Date: 28-04-2018 - Session time: 13:45:00 - Track: BI Information Delivery, Architecture, Development Administration
Speaker: Tamera Clark
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.
SessionID: 72782
What I wish I knew as a beginning DBA.
Event Date: 28-04-2018 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Michael John
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
SessionID: 72863
How can containers for my database help me?
Event Date: 28-04-2018 - Session time: 15:00:00 - Track: Application Database Development
Speaker: Carlos L Chacon
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.
SessionID: 73991
Know What Your Code is Doing to SQL Server!
Event Date: 28-04-2018 - Session time: 15:00:00 - Track: Application Database Development
Speaker: Kevin Boles
Title: Know What Your Code is Doing to SQL Server!
Abstract:
SessionID: 74264
45 Minutes to Your First SSAS Tabular Model
Event Date: 28-04-2018 - Session time: 15:00:00 - Track: BI Information Delivery, Architecture, Development Administration
Speaker: Kerry Tyler
Title: 45 Minutes to Your First SSAS Tabular Model
Abstract:
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.