Build Schedule

Advanced Filters:
  • Track

    clear all




  • Speaker


  • Level


  • Session Type

Sessions Found: 16
Se plantea la necesidad, historia, metodologías y tecnologías aplicadas, así como conceptos para la compreción integral de Inteligencia de Negocios.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: May 09

Time: 9:45 AM - 11:00 AM

Room: Room 02

En esta sesión se siembran las bases de la implementación de soluciones de Inteligencia de Negocios Hibridas, utilizando el SQL Server SSAS On-Premise y Office365 como front-end.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud

Level: Beginner

Session Code:

Date: May 09

Time: 4:45 PM - 6:00 PM

Room: Room 04

As a developer or business intelligence professional you need to make sure that your SSIS loading or business automation processes works effectively under any circumstance. In this session we will show how to configure your environment and packages to leverage logging modes and capture exceptions and errors using design patters and best practices. We will demo how to configure logging options, transaction options, deal with errors in the control and data flow, and also create a custom solution to monitor and administer your environment.

At the end of this session you will have a better understanding to configure a bulletproof SSIS environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Dev

Level: Intermedia

Session Code:

Date: May 09

Time: 1:45 PM - 3:00 PM

Room: Room 03

Data Profiling is a vital step that is often overlooked in the development process. Integration Services (SSIS) built-in support for data profiling is limited and takes manual user intervention. Learn a new approach to automate data profiling and increase your data awareness. 
In this session we will walk through a framework that dynamically develops a group of packages that can profile data based on the existing metadata within your current environment. By dynamically tracking the metadata within your environment, you can easily maintain your data monitoring solution. This will enable a more thorough view of your ETL environment that will allow you to spot issues faster and create a more scaled infrastructure based on your current performance needs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: May 09

Time: 9:45 AM - 11:00 AM

Room: Room 03

If you manage a large environment then you know how hard it can be to make sure all your SQL Servers adhere to best practice settings and more importantly is making sure they stay that way.  I'll show you how to check those settings across all your servers with Central Management Server and how it can help you manage a disperse environment.  You will also learn how to leverage the power of Policy Based Management to help you enforce those settings and standards in your enterprise.  Best of all you will see how to get alerts sent to you when one of your standard settings is changed.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: May 09

Time: 12:00 AM - 1:15 AM

Room:

There is a lot of buzz behind Microsoft's In-memory OLTP offering code named Hekaton, but does it really deliver on the performance claims? What are the implementation limits that you need to keep in mind and more importantly what are the use cases where it does and does not makes sense. Join Microsoft Certified Master Jason Horner as he skins the In-Memory OLTP Onion.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Dev

Level: Intermedia

Session Code:

Date: May 09

Time: 11:15 AM - 12:30 PM

Room: Room 02

If you have ever had a Kerberos or SSPI context error, then you won't want to miss this session.  SQL Server has a large surface area and Active Directory can influence a big part of it.  I will discuss AD DNS configuration, Group Policy Objects, Kerberos (of course), and how all of them affect your SQL Server.  By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
DBA

Level: Advanced

Session Code:

Date: May 09

Time: 11:15 AM - 12:30 PM

Room: Room 04

Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign. 

This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI

Level: Intermedia

Session Code:

Date: May 09

Time: 3:15 PM - 4:30 PM

Room: Room 02

(Spanish) - This session will explain the AlwaysOn Availability Groups feature which is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012, AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: May 09

Time: 9:45 AM - 11:00 AM

Room: Room 01

Real world apps in real word scenarios using MS-ACCESS and MS-SQL
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Dev

Level: Beginner

Session Code:

Date: May 09

Time: 1:45 PM - 3:00 PM

Room: Room 02

You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Dev

Level: Intermedia

Session Code:

Date: May 09

Time: 3:15 PM - 4:30 PM

Room: Room 03

We all know that backups are important. But are we building a backup strategy that can recover in a manner that meets business needs? All too often, we plan a backup strategy without a recovery strategy.

In this session, veteran DBA Mike Hillwig will start with understanding the recovery strategy and work toward implementing the right backups to meet that recovery strategy.  He'll also set the record straight around some very common myths around database recovery and backups. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: May 09

Time: 11:15 AM - 12:30 PM

Room: Room 03

We know BI in bits and pieces. But imagine if you had to setup the BI infrastructure from scratch. 
What do we need to consider, which players do we consider, what are the components, the HA/DR scenario for the same, what technology to use? These are the questions we will attempt to answer along the way.
What are the best practices involved in creating a BI infrastructure. We can discuss whether to outsource this project or rise above our DBA job and do it ourselves.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud

Level: Intermedia

Session Code:

Date: May 09

Time: 12:00 AM - 1:15 AM

Room:

Experienced DBAs know that SQL Server stores data in data files and transaction log files. What is less commonly known is that the transaction log file is broken up into smaller segments known as Virtual Log Files, or VLFs. 

Having too many VLFs will cause performance to suffer. And having too few will cause backup performance to suffer. How do you strike the right balance?

In this more advanced session, veteran DBA Mike Hillwig will show you what VLFs are, how they're created, how to identify them, and how to strike the right balance between too few and too many. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
DBA

Level: Advanced

Session Code:

Date: May 09

Time: 1:45 PM - 3:00 PM

Room: Room 01

n this heavily demo based session, we show some techniques for performance tuning common problems faced by DBA's Including: how to identify the problem, resolve the issue, and test the solution. Along the way we will also discuss some of theory behind the solutions. We all know there is no such thing as DBCC GO_FASTER but this session is the next best thing.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: May 09

Time: 3:15 PM - 4:30 PM

Room: Room 01

You need to implement AlwaysOn Failover Clustering or Availability Groups, but you need help with the Windows Clustering part.  I have you covered.  We'll talk about how to plan for network, DNS, Active Directory, and storage.  I'll even provide you with a check list you can use to plan your implementation.  We'll also discuss quorum, how to decide which one to use, and the effect that choice can have on your Failover Cluster Instance and/or Availability Group.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
DBA

Level: Advanced

Session Code:

Date: May 09

Time: 4:45 PM - 6:00 PM

Room: Room 01

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