Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type


Sessions Found: 26
Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process.  PowerShell scripts can greatly reduce the time required to complete the process.  They can also ensure build standardization throughout your SQL environment.  In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of a SQL Server.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment & Monitoring

Level: Beginner

Session Code:

Date: March 18

Time: 9:40 AM - 10:40 AM

Room: 124

Here is the abstract  If there was one question you could ask your CIO, what would it be? In this session you'll have the opportunity to hear a panel of three CIOs and CTOs discuss the State of IT in Virginia while covering topics such as technology strategy, leveraging cloud technologies, Big Data and more. This panel discussion will be moderated by Solvaria's CEO, Greg Samuels, and panelists will include Alex Tulchinsky, CTO of UNOS, Alan Hagerman, VP of Technology at KBH Business Management Systems and Jeffrey Potter, CTO of Davenport Investments. This interactive session is geared at all levels of experience, so we hope you'll come with questions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 18

Time: 12:40 PM - 1:40 PM

Room: Salon 1

Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment & Monitoring

Level: Beginner

Session Code:

Date: March 18

Time: 10:50 AM - 11:50 AM

Room: Salon 3

One of the most common problems I have encountered as a DBA is the complaints from users that a particular query is slow, just one query.  Many times one that used to run in acceptable time, but that over time has slowed down substantially.

In this session we will show some of the causes for this, with emphasis on I/O requests being too high for the query.  

First part of the session will explain how to find these numbers, looking at a few queries with some major performance issues, including explaining why they have a problem.

The second part will focus on how to reduce I/O requests.

All of this can be done without the need for any 3rd party tools, all within the scope of what is available to SQL Server, all versions, all editions, including Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment & Monitoring

Level: Beginner

Session Code:

Date: March 18

Time: 3:00 PM - 4:00 PM

Room: Salon 3

Are you a SQL developer, or a DBA responsible for squeezing every last drop of performance out of your instances? If so, few things are more important than a solid understanding of SQL Server indexes. In this session you will learn about index internals, approaches to good index design, and the importance of proper index maintenance. This session starts from the ground up, so it is suitable for anyone wanting to learn more about indexes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Design & Architecture

Level: Beginner

Session Code:

Date: March 18

Time: 8:30 AM - 9:30 AM

Room: Salon 1

You've decided to start using Biml to make your integration services packages. Congratulations! 

Now, you're looking at data sources other than SQL Server. How do you automate package development for these flat files, Excel Files, and other databases?  In this session, I'll share some of the techniques I've used to deal with these second-class sources. I'll be walking you through C# code.  Don't worry, I'm not a real programmer, so the code isn't the most complex, but it does solve the need.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Advanced

Session Code:

Date: March 18

Time: 1:50 PM - 2:50 PM

Room: Salon 3

Not satisfied with Multidimensional Analysis Services’ data mining or maybe you are using Tabular Analysis Services? Looking for a  flexible and robust predictive analytics tool? Consider Azure Machine Learning … a cloud service for advanced analytics. In this session, I quickly describe concepts and terms before jumping straight into a start-to-finish AML experiment. Join me to see how AML might meet your advanced data analysis needs.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: March 18

Time: 9:40 AM - 10:40 AM

Room: Salon 3

SQL Server Integration Services (SSIS) provides database administrators, business intelligence developers, and application programmers the ability to quickly and easily move and transform data.  Whether your data in on-premises or in the cloud, within SQL Server or stored in text files, clean or dirty, SSIS can help you extract, transform, and load (ETL) the information.  Join this session to learn more about SSIS, specifically how to develop, deploy, and maintain SSIS packages.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: March 18

Time: 10:50 AM - 11:50 AM

Room: 104

So you have successfully configured Availability Groups, now what? In this session we will look beyond setup and look at how to monitor your Availability Groups.  We will discuss what metrics to look at, what they mean, and what you need to alert on.  You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.  This session is for anyone that uses, or plans to use Availability Groups. You should come in with a basic understanding of Availability Groups to get the most out of this session.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment & Monitoring

Level: Intermedia

Session Code:

Date: March 18

Time: 10:50 AM - 11:50 AM

Room: 124

With the release of SQL Server 2016, Temporal tables are a new way to track changes within your tables.  This  session will walk you through moving from Change Tracking/Change Data Capture to Temporal tables and what advantages Temporal Tables has for your database and application.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment & Monitoring

Level: Beginner

Session Code:

Date: March 18

Time: 3:00 PM - 4:00 PM

Room: Salon 1

This session will present detailed examples of the newest features added or enhanced in SSIS 2016.  
Including but not limited to:
    True template based package design
    Incremental package deployment
    Non-Admin logging access
    Error Handling by Column name (prior versions only gave that cryptic lineage ID number)
    SSISDB AlwaysOn Availability Group support
    and many more...

The session will include a limited number of slides followed but demo examples of each new feature which will also be provided for download so attendees while have access to them for reference after the event.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: March 18

Time: 9:40 AM - 10:40 AM

Room: 104

PowerShell is always something you heard about and wanted to use but never did! Starting with the resources available for a PowerShell newbie, we will advance to what pro's use to automate their database activities and beyond, for both DBA's and developers. The goal of this session is to get you immersed in PowerShell. Ask questions and learn how PowerShell can enable you and more importantly do your job for you (the way, future is heading). We will also look at free libraries and tools to help you advance your automation abilities. Common automation scenarios is the theme! Anything done with with clicks can be automated.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 18

Time: 8:30 AM - 9:30 AM

Room: 104

SQL 2016 brings us many new features but one of the most anticipated is surely the Query Store. The Query Store now allows us to track query plans as they change over time giving us a whole slew of new possibilities when it comes to tuning our queries. Even just the ability to compare a previous plan to a new plan is a huge step towards understanding what may be happening in our instance. We can even tell the optimizer which plan we want it to use. These were all either extremely difficult to do before and in some cases impossible to do. This session will give you the insight to get started using this new and wonderful feature set.
Speaker:

Accompanying Materials:

Session Type:
Extended Session (90 minutes)

Track:
Database Administration, Deployment & Monitoring

Level: Intermedia

Session Code:

Date: March 18

Time: 10:50 AM - 12:20 PM

Room: Salon 1

Amazon Web Services (AWS) is the world's largest public cloud hosting provider with many companies successfully running SQL server on AWS infrastructure. In this session, we explore the options available to you for running SQL server in AWS, either as an RDS managed service or using dedicated EC2 instances. We document the different storage options, HA strategies and maintenance caveats to be aware of. We will also detail various approaches to licensing you can take when running SQL server in AWS.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure / Cloud / Big Data

Level: Beginner

Session Code:

Date: March 18

Time: 3:00 PM - 4:00 PM

Room: 104

A default SQL Server installation is reasonably secure, but "reasonably secure" doesn't cut it in an era in which one bad line of code, one weak password, or one open port can result in your customer database ending up on Pastebin. In this talk, we will look at different methods of securing a SQL Server instance, from venerable (principle of least privilege, Transparent Data Encryption) to novel (Always Encrypted, row-level security). These tools and techniques will show us ways for developers, database administrators, and network specialists to work together to secure SQL Server instances.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment & Monitoring

Level: Intermedia

Session Code:

Date: March 18

Time: 3:00 PM - 4:00 PM

Room: 124

We've all heard about massive data breaches from big name companies. As a DBA, you should consider your company's data to be the most valuable assets. So when a data breach happens at your company, will you be able to provide management with the information? If not, then discover how SQL Server Audit can help provide you with an accurate forensic analysis of who did what to your data. In this session, we'll cover what SQL Audit can capture, how to set it up for both on-premise SQL Servers and Azure SQL Database, and finally produce reports from it.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment & Monitoring

Level: Beginner

Session Code:

Date: March 18

Time: 1:50 PM - 2:50 PM

Room: 104

SQL Server R Services: Microsoft acquired Revolution Analytics in early 2015, and introduced R services (in-database/stand-alone) with SQL Server 2016 last year.  With the first Microsoft Data Science summit behind us this past Sept, in Atlanta, let us review what R Services in SQL Server brings to the table and see how it complements/supercedes features that are available with other R offerings (R GUI, Microsoft R Client [R Studio], Microsoft R Open [RROpen], Microsoft R Server[RREnterprise] etc.,)
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 18

Time: 1:50 PM - 2:50 PM

Room: 124

Using SQL 2016 AlwaysOn Availability Groups is a powerful feature which can provide HA support.  
The session will begin with a basic overview of the creation of an Availability Group (assuming the SQL Instances are already installed for time) then I will go into detailed demos of the following features:
  Availability Group Readable Secondary Replicas
      Risks of readable secondary replicas when using a replica that is part of the Automatic Failover pair
      Shared Log Chain Database Impact
  Read Only Routing
       Load Balancing with Read Only Routing (Round Robin)
       What the hell is "Read-Intent Only" and why it is MUCH safer than "YES" 
  Databases with Encryption (why you no longer need a job to set the password every time the SSISDB fails over)
  Multiple Availability Groups on a Single Cluster
  What are Basic Availability Groups (are they still better than Clustered Instances?)
  Automatic Page Repair
and many others
Demos available for download after the session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment & Monitoring

Level: Intermedia

Session Code:

Date: March 18

Time: 3:00 PM - 4:00 PM

Room: Salon 2

For the last 25 years SQL Server DBAs have administered SQL databases using only Windows GUI.
For majority of them even Windows Core is too hard to accept.
In the situation, when Microsoft invaded Linux territory with it's flagship product, as SQL DBA, you must not outsource SQL Server administration to some Linux geeks. 
You can do it yourself!
Your way!
And I show you how to do it.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment & Monitoring

Level: Beginner

Session Code:

Date: March 18

Time: 9:40 AM - 10:40 AM

Room: Salon 2

Are your statistics up to date? 
Yes, it’s that dreaded phrase you hear all the time when it comes to performance tuning your SQL Server. What does it matter? Why should I care about statistics? Aren’t they automatic or something like that?
In this session we will go over why statistics matter, how they are generated, how they impact performance, and even how to maintain them. Once we have that all settled, we will take a quick look at how the cardinality estimator uses statistics to determine a ‘good enough’ plan to use. We will close out the session by taking a look at the performance impact from a simple upgrade of your SQL Server to 2014 and using the new cardinality estimator.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Internals & Performance

Level: Beginner

Session Code:

Date: March 18

Time: 1:50 PM - 2:50 PM

Room: Salon 1

Sessions Found: 26
SQLSaturday