Build Schedule

Advanced Filters:
  • Track

    clear all













  • Speaker


  • Level


  • Session Type


Sessions Found: 65
SQL Server has many build in T-SQL functions. This session will introduce you to 42 of them and explain how they can make your life easier. To name just a few TRANSLATE(REVERSE(DIFFERENCE(STATS_TIME(STRING_SPLIT(…))))
Speaker:

Session Type:
Double Session (120 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 04

Time: 2:20 PM - 4:20 PM

Room: K

See the previous time slot for the description.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 04

Time: 3:40 PM - 4:40 PM

Room: K

Somehow you managed to get yourself voluntold to take care of the company’s SQL Server installation. Over time, you picked up the basic knowledge of how to use indexes to make queries perform better. 
But there are still cases where things just don’t appear to work as expected. Cases where SQL Server seems to ignore existing indexes. Situations where you just can’t figure out how to create a fitting index in the first place.
If that describes you, this session is for you. In it you’ll discover:
- What index selectivity is and how it impacts index selection
- The ominous “tipping point” and how it can lead to surprising index choices by the optimizer
- How to improve Aggregate Performance with indexes
- How to improve Join Performance with indexes
- Indexes on heaps and the Forwarded Records trap
- Filtered Indexes
After attending, you’ll have a set of new tools and techniques in your SQL Server toolbox that you can take home and use to increase performance in your database right away.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 04

Time: 2:10 PM - 3:10 PM

Room: C

In the last releases,  SQL Server development was enriched with new T-SQL features, such as STRING_AGG, STRING_SPLIT, TRANSLATE array of Ranking and Windowing functions (ROW_NUMBER, RANK, DENSE_RANK, TILE), MERGE statement, OUTPUT clause, EXCEPT and INTERSECT just to name a few. For various reasons some DBA/Developers do not utilize these new features. In this session, the audience will see demonstrations of the different practical use cases where these features can make T-SQL coding more efficient. This 100% code-based demo session highlights efficiency to utilize the latest T-SQL functions over conventional methods with the same functionality. The session will cover in depth live scenarios where these features have proven performance efficiency, code re
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 04

Time: 3:40 PM - 4:40 PM

Room: M

Data Science is currently the hottest topic among data analysts and technologists, but getting started can sometimes be daunting or confusing to many data professionals.  We aim to change that with this full-day, hands-on course in which you will be introduced to data science and its basic methodologies using the Python programming language!

Together we will work through some real-world data analyses using several of the most popular Python libraries, such as NumPy, pandas, Matplotlib, and SciPy.  We'll cover collecting and importing data, and introduce basic statistics around our data.  We'll then move on to create some simple visualizations of our data to help us identify trends and patterns.

Note that as this is a hands-on pre-con, participants will be required to bring a laptop with a working Python installation.  Full details on this will be provided prior to the session.

More Details and Sign-Up: https://sqlsat835precon2.eventbrite.com
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
PreCon (Friday)

Level: Beginner

Session Code:

Date: May 03

Time: 9:00 AM - 10:00 AM

Room: Q

Using Advanced Analytics to Measure Customer Experience by Brian Atkiss 

Learn the best ways to use advanced analytics techniques like machine learning and natural language processing to measure customer experience. This session will highlight the datasets that are available across most businesses that can be used to measure customer experience, the methods to analyze those datasets, and the common use cases that can be solved with this type of analysis. It will include an overview of how supervised learning is used for sentiment classification and predictive modeling.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: May 04

Time: 1:00 PM - 2:00 PM

Room: B

TBD
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: May 04

Time: 1:00 PM - 2:00 PM

Room: D

We will cover the benefit of using maintenance plans, tasks that can be created, how we create tasks, how to create sub-plans, and configuration notes and gotchas!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 04

Time: 2:10 PM - 3:10 PM

Room: D

Success of a good BI infrastructure is measured by two most important factors: 
a) Better access to data and 
b) Increased operational efficiency
How can you set up your own BI infrastructure in the cloud to address these? 
What components do we consider?
We can do that by proper selection of technology and vendors from Azure Market Place. How do we keep an eye on possible use of Big Data for your BI. We will also look at the best practices for doing so. We will take a fleeting look at some of the storage options for us in Azure and some Big Data concepts as well.
We will learn about Copy Data Virtualization in Azure Market Place that can help you provision terabytes worth of information in matter of minutes. 
We will also learn about setting up teams and ways to train them(and yourself) in this fast evolving world of Azure.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 04

Time: 10:20 AM - 11:20 AM

Room: L

In the modern world of information technology, SQL Server DBA tasks exceed typical Administration and T-SQL development. Each new SQL Server version brings additional technologies that help streamline and improve its functionalities. Within the last decade, SQL Server has evolved into a sophisticated Enterprise RDBMS tool, and it continues to grow by providing more functionalities to store and manipulate data reliably.

PowerShell, .NET, XML and JSON skills often appear in SQL Server DBA job requirements because the ability to work with those allow the DBA to adapt faster and more efficiently when solving different types of problems. This session designed to bring you up to speed with several of these technologies.

More Details and Sign-Up: https://sqlsat835precon1.eventbrite.com
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
PreCon (Friday)

Level: Advanced

Session Code:

Date: May 03

Time: 9:00 AM - 10:00 AM

Room: P

Are too many systems hitting your SQL Servers? Do you know who they all are? Are you under attack?
When it comes to this type of problem the consensus is to get with your network and domain admins to adequately configure access options. 
What happens when you can't wait or don't even have folks in that role to get the configuration right? 

A blacklist is a list of what cannot access something you are trying to protect. (Like the TSA no-fly list. If you are on the list, you are not getting anywhere fast.)

A whitelist is just the opposite. It is a list of what is permitted to access something. If whatever is attempting access is not on the list, it isn’t getting in.
In this session, we will go through the process to create and test your own SQL based whitelists and blacklists and also take a look at how whitelisting is being used in SQL 2017 to control what CLR objects can be trusted to run in your environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 04

Time: 11:50 AM - 12:50 PM

Room: K

It wasn’t that long ago when virtualization changed the way we work with SQL and infrastructure. Now it’s all about containers. Containers can make the DBA’s job of creating and deploying servers much easier, freeing them up for other tasks such as performance tuning and security. In this session, we will go over the concepts of containers and their general capabilities. Then we will build, connect and configure a SQL Server in a container for use as a private lab.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Double Session (120 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 04

Time: 3:30 PM - 5:30 PM

Room: C

In this case study, I detail how I went about designing and implementing a Speaker Database for the Project Management Institute using SharePoint, Flow, Power Apps, and Microsoft Forms. We will do a brief intro of what each technology is and it's pros and cons, and then dive into what I learned about each, each strengths and weaknesses, and how I was able to build a functional Speaker Database.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 04

Time: 3:35 PM - 4:35 PM

Room: G

Python is the one of the most popular programming languages used today and one of the most useful tools in the data scientist's tool belt especially for machine learning. Python is integrated into the Microsoft stack in tools like Azure ML and now SQL Server 2017.

The session will be an introduction to the Python language including: 

1.) Installing and Configuring Python
2.) Access and Manipulate Data
3.) Install and Manage Packages
4.) Create and Use Objects/Variables
5.) Control Flows and Functions
6.) Managing the Python installation in MSSQL

Attend this session to learn how to use Python to take your data analytics to the next level. We will use Python, SQL Server and the Anaconda distribution of Python to learn the basics of Python and how it is integrated in the Microsoft stack! We will walk through a simple deployment of a machine learning model to see how it all works together and learns some basic data science fundamentals.

No prior statistics knowledge needed.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: May 04

Time: 2:15 PM - 3:15 PM

Room: F

In this fun, interactive presentation, Je'Anna Abbott gives tips for handling those conversations you know you need to have, but you've been avoiding because it seems too difficult or dangerous. By the end of the presentation, participants will be able to: • Recognize where you are stuck because you are unwilling or unable to have a difficult conversation, and become comfortable with initiating and conducting those conversations effectively. •	Develop a strategy to ask for what you want and need without alienating other people or damaging your brand. •	Reframe and recognize the motivations of others to create the most effective responses in yourself. • Acknowledge and mitigate the effect of the conversations that are left unspoken. •	Practice dialogue techniques designed to make others receptive to your constructive conversation, and practice listening techniques designed to build true understanding and support. •	Create a strategy to conduct a constructive conversations in your person
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: May 04

Time: 10:10 AM - 11:10 AM

Room: G

This is the advanced part 2 of Innovative Data Modeling.  Learn how to leverage Master Data Management and Azure Technologies to extend your model for performance, history and reference unstructured data. We will explore how you can use continuous integration and delivery to further maximize value.   Let's look at platform specific techniques and also explore design options for Azure SQL Data Warehouse.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: May 04

Time: 3:30 PM - 4:30 PM

Room: B

Any new database design, normalization process or just simple research starts from data profiling. At first you determine number of rows in the data set. After that you run multiple similar queries against each column to determine Max and Min values, maximum length for text columns, number of nulls, distribution of data, and more.
When all these queries are already pre-set or dynamic or you are doing profiling via SQL Server Data Tools, it is not a problem on relatively small data set, but what if your table contains billions of records, and stretches for multiple gigabytes? All queries against that large data set will do a full table scan, which will produce very heavy I/O, and take forever.
In order to make the process faster, we will use a hidden gem of SQL Server:  Statistics. Only one table scan will be needed to generate them, and then we can use the science behind them to do research over our data.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 04

Time: 8:50 AM - 9:50 AM

Room: K

TBD
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: May 04

Time: 1:00 PM - 2:00 PM

Room: K

Ever wonder about becoming an ETL master using SSIS platform? Come to this session to learn some advanced techniques and design patterns that can be used in solving some day-to-day integration development challenges.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 04

Time: 11:40 AM - 12:40 PM

Room: G

Azure SQL PaaS offers different options? Which one should you choose when you move your SQL Server to Azure Cloud? This session will help you understand the difference between SQL Database Single DB, SQL managed instance and SQL Elastic Pool.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 04

Time: 3:35 PM - 4:35 PM

Room: F

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