Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 31
DevOps is the merger of app development, testing, and IT ops.  All tasks from coding to testing to operations must be automated so that new features and fixes can be continuously delivered.

Test Data Management (TDM) is the optimization of the process of software quality, ensuring that applications properly work according to their specifications.

Constraining both DevOps and TDM is data, which has grown enormous and complex. "Storage is cheap" is not merely a lie, but beside the point. It takes a lot of time to push terabytes around from place to place, and time is expensive.

Provisioning a full environment for each developer or tester on each task of each project seems unrealistic, when each might require terabytes of storage. So, everyone is limited to working in a small shared dev/test environments that are refreshed only every few months, and code quality suffers, and the pace of delivery fails to live up to requirements.

Data virtualization is the solution.  Come learn.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 25

Time: 1:30 PM - 2:45 PM

Room: 3

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:

Session Type:
Regular Session (75 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 25

Time: 8:30 AM - 9:45 AM

Room: 3

DevOps is a hot topic in today's software development world. However most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can be applied to database development by looking at both automated comparison analysis as well as migration script management. Automated building, testing, and deployment of database changes will be shown.
Speaker:

Session Type:
Extended Session (0 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: March 25

Time: 11:00 AM - 11:00 AM

Room: 3

Is it time to move some of your Business Intelligence framework to the cloud?  With so many cloud-enabled tools and platforms available today, including Azure Data Warehouse, Azure Analysis Services, Azure Data Lake, PowerBI, and many more, it has become a choice to consider for data architects.  In addition to live demonstrations, Carlos will discuss data architectures and strategies that would benefit by using these new technologies.  Come see some of these new features in action, allowing you to determine if it’s right for you and your architecture.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: March 25

Time: 1:30 PM - 2:45 PM

Room: 1

Many of us feel pressure to deploy changes to our database more often and more reliably. SSDT gives us a number of options to set up continuous integration and eventually, continuous deployment. Learn how to create and customize DACPACs, Published Profiles, and SQLPackage.exe to automate your deployment process. Whether you want to update QA or smoothly get changes to production, this session will give you the tips and tricks you need to get started.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 25

Time: 11:00 AM - 12:15 PM

Room: 5

Every organization struggles to ensure data is up to date and consistent across multiple systems.   Often this results in the development of layers of system to system data integrations or repetitive and manual processes intended to support operational and reporting needs.

Enterprise Data Warehouses and Marts are often the only stores that provide single point access to data sourced from multiple systems - but these stores can be expensive and complicated to build and maintain and tend to lag behind business need.

Data Lakes offer the promise of fast inexpensive data acquisition but without specialized tools lack the structure that makes their data accessible and useful to the business.

A managed Data Integration platform can provide both efficient data management across systems and a shared, single point, store of data sourced from all participating systems.   A Data Integration platform solution is not technology or tool specific and can provide immediate and continuing value.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Information Delivery

Level: Beginner

Session Code:

Date: March 25

Time: 9:45 AM - 11:00 AM

Room: 3

So you have a good backup strategy in place, but now you have to think about a disaster recovery.  Where do you start and what are your options?  SQL Server offers several options, but then how do you choose the right one to meet your business requirements?  In this session, we will go over some of the common DR options including log shipping, replication, mirroring, clustering, and AlwaysOn.  Then we will talk about how to choose the best one to meet your business needs.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: March 25

Time: 9:45 AM - 11:00 AM

Room: 5

Power BI Desktop is so intuitive when it comes to creating reports that even a 13 year old can do it.  In fact I'm 13 and I can do it! Don't believe me?  Come to my session as I demonstrate how to import data, create dashboards, and publish them to the Power BI service.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: March 25

Time: 11:00 AM - 12:15 PM

Room: 1

In this session, we will walk you step by step showing how we determine root cause analysis of an unexplained failure in an Availability Group.  Whether the databases simply became unavailable, synchronization stopped, or there was an unexplained failover.   We will show you specifically what we look for in the OS Cluster logs, SQL error logs, Extended Events and other sources of information.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: March 25

Time: 9:45 AM - 11:00 AM

Room: 4

Are your transaction logs ballooning? Are the VLF numbers out of control? What can you do about it? 

Let's start with "what's a VLF and why do I care?" and move forward into learning how to shrink VLFs (a temporary solution) and how to resize SQL Server transaction log files (a more permanent solution) for greater server stability, better performance during server startup, backups, and restores, and to minimize storage space requirements.

The SQL Server transaction log is a critical piece of SQL Server's ability to ensure that data is maintained exactly as the user input or modified the data. The transaction log must, at times, grow in size in order to do its job. When a transaction log’s growth gets out of control (too large, too many segments), then SQL Server’s ability to perform as it should is negatively impacted. Too-large transaction log files cause longer database start up, backup and restore times, and will require more storage space on disk. Learn how to control VLF gro
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: March 25

Time: 2:45 PM - 4:00 PM

Room: 5

Are you looking to understand what IaaS or PaaS really mean? Perhaps you are not sure of virtual, high available relational or NoSQL databases. Get started with the basics of managed services and platforms for running databases on AWS. Hear how to use managed relational databases such as MS SQL Server with minimal administration. Also discover other cloud options such as managed NoSQL or scaling your own instances with resizable elastic compute cloud. Take home an introduction from in-memory cache to petabyte-scale data warehouse databases in the Amazon cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: March 25

Time: 11:00 AM - 12:15 PM

Room: 6

Who has difficulty communicating the value of databases across their organization? Who wants to make more of a difference using database systems? Who is dissatisfied with their job and feels under-appreciated?

Welcome to my world. I've worked for years as a consultant, and I started in this situation, but I began making a living helping folks crawl their way out. Along the way, I got my Microsoft MVP, and I've helped many organizations make millions of more dollars through my consulting efforts. I'd like to help you, too.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: March 25

Time: 2:45 PM - 4:00 PM

Room: 1

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: March 25

Time: 2:45 PM - 4:00 PM

Room: 6

Developers are interested in consuming and processing very large amounts of data as quickly as possible. Microsoft Azure DocumentDB is a NoSQL document database service designed for modern mobile and web applications which require fast reads and writes of unstructured data feeds. Azure DocumentDB natively supports JSON documents which is a key performance feature. 

In this session I will demonstrate how to create a DocumentDB instance in Azure, how to work with JSON documents, create Ad hoc queries with familiar SQL syntax, create application logic as stored procedures, triggers and user defined functions (UDFs) using standard JavaScript. Finally, I will compare performance and feature difference between SQL Server 2016 and Azure DocumentDB.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 25

Time: 1:30 PM - 2:45 PM

Room: 6

We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it.  This session includes demonstration and use case scenarios.  The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: March 25

Time: 8:30 AM - 9:45 AM

Room: 1

Data Science is the gaining popularity but what does it really mean? 
Discovering useful patterns and insight in the enterprise has become more challenging without a new set of tools. Big data has taken center stage in the data warehouse community and with data sets so large and complex that traditional data processing applications are becoming inadequate. Learn about the R language that is at the center of most advanced analytics conversations. R is an open source statistical language that is rapidly gaining popularity due to a robust set of machine learning functionality and a never-ending set of R packages that are used to increase functionality of the core R language.
In this session, we will introduce the R language and review some of the features of the highly interactive environment that are available with just the base install. We will also review some of the upcoming features in the SQL Server 2016.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: March 25

Time: 11:00 AM - 12:15 PM

Room: 2

A fast and furious overview of the fundamentals of SQL (Structured Query Language), its history, language fundamentals of the data definition, data manipulation, data control, and transaction control language aspects.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: March 25

Time: 8:30 AM - 9:45 AM

Room: 5

In this session we will review Isolation levels and how they affect applications that run on SQL Server.  We will explore what happens when multiple applications accessing the same data use different isolation levels, and how that effects the server as a whole.   We will also explore different ways to relieve these tantrums, and make your applications play nice together.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 25

Time: 2:45 PM - 4:00 PM

Room: 3

SQL Server Reporting Services (SSRS) 2016 is getting the biggest update since SQL Server 2005! This session will define and demo each of the SSRS report types are and how they are developed and supported: Mobile (previously DataZen reports), Paginated (SSRS RDL reports), KPIs (new standalone Key Performance Indicators), and Power BI (now Power BI can be managed in SSRS for an on-premises solution). All of these report types can now be managed in SSRS for a single reporting solution.

We will also look at the new SSRS Web Portal (replacement for Report Manager) and how the development environment will change as well. Sometime will also be spent on how to support all of these report types and the impact it will have on IT.
If you have been curious about what has changed with SSRS in SQL Server 2016 and you want to be ahead of the curve, this is the session for you!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: March 25

Time: 2:45 PM - 4:00 PM

Room: 2

Replication can be intimidating and a bit confusing. I will show you my ten favorite tricks for working with replication that will show you how you can replicate from multiple sources to multiple destinations, chose the appropriate method of replication and, if desired, put the data in a different schema with a different collation at the destination than it was at the source. I will also cover various methods of managing your publications, agent properties and distribution schedules. This presentation assumes a basic knowledge of configuring distribution and creating a basic publication and subscription.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 25

Time: 11:00 AM - 12:15 PM

Room: 4

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