Build Schedule

Advanced Filters:
  • Track

    clear all













  • Speaker


  • Level


  • Session Type


Sessions Found: 42
The arrival of the Big Data movement (Hadoop and NoSQL) is changing the enterprise data architecture.
In this presentation, I will describe the advantages and disadvantages of OLTP, OLAP and Big Data, and the increase of BDMS (BIG DATA MANAGEMENT SYSTEMS). I will show how the Modern Database Architecture landscape is changing.
I also intend to present a general description of the techniques and tools used in The Modern Data Architecture
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: June 09

Time: 2:45 PM - 3:45 PM

Room: 3035

Come join me for this session on Adaptive Query Processing (AQP) in SQL Server 2017 and Azure SQL Database.  During this session I will show how this new feature can enhance your application and query performance without code changes.  

Come see how you can benefit from a self-learning artificial intelligent database.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA Advanced

Level: Intermedia

Session Code:

Date: June 09

Time: 1:30 PM - 2:30 PM

Room: 3044

This will be the third time delivering this session in South Florida and much has changed in the past year. In this session I will be covering the new enhancements added to the service in the past year including Managed Instance, automatic tuning capabilities and support for Open Source databases.

I will wrap up the session with an overview of the shifting responsibilities of the DBA as cloud becomes more mainstream.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure Cloud

Level: Beginner

Session Code:

Date: June 09

Time: 9:45 AM - 10:45 AM

Room: 1053

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 leverage the Python programming language integration with SQL Server 2017 Machine Learning Services (In-Database).

Most importantly, those examples are designed in a manner that are easy 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:
Data Science

Level: Beginner

Session Code:

Date: June 09

Time: 11:00 AM - 12:00 PM

Room: 3033

Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DevOps

Level: Beginner

Session Code:

Date: June 09

Time: 2:45 PM - 3:45 PM

Room: 3044

In this 60 minute interactive workshop, attendees are given the knowledge & tools to take charge of their listening skills & to improve the quality of their communication with other professionals. Ever have trouble getting the right message across to your co-workers or clients? This topic deals with the ways we communicate – accurately and inaccurately – and includes 2 interactive elements: table exercise about voice inflection called “Really? REALLY?!” & volunteer activity called the “Alien Press Conference” – a hilarious take on verbal & non-verbal cues. Other topics include: Challenges of Communicating; Listening to Understand, Not Respond; 7 Stages of Communication; Verbal vs Nonverbal Cues; Tone is Everything; 5 Ways to Change Your Listening Habits Now; and more. Attendees will learn: 
•	How to control their voice tone and inflection to improve their message delivery;
•	How to develop and improve their active listening skills;
•	How to use non-verbal cues to their advantage; more
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: June 09

Time: 2:45 PM - 3:45 PM

Room: 3045

Microsoft Cognitive services is a series of services based on Microsoft Research using Deep Learning techniques, ready for you to enrich your unstructured data. Microsoft Services includes: Vision (Computer Vision, Emotion, Face, Video), Speech/Language (Speaker Recognition, Spell, Sentiment, Language, Key Phrases, Topic detection, Linguistic Analysis), Knowledge, and Search. These services are consumed by using the Cognitive Services APIs. Power BI enables you to consume the APIs to enrich your unstructured data inside your Power BI solutions. During this session, we will cover how to consume the API using Power Query to then visualize the results with Power BI visuals. We will also consume the Cognitive services API by using a R script inside Power BI. This session is structured with a B2C Survey case study solution with a real time Dashboard using a streaming dataset.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Intermedia

Session Code:

Date: June 09

Time: 2:45 PM - 3:45 PM

Room: 3045

Joe takes you on an easy to understand journey of Blockchain technology. Blockchain is the basis of Cryptocurrencies such as Ethereum, Bitcoin etc., however, extends way beyond these as a framework for Smart Contracts.

To better understand developer Blockchain opportunities, Joe deploys an Ethereum simulated multi-member network in Azure, consisting of a set of load-balanced transaction nodes with which an application or user can interact to submit transactions and a set of mining nodes to record transactions.

Joe will also investigate new toolsets coming out to assist in Blockchain Development including CoCo Framework, App Builder and Enterprise Smart Contracts.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA Beginners

Level: Beginner

Session Code:

Date: June 09

Time: 11:00 AM - 12:00 PM

Room: 1048

There are many "social media outlets" but not all of them are "the right one" for you, especially if you don't have a brand. 
Building a brand has to be intentional. You cannot just be you. Discovering the things that make you unique is not enough. You have to package these things in a way that highlights and perhaps even over exaggerates them.
In this interactive session, you will learn how to use Social Media to create your personal brand to positioning yourself as a pro, telling the story in the way that the people want to hear at the same time that you increase your self-confidence.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 09

Time: 1:30 PM - 2:30 PM

Room: 3045

We all know how important tech is right now - but what happens when hiring managers don't know how to find the candidates they need, and they candidates don't know what the managers are truly looking for?

In this career panel we will dig into the manager / candidate gap that is prominent in the marketplace, and how to progress your career by being able to establish yourself as a leader in your field. Whether you are someone involved in the hiring process, or someone looking to move your career forward, this panel is for you!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: June 09

Time: 11:00 AM - 12:00 PM

Room: 3045

SQL Server reduces compilation and optimization overhead by caching and reusing execution plans for the queries. Plan caching helps to reduce CPU load on the server; however, it may also introduce unexpected issues and lead to suboptimal execution plans and performance problems.  

In this session, Dmitri will explain how plan caching works internally and demonstrate how to address several common issues related to the plan caching. He will talk about parameter sniffing, simple and forced parameterization, OPTIMIZE FOR UNKNOWN strategy, and several other related topics.    Finally, Dmitri will provide the guidelines how to reduce CPU load and recompilation overhead in the systems with heavy ad-hoc workload and non-parameterized queries.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA Advanced

Level: Intermedia

Session Code:

Date: June 09

Time: 9:45 AM - 10:45 AM

Room: 3046

Data Science techniques are becoming popular and because statistics usually teaches at the Math Department people think of it as an exact science but Statistic is the science of prediction and expectations. In the excitement of the possibilities that Big Data technology and Data Science techniques are opening, we are forgetting that correlation is not equal than causation and that any design model has intrinsic limitations. 
Dr. Deming said "In God we trust, all others must bring data." but what he really wanted to reach was Wisdom! Data is just the raw material the real goal is Wisdom I have been thinking about the chain toward Wisdom (Data-Information-Knowledge-Wisdom) and wonder how many organizations have reached, at least, the level of Knowledge and if any at all have reached the pinnacle of Wisdom. 
We are drowning in a sea of data and we are starving for wisdom.
How is Data Science and Big Data changing our profession? What is a Data Scientist? Which skills do we need?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: June 09

Time: 4:00 PM - 5:00 PM

Room: 3045

Continuation of previous year track from basic concepts of Conditional Probability & Regression to supervised and unsupervised machine learning techniques.

In this session, we will look at various supervised ML techniques including Decision Trees, Random Forest as well as unsupervised techniques such as Clustering. and Principle Component Analysis. 

The session includes theory around each of the technique as well as a demo using a sample data set.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Intermedia

Session Code:

Date: June 09

Time: 9:45 AM - 10:45 AM

Room: 3033

We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: June 09

Time: 2:45 PM - 3:45 PM

Room: 3047

Backups are a vital part of any DBA's job. Acting as the "last line of defense", we rely on backups to safeguard the company's most important asset: the data. But how do we know we're managing our backups appropriately? This session will cover the fundamental principles of building out our backup (and restore strategy), covering the "why" of backups and best practices for our data protection.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA Beginners

Level: Beginner

Session Code:

Date: June 09

Time: 12:30 PM - 1:30 PM

Room: 1048

Now IDEs on IntelliJ-platform are one of the most popular tools for developers. More than two million people use IntelliJ IDEA, PyCharm and other IDEs. At the same time, they use various SQL clients for writing and executing statements. But working with SQL is possible just from these IDEs. There is also a stand-alone IDE for SQL called DataGrip which was created based on a huge expertise in code-insight which JetBrains, IntelliJ creators, have. In this session, I will briefly show main tips and tricks of using database support inside IDE's based on IntelliJ platform. 

— Tips for writing and executing statements
— Editing data from UI
— Using code completion and code inspections
— Comparing result-sets
— Searching through database objects
— Navigating through data
— and other features.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DevOps

Level: Intermedia

Session Code:

Date: June 09

Time: 11:00 AM - 12:00 PM

Room: 1053

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:
DevOps

Level: Beginner

Session Code:

Date: June 09

Time: 12:30 PM - 1:30 PM

Room: 1053

When done right, data visualization informs users quickly and efficiently with a minimum of distraction.  When done wrong, we end up with spinning 3D pie charts.  In this talk, we will look at techniques for effective dashboard design, minimizing noise and clutter (like spinning 3D pie charts) while providing relevant information to the intended audience.  We will see how different types of charts work, build out rules of thumb around which charts to use, and integrate visuals to create a coherent dashboard image.  When it comes to dashboards, we will compare and contrast dashboards based on their intended uses, such as interactive dashboards versus TV dashboards.  Finally, we will take an awful dashboard and turn it into something which end users will appreciate.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: June 09

Time: 11:00 AM - 12:00 PM

Room: 3047

Contracting at the cutting edge of technology is exciting and produces great rates. But what happens when the contract ends and the mortgage payments must continue?

Maintaining a steady job with biweekly direct deposit salary is comforting. But do you ever feel technologically “stuck” at your job when so many other technology professionals are using the latest, most marketable technologies? 

In this highly interactive group session, you will learn multiple career strategies for maximizing both the Love and the Money of your multidimensional technology career.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Advanced

Session Code:

Date: June 09

Time: 12:30 PM - 1:30 PM

Room: 3045

Time and time again the same misunderstandings by developers and query writers appear when query performance issues arise. In this demo heavy presentation, we will review these specific topics such as data types, implicit conversions, sargability, and some others that all have an impact on query performance. Come join me and by the end of this session you will have the knowledge to boost your query performance!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DevOps

Level: Beginner

Session Code:

Date: June 09

Time: 11:00 AM - 12:00 PM

Room: 3044

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