Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 34
SQL Server Master Data Services (MDS) is a robust platform for master data and hierarchy management that provides master data capabilities such as business rules, a managed schema, hierarchies, versioning, workflow, and Excel Integration.   Profisee Maestro slashes your time to deployment on MDS by providing an alternate UI for data Stewards and Application owners.  Maestro adds data modeling, a first-rate user experience, ER-Win Integration, Simplified Import/Export to simplify getting MDM in the hands of your users.
Maestro also adds data quality, matching, harmonization, address corrections, an API, web parts and CRM integration.   
Come see how Profisee Maestro can take your MDS implementation from the department to the enterprise.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
3- Business Intelligence

Level: Beginner

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Your SQL Servers are probably virtualized by now, but are they running at their absolute peak performance? How can you tell? When properly configured and maintained, a virtualized SQL Server will be at least as fast as the system that it came from, if not better. If not properly configured, silent performance killers can wreck your virtualization experience. This session will give you tips and tricks to maximize performance while giving you talking points so you can convince your infrastructure engineers to design the virtualization stack your way. This session goes deep into the architecture and methodology for squeezing the best possible performance from your virtualized SQL Server, and includes valuable tips on topics such as host-level over-commitment, storage performance, In-memory OLTP, and more!
Speaker:

Session Type:
Regular Session

Track:
2- Cloud & Big Data

Level: Beginner

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

SSIS is a tool that simplifies ETL and other workflow development, automates DB maintenance, and can be used to automate data lifecycle. It has a lot of faculties that allow to extend its functionality, from built-in expressions mechanisms to scripts to custom components building. However, it takes patience to explore these capabilities - and we want to help developers to cut time necessary to learn the intricacies of the SSIS development.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
3- Business Intelligence

Level: Intermedia

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Come learn how to build and automate data sets and data models in Excel using the Power BI toolset. We'll pull data from a variety of on-premise and cloud data sources to familiarize yourself with the latest capabilities of Power Query and Power Pivot. Then we'll review the software required to automate your Power BI analysis whether you are trying to refresh your Excel workbooks on a file server, in SharePoint Online, or SharePoint on-premise.
Speaker:

Session Type:
Regular Session

Track:
3- Business Intelligence

Level: Intermedia

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Deploying your database changes to production can be nerve-wracking. We'll discuss methods that take the stress out of the process by ensuring that you practice your deployments using continuous integration before you ever get near production. Automating the deployment and testing processes through various pre-production environments can make the whole experience of production deployments more repeatable, more reliable and more robust.

In this session, we'll explore the concepts of continuous integration and continuous delivery for databases – what to consider, the challenges, the benefits, the testing, and the crucial approval gates necessary for a reliable production deployment. We'll discuss these and other release strategies as you think about how to evolve your deployment pipeline towards a more automated approach, starting with continuous integration and ending at your production systems.
Speaker:

Session Type:
Regular Session

Track:
5- Database Administration

Level: Intermedia

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Being a DBA is tough job--there are on call situations to deal with, and managing a large amount of servers with less resources is a constant challenge in corporate environments. In this session you will learn techniques to reduce the amount of manual effort in your job, and keep you three steps ahead of your users. Learn techniques such as:
	• Fully Automating SQL Server Installations
	• Dynamically Adding Databases to an Availability Group
	• Syncing jobs and logins between Availability Group members
	• Patching SQL Servers automatically
	• Other techniques for process automation
This session will benefit both new and Senior DBAs, as well as anyone who wants to automate themselves into a promotion.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
5- Database Administration

Level: Beginner

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Big Data and Data Science are two of the most hyped areas in high tech today.  But what do Big Data and Data Science really mean, and how can you move into these hot career paths?  In the discussion we will: Discuss the different roles in Big Data and Data Science teams; talk about the qualifications around each of the roles.  Andrew will also provide starting points and pointers on how to get started in these fields.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
2- Cloud & Big Data

Level: Beginner

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Master, model, msdb, tempdb. You see them on all of your servers, but what do you really know about them? If you ever wanted to learn about the SQL Server system databases, their purpose, and the maintenance and configuration required to keep your server running its best, then this session is for you! Learn best practices and techniques, including how to restore master and how to configure tempdb to reduce contention. You'll leave with a better understanding of these shared resources and how they affect your database applications.
Speaker:

Session Type:
Regular Session

Track:
5- Database Administration

Level: Beginner

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

In this unique lunch session Microsoft SQL Server MVPs Denny Cherry and Joey D’Antoni will discuss their own personal experiences for creating and implementing a cost effective high availability and disaster recovery solutions. They’ll be covering the protection of Tier-1 applications in the cloud, getting the most out of SQL Server Standard Edition, and of course be there to answer your own clustering questions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
4- Development

Level: Beginner

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Columnstore indexes were introduced in SQL Server 2012 & have been wholly re-architected & optimized in SQL Server 2014.  Columnstore indexes are optimized for data warehouse workloads & are a hybrid technology leveraging the best of off-disk & in-memory capabilities. Transparent to the app, columnstore has been shown to render queries at subsecond response times which heretofore took many minutes or longer. This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites & inside MSIT. The presentation is rich in demos, including leveraging IaaS—Columnstore in The Cloud.  Learn whether columnstore can change your users' world & why columnstore may be a compelling reason to upgrade. Learn how columnstore indexes flip the DW faster bit & why columnstore manifests my motto, “Change the world or go home!”
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
1- The Big Stage

Level: Intermedia

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Making mistakes is human nature, avoiding them comes from experience and shared wisdom from others. In this session, Tim Radney will share experiences he has encountered supporting multiple fortune level companies. Tim will share real world experiences of environments he has worked on and the impact he has seen from administrators not knowing how to properly configure and administer SQL Server. In this session you will learn many accepted best practices for installing, configuring and supporting SQL Server to help your environment run as smooth as possible. When you leave this session you will have a checklist of items to take back to your shop to make sure your environment is configured properly. 
Speaker:

Session Type:
Regular Session

Track:
4- Development

Level: Intermedia

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

If "Data is the Lifeblood of Modern Business," then most businesses are walking corpses with sludge in their veins, because 10% to 25% of all data records in the average enterprise are wrong.  Until the dramatic problems of Data Quality Management are addressed, SQL can never fulfill its original promise to eliminate application "silos", enable systems to communicate and provide useful, actionable information to the modern business.  I believe that we are on the cusp of a revolution in Data Quality that is even greater in scope and impact than the revolution in manufacturing quality that began over 40 years ago.  Businesses that make the transition will survive and thrive.  Those that don't will finally stop shambling about and lay down to die.What is this revolution in Data Quality?  How can you be a part of it (and avoid the headman's ax)?!?  This presentation will change the way you think about your jobs as Database Administrators and Application Developers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
4- Development

Level: Beginner

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Dell SQL Server Systems Consultant Trent Mera will provide a quick overview of two performance management tools:

Spotlight on SQL Server alerts you to problems in your data environment and provides intuitive and rapid diagnostics of the root causes.

Performance Analysis for SQL Server exposes the best tuning opportunities in your database applications by providing a detailed historical view of the workload in your environment, right down to the statement level.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
5- Database Administration

Level: Intermedia

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

The demands for compliance reporting, failover testing, RPO’s and RTO’s in the seconds range, with high performance workloads are all challenges.  Getting the SQL data to the remote site is usually the easiest piece of the puzzle.  What about everything else that is necessary to have a working application.  In 2014, Microsoft released Azure Site Recovery, a cloud based disaster recovery control plane enabling orchestrated failover of virtualized workloads leveraging the replication capability  on many of the leading storage array products.  This combination of virtualized SQL Server applications, cloud orchestration, and high performance storage replication delivers low RPO’s and RTO’s for consistent multi-server distributed SQL Server applications recovery.  Topics covered will include solution architecture, recovery plans, failover testing, failback, audit reporting and compliance using Azure Site Recovery, Hyper-V, and storage array replication.
Speaker:

Session Type:
Regular Session

Track:
6- Bonus Track

Level: Intermedia

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

This session discusses a proven organizational approach and important technical considerations that lead to the successful adoption of Master Data Management (MDM) on SQL Server. Organizational considerations include building buy-in, team capability & expertise, and selling MDM to the rest of the organization while building a subject-area center of excellence. We also discuss approaches to improved time-to-value and to ensure that the technology and staff investment is matched to the expected outcome. Great technology choices will help ensure that your best laid plans succeed and the second half of this session goes over some important technology considerations. In this part of the session we discuss User Experience, Integration Patterns, Matching, Programmability, and Data Quality. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
3- Business Intelligence

Level: Beginner

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Flash storage is a game changer for virtually every app in which it is used. Whether used locally, for tiered storage, or all-flash arrays, flash is turning what we thought we knew about SQL Server best practices on its head. Contemporary IT environments should standardize their architecture including a tier of flash. Virtualized or non-virtualized, standardizing on in-server flash is vital for optimizing performance, scalability, efficiency (technical and cost), reliability, & availability. Learn how flash flips the /faster bit & the significant impact flash makes not just in terms of performance, but also best practices, & the massive savings in licensing driven by consolidation on flash. 
Speaker:

Session Type:
Regular Session

Track:
6- Bonus Track

Level: Intermedia

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

There are many books and articles on how to design a dashboard or create a pretty chart. But how do you know which graphical representation is the right one for your data?  What kind of chart will answer the right business question?  Should you use a line, bar, or pie chart? (Yes, even a pie chart.  Stephen Few is not always correct in a business context.)  When should you use multiple series on a chart versus using small multiples?  What is the best way to show contribution to the whole?  Why would you mix a line and bar chart?  

This session will take a practical approach not theoretical one.  How to give your users and management what they are looking for in a way that balances information content vs. visual impact.  A visualization that not only answers the business questions but draws the eye to the most important aspects of the data.
Speaker:

Session Type:
Regular Session

Track:
3- Business Intelligence

Level: Beginner

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

It’s 2015 and you’re still running your SQL Server on physical servers.  Why?  You don’t have to.  We’ll show you how to run highly available, performant, clustered SQL Server on Azure and Hyper-V.  For Azure solutions we'll cover SQL Server on IaaS including OS, VM and storage configuration.  Would you like to live migrate a SQL Server cluster node in a VM without losing network, storage and client connectivity?  You can using SQL Server, various storage options including virtual fibre channel, iSCSI, and shared VHDX, SMI-S, Hyper-V and Virtual Machine Manager with high performance guest clusters up to 64 nodes.  We’ll review the solution architecture and complimentary high availability features of SQL Server, Windows Failover Clustering, Azure and Hyper-V.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
2- Cloud & Big Data

Level: Advanced

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

DocumentDB is a really easy place to store all kinds of data...as long as its JSON.  It's a NoSQL document database that Azure has released as a platform-as-a-service (PAAS) offering.  Come learn all about what you can do with it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
2- Cloud & Big Data

Level: Beginner

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Imagine taking historical sales data and using data science to accurately predict future sales values. This is precisely the objective of time series forecasting – to predict future values based on previously observed values.

This session will introduce time series forecasting, and describe how different Microsoft BI products enable forecasting for various audiences, including the business analysts, IT developer, and even the Information Worker.

Topics will include Analysis Services forecasting by using the Microsoft Time Series algorithm with the Excel add-ins (Table Analysis Tools and the Client Tools), SQL Server Data Tools (SSDT) and script.
Speaker:

Session Type:
Regular Session

Track:
1- The Big Stage

Level: Intermedia

Session Code:

Date: March 28

Time: 12:00 AM - 1:00 AM

Room: TBD

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