Build Schedule

Advanced Filters:
  • Track

    clear all













  • Speaker


  • Level


  • Session Type



Sessions Found: 37
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: 2072

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure Cloud

Level: Beginner

Session Code:

Date: June 09

Time: 9:45 AM - 10:45 AM

Room: 2064

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

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:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DevOps

Level: Beginner

Session Code:

Date: June 09

Time: 2:45 PM - 3:45 PM

Room: 2073

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

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

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

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

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

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

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

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:

Accompanying Materials:

No material found.

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

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:

No material found.

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

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

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DevOps

Level: Beginner

Session Code:

Date: June 09

Time: 11:00 AM - 12:00 PM

Room: 2073

Azure SQL Database offers a way to quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore.
In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible.
By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: June 09

Time: 1:30 PM - 2:30 PM

Room: 2064

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 these 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.

Lastly, I will have a quick raffle at the end of this session. (2x Amazon Gift Cards - $50 value each) – Must attend and submit an evaluation (https://goo.gl/2ywtMi).
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA Advanced

Level: Advanced

Session Code:

Date: June 09

Time: 1:30 PM - 2:30 PM

Room: 2066

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DevOps

Level: Intermedia

Session Code:

Date: June 09

Time: 9:45 AM - 10:45 AM

Room: 2073

We SQL developers have spent years honing our "back-pocket" code snippets of string manipulation tricks, date arithmetic, JSON cracking, delimited string creation and parsing, and so on to handle a variety of requirements in our queries, procedures and functions. Meanwhile, each new release of SQL Server adds a few new built-in functions and system views that can be so easy to miss while we're in the middle of testing and implementing the SQL version upgrade itself. Suddenly our trusty old methods aren't clever, they're obsolete! Swing by this rapid-fire demo of some of the newest Transact SQL functionality today, pick up a tip or two, and look smart around your colleagues on Monday.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lightning Talk (15 minutes)

Track:
DevOps

Level: Intermedia

Session Code:

Date: June 09

Time: 4:00 PM - 4:15 PM

Room: 2073

What is the Optimizer, what does it have to do with Statistics?? Database Engines rely on an algorithm to determine the best way to access data.   The power to influence how the data is accessed to achieve the best SQL performance possible is in your hands!!  Focusing on the Optimizer and Statistics, many techniques and tools are available to assist report writers, developers and DBA's in achieving the optimal paths to the data.  I will give you the education you need to consider the options, and a portal into how the optimizer works to help your code work with the optimizer to achieve the better performance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA Beginners

Level: Beginner

Session Code:

Date: June 09

Time: 1:30 PM - 2:30 PM

Room: 2065

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