Hampton Roads Sql Server User Group (HRSSUG)

Speaker – James Donahoe (view bio)

Session – New Instance, Now What?

Congratulations, you’re now our DBA! For new DBA’s a new SQL instance is like a blank canvas, you stare at it and wonder where to start. As an accidental DBA, this session will help you learn how to survive in your new role.

In this session, you will be supplied with the beginning brush strokes to make your server a master piece. To do so, we will review best practices for standard configurations, backups, maintenance, and disaster recovery.

By the end of this session, you will have developed a pallet of tools to help you create your SQL Server Masterpiece and be able to use it as a print for others.

Speaker – Melissa Coates (view bio)

Session – Building Blocks of Cortana Intelligence Suite in Azure

Join us for a practical look at the components of Cortana Intelligence Suite for information management, data storage, analytics, and visualization. Purpose, capabilities, and use cases for each component of the suite will be discussed. Expertise required for implementation of each component will be covered as well. If you are a technology professional who is involved with delivering business intelligence, analytics, data warehousing, or big data utilizing Azure services, this technical overview will help you gain familiarity with the components of Cortana Intelligence Suite and its potential for delivering value.

Speaker: Wayne Sheffield (view bio)

Topic –Minimally Invasive – Tools to Doctor Up Your Code

This code filled session examines several additions to recent versions of SQL Server. These tools allow you to perform minimally invasive surgery on your code and gain performance! Learn how the APPLY operator works; iterate through incoming data just once with the MERGE statement; “slice and dice” your data with the Windowing (ranking) functions; re-write your multi-statement table-valued functions to inline functions to help the optimizer and speed up your queries; learn how to create a grouped delimited list – without loops!

Speaker – Jessica Moss (view bio)

Topic – SQL Server 2016 On-Premises Business Intelligence Tool New Features

Business intelligence developers and users everywhere are happily anticipating new updates to the on-premises business intelligence tools for SQL Server.  With the full release of SQL Server 2016 around the corner, Microsoft has released several preview versions of the on-premises tools.  Based on these previews, we can expect to see updates in Reporting Services, such as customizable parameters, mobile reports, and new chart types.  Integration Services also boasts new changes, such as incremental package deployment, better error handling, and new logging levels.  Finally, Analysis Services has additional features, including new DAX functions and extended event viewing.  This session will cover these new items and more in a demo-focused presentation.

Speaker: Kenneth Jensen (view bio)

Session: SQL Injection and the DBA

Per OWASP, SQL Injection (SQLi) is the number one threat to database driven web sites. But the SQLi menace is not limited to just web attached databases, all databases are threatened.

If you are asking yourself, what is SQL Injection, how can it affect my company or what can I do about it as a database professional, this session is for you.