Cleveland, Ohio, United States
Sam Nasr has been a software developer since 1995, focusing mostly on Microsoft technologies. Having achieved multiple certifications from Microsoft (MCSA, MCAD, MCTS, and MCT), Sam develops, teaches, and tours the country to present various topics in .Net. He’s involved with the Cleveland C#/VB.Net User Group, where he has been the group leader since 2003. In addition, he’s the leader of the .Net Study Group, an author for Visual Studio Magazine, and a Microsoft MVP since 2013. When not coding, Sam loves spending time with his family and friends or volunteering at his local church.
FileTables is a SQL Server features that allows easy storage and access to documents dynamically. After some initial setup, users can simply drag files into a folder and then be able to access their meta-data and contents through SQL Server, seamlessly. Due to the way FileTable uses the FileStream feature, it stores files on the file system but maintains the metadata in the database. This allows full control over the file while not bloating the database.
SQL Server 2016 provides several new security features for developers and architects. Features such as Dynamic Data Masking (DDM), "Always Encrypted", and Row-Level Security provide an additional level of security natively through the database server. We'll explore the implementation of these features on the client/server for data in transmission or at rest. In addition, we'll examine built-in features and custom implementations.
After being thoroughly revamped, SSRS (SQL Server Reporting Services) offers several new features, making it more robust than ever. These features include Web Report Portal with KPI, Mobile Report Publisher, Redesigned report rendering engine supporting HTML5, and treemap & sunburst chart types.
With intuitive interfaces and rich data visualization, business users and stake holders can now view valuable information, not just numbers. This session will cover requirements for installing and configuring SSIS, and how to quickly generate reports.
JSON functions have been included with SQL Server 2016 and later, allowing data to be retrieved in JSON formats, as well as writing JSON documents to tables. By using these functions, data can be retrieved in a ready to use format by applications or sent to other trading partners. We'll discuss the basics of JSON, and demonstrate the use of SQL Server's built-in JSON functions.
Azure offers a variety of different storage options, each with its own pros and cons. Some of these include Blob Storage, File Storage, Table Storage, and Queue Storage. In this session we’ll explore the various options, where they can be a fit, and demonstrate how they can be implemented.
Machine Learning has been gaining wide acceptance due to its ability to make a determination in various scenarios based on specific training. It is now available to .Net developers for integration into applications. This allows it to be effective and ubiquitous in the enterprise. .Net developers can now incorporate machine learning into line-of-business applications using Visual Studio and C#. This session will walk you through the fundamentals of creating an ML integrated application and ongoing model training.
The ASP.NET Web API framework allows a single Web service to communicate with multiple clients in various formats such as XML and JSON directly over HTTP. The architecture is designed to support applications built with REST, but it does not force new applications to use a REST-style architecture. In this session we’ll discuss various ways of creating and consuming Web APIs, different output formats, including BSON, and tools for testing and debugging.
Artificial Intelligence has been available to developers via API or libraries for integration with Code. Now SQL Server offers Artificial Intelligence via T-SQL. In this session we'll look at specifying a model for making decisions about time series data, programming the model using T-SQL, and evaluating the results of the model.
Most web applications simply provide the content for the user along with a standard list of links and articles. Wouldn't it be nice to be able to customize this list of links for each user, making it a better user experience? The Azure Custom Decision Service provides contextual decision-making, allowing for a more robust user experience. It does so by converting content into features for Machine Learning. This technology utilizes several other Microsoft Cognitive Services, such as Entity Linking, Text Analytics, Emotion, and Computer Vision for a more personalized and intelligent experience.
Blazor is a .NET web framework used for building web applications that can run in any browser. It uses C#/Razor and HTML, with no plugins needed. Blazor runs in the browser on a real .NET runtime (Mono) implemented in WebAssembly that executes normal .NET assemblies. It also supports older browsers by using an asm.js based .NET runtime.
Many times developers have to support users by answering the “What happened to the data?” The task of retrieving data from a specific point in time is not an easy one. Often this involves retrieving a backup and restoring the data in question (hopefully!). SQL Server 2016 introduced Temporal Tables, allowing a developer to retrieve data from a specific point in time, without backups. With a few TSQL commands a historical table can be created, automatically updated, and readily accessed.
The Custom Vision Service is part of Azure's Cognitive Services. It allows you to build classifiers that recognize specific content in images. Through machine learning, a classifier can be trained to recognize key factors in a picture that are specific to your application. In addition, the Custom Vision Service could be used for filtering image content for a web site, expediting the content filtering process.
With security attacks on the rise, protecting your applications and data is more of a necessity than ever before. We’ll discuss some of the features provided by Visual Studio and the .Net framework, such as Dotfuscator, SignTool, and encryption tools. In addition we'll look at other protective measures such as early intrusion detection, mitigation, and Social Engineering. These are topics not typically covered in other security presentations or material.
Managing all the resources for an application to run properly can be daunting. Application require the proper hosting environment and DB access, with sufficient capacity to accommodate usage spikes when site demand increases temporarily. With Azure offering a variety of services for infrastructure, development platform, and software services, the decision to migrate to the cloud can be a difficult one. In this session we’ll review the various options available in Azure, helping you to identify the best migration path.
Language Understanding Intelligence Service (LUIS) is part of Azure's Cognitive Services. It's built on the interactive machine learning and language understanding research from Microsoft Research. Luis provides the capability to understand a person’s natural language and respond with actions specified by application code. In this session we'll examine how this powerful feature can be integrated into applications, offering a more natural interaction with a device.