Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type



Sessions Found: 47
Visual Studio 2013 (VS) has finally delivered a great way to manage databases within the Software Development Lifecycle.  While VS has offered a Database Project type for several years, to me, it was never really a sustainable way to create, manage, source control, schema compare, and deploy database objects.  In this presentation, I’ll break down the feature set of database development in VS and offer some experience tips for SQL database developers to start working in what really is a great new way.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 19

Time: 8:30 AM - 9:30 AM

Room: 112

Window functions and the OVER() clause are an underused feature in T-SQL. These functions can help you solve complex business problems such as running totals and ranking. If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for a demo filled session on SQL window functions. We will also look at some of the performance implications of using these functions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: March 19

Time: 4:00 PM - 5:00 PM

Room: 112

Make your SSIS Life easy by learning SSIS administration.  There is lots of new stuff to learn in SSIS 2012 and 2014, to name a few: SSIS Catalog, Environmental Parameters, Encrypting passwords.  We will cover new upcoming features in 2016. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: March 19

Time: 9:40 AM - 10:40 AM

Room: 143

How do you know if Availability Groups are the correct high availability solution for your business application?  We’ll cover some common business problems that Availability Groups can solve and go through a quick demo where we’ll cover some pre and post checklist items to help you understand the requirements for a successful implementation.
Speaker:

Accompanying Materials:

Session Type:
Extended Session (75 minutes)

Track:
Database Administration, Deployment, Monitoring

Level: Beginner

Session Code:

Date: March 19

Time: 10:50 AM - 12:05 PM

Room: 111

The cloud is here! Are you ready?  Microsoft, Amazon and others are all vying for your cloud attention.  In this session, we will review the different types of cloud platforms available and what they mean to you.  We will pay close attention to Microsoft’s Azure platform that offers two hosting solutions.  What are these hosting options and what are the differences between them?  Most importantly, how do I get started with all of this cloud business?  Let's put SQL Server into the cloud!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Azure / Cloud / Big Data

Level: Beginner

Session Code:

Date: March 19

Time: 2:50 PM - 3:50 PM

Room: 112

The breadth of options available to data professionals today is staggering:  between relational, object, graph, and document databases, we have a wide array of storage options, as well as a huge number of access and analysis tools.  This talk will walk you through data platform, data analysis, and data processing options.  We’ll discuss when to use (and when not to use) Spark, R, Storm, and SSAS, as well as a range of other tools and technologies.  By the end of this talk, you may not have MongoDB or Neo4J, but you will know where they might fit.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure / Cloud / Big Data

Level: Beginner

Session Code:

Date: March 19

Time: 4:00 PM - 5:00 PM

Room: 113

For most of us, our career in technology was and is the result of our combined education, experience, opportunities, and luck. In this presentation we will explore approaches to creating the career we want instead of the one we stumble into.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 19

Time: 2:50 PM - 3:50 PM

Room: 170

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 B2B's owner, Greg Samuels, and Alex Tulchinsky, CTO of UNOS, Chris Walton, CIO of Chemtreat and George Boatright, former CIO of Media General will be serving as panelists. 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:
Sponsor Session (45 minutes)

Track:
Sponsor Session

Level: Beginner

Session Code:

Date: March 19

Time: 12:45 PM - 1:30 PM

Room: 143

Come and hang out with community members, and discuss SQL Server issues or just ask any questions. Have a work problem? Maybe you can leave here today with a solution!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: March 19

Time: 8:30 AM - 9:30 AM

Room: 115

For those of you that don’t have a full time DBA on staff, this session is built around you. I will give you the skills and tools necessary to successfully manage Microsoft SQL Server. Automation is the key to any monitoring effort and SQL Server is no different. I will show you publicly available tools and scripts to alert you when key areas of SQL Server are being stressed. Proactively monitoring SQL Server will make you more efficient and allow you to continue your success within your role.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 19

Time: 4:00 PM - 5:00 PM

Room: 143

John knows everything and goes out of his way to correct you at every turn.  Mary is agreeable to a fault and just placates everyone.  Mike is full of doom and gloom and whines constantly. Are these your co-workers? Relatives? Frenemies? You? Learn two golden rules to reduce the stress produced by the difficult people in your life.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 19

Time: 10:50 AM - 11:50 AM

Room: 112

Problems with your boss micro-managing you?  Wondering how to deal with an absent boss who takes credit for your work? Learn about dealing with several types of managers and how to deal with them, survive them, and possibly even excel despite them.  
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 19

Time: 1:40 PM - 2:40 PM

Room: 143

So you have a good backup strategy in place, but now you have to think about a disaster recovery.  Where do you start and what are your options?  SQL Server offers several options, but then how do you choose the right one to meet your business requirements?  In this session, we will go over some of the common DR options including log shipping, replication, mirroring, clustering, and AlwaysOn.  Then we will talk about how to choose the best one to meet your business needs.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: March 19

Time: 8:30 AM - 9:30 AM

Room: 144

Performance tuning can be complex.It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, Database Performance Evangelist, SolarWinds, will detail 12 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to:

    Quickly fine tune a SQL statement
    Identify performance inhibitors to help avoid future performance issues
    Recognize and understand how new SQL Server features can help improve query performance

Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Performance

Level: Intermedia

Session Code:

Date: March 19

Time: 9:40 AM - 10:40 AM

Room: 112

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:

Session Type:
Extended Session (75 minutes)

Track:
Database Administration, Deployment, Monitoring

Level: Beginner

Session Code:

Date: March 19

Time: 10:50 AM - 12:05 PM

Room: 170

Microsoft has been busy working on the next version of SQL Server - SQL Server 2016.  We will go over some of the new features at a high level and dig deeper on Row Level Security and StretchDB.  Row Level Security allows you to add another layer of security to your environment.  StretchDB will allow you to transparently place part or all of a table into a SQL Azure DB freeing up your valuable SAN space for data that is COLD.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration, Deployment, Monitoring

Level: Intermedia

Session Code:

Date: March 19

Time: 8:30 AM - 9:30 AM

Room: 170

With so many languages around to extract, transform, analyze, and visualize data, Microsoft introduced yet another language : U-SQL.  In this session, we'll take a look at what U-SQL is, what it brings to the table, and how it differs from (or overlaps with) the existing constructs (T-SQL, SQL CLR, DAX/MDX, PowerQuery/M, R etc.,).  We'll go over step-by-step in getting started with U-SQL, and review some use case scenarios.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Azure / Cloud / Big Data

Level: Beginner

Session Code:

Date: March 19

Time: 1:40 PM - 2:40 PM

Room: 144

Often times we might feel like we are simply spinning our wheels and can't seem to move ahead.  Perhaps we see others getting opportunities and can't quite place why more doesn't come our way.  This session will discuss how we can put ourselves in the drivers seat when it comes to making opportunities so we can make some decisions about what we want to do rather than choosing from what is left.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 19

Time: 9:40 AM - 10:40 AM

Room: 144

Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering.  This session will cover how you can keep your sanity, get stuff done, and still love your job. We'll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too.  When you finish this session, you'll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 19

Time: 8:30 AM - 9:30 AM

Room: 143

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:

Session Type:
Regular Session (60 minutes)

Track:
Database Design and Architecture

Level: Beginner

Session Code:

Date: March 19

Time: 1:40 PM - 2:40 PM

Room: 112

Sessions Found: 47
Back to Top cage-aids
cage-aids
cage-aids
cage-aids