Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 37
In the day-to-day operations of business, how often have we heard or even asked someone the question ourselves, “Can I get a report of this?”  Regardless of your area of expertise, reporting has become a necessity and requirement among businesses and is impacting our roles as IT professionals.  With the huge wave of trendy reporting tools and software surrounding the BI industry, many people are unaware or often overlook SSRS as a reporting solution.  In this session, we will look at the features and capabilities of SSRS, as well as supply you with the tools to begin fulfilling basic report requests.   At the conclusion of this session, you will know the difference between Report Builder and SQL Server Data Tools to determine which one is suitable for your needs.  You will also be able to create and deploy a basic report consisting of a data source, data set, a parameter and a row group.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: January 30

Time: 3:10 PM - 4:10 PM

Room: BI

This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the "noteworthy" query plan patterns that go beyond the normal areas that customer tend to investigate. This session covers SQL Server 2005 forward and includes the new SQL Server 2016 Query Store and Live Query Statistics. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: January 30

Time: 4:20 PM - 5:20 PM

Room: DBA

Machine Learning is a subfield of computer science concerned with systems that learn from data. In this session, learn how a Microsoft Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with machine learning algorithms, and then finally to the integration and integration of predictive insights.

This session has been specifically designed to describe machine learning fundamentals, and to help enable and inspire existing developers taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease in which it can be accomplished.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: January 30

Time: 2:00 PM - 3:30 PM

Room: Cloud

Do you need to devise a backup and restore plan to meet the Recovery Point Objective (RPO) and Recovery Time Objective (RTO) of your business?  I'll show you how to pick the right backup type, method, and recovery model to meet your business needs.  You'll learn how the network and drive format can have an effect on your backups and avoid the pitfalls that slow down your backup and restore plan.  You'll also learn how to keep your transaction log from growing uncontrollably while speeding up your backups and restores using the native tools without any added cost!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: January 30

Time: 2:00 PM - 3:00 PM

Room: DBA

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: January 30

Time: 9:00 AM - 10:00 AM

Room: DBA2

Do you dread handing your T-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your T-SQL? In this demo heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn about formatting T-SQL for readability and why top down design is not the best solution for writing T-SQL. You’ll learn why implicit conversions slow queries down and how to leverage simple techniques for minimizing the performance impact of explicit conversions. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: January 30

Time: 3:10 PM - 4:10 PM

Room: Developer

Column store technology was first introduced in SQL Server 2012 and has been significantly enhanced for SQL Server 2014 and SQL Server 2016. Column store indexes can not only accelerate data warehouse workloads by an order of magnitude but also reduce storage requirements by an order of magnitude. Column store indexes are a hybrid technology leveraging the best of disk & in-memory capabilities. In this session we cover how to take advantage of column store capabilities in your applications and dive into the internals of how column store works in following areas.
Business Rationale ,
Overview,
Data Compression,
Query Performance,
Clustered Column Store Index,
Supportability: DMVs, Perfmon, XEvents,
High Availability/Supportability,

You will also learn what is available new in SQL Server 2012, SQL Server 2014 and SQL Server 2016.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: January 30

Time: 2:00 PM - 3:00 PM

Room: Developer

SQL Server offers various configuration settings and tuning parameters. As hardware capabilities increase rapidly, choosing the proper configuration settings is extremely important to scale SQL Server for the required application throughput rates. In the last two  years, SQL Server Escalation Team has helped many systems administrators and database administrators scale their SQL Server with several configuration parameters and application patterns. In this session you will hear directly from an experienced member of the Microsoft SQL Server escalation team [Suresh Kandoth], about these specific learnings, configurations and approaches for scaling SQL Server on the largest hardware systems available on the planet.
The goal of this session to help you and guide you to perform successful deployment of SQL Server for your largest SQL Server installations.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: January 30

Time: 3:10 PM - 4:10 PM

Room: Big Room

DevOps is a word that gets thrown around a lot these days and is the way most shops will operate in the future. In my presentation I'll show you how to fast forward to the future by automating your deployments from SSDT using Powershell and SQLPackage.exe.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: January 30

Time: 10:10 AM - 11:10 AM

Room: Developer

Everyone agrees that great database performance starts with a great database design. Unfortunately, not everyone agrees which design options are best. Data architects and DBAs have debated database design best practices for decades. Systems built to handle current workloads are unable to maintain performance as workloads increase.

Attend this new and improved session and join the debate about the pros and cons of database design decisions. This debate includes topics such as logical design, datatypes, primary keys, indexes, refactoring, code-first generators, and even the cloud. Learn about the contentious issues that most affect your end users and how to avoid them. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: January 30

Time: 2:00 PM - 3:00 PM

Room: Big Room

This presentation is based upon a top 10 presentation “Virtualizing Databases: Doing IT Right given” at VMworld last year in Barcelona and the US. . In this presentation we will teach you how to properly virtualize any business critical application with specifics on databases and VMware newest release vSphere 6.0.  A database is a very resource intensive by its very nature a monster VM and one of the most resource intensive applications you will ever virtualize. If it is not done correctly you will not be successful. This presentation will teach you how to do it right. We will discuss why you virtualize a database, using the right hypervisor, installation, Architecting for performance, the storage layer, the processor, Memory considerations, the network layer.  Topics include NUMA, Memory reservations, Network details to how to avoid common mistakes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: January 30

Time: 11:20 AM - 12:20 PM

Room: Cloud

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: January 30

Time: 9:00 AM - 10:00 AM

Room: Developer

You have a lot of servers and need to make sure you have consistent settings configured like disabling auto shrink, disabling extended stored procedures, or enabling database mail.  I'll show you how to check those settings across all your servers with Central Management Server and how you can manage a disperse environment.  You will learn how to leverage the power of Policy Based Management to 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 settings is changed.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: January 30

Time: 9:00 AM - 10:00 AM

Room: Big Room

As the concept of Hybrid Datacenter becomes more mainstream data professionals will need to understand how to effectively manage and migrate data between on-premises and cloud servers. Attend this interactive session and learn how to create, deploy, and migrate data from your on-premises instance of SQL Server to Microsoft Azure Virtual Machines and Microsoft Azure SQL Database.

Attendees of this session will learn (1) How to decide if IaaS of PaaS is the right option, (2) How to prepare your database for migration to SQL Azure, (3) How to best migrate data to Microsoft Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: January 30

Time: 9:00 AM - 10:00 AM

Room: Cloud

Discussion regarding "Fun Facts" pertaining to AGs
For Example  "max worker threads" minus 40 or Cross database ownership chaining support in AGs
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: January 30

Time: 10:10 AM - 11:10 AM

Room: DBA

Who needs to move data around? Everyone, of course. Whether we're moving data on-premises or in the cloud, Microsoft's Azure Data Factory (ADF) service is a great way to compose and manage the pipelines that transform data inside and between our systems. ADF integrates well with existing Extract, Transform and Load (ETL) frameworks while closing the gaps left by data-UNaware task schedulers. In this introductory, highly-interactive session, you'll learn how ADF can help you visualize, define and manage data as it moves around, no matter whether that's on-premises, in the cloud or in between the two. Even though this is an introductory session, basic familiarity with common ETL and task-scheduling concepts is recommended.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: January 30

Time: 10:10 AM - 11:10 AM

Room: Cloud

SQL Server 2016 is one of the largest SQL Server releases of all time.  This talk will give an overview of the features we are introducing to give you a primer on how this release of SQL can help you and your business succeed. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA Track

Level: Beginner

Session Code:

Date: January 30

Time: 10:10 AM - 11:10 AM

Room: Big Room

SQL Server 2016 is one of the largest SQL Server releases of all time.  This talk will give an overview of the features we are introducing to give you a primer on how this release of SQL can help you and your business succeed. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA Track

Level: Beginner

Session Code:

Date: January 30

Time: 11:20 AM - 12:20 PM

Room: Big Room

Have you ever needed to generate dozens (or even hundreds) of similar SSIS packages? Do you ever find yourself needing to regenerate a lot of packages when some piece of the upstream data format changes? Using native SSIS, this can be a tedious and error prone exercise. However, using Biml (Business Intelligence Markup Language) can greatly increase your productivity as an ETL developer.

In this session, we'll cover the essentials of Biml. I'll discuss what it is and what it can do for SSIS, demonstrating how it can easily generate dozens or even hundreds of packages in just a few minutes. I'll also demonstrate some realistic examples and discuss how Biml fits into the enterprise ETL picture.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: January 30

Time: 4:20 PM - 5:20 PM

Room: BI

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. This session will also introduce and describe the impressive new forecasting capabilities delivered in Power View with Office 365. As part of Microsoft’s new approach to simplify complex Machine Learning technology, forecasting in Power View enables powerful forecasting capabilities for the unspecialized Information Worker.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: January 30

Time: 10:10 AM - 11:40 AM

Room: BI

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