Session List
Full Schedule
Date/Time Session Room
10/24/2017 9:00 AM -to- 11:00 AM Chatbots Design Patterns
Vikram Sharma
Chatbots are looked upon as the next big thing. Industry experts have forecasted the chatbots to take over from apps as the new niche skill. Given the never before emphasis on artificial intelligence and self-learning programs is aiding to this ascent of chatbots. The design and production of interactive chatbots presents new possibilities, enabling the development and creation of new niche markets and areas that can be made so much better through chatbots. We will go over what is chatbot and the building blocks of a chatbot. We will also cover the common patterns of a chatbot design so you can figure out if a chatbot is for you and if yes, which one is the best fit. We will briefly touch upon the best practices to implement your chatbot idea.
10/24/2017 11:00 AM -to- 12:00 PM Social Media Mining and Sentiment Analysis
Vikram Sharma
Humans are social animals, a lot of decisions in our lives are taken based on what other people prefer or choose. A very important part / way to acquire knowledge is to keep opinions of similar and like-minded people handy. In some cases the reverse is also true. With the growing availability and popularity of information-rich sources on the social media, new opportunities have presented themselves that one can employ to quickly test the waters, predict and correct the strategy to suit the current sentiment. Opinion mining and sentiment analysis, which deals with the computational treatment of opinion, sentiment, and subjectivity in text, has come up in leaps and bounds and is widely used across industries to make decisions and audit the current strategy. We will go over the basics of social media mining and the different methods to perform sentiment and opinion mining and how-to draw meaningful insights from this mining. I will take an example and demonstrate the concept using python and twitter feed. We will also touch upon popular applications of this concept and the impact it made.
10/24/2017 11:00 AM -to- 12:00 PM TBD
Stephen Wynkoop
10/24/2017 12:00 PM -to- 1:00 PM THE LEADERSHIP ORBIT™: Attracting the Right Followers
Laura Rose

Many people have passion; many people have goals; but the leaders of this generation need more. 

 

They need to have a vision, mission, a strategy or plan of action, execution and the desire for continuous improvement of the plan and execution.T

 

This presentation introduces the idea of using the Law of Attraction and The Leadership OrbitTM  to attract the right followers

This presentation will answer the following:

 

What differentiates leaders?
What is The Leadership OrbitTM?
How can The Leadership OrbitTM be used to achieve your goals?
10/24/2017 1:00 PM -to- 2:00 PM Remote Diagnosis
Saumya Sanjeev
TBD
10/24/2017 2:00 PM -to- 3:00 PM Query Store and Query Optimization on SQL Server 2017
Dean Savovic
In this session, I will talk about advantages of Query Store, features, configuration and query optimization using Query Store on SQL Server 2017. Session will also cover how one can monitor query performance, how Query Store gathers data and which are the best practices for using Query Store. During the session there will be various demos.
10/24/2017 3:00 PM -to- 4:00 PM Becoming a Master by Letting go
Michael Wall
A talk on mentoring, knowledge management systems, and the value for passing on knowledge for both the teacher and the student.
10/24/2017 4:00 PM -to- 5:00 PM Automating SQL Server Transactional Replication
Michael Wall
One of the weird things about replication is that if you tear it down (which you have to do a lot), is that it creates new jobs when you bring it back up. My process (I’m sure I’m not the first), shows how you can set it up so anyone on your team can literally push a button so they can bring down replication for downtimes, upgrades, and other issues.
10/25/2017 10:00 AM -to- 11:00 AM Security "Best" Practices That Aren't
K. Brian Kelley
You want to secure SQL Server. As with every established technology, you find a lot of security “best practices” to implement. The number of different recommendations can be overwhelming. Some even contradict others. If you’re familiar with auditors and meeting compliance requirements, you are probably thinking that some of these best practices contribute nothing to security. We just do them to check a box. So what are those “best” practices for SQL Server security that really aren’t? In this session we’ll look at some of the recommendations that are out there and why they aren’t effective controls.
10/25/2017 11:00 AM -to- 12:00 PM Automating SQL Server Installation and Configuration
K. Brian Kelley
In the current fast paced environment that is information technology, we want to build fast and we want to build consistently. When it comes to SQL Server, that means automation. We want to automate the whole build process, from the server deployment to the after installation scripts. In this session we’ll look at what you can automate, how to do it, and how to include some options for customization using a template-based approach. We’ll also look at how to set specific configuration and attempt to maintain them beyond installation.
10/25/2017 12:00 PM -to- 1:00 PM Introducing Microservices
Joydip Kanjilal
Microservices is an architectural approach for building flexible, extensible, independently deployable services with each of these services running and communicating using lightweight communication mechanisms.

This presentation helps the reader to learn what Microservices are, provides a high level architectural overview of Microservices, and discusses the benefits, drawbacks and challenges of Microservices. Lastly, it illustrates how one can build Microservices using .NET Core.
10/25/2017 1:00 PM -to- 2:00 PM New features in .NET Core 2
Joydip Kanjilal
NET Core is a light-weight, extensible, cross-platform, and open source managed software framework from Microsoft. The software giant has recently released .NET 2. This session discusses what .NET Core is all about, differences between .NET Framework and .NET Core, why .NET Core useful, where it is applicable and the new features and benefits in .NET Core 2. Lastly, it presents a discussion on how we can get started working with .NET Core 2 in Visual Studio 2017.
10/25/2017 2:00 PM -to- 3:00 PM New features in Entity Framework Core 2
Joydip Kanjilal
Entity Framework Core is a lightweight, extensible, and cross-platform version of Entity Framework - Microsoft's flagship ORM. This session presents an introduction to the core concepts in Entity Framework Core followed by a discussion on the new features and enhancements in Entity Framework Core 2 with code examples and demo to illustrate the concepts covered.
10/25/2017 3:00 PM -to- 4:00 PM Adopting an Enterprise Data Security Approach to Safeguarding Data Assets
Scott Simmons
In a review of recent data breaches - it is clear that traditional mechanisms for data protection are simply inadequate. The emergence of the cloud, micro-services, social media has necessitated a re-evaluation of how to safeguard data assets especially PII (Personally Identifiable Information), PHI (Protected Health Information), and PCI (Payment Card Information). Regulatory statutes are additionally influencing these requirements including GDPR, HIPAA, and Privacy Shield. This presentation will review the current challenges and the requirements arising from these new trends providing an action plan for an enterprise data security approach based on Data-Centric Audit and Protection (DCAP) solutions.
10/25/2017 4:00 PM -to- 5:00 PM SQL Server Containers and Clones
Paul Stanton
“Containers and Clones for SQL Server Development and Test”

Microsoft is emphasizing the use of containers for development and test on SQL Server 2017, and new solutions from Red Gate and Windocks add support for containers and SQL Server database database cloning, for the full range of the SQL Server family.

We’ll explore use of Docker based tooling for delivery of container environments, and their pros and cons. We’ll also look at SQL Server cloning, and how clones enable Dev and Test teams to work on large database environments for containers as well as existing SQL Server instances.