SQL Saturday #557 Pre-Con Registration


Pre-Cons will be held on 09/30/2016 from 9AM - 5PM - Lunch will be provided

Sessions will be held at Dakota County Technical College in Rosemount, MN.  More details to follow.

After reviewing the sessions below, select the one session you would like to attend from the drop down list.  You will then be redirected to our PayPal payment site.  You may either pay with a PayPal account or chose to pay with a major credit card.  To pay by check, please email us at sqlsaturday557@sqlsaturday.com

Please send any questions regarding the sessions or payments to: sqlsaturday557@sqlsaturday.com




  






  

Jes Borland


Concurrency

Getting Started With SQL Server In Azure

Microsoft Azure is a mature, stable ecosystem, but some people and companies are still hesitant to adopt it. In this full day class, I’ll teach you why building SQL Server environments in Azure is safe, easy, and reliable - and how to do it.
 
We’ll begin with an overview of the Azure ecosystem. SQL Server is one of a large number of services being offered, and many work together. I’ll walk through the main management tool, the Azure Portal, to show you how to use it. I’ll cover the security and compliance of features of Azure, which are numerous. You’ll understand the differences between Azure Infrastructure as a Service (Iaas) and Platform as a Service (PaaS) offerings.
 
You’ll see how to build IaaS SQL Server VMs. I’ll talk through licensing, networking, security, and what you’ll pay for. We’ll talk about how to move your current data into the VM, how to connect to the databases for management or from the application, and uses for VMs such as DR. The HA/DR options for IaaS will be explained.
 
You’ll also see how to build PaaS Azure SQL Databases, with the same information such as networking, security, and what you’ll pay for. I’ll show you how to move your current data to the database, and how it differs from the IaaS product. You’ll learn how to connect to and manage the databases. We’ll also cover how HA/DR is handled with PaaS databases.
 
I’ll cover intricacies learned from hands-on experience, such as security and networking settings to be aware of, and how to use Azure’s ability to scale up and down as necessary. You’ll come away from this class fully prepared to build your first IaaS or PaaS deployment. 

About Jes

Jes Borland is a Senior SQL Engineer at Concurrency and a Microsoft Data Platform MVP. She holds an AAS - Programmer/Analyst degree and has worked with SQL Server as a developer, report writer, DBA, and consultant. She is a user group founder, a blogger, and a frequent speaker. In her free time, she runs, cycles, and cooks. 


 

Ginger Grant


Pragmatic Works 


R School for SQL Pros

R is quickly becoming the language for data analysis, and attendees will leave this workshop knowing the fundamentals of writing R code. Hands-on instruction using open source versions of Visual Studio 2015 with R tools will provide attendees the knowledge they need to create R programs on their own laptops and provide results using various types of visualizations.  Materials are provided to continue the process of learning R after the class completes.

Using SQL Server 2016, attendees will learn how to incorporate R in SQL Server stored procedures as well as use of the R Server.  The R server provides the ability to scale R code to use more data than can be loaded into memory, and attendees will learn the best use cases for it.  Within Azure ML, attendees learn to use R code they create and to call R libraries.  Attendees also learn how R and Power BI can be combined for powerful data visualization.

Session Goals

  • Learn how to code applications in R to provide data insight and data visualizations while taking advantage of the the enhanced features of the Microsoft R Open Libraries in Visual Studio.
  • Understand the use of R Server and how and when it can be used to integrate R into existing data environments.
  • Extend the functionality of SQL Server, Aure ML, and Power BI by integrating R code for developing solutions in different environments.
Session Agenda
  • History and Introduction to the R Language
  • Walk through of Microsoft R Open
  • Class Exercise of writing Hello World in R
  • When and How to use R Language Libraries
  • Class Exercise of R code with Graphical Output
  • Common uses and best fit for R programs
  • Develop R program for Data Integration
  • Integration of R code into SQL Server 2016
  • Adding R to Azure ML


About Ginger

Ginger is a  senior consultant at Pragmatic Works.  Having worked with the Microsoft BI stack for many years, Ginger Grant is exploring new challenges by applying her data expertise to the expanding field of data science and data visualization.  Using R and Machine Learning she has been able to use data and algorithms to answer many different business questions for users. When not working, Ginger is studying for the pilot degree program Microsoft created for Data Science, blogging at DesertIsleSQL.com and speaking at numerous technical events, including SQL Saturdays, GDI and Women Who Code. An active member of the Microsoft data community, she was recently awarded a Microsoft MVP in Data Platform.




 

David Klee


Heraflux Technologies


The Complete Primer to SQL Server Infrastructure Tuning

  

Length:

1 Day

Language:

English

Audience(s):

System Administrators, Developers, Database Administrators

Level:

200-300 (Intermediate)

Technologies:

Storage, Networking, Windows Server, VMware vSphere, Microsoft Hyper-V, SQL Server

 

Course Description

Microsoft MVP and VMware vExpert David Klee leads this full-day introduction to getting the most out of the infrastructure underneath your SQL Server environment. The focus of the course is to help those new to the enterprise server infrastructure concepts become familiar with function and purpose of each layer of the architecture around their databases, and how this knowledge can benefit them as data professionals. Participants will gain exposure to all layers of infrastructure and virtualization underneath SQL Server, from storage all the way through to the SQL Server instance, and will learn how to review and engineer the entire stack with a strong emphasis on SQL Server performance.

Intended Audience

The intended audience of this course is information workers (both business and IT-centric) involved with architecting an enterprise IT strategy for SQL Server.

Course Topics

The following topics will be addressed during the course

  • Datacenter Fundamentals
  • Infrastructure Stack Fundamentals
  • Storage and SAN Concepts and Design
  • Networking and Interconnect Topologies
  • Physical Server Technologies
  • The SQL Server Virtual Machine
  • High Availability and Disaster Recovery
  • Performance Investigation and Tuning of the Entire Stack

Course Objectives

Upon completion of this course, attendees will be able to:

  • Understand key infrastructure concepts
  • Determine the optimal infrastructure configuration for best performance
  • Review their own enterprise infrastructure for performance bottlenecks
  • Construct a SQL Server virtual machine template with best practices for agility and performance\
  • Understand how and what stack metrics to benchmark and baseline to ensure proper objective performance measurement
  • Identify and remediate common infrastructure-related SQL Server performance killers\
  • Understand proper capacity management techniques for long term management

Prerequisites

Attendees with the following experiences will benefit the most from this course:

  • Basic familiarity with the core components of a server
  • SQL Server installation and configuration
  • Exposure to SQL Server performance metric measurement and identification

A working set of the screens and configuration settings referenced in the session, together with the reference slides and documentation, will be provided to attendees, for strategic reference in working with SQL Server and the infrastructure underneath in their own environments.

Please contact David with any questions: dklee@heraflux.com.

About David

David Klee is a Microsoft MVP and VMware vExpert with over seventeen years of IT experience. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise are virtualization and performance, datacenter architecture, and risk mitigation through high availability and disaster recovery. When he is not geeking out on technologies, David is an aspiring amateur photographer. You can read his blog at davidklee.net, and reach him on Twitter at @kleegeek.

David speaks at a number of national and regional technology related events, including the PASS Summit, VMware VMworld, IT/Dev Connections, SQL Saturday events, SQL Cruise, PASS virtual chapter webinars, and many SQL Server and VMware User Groups.


 

Ed Leighton-Dick 


Kingfisher Technologies


Securing the Data Platform: Crafting A Strategy That Works


Length:

1 Day

Language:

English

Audience(s):

Database Administrators; IT Security Professionals

Level:

200-300 (Intermediate)

Technologies:

Microsoft Data Platform

Microsoft SQL Server, with an emphasis on SQL Server 2012 and later

 

Course Description

Your database servers are insecure, and you know it.  Unfortunately, so does the person upstairs who just wants to take a peek. That executive who wants a copy of the database to build some reports on the plane knows it.  So does the call center rep who's trying to provide great service to the customer on the phone.  And the hacker who's attacking your website?  Yeah, they know it, too.  We can no longer rely solely on the same old security practices to protect our data.  We need to secure the data at its source.

Intended Audience

This course is intended for database administrators and others responsible for maintaining the security of database systems.

Course Topics

Topics to be addressed in this course include the following:

·         Authentication and authorization structures

·         Separation of duties

·         Securing server-to-server communications

·         Encryption

·         Cloud security

·         Common threats

·         Defenses

Course Objectives

Upon completion of this course, attendees will understand:

·         Current threats to their SQL Server environment

·         How to implement SQL Server’s built-in security features to defend against threats

·         How to monitor the security framework they have implemented

Prerequisites

Attendees with the following experiences will benefit the most from this course:

·         1-3 years experience administering SQL Server databases in some capacity

A copy of the reference slides and demonstrations will be provided to attendees for reference and experimentation in their environments.

About Ed

Ed Leighton-Dick is a SQL Server performance and architecture expert with twenty-five years of experience in development, database administration, and system administration. In 2014, he founded Kingfisher Technologies, a consultancy focused on SQL Server performance, architecture, and security. Ed volunteers his time with PASS, including roles as Midwest Regional Mentor, Chapter Leader of I-380 PASS SQL Server User Group, and organizer of SQLSaturday Iowa City. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday events, 24 Hours of PASS, Iowa Code Camp, and PASS Summit. Outside of work, he is a devoted husband, father of two beautiful girls, and beginning runner.

Ed can be reached through his blog, edleightondick.com, and on Twitter at @eleightondick.