Universal Apps – What it Means to You

8:30 am on

Want to get the most bang for your buck? Universal Apps give you a great way to get in front of the changing landscape of Windows development and to maximize your ROI. You’ll find out how to make your app quickly and efficiently for all the screens.

Start getting ready for the next wave now!

PowerShell for Developers

8:30 am on

Microsoft Most Valuable Professional (MVP) Doug Finke takes us through PowerShell from a developer’s point of view. Doug shows techniques for integrating/debugging PowerShell from
and to C# code as well as using PowerShell with a Windows Presentation Foundation (WPF) application. He also addresses using reflection at the command line, object pipelining, and
PowerShell’s REPL. Plus, time permitting, Doug will highlight some of the new features in the PowerShell v5 November Preview.

Hack the Planet

10:00 am on

The best way to learn how to protect yourself is learn the techniques that will be used against you. This session is an intro to hacking using the tools that black-hat hackers use on a regular basis to detect and exploit vulnerabilities and how to protect yourself against them. Learn how horribly unsecured Wi-Fi is and some of the most common web site vulnerabilities.

Web Developer by Day, Game Developer by Night

11:30 am on

Today’s modern browser is an excellent platform for games. If you’re developing web applications, you already have the skills you need to make and publish your first game! What you need to learn now are the fundamentals of game development. It is a different way of thinking than we are used to when building business applications, but the result is high performance graphics, audio, and controls that you can use to make the game you’ve always wanted. Support touch, mouse, keyboard, or the controller from your Xbox! The web is truly ready for game development.

In this talk, Chris will introduce you to PhaserJS. It takes care of the basics so you can concentrate on your game. We’ll build a basic game using HTML and JavaScript and you’ll see that it fits right at home on phones, tablets, and desktops. We’ll discuss using powerful toolkits like Apache Cordova to publish to iOS, Android, Windows Phone or the Windows Store. Afterwards, you’ll have taken your first step into the world of building games and have the support of a growing community behind you!

Building high performance JavaScript games using BabylonJS & WebGL

1:30 pm on

After an introduction to BabylonJS and using your web development skills to make games that run in the browser, we continue with more samples and labs.

Be sure to bring your laptops so you can work with the labs right on your own system.

This series will be the easiest to pick up for seasoned web developers who are familiar with JavaScript.  However, everyone interested in game development can benefit because the skills for game development are often different from business development anyways.

Using the BabylonJS library, we’ll have been building 3D worlds that run in your browser without any plug ins or add-ons.

Getting Fired up About Ember.js

3:00 pm on

Ember.js is an exciting client-side application framework that makes it very easy to get a lot accomplished with very little code. Once you understand the basics of how Ember.js handles MVC (it’s a little different from server-side MVC!) and routing, you will enjoy the productivity boosts the framework offers you. In this session I’ll introduce you to Ember.js basics, how to handle data, and how to use Handlebars templating to build your application. Upon leaving the session, you’ll be ready to join Groupon and Square and many other companies using this hot new framework!

All Developers Can Be SharePoint Developers

8:30 am on

Sold Out

Until recently, SharePoint was the red-headed stepchild of the Microsoft web development world, requiring intimate knowledge of SharePoint and it’s gargantuan object model. This made SharePoint a very specialized skill-set that stood off to the side on its own.  It’s lack of support for standard web-development practices made it difficult for new developers to learn – or to even want to learn.

Fortunately, this has changed.

SharePoint 2013 has joined the rest of the web-development world – supporting standard technologies such as REST, and languages ranging from .NET to Perl, PHP, Ruby, etc. JavaScript is now a first-class citizen.  Gone are the days when “doing SharePoint” required extensive, arcane knowledge. For developers, SharePoint is now just another data store accessible via a robust, REST-based API.

In this full-day session, SharePoint MVP David Mann will introduce the SharePoint REST API and show how it can be used to build client-side applications using JavaScript, utilizing popular frameworks such as Angular and libraries such as JQuery, common tools like Node, Bower, Gulp and Yeoman, as well as rich-client applications using C#. This includes both on-premises installations of SharePoint as well as cloud-based environments such as Office 365.

Bring your laptops as this is a hands-on session.  No SharePoint experience is necessary, but basic programming skills would be a big help.  This is a great opportunity to add SharePoint to your toolkit, or to take your SharePoint skills to the next level.  Individuals and teams are welcome. 

Details, including what you need to bring for the labs are available here: http://blog.mannsoftware.com/?p=1881

Building Secure Applications in Azure SQL Database

8:30 am on

SQL Azure Database has undergone massive change in 2015. In this session you will learn about how to secure your data end to end, and about the available mix of security and encryption technologies in SQL DB. You will learn about the benefits of Always Encrypted, Transparent Data Encryption, and row-level security.

SQL Server 2016 Always Encrypted

10:00 am on

Join this session by security expert Sebastian Meine (PhD) for an introduction to the fascinating new SQL Server 2016 feature Always Encrypted. In this session, geared towards the Database Developer, you will learn what makes Always Encrypted more secure and easier to use than prior encryption technologies available in SQL Server. After exploring the architecture behind this new feature, you will be able to observe how to implement Always Encrypted in SQL Server and discover how it might affect your maintenance and recovery strategies.
After attending this session, you will be able to:
• Explain how Always Encrypted works.
• Setup and use Always Encrypted in your own SQL Server 2016 environment.
• Identify places in your application that might require small changes.
To benefit from this 200 level session, you should feel comfortable writing stored procedures and views and not be scared when seeing C# code.

SQL Server Database Administration for the Non-DBA

11:30 am on

If you are a developer or systems admin, have just been handed a SQL Server database, and have no idea what to do with it, this session has some answers for you. The session covers a variety of topics, including backup and restore, recovery models, database maintenance, compression, data corruption, database compatibility levels, and indexing.

Although this session doesn’t teach you everything you need to know, it gives you some insights into the SQL Server database engine–and the ability to know what you’re looking for.

Sending a Variable Number of Elements in a Parameter and more…

1:30 pm on

In this session with the audience I would like to go over the options that DBAs or developers can use when a table or the multiple rows of values need to be sent to a stored procedure as a parameter. With today’s technology we have several different options to accomplish this task. I will also demonstrate table variable misconceptions.

Self-service ETL with Power Query

3:00 pm on

A common requirement when creating a data model is to transform the data after it is loaded from the source and before it is loaded into the data model. For example, you may need to group, pivot, replace, or expand the data. In a traditional data warehouse implementation this is performed using an ETL (Extraction, Transform and Load) tool such as SQL Server Integration Server (SSIS). While SSIS is a great tool for developers it is not meant for Business Analysts implementing self-service BI. To enable self-service ETL Microsoft has created a great tool – Power Query. Power Query lets the user create robust transformations using an intuitive interface and then loading the results into a Power Pivot Model. This session guides you through the process of using Power Query to extract, transform and load data into your data model from a variety of sources.

Introduction to R

8:30 am on

R is the key language for Data and Statistical Analysis. It has been around for some time but is now going to be included in SQL Server 2016. This is a big deal as it provides an integrated set of analytical and data manipulation tools into the SQL environment and simplifies programming over what is available in TSQL and .NET extensions.

This session will provide some use cases and an overview of R, the development process and how to get about learning the tools. This session will be heavy on examples.

T-SQL for .NET Developers: Most Common Misconceptions

10:00 am on

Throughout the last decade, having worked on various code reviewing, performance tuning and optimization, I have experienced many hidden T-SQL misconceptions that caused problems for the applications that use SQL Server. In this session, I will go over many scenarios and will demonstrate the appropriate problems and solutions. Sessions are fully code-based; no PowerPoint will be used in this lecture.

Transact-SQL for Developers – attendees choose

11:30 am on

That’s right, attendees choose! I’ll show 30 possible topics on the screen, and the attendees vote on which topics I’ll cover. Everything from isolation levels to ranking…everything from GUIDs to table-valued functions….everything from querying temporal data to instances where subqueries are necessary….everything from update triggers to reading execution plans. The good news is that you’ll walk away with 30 code samples, even though we’ll only cover a portion of them in the presentation. This has always been a very popular session.

Bring SOLID to Web Development

1:30 pm on

An in depth look at the SOLID design patterns and how to use them when building Single Page Web Application. In this talk you will learn about applying the Model View Controller (MVC), Gang of Four and dependency injection patterns to build stable and maintainable applications that are built to last.

SQL Server Reporting Services for Developers – attendees choose topics!

3:00 pm on

In this presentation, I’ll show over a dozen different SSRS topics, and allow attendees to select which topics to cover. Everything from sparklines to heat maps, from Tablix-drilldown reports to advanced charts, from performance gauges to subreport/drilldown reports to new page/group control features in R2….and even topics like data-driven subscriptions, reports against OLAP cubes, and deploying to SharePoint. There are even topics for integrating SSRS reports into ASP.NET pages, and launching SSRS reports using C#. Since no presentation can cover all the topics, I’ll let the majority of the audience decide which to cover.

Contain Yourself

8:34 am on

Both Windows 10 and Windows Server 2016 have containers built in to the OS. In this class we will go over the how to use Docker to take advantage of container technology. We’ll setup Docker, learn about Compose and Swarm and go over building and deploying containers.

Micro controller Setup and Development With RiPi and Pine64. Using Windows 10 IOT to talk to Android/Linux

8:30 am on

Setting up a Home security system with DIY IOT parts requires a “Certain set of skills” in this session we will talk about the ways to make IOT instances of Windows 10 IOT talk with Remix 2.0 (an Android distribution http://www.jide.com/remixos that comes with Pine 64 2GB Boards)
We will also talk about how to make your IOT Devices talk to Linux.

This is a high level overview of options available to you as a developer with or without internet access. (Internet Access is required for development of the applications but not required to run the applications in a self hosted environment)

While there are many ways, we are going to use the RestClient Communication process to exchange data between IOT devices and a self hosted API Interface, and with time allowed I can show how easy it is to migrate your self hosted Rest Storage interface to Microsoft Azure IOT services.

Applications Used:
Visual Studio 2015 Update 3 : Windows 10 UWP App, MVC5 WebAPI App, NuGet
Eclipse : Android App

CONVERT_IMPLICIT is a hidden danger

10:00 am on

The CONVERT_IMPLICIT operator is part of an execution plan. When an execution plan has a CONVERT_IMPLICIT operator, this is a signal that “your statement has a problem”. This presentation will show you how to detect the Execution Plans with CONVERT_IMPLICIT operator; how to find the statement that causes conversion, and what DMVs can help to solve the problem. It will also show you the solution to collect the Execution Plans with CONVERT_IMPLICIT operator across the servers.

T-SQL for Application Developers – Attendees chose

11:30 am on

That’s right, attendees choose! I’ll show 30 possible topics on the screen, and the attendees vote on which topics I’ll cover. Everything from isolation levels to ranking…everything from GUIDs to table-valued functions….everything from querying temporal data to instances where subqueries are necessary….everything from update triggers to reading execution plans. The good news is that you’ll walk away with 30 code samples, even though we’ll only cover a portion of them in the presentation. This has always been a very popular session.

How to Create an Alexa Skill

1:30 pm on

By now you must have heard of it – the Amazon Echo. It is leading the smart home battles and has become the device everyone is playing catch up to. And yet, the application (or skill) offerings are very low (only about 2,000 at this point). This means it is still a great time to learn how to create an Alexa skill and get millions of people to interact with it. By using Amazon’s REST API, JavaScript, and Node.js we will build an Alexa Skill that can be hosted in the cloud and available to all Alexa devices (Echo, Tap, Dot, Fire TV, and a host of other devices embedding the Alexa Voice Services). This session will cover an introduction to the Echo and the current development environment for building skills. We will use that knowledge to build a working skill and experiment with it during the session.

13 Reasons to upgrade to SQL Server 2016 Enterprise

3:00 pm on

SQL Server 2016 is one of the most important versions in the history of Microsoft SQL Server. In this presentation I’ll walk through 13 enhancements in SQL Server and why they are important. I’ll cover SSRS enhancements, changes to in-memory OLTP and Columnstore index functionality, the new Query Store, new row-level security, temporal tables, and many others. If you want to see a good (and fast) deep-dive on what’s new in SQL Server 2016 Enterprise, this is the session to attend!