Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 36
The Applied Machine Learning with Python session covers some basic concepts, tools and a workflow used to explore, visualize, develop a model to attain answers from data. 

This is an introduction designed for those with minimal or no Machine Learning experience. It is also an applied session focused on getting answers from data, and it does not emphasize the Math behind the ML model. The examples use SQL Server 2017 Machine Learning Services (In-Database) integration with T-SQL, Python, Numpy, Scipy, Pandas, MatplotLib, Scikit-Learn (Machine Learning Library), MicrosoftML, Revoscalepy..

Most importantly, those examples are designed in a manner that are easy for you to understand and to spur your future exploration, by making it possible for you to replicate and use it to expand your knowledge.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: October 06

Time: 11:00 AM - 12:00 PM

Room: 2104

WIll present a sample business intelligence/analytics application using cloud technologies such as Azure Sql Server Analysis Services, Power BI and Azure Machine Learning and how it all works together.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: October 06

Time: 1:45 PM - 2:45 PM

Room: 3103

Thinking about migrating your data warehouse to the cloud? What about all those SSIS packages executing ETLs against your on-prem data sources? In this presentation we will discuss how to successfully "lift and shift" your ETL workloads to the Azure cloud. You will l learn how to configure and deploy an Integration Runtime, deploy and execute SSIS packages in an Azure Data Factory pipeline, and how to monitor and troubleshoot your ETL executions in the cloud. Attendees will walk-away with an understanding of the features, capabilities and limitations of Azure Data Factory and the Integration Runtime and a strategy to leverage your existing SSIS package development efforts to the cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 06

Time: 1:45 PM - 2:45 PM

Room: 4105

In this session we will investigate the various data storage options that are presented for developers in the Microsoft Azure Cloud. We will look at the various storage options for both strongly and loosely bound schema. Topics will include table storage, Azure Search, CosmosDb, Azure Sql Database, and Azure Data Lake Analytics. We will also cover data movement options and security before doing a deeper dive into Azure Sql Database.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 06

Time: 9:45 AM - 10:45 AM

Room: 2105

You’re company is transitioning to the Cloud. Initially, your Azure deployment was small and could be managed primarily via the Azure portal but now it spans the globe with implementations in several countries. You have too many resources to manage with the Azure portal alone. You can automate these tasks with PowerShell without being a PowerShell expert. I’m Ronald Dameron. I’m responsible for managing the resources of twelve Azure subscriptions containing hundreds of resources. I can show you how. I’ve done it.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 06

Time: 11:00 AM - 12:00 PM

Room: 3102

This session looks at both Power BI Desktop and Power BI.com to compare the advantages and capabilities of both platforms for creating and distributing data analysis within your organization.  It will also touch a little on why you might choose Power BI over Power Pivot and why you might not.  It will also look at how to create drill down detail screens to expose the details behind your visualizations.  Finally, we will touch on how to publish your Power BI results for others in your organization to share.  A basic understanding of database structures and referential integrity is an advantage to gain the most from this session, but as will be shown, not always necessary depending on the source of the data to be analyzed.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: October 06

Time: 3:00 PM - 4:00 PM

Room: 1206

The world is going to the cloud and there is plenty of good reason for it, but NOT every IT workload should go to the cloud and your BI is no different. Maybe you aren’t ready, maybe your organization feels fully invested in your current On-Prem infrastructure. Maybe there is some fear of the unknown.

The speaker will tackle these challenges and help you, the attendee, understand how and when to decide to stay On-Premises or move to a Cloud or a Hybrid solution. As an attendee, you should have the information to comfortably determine what is right for your organization today, and have a plan for the future.

Attendees will understand what On-Premises benefits are available exclusively to them
Attendees will understand where Cloud and Hybrid solutions complement their existing deployments 
Attendees will be in a better position to explore moving beyond their On-Premises deployment
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 06

Time: 11:00 AM - 12:00 PM

Room: 3103

Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged…  we have you covered.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: October 06

Time: 12:30 PM - 1:30 PM

Room: 3103

More and more regulatory requirements are coming out around having your data encrypted.  Many DBAs are struggling to know where to encrypt and the impact to performance encryption causes at each level.  We will walk through the basics of all encryption options for SQL Server workloads including TDE, Always Encrypted, database and column level encryption, encrypted connections, storage encryption, certificates, key management and much, much, much more!!!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 06

Time: 9:45 AM - 10:45 AM

Room: 2104

in this session, We will go over different design patterns to perform ETL using ssis and biml.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 06

Time: 11:00 AM - 12:00 PM

Room: 2105

You probably already know that indexes make your queries go faster. But do you know all the different types of indexes in SQL Server and when to use them? Also with each new release of SQL Server, there are new features that can impact how indexes function and are maintained. Finally, knowing how the different types of indexes work can help you make better indexing choices when tuning your queries.
This presentation will review current SQL Server index structures and options, discuss how they work, when they should be used and how to maintain them. Examples of all the index types such as hash, in-memory, columnstore, filtered, etc… will be shown.
This presentation is a must see for DBAs, Developers, Application Architects and anyone else who is interesting in maintaining high performance SQL Server applications.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 06

Time: 9:45 AM - 10:45 AM

Room: 1206

In this session we will review how to leverage Enzo Data Pipelines to export and synchronize data from hosted data sources (SharePoint Online, Twitter and SalesForce) into a relational database in the cloud for software integration and reporting. As part of this presentation you will see how you can implement a Change Data Capture (CDC) architecture on top of SharePoint Online, Twitter and SalesForce, allowing you to trigger actions when source data changes in those systems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: October 06

Time: 12:30 PM - 1:30 PM

Room: 2104

When designing your HA/DR solution, you need to consider all the possible options SQL Server has to offer to implement what is right for you.  You will see how to use Failover Cluster Instances, Standalone Instances, Clusters, Availability Groups and Distributed Availability Groups.

We will walk through how to set up and configure an HA/DR solution from beginning to end, review possible alerts, and how to monitor.  We will take a look at the new SQL2017 Read-scale Availability Groups and why to use them.  We will architect one of many possible VM solutions to host your HA/DR implementation.

Finally, we will see Automatic Failover and see how to perform a Manual Failover.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: October 06

Time: 9:45 AM - 10:45 AM

Room: 2103

In this session, I'll show you how to hack SQL Server using a simple C# console application and other tools. Most importantly, I'll show you how to protect vectors that perhaps you're trying to use to safeguard sensitive data for GDPR compliance.
 
1. Tabular Data Stream (TDS) Protocol
2. Dynamic Data Masking
3. Row Level Security (Yep...)
4. Database Source Control
 
Perhaps, you've seen these exploits before but do you really know how to reproduce them? Or, how to even protect yourself against them? No worries, I'll show you the way along with a load test.
 
Finally, I am very excited to share with you how to analyze text using pre-trained Machine Learning models to predict a sentiment, on-prem with SQL Server 2017.
 
5. SQL ML / AI - A deep dive to predict the sentiment
 
Looking forward to meeting you all.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: October 06

Time: 11:00 AM - 12:00 PM

Room: 2103

This session will cover how to setup your database source code in a source code repository, configure your website application, configure continuous integration and continuous deployments of your database alongside your application using Visual Studio Online, Red Gate DLM SQL CI, and Octopus Deploy.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: October 06

Time: 9:45 AM - 10:45 AM

Room: 3102

Attendees of this session at SQL Saturday South Florida 2018 voted to recommend it for SQL Saturday Orlando! There have been more advancements in the topic of auditing SQL inserts, updates and deletes during the past few years than in the nearly 30-year history of SQL Server. Eric Berkowitz presents a fast-paced, live demonstration and comparison of Change Data Capture, the new SQL Temporal Tables and conventional trigger-based methods. Gain the ability to audit, research and report on data changes, without recoding existing applications and proactively plan for auditing in new systems. Understand the overhead and performance implications and storage and retention options for each approach. See how querying, DDL changes and compatibility considerations vary among the methods so you can make informed decisions about implementing auditing in your system.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 06

Time: 1:45 PM - 2:45 PM

Room: 3102

Organizations are faces with information overload from employee generated unstructured data in the form of emails and electronic documents.    With no idea of the content that exists within these documents or the locations with more and more options being provided for storage of documents,  Organizations are having to come to terms with the liabilities, overhead and management of these resources.      This session looks at the issues of dark data within an organization and methods to understand and combat it.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: October 06

Time: 12:30 PM - 1:30 PM

Room: 2105

Indexing in SQL Server is both - art and science. It is also never-ending process. Database schema, queries and workload change overtime, making old indexing strategy obsolete and leaving you with inefficient or unused indexes.  

In this session, Dmitri demonstrates several techniques that help you to perform index analysis in the system. You would learn how to detect unused and inefficient indexes, identify incorrect clustered indexes and choose the right candidates for consolidation and further index refactoring.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 06

Time: 11:00 AM - 12:00 PM

Room: 4105

In this session you will learn about Azure Functions and how to build a simple HTTP proxy that returns data from an Azure SQL Database, built entirely in the cloud. We will review configuration settings, how to securely store your connection strings, how to implement logging, how to implement retry logic and how to troubleshoot your Azure Functions. The demos will be done entirely in the cloud, without using Visual Studio.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 06

Time: 12:30 PM - 1:30 PM

Room: R3

Ever wondered on what is the buzz about Internet of Things (IoT)? and interested in making your own?
We will take an look on what is Internet of Things (IoT), the impact of IoT to the world, industries that IoT can disrupt and then, we will provide an overview of building an IoT solutions using various technologies in Azure such as IoT Hub, Functions, Stream Analytics, Power BI, and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: October 06

Time: 1:45 PM - 2:45 PM

Room: 2103

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