Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type


Sessions Found: 65
2016 SSIS packages can access data anywhere throughout the network, but normally run on the server they are deployed on. And if something terrible happens to that server, the manual setup of the SSISDB can be time consuming. With 2017, SSIS packages can be deployed once and run on several servers, even simultaneously. At this meetup, Paul LaGrone will teach you how to set up 2017 SSIS Scale Out packages so that your SSIS packages can now be in a Highly Available and Disaster Recovery environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: August 11

Time: 2:45 PM - 3:45 PM

Room: 1735

Evaluate Session

Creating Windows IoT image for Raspberry Pi 3 and writing code that manages to the GPIO ports.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
.NET Dev

Level: Intermedia

Session Code:

Date: August 11

Time: 1:30 PM - 2:30 PM

Room: 1305

Evaluate Session

Performance troubleshooting is a required skill for every DBA. Knowing the deep internals of how a query functions and why SQL Server chose to run it in a certain way is important. Knowing how to design a table or configure a database to squeeze every ounce of performance is our lifeblood. 

What if I told you that you may be doing this all wrong? What if all the work and laborious effort put into design or configuration don't improve the situation because the issue was never in SQL to begin with? Truth be told, the biggest differentiator between a good DBA and a great DBA is knowing the hardware and O/S; not just SQL.

Join me as I guide you through troubleshooting SQL Server performance from tip to toe to demonstrate the common performance problems you never knew you had.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Server Administration

Level: Advanced

Session Code:

Date: August 11

Time: 12:15 PM - 1:15 PM

Room: 1510 (Auditorium)

Evaluate Session

Protecting our data from unauthorized access becomes more and more important all the time. SQL Server includes a number of features that make data protection and security easier for developers and DBAs with a framework for protecting data. Come learn how Always Encrypted, TDE, Row Level Security, Dynamic Data Masking, and column level encryption can protect your systems.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server Development

Level: Beginner

Session Code:

Date: August 11

Time: 9:15 AM - 10:15 AM

Room: 1510 (Auditorium)

Evaluate Session

DevOps is changing today's software development world by helping us build better software, faster. However most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can be applied to database development by looking at both automated comparison analysis as well as migration script management. Automated building, testing, and deployment of database changes will be shown.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
.NET Dev

Level: Beginner

Session Code:

Date: August 11

Time: 12:15 PM - 1:15 PM

Room: 1305

Evaluate Session

The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
PowerShell

Level: Beginner

Session Code:

Date: August 11

Time: 12:15 PM - 1:15 PM

Room: 1920

Evaluate Session

Everyone wants a great job that they enjoy, but few of us know how to take charge of our career. Learn why it's important to raise your profile in today's highly competitive world where there are often more candidates than positions for great jobs. This session will help you build a strong brand that allows you to attract potential employers or clients and start to convince them ahead of time that you are the person they want to hire.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 11

Time: 10:30 AM - 11:30 AM

Room: 1615

Evaluate Session

I am responsible for several Azure-based microservices at Microsoft that are consumed internally and exposed to customers through PowerApps, Dynamics 365, and more to come in the future. In this session we will discuss the following qualities that help make-up a great cloud based service: reliable, scalable, secure, compliant, and supportable. This is an architectural level discussion with no code.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
.NET Dev

Level: Intermedia

Session Code:

Date: August 11

Time: 2:45 PM - 3:45 PM

Room: 1800

Evaluate Session

Careers in IT will feature a panel of industry leaders and experts who directly interact with participants in a moderated question and answer session.  This will allow participants to gain insight into what the IT community sees as valuable (skill-sets, certifications, experience, and etc) so that they can be better prepared for a career transition or to start work in the IT field for the first time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Career

Level: Beginner

Session Code:

Date: August 11

Time: 2:45 PM - 3:45 PM

Room: 1615

Evaluate Session

R is the most popular statistics language used today. It is one of the most useful tools in the data scientist's tool belt. It is also integrated into the MS stack in tools like Azure ML, SQL Server and Power BI and can be used to take your data analytics to the next level. 

  

Come to this session to get an introduction to the R language including:

 

  - installing and Configuring R and RStudio

  - RStudio Overview and Debugging

  - how to Access and Manipulate Data

  - install and Manage Packages

  - create and Use Variables

  - control Flows

  - functions

  - basic Graphing and Statistical Analysis.

 

We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos. 

  

The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: August 11

Time: 1:30 PM - 2:30 PM

Room: 1325

Evaluate Session

Python is the one of the most popular programming languages used today and one of the most useful tools in the data scientist's tool belt especially for machine learning. Python is integrated into the Microsoft stack in tools like Azure ML and now SQL Server 2017.

The session will be an introduction to the Python language including:

1.) Installing and Configuring Python

2.) Access and Manipulate Data

3.) Install and Manage Packages

4.) Create and Use Objects/Variables

5.) Control Flows and Functions

6.) Managing the Python installation in MSSQL


Attend this session to learn how to use Python to take your data analytics to the next level. We will use Python, SQL Server and the Anaconda distribution of Python to learn the basics of Python and how it is integrated in the Microsoft stack! We will walk through a simple deployment of a machine learning model to see how it all works together and learns some basic data science fundamentals.

No prior statistics knowl
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: August 11

Time: 10:30 AM - 11:30 AM

Room: 1845

Evaluate Session

What is this function composition wizardry? 
From defining and understanding it conceptually to digging in and refactoring some code, you will gain 
 useful insight into utilizing function composition. 
We will also look at common architecture strategies and take a fresh look at common composition-based design patterns.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
.NET Dev

Level: Intermedia

Session Code:

Date: August 11

Time: 2:45 PM - 3:45 PM

Room: 1305

Evaluate Session

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: August 11

Time: 12:15 PM - 1:15 PM

Room: 1321

Evaluate Session

A popular buzzword, CQRS is often misunderstood and more often misused. Less of an architecture, than a set of related techniques and an architectural flavor, it is an important and powerful technique to have in your arsenal. Here we will discuss traditional CQRS, break it down to its essence, and discuss a lightweight alternative by which an application can be created without much of the overhead and a straightforward transition path to a fully CQRS style.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
.NET Dev

Level: Intermedia

Session Code:

Date: August 11

Time: 10:30 AM - 11:30 AM

Room: 1720

Evaluate Session

Microsoft has been hard at work converging multiple business application platforms, including PowerApps, XRM/Dynamics CRM/CE, and the Common Data Service, enabling you to create rich, complex, and extensible apps that span devices with little or no code. In this session we will create a model-driven app with no code that includes the data model, user interface, visualizations, and logic. This is an introductory session and is for anyone who has used line of business applications and can work with Excel or Access.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
.NET Dev

Level: Beginner

Session Code:

Date: August 11

Time: 9:15 AM - 10:15 AM

Room: 1305

Evaluate Session

Dreams become reality and it's time for you to create the life you want. What's your vision? Where do you see yourself in 5 years? What's the next step in your professional career? Are you living life to the fullest and doing what really makes you happy? Discover a new you and learn to succeed and live without regrets in this very interactive seminar.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: August 11

Time: 9:15 AM - 10:15 AM

Room: 1615

Evaluate Session

They're just numbers, right?  A date's a date.  It's just string data, who cares?  I can't tell you how many times I've heard these phrases.  This session will help you understand why choosing the correct data type for your data is so important.  It affects data quality, storage and performance.  It can even produce incorrect query results.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server Development

Level: Beginner

Session Code:

Date: August 11

Time: 9:15 AM - 10:15 AM

Room: 1620

Evaluate Session

One of the most misunderstood aspects of virtual machine performance is vNUMA. In addition to an overview on the CPU architecture, NUMA and CPU scheduling; we'll discuss some nuances of the CPU that are not commonly known. We will deep dive into how a single VM's misconfiguration can cause performance problems for itself and also how many misconfigured VMs degrade the norm of performance of your virtual infrastructure.  
DBAs will be taught to identify misconfigured virtual machines and be explained what the infrastructure engineer can do to resolve it. 
The presentation will be completed with a discussion on virtual machine RightSizing and how it benefits the larger virtual infrastructure.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Windows Server/Virtualization

Level: Intermedia

Session Code:

Date: August 11

Time: 10:30 AM - 11:30 AM

Room: 1800

Evaluate Session

Have you wondered what the right approach is for creating and deploying your Power BI content? Which tools are the right ones? When do you use app workspaces and apps? How to understand your licensing options? And how to keep your data up to date? If, so this session is for you.  During this session we will discuss and show:  Deployment options, Licensing Options, Refreshing Data, Collaborating and Sharing options and many more details about deploying Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: August 11

Time: 10:30 AM - 11:30 AM

Room: 1425

Evaluate Session

Azure Data Lake Analytics provides a set of built in extractors to process well-structured delimited text files. U-SQL uses these extractors to parse these files
But U-SQL is not limited to processing delimited files. Using Custom Extractors you can parse JSON or XML files.  You can use Custom Extractors to work with irregularly formatted delimited files.  Custom Extractors can even parse image files.
Developers have created Custom Extractors for these and other file formats and made them available on the U-SQL GitHub site.  We will look at two of these Custom Extractors:  Flexible Schema Extractor and the JSON Extractor.  We will look at how to deploy these Extractors and extend them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
.NET Dev

Level: Intermedia

Session Code:

Date: August 11

Time: 2:45 PM - 3:45 PM

Room: 1920

Evaluate Session

Sessions Found: 65
Back to Top cage-aids
cage-aids
cage-aids
cage-aids