Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 31
Head starting to explode from all the technical information you’re absorbing?  Come spend a session with us while we play games with Reporting Services…literally!  Come watch as Stacia and Dean Varga introduce you to some  word play, all wrapped up in SQL Server Reporting Services.  They'll push the limits with what can be built in SSRS and show you how to have fun while doing it.  Board games and SQL…who could ask for more?
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: July 16

Time: 2:30 PM - 3:30 PM

Room: Worthington (SQL Sentry)

Let’s face it, using SQLPS prior to SQL Server 2016 was like installing training wheels on a Ducati.   Then, some community feedback was incorporated before SQL 2016 shipped and presto, SQLPS is actually useful all of a sudden.

There is a faster way to manage and even SQL Servers using PowerShell.  I will show you what the new features in SQLPS and why you will probably find it useful, even if you aren't a "DBA".
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: July 16

Time: 9:45 AM - 10:45 AM

Room: Delaware (MinionWare, LLC)

Ever feel like you are just doing busy work while creating new SSIS packages?  Feel like you are doing the same thing over and over while changing the names to protect the innocent?  Ever wonder if there is a better way?  Well wonder no more.  Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors.  Come with intrigue and leave with a fundamental understanding of BIML!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: July 16

Time: 9:45 AM - 10:45 AM

Room: Westerville (Microsoft)

You're looking to protect your SQL instance from a machine failure.  Or maybe your storage budget and tight and you don't want to have your databases in two places with one of the other highly available options that SQL provides.  Let's learn what a cluster is and why it might be the right thing for you.  We'll explore the system, network, storage and database administration sides of the equation.  And, when it's all said and done we'll even have built a SQL clustered instance!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration, Architecture & Deployment

Level: Beginner

Session Code:

Date: July 16

Time: 3:45 PM - 4:45 PM

Room: Dublin (DELL)

Microsoft Power BI is going great places. Its great visualizations, easy-to-use tools, and robust sharing capabilities are improving with new releases almost every time you turn around. But, what if uploading or storing your company's data in the cloud is a potential deal-breaker? Fortunately, the Microsoft Power BI Gateway - Enterprise make it possible to live query data in an on-premises SSAS instance for display in Power BI. In this session, we will go through what this gateway does, how it works, and how it is installed to show that BI in the cloud doesn't require data in the cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: July 16

Time: 2:30 PM - 3:30 PM

Room: Westerville (Microsoft)

This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!

This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 16

Time: 1:15 PM - 2:15 PM

Room: Worthington (SQL Sentry)

With a little T-SQL experience, you can create a stored procedure that completes a task. But it's harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about: 

Asking the right questions to set yourself up for success
Making the case for stored procedures over ad hoc code and other objects
Pro tips for standardization and cross-version compliance
Reevaluating and expanding on your solution
Limiting inputs to reduce unexpected behaviors and errors
Choosing between alternate solutions
Evaluating for performance

This session is for data professionals who can write T-SQL, but haven't spent a lot of time in SQL development.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: July 16

Time: 2:30 PM - 3:30 PM

Room: Dublin (DELL)

Recovery in the cloud is now easier and more convenient than ever.  This session describes some common scenarios and reviews the steps needed to prepare for a disaster with a recovery in Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration, Architecture & Deployment

Level: Beginner

Session Code:

Date: July 16

Time: 11:00 AM - 12:00 PM

Room: Westerville (Microsoft)

Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? You need to get the updates in your OLTP database to the Data Warehouse quickly, but with minimal impact on your application. Asynchronous messaging with Service Broker makes this simple and painless. This session will walk through the basic transformations to build a Kimbal-style data warehouse from an OLTP database and demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: July 16

Time: 8:30 AM - 9:30 AM

Room: Westerville (Microsoft)

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:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: July 16

Time: 3:45 PM - 4:45 PM

Room: Capitol (Pure Storage)

In this session we’ll explore several methods of hacking into SQL Server instances. Some methods assume you have Windows Administrator privileges on the box; others only require access to your physical network. We will cover SQL injection, memory dumps, man-in-the-middle, pass-the-hash, and other attack vectors. Armed with this knowledge, you should be able to go back to your job and make a difference in your network security.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration, Architecture & Deployment

Level: Beginner

Session Code:

Date: July 16

Time: 11:00 AM - 12:00 PM

Room: Capitol (Pure Storage)

PowerPoint can enhance the presentation of any speaker or business professional, but using it effectively in your sessions or presentations can be difficult without practice. In this session, you will learn how to take your PowerPoint skills to the next level, using more advanced transitions, animations, and media forms in your presentations. This will help you engage your audience and communicate visually instead of just verbally, making your presentations more effective. After attending this session, you can feel confident that your PowerPoint skills have improved.   
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 16

Time: 9:45 AM - 10:45 AM

Room: Worthington (SQL Sentry)

SQL Server Service Broker is often seen as a black box. Messages go in, and hopefully they come out on the other side.  But when they don't, DBAs typically don’t know where to look. Trying to figure out what’s wrong quickly turns into a guessing game.
It’s not that complicated once you understand how it all works. 
Service Broker is an asynchronous messaging technology built into SQL Server that allows you to scale out your application, replicate data or perform ETL, all while guaranteeing messages are delivered and processed in the right order.   In this session, we'll discuss the basics of the Service Broker architecture, its components, and deployment options.  We will discuss troubleshooting tips and performance best practices to help you deploy a Service Broker solution in your own environment.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration, Architecture & Deployment

Level: Beginner

Session Code:

Date: July 16

Time: 8:30 AM - 9:30 AM

Room: Capitol (Pure Storage)

Azure SQL Databases are still something that is new and not completely understood by many data professionals. There is a definite shift from installing SQL Server on a machine to creating and using a Microsoft's Platform-as-a-Service database. This session will cover the basics of what an Azure SQL Database is, how we create one, and what it takes to access and use this database. After attending this session, you will have a solid understanding of what Azure SQL Database is, how to configure it, and how to use in your own environment.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: July 16

Time: 1:15 PM - 2:15 PM

Room: Capitol (Pure Storage)

Tired of job boards and recruiter spam? There’s a better way to manage your career growth. Networking is something that doesn’t come naturally to many people, but it’s a tool that every tech professional should have in their tool belt. In this talk, you’ll learn tips for growing your professional network online and offline. You’ll also learn strategies for intentionally fostering relationships. A good network means fewer strangers, more free lunches, and a better path to finding your next opportunity.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 16

Time: 8:30 AM - 9:30 AM

Room: Worthington (SQL Sentry)

Have you ever thought about speaking at a user group, SQL Saturday, or even the PASS Summit, but weren't quite sure how to get started? If so, this session is for you! Technical speaking is loads of fun, great for your career, and you get to hang out with some terrific people. This session will provide the tools necessary to get your first session off the ground, and prep you to be a great speaker. Attend this session and you'll be able to: * Identify your topic and submit it to a conference, * Design and build the presentation, and * Prepare and deliver your first session.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: July 16

Time: 3:45 PM - 4:45 PM

Room: Westerville (Microsoft)

Heartbroken over Microsoft’s neglect of SSRS over the years? Well the 2016 release might start healing that broken heart. This upcoming release boast a handful of great new items; from connecting SSRS & PowerBI to mobile report publishing. Join me while I walk you through the best of 2016 for Business Intelligence and help you fall in love with Microsoft BI again. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: July 16

Time: 11:00 AM - 12:00 PM

Room: Dublin (DELL)

Your cold data growth is getting out of control, storage consumption is increasing faster than your budget, your end-users won't (or can't) tell you what can delete or truncate, but they demand their cold or archived data always be online and available. Now you have tables so big that you dread re-indexing, and you have to look for ever more creative solutions to manage this data, while still remaining compliant.
 
There’s a solution that lets you take advantage of the Cloud, on your terms, all without impacting your existing end-user applications or queries.
 
Come find out how you can move your data securely and transparently, free up disc space and reduce your enterprise storage consumption, while retaining full control from the on-premises SQL Server. You’ll reduce maintenance operations time and resources, plus lower overall cost. Learn how SQL Server Stretch database will simplify your journey to the Cloud!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: July 16

Time: 9:45 AM - 10:45 AM

Room: Capitol (Pure Storage)

Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures, filled with table variables, instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cut that work from hours or days to minutes or even seconds. Stop writing code manually and let regular expressions do it for you. Learn:
• The most useful regular expression commands
• The appropriate times to use regular expressions
• How to use regular expressions to write code for you
• How to incorporate regular expressions into large tasks and combine them with other methods
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration, Architecture & Deployment

Level: Intermedia

Session Code:

Date: July 16

Time: 9:45 AM - 10:45 AM

Room: Dublin (DELL)

SQL Server has so many options for data redundancy, how do you know when you should use replication, or log shipping or AlwaysOn, etc? We will use real world examples where data redundancy is needed and discuss which is the appropriate technology and why. This is more than just a high availability vs disaster recovery discussion. If you have ever been confused or overwhelmed by all of the options, they will be broken down and made clear in this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration, Architecture & Deployment

Level: Intermedia

Session Code:

Date: July 16

Time: 8:30 AM - 9:30 AM

Room: Dublin (DELL)

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