Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 58
Docker and Kubernetes are becomes very hot industry since last couple of years.

SQL Server used to run only on Physical machine.
Now, it's not any more strange or wrong that SQL server run on VM.

This session is designed for understanding about container and how SQL server could run on container.

There are 2 types of applications, Stateless and Stateful.
We will go over the difference between them and will deliver the detail cases how SQL server could adjust in Container environment.

Therefore, developer or DBA could choose better architecture in various conditions.

Within this session will cover what the market demand is and what SQL server can do on the demand.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Private and Public Cloud Architecture and Infrastructure

Level: Beginner

Session Code:

Date: June 15

Time: 11:30 AM - 12:30 PM

Room: #235 - AWS

Azure Databricks is an Apache Spark-based analytics platform optimized for the Microsoft Azure cloud services platform. Designed with the founders of Apache Spark, Databricks is integrated with Azure to provide one-click setup, streamlined workflows, and an interactive workspace that enables collaboration between data scientists, data engineers, and business analysts. This session will cover the basics of Azure Databricks, how to start developing applications within Azure Databricks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration and Development

Level: Beginner

Session Code:

Date: June 15

Time: 11:30 AM - 12:30 PM

Room: #233 - CozyRoc

Forensic accountants and fraud examiners use a range of techniques to uncover fraudulent journal entries and illegal activities. As data professionals, most of us will never unravel a Bernie Madoff scheme, but we can apply these same techniques in our own environments to uncover dirty data. This session will use a combination of SQL Server and R to apply these fraud detection techniques, which include Benford's Law, outlier analysis, time series analysis, and cohort analysis.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Presentation, Visualization, and Analytics

Level: Beginner

Session Code:

Date: June 15

Time: 8:30 AM - 9:30 AM

Room: #249 - WhereScape (recorded)

So you have already decided to move to Azure but which platform is the best for your databases, from functionality perspective as well as price? In this presentation Michelle will present the advantages and disadvantages of each platform as well as how to choose the best one for your database(s).
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration and Development

Level: Intermedia

Session Code:

Date: June 15

Time: 4:00 PM - 5:00 PM

Room: #234 - Microsoft

In this session we will investigate what Big Data really means, and more importantly - what it doesn't mean. 
What makes Big Data different than any other data? 
What makes Big Data challenges different than the same old challenges we had 30 years ago? 

Together, we will perform an honest, inquisitive, and enlightening investigation of what Big Data really is, it's origins, and how it evolved over the last decade. 
We will use history, analytics and logic to dissect the beast, and expose it for what it really is. 

Why should you care? 
The Big Data hype is holding you back from doing what is really important with data - getting value out of it. Making sense of it. 
Vendors, organizations, and architects have become so obsessed with the 'Big Data' fad, and too many either lost sight, or no longer have the resources to pursue their real goals. 

In this session I will plea to your reasoning, critical thinking, and plain common sense, to wake up and shout with me "The Emperor has no clo
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Private and Public Cloud Architecture and Infrastructure

Level: Beginner

Session Code:

Date: June 15

Time: 8:30 AM - 9:30 AM

Room: #233 - CozyRoc

Overview of Columnstore indexes introduced in SQL Server 2012 and its evolution through each release. We will explore how data is organized differently in Columnstore and its impact on query performances. We would cover some of best practices when using this new technology and pitfalls to watch out for when designing your system.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration and Development

Level: Beginner

Session Code:

Date: June 15

Time: 4:00 PM - 5:00 PM

Room: #248 - DatAvail

Columnstore indexes are available to all SQL Server editions, Express to Enterprise, starting with SQL Server 2016 Service Pack 1. They can save disk space, increase query performance, and combine OLTP and OLAP workloads. Should you change all your tables to columnstores? Let's find out!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration and Development

Level: Intermedia

Session Code:

Date: June 15

Time: 4:00 PM - 5:00 PM

Room: #248 - DatAvail

Let's face it: Microsoft Data Platform is not just SQL Server anymore. Azure has added a dozen of other data related products to the menu. Being a cloud DBA means dealing with these new options when needed. 
In this session packed with demos you will see how to cross the bridge between SQL Server and Cosmos DB back and forth; how to related items from both sides and what is required to design a CosmosDB deployment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration and Development

Level: Intermedia

Session Code:

Date: June 15

Time: 11:30 AM - 12:30 PM

Room: #249 - WhereScape (recorded)

CozyRoc
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Presentation, Visualization, and Analytics

Level: Beginner

Session Code:

Date: June 15

Time: 1:00 PM - 2:00 PM

Room: #233 - CozyRoc

In today’s world reporting and analytics are no longer focused exclusively on internal data from transactional systems and the data warehouse. Mashups of data from corporate, partner, commercial and public sources are the new normal.
In this presentation we will review traditional strategies for data cleanup, explore Power BI Desktop features for data exploration and look at Power BI Desktop configuration tips. Building readable, reusable and shareable cleanup scripts in M using the Power Query Advanced Editor will also be covered.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Presentation, Visualization, and Analytics

Level: Beginner

Session Code:

Date: June 15

Time: 4:00 PM - 5:00 PM

Room: #249 - WhereScape (recorded)

We'll look at the new features that have rolled out in response to a major push at Microsoft to make Power BI reports more accessible. What some of the different areas of accessibility to think about, and some handy tools to help you make your reports more usable for everyone.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Presentation, Visualization, and Analytics

Level: Beginner

Session Code:

Date: June 15

Time: 10:00 AM - 11:00 AM

Room: #237 - SolidQ

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration and Development

Level: Advanced

Session Code:

Date: June 15

Time: 11:30 AM - 12:30 PM

Room: #248 - DatAvail

Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates provide by SSMS for views, stored procedures, functions.
Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code.
 - Source to Target mapping documents can be used to generate the code to effect the mapping.
 - Service Broker activation stored procedures have a clearly defined structure. They can be mass-produced.
 - Standard CRUD stored procedures can be stamped out cookie-cutter fashion.
 - Business rules can be encoded in data and the code to implement them manufactured.
Generated code has systematic errors. Fix the errors at the generator. All the code now works. If the code is so boring that a computer can produce it, why not spend your talent doing something interesting?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: June 15

Time: 1:00 PM - 2:00 PM

Room: #248 - DatAvail

Are you interested in data encryption?  Do you store sensitive data in SQL Server databases?  Does GDPR affect your company?  If you answered yes to any of these questions then this session is for you.  In this session we will introduce and implement 4 methods of encryption available in SQL Server --Backup encryption, Transparent Data Encryption, AlwaysEncrypted, and connection encryption.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration and Development

Level: Intermedia

Session Code:

Date: June 15

Time: 11:30 AM - 12:30 PM

Room: #242 - Attunix

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:
Database Administration and Development

Level: Beginner

Session Code:

Date: June 15

Time: 8:30 AM - 9:30 AM

Room: #242 - Attunix

For many organizations Active Directory is the heart of the Network.  In this session we'll cover how to query users from AD groups, query groups within a specific OU, and dynamically get users for all groups in a specific OU.  We'll also discuss some of the limitations of ADSI and how to work around it.  Finally, we'll use a little SQL and a dash of Powershell and push updates back into Active Directory.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration and Development

Level: Beginner

Session Code:

Date: June 15

Time: 11:30 AM - 12:30 PM

Room: #239 - MelissaData

Databricks Delta is a single data management tool that combines the scale of a data lake, the reliability and performance of a data warehouse, and the low latency of streaming in a single system for the first time. This session will go over the basics of what Databricks Delta is and how it can be used as part of your Data Platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Private and Public Cloud Architecture and Infrastructure

Level: Beginner

Session Code:

Date: June 15

Time: 10:00 AM - 11:00 AM

Room: #246 - VMware

My company uses a NoSQL style database engine. As such we have no access to standard database functions like relational queries. To get around this we built an ElasticSearch caching layer on top of our database to make complex queries, but we got so much more than just a caching layer by choosing ElasticSearch.

In this talk we will cover a variety of out of the box features you get with ElasticSearch, why ElasticSearch is so popular, and what it can do for your company, even if you don't have the type of database handicaps a noSQL install might create.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Private and Public Cloud Architecture and Infrastructure

Level: Beginner

Session Code:

Date: June 15

Time: 2:30 PM - 3:30 PM

Room: #235 - AWS

Many times we look at the success of others and think it is beyond us. In this session, 12 time Microsoft MVP and author of How to Be an MVP in Life, David Lundell, will share stories from fellow Microsoft MVPs, and some sports MVPs illustrating key attribute in professional and personal development relating to becoming a Microsoft MVP, and even more importantly becoming an MVP in Life.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development and Personal Branding

Level: Beginner

Session Code:

Date: June 15

Time: 2:30 PM - 3:30 PM

Room: #234 - Microsoft

We’ve all screwed something up, haven’t we? Assembling Ikea furniture, reverse parking…. presenting at a SQL Saturday. Ben was an early adopted of Power BI and thus had to learn a lot of things the hard way. In this presentation, Ben will run you through lessons learnt around the Data Gateway, BI prototyping, report development and deployment, customer engagement and more. Come along to this session to learn about some of the best and worst Power BI Practices.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Presentation, Visualization, and Analytics

Level: Intermedia

Session Code:

Date: June 15

Time: 1:00 PM - 2:00 PM

Room: #246 - VMware

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