Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 67
SQL Server 2016 introduces a new way of deploying an availability group: Distributed Availability Groups. This new form of an AG allows you to span different underlying Windows Server Cluster topologies which can enable both disaster recovery and migration scenarios. This session will cover how Distributed Availability Groups work, how you need to think about them in a possible deployment scenario, as well as show a demo of one in action.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 20

Time: 9:15 AM - 10:25 AM

Room: Radio City (6-48)

DevOps is the merger of app development, testing, and IT ops.  All tasks from coding to testing to operations should be automated so new features and fixes can be continuously quickly.

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 database size. "Storage is cheap" is not merely a lie, but more to the point it takes a lot of time to push terabytes around from place to place, and time itself is expensive and dear.

Providing full databases for each developer or tester on each task of each project seems unrealistic, when each copy might require terabytes of storage, so for decades everyone has limited themselves to working in shared dev/test environments that are refreshed only every few months, where conflicts occur,  quality suffers, and things move slowly.

Come learn why data virtualization is the solution to a problem everyone knows.
Speaker:

Session Type:
Regular Session (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: May 20

Time: 10:35 AM - 11:45 AM

Room: Ambassador (6-18)

More and more regulated and audited industries have the problem that the DBA's that manage SQL Server can access all the data. While application level encryption can solve the problem for special data like SSN sometimes encryption is not an option (keyword 3rd party application).

This session shows how to manage SQL Server without being a member of the sysadmin server role and how to audit SQL Server in cases where the DBA has to troubleshoot a problem as sysadmin.
Speaker:

Session Type:
Regular Session (70 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 20

Time: 9:15 AM - 10:25 AM

Room: Ambassador (6-18)

As an ETL developer using SQL Server Integration Services have you ever wondered how to:
1.	Import all .csv files from a folder
2.	Replace dynamic SQL using variables in SSIS
3.	How to configure the data flow buffer
4.	Create custom logging solutions
5.	Use a script component as a data flow transformation
This session focuses on advanced techniques that are used in SSIS and is meant for the experienced SSIS developer.  We will focus on tasks and techniques that are native to SSIS 2005-2014 as well as some of the more advanced and vague  properties.  
Attendees must have a good working knowledge of SSIS as well as familiarity with VB.NET or C# as some time will be taken looking at extending SSIS with script tasks and components.
Upon completion of this workshop attendees will be able to:
1.	Import/export multiple sources/destinations
2.	Use an execute SQL task with variables to replace dynamic SQL within a package
3.	Dynamically handle errors within any part of a package
4.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: May 20

Time: 9:15 AM - 10:25 AM

Room: Broadway (5-30)

This will be an introduction to the new SQL Server 2016 Always Encryption feature. Unlike Transparent Data Encryption Always Encrypted provides encryption in transit as well as encryption at rest. This will be a survey overview of both the operations and development side of Always Encrypted, but will be mainly operations focused. Considerations for porting existing databases to Always Encrypted will also be discussed.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 20

Time: 2:25 PM - 3:35 PM

Room: Ambassador (6-18)

We will take a look at an introduction and overview of Azure Analysis Services - Microsoft 's cloud-based analytical engine and Platform as a Service (PaaS) offering. We will discuss Azure Analysis Services features and capabilities, use cases, provisioning and deployment, managing and monitoring, tools, and report creation. Although Azure Analysis Service is in Public Preview at the time of this session submission, we will incorporate the latest publicly  available information.
Speaker:

Session Type:
Regular Session (70 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 20

Time: 10:35 AM - 11:45 AM

Room: Broadway (5-30)

Azure Data Catalog is a fully managed cloud service that enables users to discover the data sources they need, and to understand the data sources they find, while helping organizations get more value from their existing investments. Data Catalog provides capabilities that enable any user – from analysts to data scientists to developers – to discover, understand, and consume data sources. Data Catalog includes a crowdsourcing model of metadata and annotations, and allows all users to contribute their knowledge to build a community and culture of data.

This session will provide a 101 introduction to Azure Data Catalog. Included in this session will be creating an Asset in Azure Data Catalog, setting up access control for Assets, amongst the demonstration of features of the product.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
Information Delivery

Level: Beginner

Session Code:

Date: May 20

Time: 3:45 PM - 4:55 PM

Room: Ambassador (6-18)

They are the largest hosting companies in the world, Amazon AWS and Microsoft Azure, both have our beloved SQL Server running as a PaaS (Platform-as-a-Service). 

The term DBaaS (Database-as-a-Service) is a brand new concept that brings the self-managing cloud process to our reality, now administrative tasks and process such as backup, high availability and disaster recovery solutions will be handed to the hosting company.

Flexibility, scalability on-demand, and rapid provisioning are the hottest points to move towards to the PaaS delivery.
Ready to change the mindset of your company and concern only with the business value, join with me on this session and open your mind to the new reality.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 20

Time: 2:25 PM - 3:35 PM

Room: Central Park East (6-80)

Cloud computing requires new security paradigms that are unfamiliar to many application users, database administrators, and programmers. Consequently, some organizations are hesitant to implement a cloud infrastructure for data management due to perceived security risks. However, much of this concern can be alleviated through a better understanding of the security features built into Microsoft Azure and Microsoft Azure SQL Database.

Azure provides extremely robust security protection at the physical, logical, and data layers of its services and applications, making Azure datacenters among the most secure facilities of their kind in the world. Likewise, Azure SQL Database includes multiple layers of security, with role-based logical data protection and auditing to monitor the security of your data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: May 20

Time: 3:45 PM - 4:55 PM

Room: Radio City (6-48)

Has your company been building data warehouses for years using SQL Server?  And are you now tasked with creating or moving your data warehouse to the cloud and modernizing it to support “Big Data”?  What technologies/tools should use?  That is what this presentation will help you answer.  First we will cover what questions to ask concerning data (type, size, frequency), reporting, performance needs, on-prem vs cloud, staff technology skills, OSS requirements, and cost.  Then we will show you common big data architecture solutions and help you to answer questions such as: What tool do I use to move data to the cloud?  Where do I store the data?  Should I use a data lake?  Do I still need a cube?  What about Hadoop/NoSQL?  Do I need the power of MPP?  Should I build a "logical data warehouse"?  Finally, we’ll show some architectures of real-world customer big data solutions.  Come to this session to get started down the path to making the proper technology choices in moving to the cloud.
Speaker:

Session Type:
Regular Session (70 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 20

Time: 3:45 PM - 4:55 PM

Room: Broadway (5-30)

It is very frustrating when users complain about inability to connect to SQL Server while SQL Server functioning as normal as usually.
This session demonstrates multiple different scenarios of SQL Server connectivity issues, describes  basic of troubleshooting methods and showing possible fixes using PowerShell  scripts.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 20

Time: 10:35 AM - 11:45 AM

Room: Majestic (5-18)

SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.
Speaker:

Session Type:
Regular Session (70 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 20

Time: 9:15 AM - 10:25 AM

Room: Belasco (6-20)

Azure Machine Learning is a predictive analytics service that allows you to quickly create and deploy analytic solutions. These solutions can predict future trends based on current and historical data. This allows solutions to get smarter over time. Azure Machine Learning Studio allows you to set up an experiment using drag-and-drop modules preprogrammed with predictive modeling techniques with just a web browser. 

This session will provide a fundamental introduction to the Azure Machine Learning cloud service (as well as key machine learning paradigms and concepts). In addition, we will go over setting up a workspace, training a machine learning model, and publishing the model as web service using Machine Learning Studio.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: May 20

Time: 1:05 PM - 2:15 PM

Room: Broadway (5-30)

The new term called - DBaaS (Database as a Service) is being widely recognised nowadays, this denomination provides a flexible, scalable and on-demand platform that is oriented toward self-service and easy management delivering, principally in terms of provisioning a business own environment. Is not necessary anymore the acquirement of a machine on the Microsoft Cloud [IaaS] to run a SQL Server Database, now you can leave this complexity behind by handing over this responsibility to Microsoft Azure Datacenter. 

This new technology is being adopted for a lot of customers around the world and now it’s your time to get into it by learning the best practices configurations and caveats. Immerse yourself in this session and learn how to provide a to your customer the best database solution available on the market, the SQL Database from Microsoft Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 20

Time: 3:45 PM - 4:55 PM

Room: Central Park East (6-80)

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 20

Time: 1:05 PM - 2:15 PM

Room: Music Box (5-46)

SQL Server 2016 SP1 makes data compression available in all editions. Data compression can reduce storage costs, and provide a performance boost—and now compression is available without the added cost of Enterprise Edition. Whether you are a developer or a DBA, it's important to know how to use compression to save money and improve speed.

Come learn about how data compression actually works, the differences between ROW and PAGE compression, and learn how to pick the best compression level for your data. This session will cover the details of the compression algorithms, and the costs and benefits associated with each type of compression. 

By the end of this session, you'll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (70 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 20

Time: 3:45 PM - 4:55 PM

Room: Majestic (5-18)

In this session attendees will learn how to make decisions around which technologies to use when delivering BI solutions including some exciting new BI features in SQL 2016.  We will explore the starting point of the project with data sources, step through the ETL decision making process and on to picking the medium for best delivery of content, while learning some best practices along the way.
Speaker:

Session Type:
Regular Session (70 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 20

Time: 9:15 AM - 10:25 AM

Room: Marquis (5-18)

What if you could import 25 million rows of CSV data in less than 2 minutes? Or regain lost sysadmin access to your SQL Server in 20 seconds?  Need to check which of your 200 servers has misconfigured max memory, calculate the proper memory and then set it? No problem, couple of minutes, tops.

PowerShell can do amazing things for database administrators. It can automate your complex, onerous tasks.  It can also automate the boring yet vital tasks like testing backups, and it can do it faster than you think.  Even better, it is easier to learn than you might expect.

Get Better, Faster, Stronger with PowerShell & SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (70 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 20

Time: 9:15 AM - 10:25 AM

Room: Majestic (5-18)

Abstract:

Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).

Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.

How do you reduce the size of your data mart and speed up data retrieval?

This presentation will review the following techniques to fix your woes.

Coverage:

1 – What is horizontal partitioning?
2 – Database sharding for daily information.
3 – Working with files and file groups.
3 – Partitioned views for performance.
4 – Table and Index partitions.
5 – Row Data Compression.
6 – Page Data Compression.
7 – Programming a sliding window.
8 – What is different in Azure SQL database?
Speaker:

Session Type:
Regular Session (70 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: May 20

Time: 2:25 PM - 3:35 PM

Room: Winter Garden (5-46)

For beginning database professionals, execution plans can be intimidating. This 1-hour session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache. 

Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.
Speaker:

Session Type:
Regular Session (70 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 20

Time: 3:45 PM - 4:55 PM

Room: Music Box (5-46)

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