Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type



Sessions Found: 30
Conversations about SQL Server administration tends to be all about administering OLTP systems. If you administrer BI systems, you can't apply everything you know about administering OLTP systems to BI systems. BI systems usually end up being administered by OLTP DBAs or by BI developers and architects. Where does one even find a BI Administrator?

Fortunately, I've been administering BI systems for several years, and I have learned the hard way the difference between administering OLTP and BI systems. This session will cover the top 10 things that I think an administrator of BI systems need to know.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code: 1435

Date: May 14

Time: 11:00 AM - 12:00 PM

Room: 1435

This is not your regular Agile BIML session. By now you already know that BIML is a great productivity enhancement to SSIS. You also know that you can build metadata driven solution and include C# code in your BIML scripts or snippets. If you don't know what I'm talking about this session is not for you. If you - on the other hand - want to know how to build a modular BIML framework, do real C# development and include it in your BIML code so that you can pass custom objects around for optimized performance and code reuse then this session is for you. We will see how to build a reusable C# framework that can be obfuscated and deployed to customers without worrying about Intellectual property. I promise you no more than a few slides but a lot of demos and real life experience acquired from major BIML projects. We will also have a look at how to harness integration and unit tests in the setup with a twist of Continuous Integration with Team Foundation Server.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code: 1435

Date: May 14

Time: 9:45 AM - 10:45 AM

Room: 1435

You are a DBA familiar with some basic Windows clustering and database mirroring concepts, and now you are considering AlwaysOn Availability Groups. This session will cover the pros and cons of four typical configurations of AlwaysOn Availability Groups; stand-alone instances, fail-over cluster instances, multi-subnet, and a hybrid approach that I call disaster-recovery-on-the-cheap. It will also include their exclusive features such as read-only routing and backup off-loading. In addition, you'll learn how to use the Availability Group Listener correctly and why you should be using Windows Server 2012 R2 or above, along with some of my own personal lessons learned.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code: 1610

Date: May 14

Time: 2:45 PM - 3:45 PM

Room: 1610

SQL Server Data Tools (SSDT) is Microsoft developer tools for working with SQL Server databases on premises and in the cloud. It supersedes Management Studio in development functionality. Team Foundation Server (TFS) is the collaboration platform at the core of Microsoft’s application lifecycle management (ALM) solution. TFS gives you the tools you need to effectively manage software development projects throughout the IT lifecycle. In this session, we are going to focus on the interaction between SSDT and TFS. Developing locally and publishing the changes to an on-premises instance of SQL Server. We will look at how we can do continuous integration between development and other environments pushing the schema changes and upgrading the version numbers in a seamless manner upon successful build of the solution. Furthermore we'll look at how to lift the integration to an even greater level by using Microsoft Release Management thus automating the deployment and testing of your software.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code: 1445

Date: May 14

Time: 1:30 PM - 2:30 PM

Room: 1445

Many companies scale out their databases horizontally, partitioning data by customer (or some other identifier) into separate databases or instances.  Sometimes, it becomes important to move that data from one database to another.  SQL Server Integration Services is a fantastic tool for ETL, but creating and maintaining dozens or hundreds of data flows by hand is exhaustingly tedious.  Instead of doing it the hard way, use the BI Markup Language (BIML) to automate package development.  This talk will show how we can use metadata tables and BIML to auto-create SSIS packages to migrate data from one database to another, handling foreign key constraints along the way.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code: 1435

Date: May 14

Time: 8:30 AM - 9:30 AM

Room: 1435

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: 1455

Date: May 14

Time: 4:00 PM - 5:00 PM

Room: 1455

Once you agreed to an SLA for the databases you manage its time to deliver on this promise
This session will show how to select from the many HA/DR features you have in SQL Server to pick the ones that will help you meet the SLA and most important will tell you how you must combine them to be successful.
For each one of the solutions we discuss we will define a series of failure modes and then check if the solution actually can fulfill the SLA as promised or if it needs more
Speaker:

Session Type:
Half Day Session (240 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code: 1610

Date: May 14

Time: 1:30 PM - 5:30 PM

Room: 1610

I was an employee of a company that had an office in the World Trade Center on Sept. 11, 2001.  Prior to that infamous date, I had written several departmental documents that ended up being critical to our recovery.  In this presentation, I provide a narrative of what happened in the weeks following 9/11, and how documentation played a role in getting the organization back on its feet.

While other disaster recovery presentations talk about strategies, plans, and techniques, this presentation focuses on the documentation itself.  We will discuss the documents we had and how they were used in our recovery.  We will also discuss what documents we didn't have, and how they could have made the process better.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code: 1435

Date: May 14

Time: 4:00 PM - 5:00 PM

Room: 1435

There is no better way to understand how TSQL is executing than through the execution plan.  We will go into detail about the more complex parts of execution plans, relating them to other query statistics, and use this information to improve overall query performance.  Be sure to bring your safety helmet!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code: 1445

Date: May 14

Time: 4:00 PM - 5:00 PM

Room: 1445

Dynamic SQL can be a powerful tool that allows you to write fast & efficient queries when the specifics may not be known until run-time.  It can also be complex, difficult to read and debug, and the source of some of the most confusing TSQL you'll ever see.

Explore the many uses for dynamic SQL as well as best practices for writing, testing, debugging, and maintaining it, with the bonus of helping to improve the sanity of your coworkers (and your own) in the process!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code: 1455

Date: May 14

Time: 9:45 AM - 10:45 AM

Room: 1455

In this session, led by Microsoft BI Architect, SQL Server MVP AND SSAS Maestro Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2 and above . We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code: 1435

Date: May 14

Time: 1:30 PM - 2:30 PM

Room: 1435

You know all the ways to protect your database when it is at rest, but what about when someone connects and starts running some queries? What if they connect and don't do anything? Just how exposed is that data? 
We will assume the role of a hacker and, by using a simple technique, we will sniff packets on a network to reveal what data is being sent. You may be shocked! 
We will then secure our database connections with a simple self-signed SSL certificate. 
Once secured, we will resume the role of the hacker and look inside the packets to see what has changed. 
*Warning - Do not try these demos at work without proper permissions as actual hacking techniques are used. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code: 1610

Date: May 14

Time: 9:45 AM - 10:45 AM

Room: 1610

SQL 2014 and 2016 have the new In-Memory table aka Hekaton.  This session will talk about "why in-memory" as well as the options available with new development scenarios around this in-memory table structure with SQL 2014, 2016, and Azure.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code: 1445

Date: May 14

Time: 9:45 AM - 10:45 AM

Room: 1445

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 & Deployment

Level: Beginner

Session Code: 1610

Date: May 14

Time: 8:30 AM - 9:30 AM

Room: 1610

SQL Server memory management is one of the most important aspects of a writing T-SQL code. And yet many of us don’t know the fundamentals beyond “SQL Server will take care of that”. In this session, we’ll go deep into the internal behavior of the plan cache. We’ll cover four main problem scenarios within the plan cache, what causes them, and how to fix them, including:

1.	Bloating – scenarios that cause SQL Server to needlessly waste space in the plan cache. 
2.	Suboptimal plans – scenarios where SQL Server can’t help but choose a bad execution plan, usually self-inflicted.
3.	Parameter sniffing – situations in which SQL Server specifically chooses a bad execution plan do to the type of parameters pass into T-SQL code.
4.	Recompiles – situations where SQL Server is unable to completely process a block of T-SQL code without having to recompile it. 

If you don’t know much about SQL Server memory management, especially if you write T-SQL code, then this session is for you! You’ll learn 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code: 1620

Date: May 14

Time: 11:00 AM - 12:00 PM

Room: 1620

SQL Server 2016 is introducing some new tools for analyzing and troubleshooting queries that is going to change the way we do performance tuning. It's not just new tools, it's a whole new paradigm.

SQL Server 2016 will introduce the Query Store and the Plan Compare Tool which will help you to quickly analyze and troubleshoot problem queries, diagnose the root-cause of query slow-downs, force execution plans and prevent future plan regressions, and track actual execution plan run-time statistics.

Have you ever had a job run unusually slow at 2 AM? If you are using Query Store, diagnosing the problem is as easy as looking at the execution data and plan for the 2 AM execution.

Does a query run fast with one plan but slow with another? With the plan compare tool, you can compare 2 plans in the same window to identify what is the same and what is different.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code: 1445

Date: May 14

Time: 2:45 PM - 3:45 PM

Room: 1445

So you jumped on the bandwagon and set up a Hadoop cluster…but now what?  Your database developers and app developers know how to integrate with and develop against SQL Server, but the Hadoop world is a completely different experience.  This talk will help bridge the gap between SQL Server and Hadoop, using tools such as SQL Server Integration Services and Sqoop to migrate data between a Hadoop cluster and a SQL Server instance, as well as PolyBase to integrate the two like never before.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code: 1620

Date: May 14

Time: 9:45 AM - 10:45 AM

Room: 1620

Power BI (either Desktop or the service) supports a wide (and growing) range of data sources.  From the sources with which most IT pros and data analysts are regularly involved (relational and OLAP databases, text and similar files, etc.) to sources that are a little more out of the ordinary for some of us (OData, MS Exchange, Active Directory, and a growing list of others), these reservoirs and suppliers of data grow increasingly more valuable in self-service BI.  
In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson focuses upon the first step in working with data sources in Power BI:  connecting to, and extracting data from, a diverse range of data sources. Throughout the session, we explore various sources and witness how to employ Power BI with each.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analysis Techniques and Visualization

Level: Beginner

Session Code: 1620

Date: May 14

Time: 8:30 AM - 9:30 AM

Room: 1620

There is a lot of confusion about the place and purpose of the many recent non-relational database solutions (“NoSQL databases”) compared to the relational database solutions that have been around for so many years.  In this presentation I will first clarify what exactly these database solutions are, compare them, and discuss the best use cases for each.  I’ll discuss topics involving OLTP, scaling, data warehousing, polyglot persistence, and the CAP theorem.  We will even touch on a new type of database solution called NewSQL.  If you are building a new solution it is important to understand all your options so you take the right path to success.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code: 1620

Date: May 14

Time: 4:00 PM - 5:00 PM

Room: 1620

Indexes are one of the most troubling and mysterious areas for DBAs and developers.  Adding, deleting, or modifying them can yield dramatically positive or negative changes in query performance.  The mystery is knowing how indexes need to be adjusted and what outcomes will result.  This uncertainty often leads to great reluctance to eliminate indexes that are used sparingly or only because the optimal ones are missing.  This leads to index proliferation, which ultimately produces inconsistent and poor query performance.  Some believe that the SQL Server Database Tuning Advisor will solve all these issues, but it frequently does not.  In fact, it often compounds the proliferation problem significantly.  This presentation will enable a DBA to make informed decisions regarding what query and index metrics to monitor, determine how indexes are used, and devise appropriate index strategies to improve query performance through index addition, deletion, or modification. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code: 1455

Date: May 14

Time: 11:00 AM - 12:00 PM

Room: 1455

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