EVENT SUMMARY




A combination of development, cloud technologies, on-premise technologies, and so much more, the SSWUG.org Spring Virtual Conference is a must-see event for any database professional in 2017. 

With speakers from all over the world with backgrounds in various technologies, our selection of session are vetted carefully for originality and relevance to bring the highest quality event possible to you, our audience. 


ONLINE REGISTRATION NOW OPEN!

To keep on top of the changes in technology and the industry, attending classes, conferences, and webcasts has become a necessity. SSWUG.org puts together two conferences a year to help you get all that information in one place - allowing you to stay sharp and still have time to do your work. (Thanks, boss!)

SSWUG.org is hosting their Spring Virtual Conference on May 2nd and 3rd, 2017. We know that you have a busy schedule - which is why we would never require you to fly across the country to attend the event of the season! Because of this, this event will take place entirely online, for you to enjoy from your office, home, or anywhere that has an internet connection. 

Also - because we want this event to be available to all, we've made it free! If your job requires continued education or you like to stay sharp, this is the event for you. 

----------

Content and schedule are subject to change without notice.

SESSIONS

All times are Eastern Time Printable Schedule || Times, presenters and sessions are subject to change.

5/2/2017 10:00 AM
-to-
11:00 AM


Track:
Emerald

Introduction to Power BI

Thomas  LaBlanc
Microsoft has taken all the Power features of Excel and consolidated them into a single product: Power BI. From PowerQuery to PowerView, the basics of Power BI involves getting data then making insightful visualizations. Connections to data sources in Power BI are growing monthly in new releases. Changing the structure of data and formatting columns are tracked through a list of steps that can be reversed or copied and used as a different data source. The measure and calculated columns from PowerPivot are integrated like the Tabular Model from Analysis Services. Finally, lots of built-in and custom visualizations are available for free. Once you get the hang of the basics, you can move to advanced analytics like forecasting or using the R Language to perform deeper analysis."}" style="font-size:13px;font-family:arial,sans,sans-serif;">Microsoft has taken all the Power features of Excel and consolidated them into a single product: Power BI. From PowerQuery to PowerView, the basics of Power BI involves getting data then making insightful visualizations. Connections to data sources in Power BI are growing monthly in new releases. Changing the structure of data and formatting columns are tracked through a list of steps that can be reversed or copied and used as a different data source. The measure and calculated columns from PowerPivot are integrated like the Tabular Model from Analysis Services. Finally, lots of built-in and custom visualizations are available for free. Once you get the hang of the basics, you can move to advanced analytics like forecasting or using the R Language to perform deeper analysis.


5/2/2017 10:00 AM
-to-
11:00 AM


Track:
Pearl

Building a Home Grown Auditing Infrastructure for SQL Server

Brian   Kelley
Not everyone has the budget for 3rd party tools to provide audit / security information on their SQL Server environment. If you are in this situation, what do you need to build? What information should you be capturing in order to know what's going on for each of your SQL Servers? How do you gather that information and store it? How do you report on it? In this presentation we'll answer each of those questions, presenting options you can build yourself. We'll look for the most efficient solutions because if you don't have budget, you likely don't have allocated time except for what you can carve out amidst your other responsibilities. Knowledge of T-SQL and Powershell is expected.


5/2/2017 10:00 AM
-to-
11:00 AM


Track:
Sapphire

SQL Server 2016 SP1 changes the game: things you can do now that were Enterprise-only before

Charlie  Arehart
As some may know, the recent release of SQL Server 2016 SP1 included a major change that enables nearly all features to work in all editions. In other words, there used to be features that were Enterprise-only (or Trial or Dev), such that folks on editions below that (Standard, Web, Express, and Express LocalDB) could NOT use, at all. Or you may try things in Trial/Dev only to find they didn't work in production if using one of those other editions, or Azure SQL DB. Now you can use many features previously limited to Enterprise-only. This opens doors to capabilities which will be very helpful, even amazing, to many.

And this is not just about features that are new in SQL Server 2016 but also some features from previous editions which are also now available in editions other than Enterprise (of course, you need to be using SQL Server 2016 SP1 to get the benefit of being able to use such features on an edition below Enterprise).

In this talk, veteran server troubleshooter Charlie Arehart will outline, discuss, and in some cases demonstrate the features that are now available. He’ll also indicated the specific editions where they are, as well as why they are so important, and he’ll conclude with some related changes of interest, all of which can be considered before leveraging or planning for this important change of functionality.


5/2/2017 11:00 AM
-to-
12:00 PM


Track:
Emerald

Creating an End to End Power BI Solution

Devin   Knight
Power BI has a many moving parts that can make it difficult to know when and where each part of the tool is necessary. In this session you will get a clear end to end journey through creating a Power BI solution. Start with the data discovery phase by importing and applying business rules to your data. Then load that data into a data model where you can apply hierarchies and calculations. Finally using that data model design reports to visualize the results. Once complete learn how the results can be shared with others by creating dashboards on the Power BI service. Taking this end to end trip through the tool will allow you to fully understand how each piece fits together.

Sponsored by:


5/2/2017 11:00 AM
-to-
12:00 PM


Track:
Pearl

Reading Execution Plans for Performance Tuning

Thomas  LaBlanc
This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. The, we will answer questions like the following. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?


5/2/2017 11:00 AM
-to-
12:00 PM


Track:
Sapphire

Are Spiders Eating Your Servers? The Impact of Their Unexpected Load and How to Counter It

Charlie  Arehart
For years I've watched people try to tame \"database problems\" with a focus on their code, their SQL, their app server, and so on. Yet often it turns out that the root cause is actually unexpected load. And that load may be from things you never expected (automated), at volumes you never expected. I've found folks with as much as 80% of their web traffic to be such unexpected automated traffic! Worse, there are characteristics of such automated visits that may actually have MORE IMPACT than \"real users\".\n\nA common reaction on learning of this unexpected volume is to want to \"block\" such automated requests, and perhaps some could be, but most just needs to be better \"managed\". (And bad guys have become clever about looking like \"regular users\".) The good news is that there are solutions to better manage (or simply block) such automated requests which may already exist in your environment, and there are tools you may consider (some free, some commercial) which can be easily implemented. There are even SAAS solutions which could help alleviate such problems with just a single tiny change in your environment!\n \nIn this session, veteran server troubleshooter Charlie Arehart will guide a detailed review of the issue, including how to identify such traffic, more on their specific impact, and most important identifying the solutions along with their pros and cons. He has helped shops achieve dramatic reductions in impact from such automated requests, resulting in greater server stability and performance."}" style="font-size:13px;font-family:arial,sans,sans-serif;">For years I've watched people try to tame "database problems" with a focus on their code, their SQL, their app server, and so on. Yet often it turns out that the root cause is actually unexpected load. And that load may be from things you never expected (automated), at volumes you never expected. I've found folks with as much as 80% of their web traffic to be such unexpected automated traffic! Worse, there are characteristics of such automated visits that may actually have MORE IMPACT than "real users".

A common reaction on learning of this unexpected volume is to want to "block" such automated requests, and perhaps some could be, but most just needs to be better "managed". (And bad guys have become clever about looking like "regular users".) The good news is that there are solutions to better manage (or simply block) such automated requests which may already exist in your environment, and there are tools you may consider (some free, some commercial) which can be easily implemented. There are even SAAS solutions which could help alleviate such problems with just a single tiny change in your environment!

In this session, veteran server troubleshooter Charlie Arehart will guide a detailed review of the issue, including how to identify such traffic, more on their specific impact, and most important identifying the solutions along with their pros and cons. He has helped shops achieve dramatic reductions in impact from such automated requests, resulting in greater server stability and performance.


5/2/2017 12:00 PM
-to-
1:00 PM


Track:
Emerald

Deploying SSIS Projects to the Catalog

Thomas  LaBlanc
Integration Services (SSIS) stepper up its enterprise case for managing ETL jobs with the addition of the SSIS Catalog. This container has deployed packages safely stored in a SQL Server database. More integrated than MSDB, the deployed projects enable many ways for SSIS packages to be executed and configured. The Environment for a project has replaced the configuration files of the past. Project Parameters can be shared between packages without having to pass variable values from a parent package. There is also a Project Connection Manager for sharing database connections as well as the expressions used to change the database or server locations. The logging and error tracking in the Catalog has free reports and dashboards integrated into Management Studio for failed jobs as well as performance tracking. Of course, the Data Management Objects have been updated giving you the ability to dig into the execution of the package logs."}" style="font-size:13px;font-family:arial,sans,sans-serif;">Integration Services (SSIS) stepper up its enterprise case for managing ETL jobs with the addition of the SSIS Catalog. This container has deployed packages safely stored in a SQL Server database. More integrated than MSDB, the deployed projects enable many ways for SSIS packages to be executed and configured. The Environment for a project has replaced the configuration files of the past. Project Parameters can be shared between packages without having to pass variable values from a parent package. There is also a Project Connection Manager for sharing database connections as well as the expressions used to change the database or server locations. The logging and error tracking in the Catalog has free reports and dashboards integrated into Management Studio for failed jobs as well as performance tracking. Of course, the Data Management Objects have been updated giving you the ability to dig into the execution of the package logs.


5/2/2017 12:00 PM
-to-
1:00 PM


Track:
Pearl

Performing a Risk Assessment for Your SQL Server Environment

Brian   Kelley
You have SQL Servers you need to secure. But where do you start? In this presentation, we'll look at how to do a security risk assessment on SQL Server. First we'll start off with how to present your findings to management. What information do you need to give them? What will sway them to your side? We'll then switch to the technical side and cover what to look at first: the issues that could lead to a server breach, data loss, and/or a system becoming unavailable due to mismanagement. Finally, we'll discuss how to assess other problems you may find and how to rank and prioritize them.


5/2/2017 12:00 PM
-to-
1:15 PM


Track:
Sapphire

SSIS Packages – Data collection with For Loop

Matt  DeWitt
SSIS packages are excellent tools for data gathering from multiple sources. In an environment where a COTS database is being managed for multiple clients. Data collection for enterprise level data marts and reporting.

Environment: SQL 2014 Enterprise

There are five database instances that have ten databases housed on each. Each database is schematically the same and kept in sync at the DDL level. These databases are used for separate facilities to stored and manage that site’s data. Each facility is separate from the others and no interaction occurs. Each facility is related and under the direction of a controlling entity. That controlling entity needs to be able to report on data and investigate information from a high level view.


5/2/2017 1:00 PM
-to-
2:00 PM


Track:
Emerald

APIs for your Database: Building Dynamic Data Apps with Angular, React & D3.js

Jerod  Johnson
Do you want to see your SQL Server data used in dynamic Web apps? The CData API Server allows you to create universally consumable REST APIs for your databases (plus 80+ other data sources) making it simple to build dynamic Web apps using popular JavaScript frameworks to display and report on that data. In this session, we will cover creating a REST API for your SQL Server databases using the CData API Server and work through 3 sample projects (using Angular2, React, and D3.js) that build dynamic Web apps featuring data from the SQL Server database.


5/2/2017 1:00 PM
-to-
2:00 PM


Track:
Pearl

BEST OF: Powershell

Ben  Miller
 

Sponsored by:


5/2/2017 2:00 PM
-to-
3:00 PM


Track:
Emerald

SQL Server Cardinality Estimator in SQL Server 2014/2016

Dean  Savovic
Cardinality Estimator had a major upgrade in SQL Server 2014 version and 2016. After a few introductory words, I will speak about model assumptions of Cardinality Estimator, calculation direction, model selection of Cardinality Estimator and improvements in SQL Server versions 2014 and 2016. I will also have a few demos where I will demonstrate how to optimally use the new features


5/2/2017 2:00 PM
-to-
3:00 PM


Track:
Pearl

Steps to a Perfect Pitch Presentation

Laura  Rose

Have you ever needed to:

         convince someone to vote for your cause?

         influence someone to purchase your product or service?

         or illustrate why you are the best person for the promotion?

 

Regardless if you are pitching a project, an idea, a product, a service or even convincing your boss why you are the right person for the next high-profile position, being well-prepared is essential.

 

So - what if you had a proven technique in the form of a re-usable presentation structure that can be used to pitch any situation? 

 

This webinar will outline the steps to creating a pitch-perfect presentation that will not only persuade but excite people into action.


5/3/2017 9:30 AM
-to-
10:00 AM


Track:
Emerald

Welcome

 
 


5/3/2017 9:30 AM
-to-
10:00 AM


Track:
Pearl

Welcome

 
 


5/3/2017 9:30 AM
-to-
10:00 AM


Track:
Sapphire

Welcome

 
 


5/3/2017 10:00 AM
-to-
11:00 AM


Track:
Emerald

What Data opportunities can AI/Machine Learning unravel in Healthcare Specialist care?

Saumya  Sanjeev
This session will cover the state of healthcare today, the challenges the industry is facing and how technology can help solve some of the problems.

It will further delve into how bigdata can play a key role in transforming the healthcare landscape globally – making quality healthcare accessible, affordable and patient centric for all.


5/3/2017 10:00 AM
-to-
11:00 AM


Track:
Pearl

New features in Entity Framework 7

Joydip  Kanjilal
Entity Framework is an open source, lightweight,extensible Object Relational Mapper that abstracts the calls to your ADO.Net data access provider underneath. This presentation would discuss the some of the interesting new features / enhancements in EF7.
These include:

  • Support for in-memory data
  • Support for Windows Phone and Windows Store applications
  • Support for new platforms and new data stores
  • Support for Batch Update and Optimized Query generation 


Sponsored by:


5/3/2017 10:00 AM
-to-
11:00 AM


Track:
Sapphire

Indexes - The Unsung Heroes of SQL Server 2014

Pinal  Dave
Slow Running Queries are the most common problem that developers face while working with SQL Server. While it is easy to blame the SQL Server for unsatisfactory performance, however the issue often persists with the way queries have been written, and how Indexes has been set up. The session will focus on the ways of identifying problems that slow down SQL Server, and Indexing tricks to fix them. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

Session Prerequisites: Basic understanding of SQL Server concepts.


Sponsored by:


5/3/2017 11:00 AM
-to-
12:00 PM


Track:
Emerald

Introduction to the SQL Server Query Store

Brandon  Preece
Don't you wish there was a recording of everything running on your SQL Server instance tracking performance data? Well in SQL Server 2016, Microsoft has introduced a new feature called the Query Store. This session will go over how the query store works, how you configure it for your workloads and how to use the information to track performance data. When you leave this session, you will know how to get started using the Query Store.

Sponsored by:


5/3/2017 11:00 AM
-to-
12:00 PM


Track:
Pearl

BEST OF: Everything you wanted to know about Stored Procedures

Jeffrey  Garbus
Everything you wanted to know about Stored Procedures but were afraid to ask. This session talks about stored procedure creation management, performance, and transaction management. We also review and make formal recommendations on optimal coding techniques and mechanisms for managing return values.

Sponsored by:


5/3/2017 11:00 AM
-to-
12:00 PM


Track:
Sapphire

Enterprise Data Lakes: Design Patterns and Anti-Patterns

Vikram  Sharma
Every data centric organization wants to setup their own Enterprise data lake for their needs. The motivation may vary from democratization of data to transparent and centralized access control to just staying up to speed with the buzz. With the recent data explosion, organizations are generating massive amount of data in a variety of forms and velocity. Consequently, the need to maintain a centralized single source of truth that can be utilized to suit multiple needs is greater than ever. However, this is not a one size fits all situation. The needs are different so are the mechanisms and the type of data. We will explore the underlying concepts of an enterprise data lake, common patterns of usage and how to identify what works and what does not for the current need. We will also touch upon the building blocks of data lakes and a comparison and contrast of the available technologies.


5/3/2017 12:00 PM
-to-
1:00 PM


Track:
Emerald

Performance in 60 Seconds – SQL Tricks Everybody MUST Know

Pinal  Dave
Data and Database is a very important aspect of application development for businesses. Developers often come across situations where they face a slow server response, even though their hardware specifications are above par. This session is for all the Developers who want their server to perform at blazing fast speed, but want to invest very little time to make it happen. We will go over various database tricks which require absolutely no time to master and require practically no SQL coding at all. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

Session Prerequisites: Basic understanding of SQL Server concepts.


Sponsored by:


5/3/2017 12:00 PM
-to-
1:00 PM


Track:
Pearl

How to use LogParser to make it easier to monitor your SSRS log

Michael  Wall
Log Parser is one of Microsoft’s best and most under recognized tools. Originally designed to read IIS and system logs, its simple complexity makes it a true “swiss army knife” of a tool. With its ability to read multiple log and text formats and then spit them out in multiple formats, it can be used to quickly analyze large amounts of data and present them in a readable format.

This presentation will start with some basic uses of Log Parser, explain some of the core features, demonstrate some of the challenges, and finally focus on using Log Parser to decrypt SSRS logs. These decrypted logs can then be used as a monitoring system.

As with most things, there are multiple ways to accomplish a task. Log Parser will be a welcome addition to your tool belt!


5/3/2017 12:00 PM
-to-
1:00 PM


Track:
Sapphire

Introduction to Blockchain and cryptocurrencies

Vikram  Sharma
Blockchain is a concept made popular by bitcoin and is the current hot and trending technology that everybody wants to get their hands onto. Blockchain works as a distributed ledger shared across several users, mostly unknown to each other. The beauty of the concept lies in fact that it facilitates making trusted transactions between untrusted users/ machines. Blockchain technology offers a secure, transparent and audit ready mechanism to record digital trail of an interaction or transaction. We will go over the building blocks of a blockchain and explore why is it considered as the next wave of disruption. We will also cover how smart contracts work. We will go over the basic concepts of bitcoin and other popular cryptocurrencies. We will also look at industries/verticals that can be disrupted/ revolutionized using blockchain concepts.


5/3/2017 1:00 PM
-to-
2:00 PM


Track:
Emerald

BEST OF: Ten Query Tuning Techniques Every SQL Developer Should Know

Kevin  Kline
SELECT statements have a reputation for being very easy to write, but hard to write very well. This session will take you through ten of the most problematic patterns and anti-patterns when writing queries and how to deal with them all. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.

Sponsored by:


5/3/2017 1:00 PM
-to-
2:00 PM


Track:
Pearl

How I Use PowerBI as a DBA

Tjay  Belt
Microsoft’s PowerBI is the new hotness. In this session you will get your hands dirty and dive into PowerBI and create an actual report, with actual data. You will get to learn from examples from what a DBA has done to implement PowerBI in his shop and make his data accessible. As a DBA, we often need to collect and display data in a friendly and interactive fashion. We will play with some PowerShell to collect data from several systems, store this data in an Azure DB in the Cloud, then point PowerBI at this data to display and interact with said data. You will learn a little about PowerShell, Azure SQL DB, PowerBI, and how to make these work for you. You will be given permissions to an Azure DB, and get connected to this source. You will also need to have PowerBI desktop downloaded and installed. We will be using this to create the report during the session. So please come prepared to interact with the internet, with a cloud based database you will be provided, and PowerBI Desktop.


5/3/2017 1:00 PM
-to-
2:05 PM


Track:
Sapphire

Working with Entity Framework Core

Joydip  Kanjilal
Entity Framework is a popular ORM and has been in use for quite some time now. Entity Framework Core is a lightweight, open source, extensible, and cross-platform version of Entity Framework. This presentation discusses the architecture of Entity Framework, the new features and enhancements in Entity Framework Core and how to get started using it and work with this ORM to create an Entity Data Model (EDM) and perform CRUD operations.


5/3/2017 2:00 PM
-to-
3:10 PM


Track:
Emerald

PowerShell working with Python and SQL Server

Maximo  Trinidad
As PowerShell is the main technology for automation in Windows Datacenters Infrastructure, now becomes clear its importance in other non-Windows Operating Systems. The way I see it, Windows Admin has the advantage with PowerShell as the Linux Admin has the upper hand with Bash/PHP/Python. Here’s where we can collaborate and work with each other.

Sponsored by:


5/3/2017 2:00 PM
-to-
3:05 PM


Track:
Pearl

SSRS Reports – Variables for reports

Matt  DeWitt
SSRS is an excellent reporting solution. Reporting Server reports can be created with built in criteria and drop down menus to help a user find the correct data for their situation"}" style="font-size:13px;font-family:arial,sans,sans-serif;">SSRS is an excellent reporting solution. Reporting Server reports can be created with built in criteria and drop down menus to help a user find the correct data for their situation.

Environment: SQL 2014 Enterprise

There are five database instances that have ten databases housed on each. Each database is schematically the same and kept in sync at the DDL level. These databases are used for separate facilities to stored and manage that site’s data. Each facility is separate from the others and no interaction occurs. Each facility is related and under the direction of a controlling entity. That controlling entity needs to be able to report on data and investigate information from a high level view.


SPEAKERS

Charlie Arehart

A veteran server troubleshooter who's worked in enterprise IT for more than three decades, Charlie Arehart (@carehart) is a longtime community contributor who as an independent consultant provides short-term, remote, on-demand troubleshooting/tuning assistance for organizations of all sizes and experience levels (carehart.org/consulting).

Tjay Belt

Tjay Belt is an outdoorsman who enjoys riding dirtbikes, waterskiing/boating, playing racquetball and spending time with his family. When he can't be out playing, Tjay loves to tinker with databases. Tjay has been an IT professional for over a decade. Currently serving as a Senior Database Engineer with Cybersource in the Infrastructure Engineering group, TJay has progressed through several roles in his database career including developer, data guy, database developer, database analystand DBA. Prior to Cybersource, he worked at several software companies, working at internal customer sites in the United States and abroad. He has always gravitated to the database side of each job and excelled. TJay studied Computer Science at Brigham Young University and is a member and active volunteer of PASS.

Pinal Dave

Pinal Dave is a technology enthusiast and independent consultant with over thirteen years of experience in the information technology sector. He has successfully authored 11 SQL Server database books, 18 Pluralsight courses and written over 3200 articles on database technology via his blog http://blog.sqlauthority.com. Rounding out his professional career, Pinal has held key positions as Sr. Consultant for SolidQ and as a Technology Evangelist for Pluralist and Microsoft. Pinal holds a Master of Science from the University of Southern California, and numerous professional certifications, including MCTS, MCDBA and MCAD (.NET).

Matt DeWitt

I have been working with databases for almost 10 years. Starting out with database migrations and installation of MS SQL Server 6.5. I have worked in various industries over these years and have found a great fondness for SQL Server. I am now a Database Architect for a healthcare company here in Utah and find myself in the unusual position of working with Oracle. I hope to share some fun stories, tricks and tips and some of the pitfalls I find going through this journey.

Jeffrey Garbus

Jeff Garbus has over twenty years of expertise in architecture, tuning and administration of Microsoft SQL Server databases at hundreds of client sites. He has authored 17 books, developed advanced training workshops, and has published dozens of articles on the subject. Mr. Garbus is the CEO of Soaring Eagle Consulting, an organization that specializes in assisting businesses maximize database performance. His latest book Microsoft Transact-SQL, The Definitive Guide, is available now, use the Coupon Code “GARBUS” when ordering for a 35% discount.

Jerod Johnson

Jerod became a Technical Marketing Engineer for CData Software at the beginning of 2016, coming off of two and a half years working as a developer for CData, creating the very products that he markets and supports now. Prior to his work at CData Software, Jerod was a high school mathematics and computer science teacher. Now he is able to leverage my heart for education, knack for communication, and technical expertise to the benefit of CData Software and its customers, participating in trade shows, writing articles for CData’s blog and for other sites, helping CData’s customers learn how to best use their drivers, and initiating and managing technology partnerships with data sources and 3rd party tools to which CData’s drivers connect.

Joydip Kanjilal

Joydip Kanjilal has won the Microsoft Most Valuable Professional (MVP) award in ASP.NET six times in a row from the year 2007 to 2012. He is a speaker and author of several books and articles. He has more than 15 years in .NET and its related technologies, with more than 14 years in Microsoft .NET and its related technologies. Joydip is currently working as a Principal Software Engineer at DELL International Services at Hyderabad. He has been selected as an MSDN Featured Developer of the Fortnight (MSDN) a number of times and has also been a Community Credit Winner at www.community-credit.com several times. He has authored the following books:
 
Entity Framework Tutorial (Second Edition) by Packt Publishing
ASP.NET Web API: Build RESTful Web Applications and Services on the .NET Framework by Packt Publishing
Visual Studio 2010 and .NET 4 Six-in-One by Wrox Publishers
ASP.NET 4.0 Programming by Mc-Graw Hill Publishing
Entity Framework Tutorial by Packt Publishing
Pro Sync Framework by APRESS
Sams Teach Yourself ASP.NET Ajax in 24 Hours by Sams Publishing
ASP.NET Data Presentation Controls Essentials by Packt Publishing
 
He has also reviewed more than 10 books and authored more than 350 articles for some of the most reputable sites, such as www.msdn.microsoft.comwww.code-magazine.comwww.asptoday.comwww.devx.comwww.ddj.comwww.aspalliance.comwww.aspnetpro.comwww.sql-server-performance.comwww.sswug.org, and so on.
 
He has years of experience in designing and architecting solutions for various domains. His technical strengths include C, C++, VC++, Java, C#, Microsoft .NET, AJAX, WCF, JQuery, ASP.NET Web API, REST, SOA, Design Patterns, SQL Server, Operating Systems, and Computer Architecture. Joydip has been exploring Cloud technolgies, IoT and Machine learning these days.
 
He can be contacted at:
 
 

Brian  Kelley

Brian is a SQL Server author and columnist focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress) and Professional SQL Server 2008 Administration (Wrox). Brian currently serves as an infrastructure and security architect where he works on Active Directory, Windows security, VMware, and Citrix in addition to Microsoft SQL Server. In the technical community, Brian is part of the Midlands PASS Chapter, an official chapter of PASS, where he currently serves as president and director of communications. Databases - Infrastructure - Security The Goal Keeping DBA

Kevin Kline

Kevin Kline is a renowned database expert and software industry veteran. A long-time Microsoft SQL Server MVP and noted leader in the IT industry, Kevin is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a top-rated speaker at industry trade shows worldwide. He tweets at #kekline and blogs at http://KevinEKline.com.

Devin  Knight

Devin (MCTS, MCITP) is a Senior BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin helps run his local users’ group (JSSUG) as a Vice President.

Thomas LaBlanc

Thomas LeBlanc is a Data Warehouse Architect in Baton Rouge, and uses his 25 years in IT to help develop OLTP systems with normalized databases for high-performing T-SQL systems and end-to-end dimensional data marts using SSIS, SSAS, 3rd party apps, and Excel. His SQL Server certifications include MCSA 12, MCITP 08 BI and DBA, MCITP 2005 DBA, and MCDBA 2000. As a PASS volunteer, he is currently the Excel BI VC chair and past chair of Data Arch VC and VC Mentor. Thomas has spoken at the PASS Summit for the last 4 years(2011-2014). Local work includes the Baton Rouge SQL Server User Group and assisting with four SQLSaturday’s. Bing TheSmilingDBA for more information about Thomas

Ben Miller

Ben has been a member of the SQL Server Community for over 14 years now. He is currently a Director of Database Admin at MaritzCX in Lehi Utah. He is a SQL Server MVP and has spent time in the field using SQL Server since 1997. He has worked at various companies throughout the US as well as at Microsoft for 7 years. He is passionate about SQL Server and automation and integration. Ben is also a SQL Server MCM (Microsoft Certified Master). He can be found on the internet as DBAduck (Twitter, LinkedIn, Facebook and Blog).

Brandon Preece

Brandon Preece started from the early days of SQL Server. His first migration was from SQL Server 6.5 to SQL Server 7.0. Since that day, he has loved being a Database Administrator working with every major version since then. He now manages the best SQL Server Team you will ever find (maybe he is a little biased). He love teaching technology and helping others find the best way to use this incredible tool that we all love called SQL Server. I work with SQL Server during the day and have been for many years. I enjoy teaching and making a difference. In my free time, I like action sports. I enjoy snowboarding and Mountain Biking. I started doing triathlons in 2015 and am liking the challenge.

Laura Rose

Laura Lee Rose has been in the software and testing industry for over 20 years. She’s worked with such companies as IBM, Ericsson, Staples, Fidelity Investments and Sogeti in various client advocacy and project management roles. The techniques she used in her business coaching and client advocacy work saved these companies both time and money, which resulted in on-time, quality product delivery with higher client satisfaction.

Even though Laura excelled in the corporate environment, she felt a calling toward something more.  Laura now uses her time management, work life balance and personal development skills as a life coach and Corporate Exit Strategist.  Laura Lee Rose helps people blend their goals and dreams into their everyday lives. Laura uses creative transition strategies to help her clients realize what really matters to them. Combining inspired action with practical, tangible techniques easily lead you toward more autonomy, freedom and balance. 
 
If you are ready for your next chapter, learn more about Laura and her products at www.LauraLeeRose.com

Saumya Sanjeev

A technology enthusiast who loves solving complex business problems with tech-enabled solutions with an aim to positively impact over a billion lives through new age thinking and strategy models.

A senior leader in the business and technology industry known for strategy and execution resulting in improved productivity, speed of delivery & customer satisfaction.

Passionate about improving healthcare globally and encouraging ‘Women in STEM’. Trained and enjoy classical music, theatre and music.

Dean Savovic

Experienced project manager, software architect and developer. System designer, database specialist, experience with managing, optimizing and developing Microsoft SQL Server (certified MCDBA). Experienced lecturer, held numerous MOC seminars (certified MCT). Certified project manager (Project Management Professional (PMP)) using project management methodologies in practice.

Specialties: Software architecture and analysis. Project management implementation and consulting. Server and database performance tuning and optimization

Vikram Sharma

A Technical Project Manager with more than 15 years of engineering experience designing and delivering highly-available, multi-tenant web, XML/SOAP/REST endpoints and services, and rich client applications, using JDBC/ORM or XML to interface to backing data stores. Experienced with assessing, monitoring and optimizing performance of applications interfacing and aggregating large data stores. Certified Scrum Master and Safe 4 agilist , responsible for delivering big data programs across verticals of the financial domain. Experienced in making use of cutting edge technologies through industry best practices and design patterns to define solutions mapping business needs to technical capabilities.

Maximo Trinidad

I’m from Puerto Rico, have been working with computers since 1979. I work with SQL Server Technologies, providing support to Windows Servers/Client Systems, Microsoft Cloud and finally Linux. I’m a Microsoft MVP, SAPIEN MVP, and IDERA ACE 2017. I speak in most of the SQLSaturday, IT Pro and .NET camps events around the Florida’s State. Also founder of the Florida PowerShell User Group which meets online every 4rd Thursday evening of the month.

Michael Wall

Michael Wall has been a Database Administrator since he was asked if he wanted to be one after successfully managing the Y2K upgrade project on over fifty UNIX servers. Immediately thrust into a major Oracle upgrade project, he has since then managed multiple challenges and now is the sole DBA for a global food processing company responsible for both SQL Server and Ingres databases.

He is active in his local SQL Server community and hopes to make it to PASS this year!

Sponsors

PAVILION Sponsors




IDERA designs powerful software with one goal in mind – to solve customers’ most complex challenges with elegant solutions. We don’t abide by the belief that a professional must sacrifice powerful features and quality for fast time to value and ease of use. With IDERA, you really can have it all. Our unique DNA is reinforced by a user community of nearly 100,000 database and IT professionals who use and evangelize our tools. From our award-winning SQL Server database solutions to multi-platform database, application and cloud monitoring tools, IDERA ensures your business never slows down.




Founded in 1999, SSWUG.ORG is an industry-leading website that provides news and information on data management, collaboration software, development tools and cloud computing to more than 550,000 registered users. Events and instructional videos are regularly provided, and in-depth articles are posted daily onto the site. For more information, visit www.sswug.org.




The vConferenceOnline platform let's you hold complete online events, complete with live sessions, simulated live and on-demand sessions, all in the same event.  From webinars to full virtual events with sessions, booths, chat and much more, vConferenceOnline and the team that helps you each step of the way, will make your event shine.  

For the first 5 people that request it, we'll host a free webinar for your audience, complete with project management and other goodies.  We'll provide the platform and tech support and everything you need to have a great event.  

The platform has many options - from helping you monetize your youtube channel, to marketing and customer (and pre-sales lead) education.  We work hand-in-hand with you and provide ideas, best practices and guidance about what works, what doesn't, unique ideas and lessons learned from the many, many events we hold.  

Contact us - let's chat about your projects for leads, education and more!