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 firstname.lastname@example.org
Please send any questions regarding the sessions or payments to: email@example.com
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.
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.
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.
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.
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.
The intended audience of this course is information workers (both business and IT-centric) involved with architecting an enterprise IT strategy for SQL Server.
The following topics will be addressed during the course
Upon completion of this course, attendees will be able to:
Attendees with the following experiences will benefit the most from this course:
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: firstname.lastname@example.org.
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.
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.
This course is intended for database administrators and others responsible for maintaining the security of database systems.
Topics to be addressed in this course include the following:
Upon completion of this course, attendees will understand:
Attendees with the following experiences will benefit the most from this course:
A copy of the reference slides and demonstrations will be provided to attendees for reference and experimentation in their environments.
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.