Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 66
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:

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: AWS - #235

A dive into the basics and some advanced dimensional modeling concepts and design patterns. Topics covered will be introduction to dimensional modeling and difference from transaction vs analytics consumptions, primary and foreign keys, different types of facts and dimensions, slowly changing dimensions and various types, common design patterns for handling date, time, product, inventory etc.
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: 1:00 PM - 2:00 PM

Room: Attunix - #242

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: CozyRoc - #233

The best way to deal with the elephant that takes up residence in every business is to name it and tame it! Bad data is bad for business – costing you 10-25% of revenue, along with poor analytics and unhappy customers.  
Join our lunch presentation to learn how to effectively address your elephant. We’ll discuss:
•	6 dimensions of Data Quality 
•	Easy tools that can be applied in-line using SSIS & SQL Server
•	How to overcome international data challenges – language, formatting & field requirements
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: MelissaData - #239

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:

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: WhereScape - #249

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:

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: Microsoft - #234

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: CozyRoc - #233

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:

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: DatAvail - #248

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:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration and Development

Level: Intermedia

Session Code:

Date: June 15

Time: 1:00 PM - 2:00 PM

Room: SolidQ - #237

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: WhereScape - #249

Not long ago, being a Microsoft DBA meant be specialized in Microsoft SQL Server and all the whistles and bells shipped together in the same box. That was the on-prem age.

Now in the cloud computing age, all cloud providers support multiple database engines in order to welcome all applications to their infrastructure. SQL Server is not always the way to go for an application.

In this session full of demos, we will discuss what it takes to be an all-rounded Azure cloud DBA, best applicable scenarios, price budgeting and tuning.
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: #246 - VMware

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: SolidQ - #237

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: DatAvail - #248

One of the most pervasive problems in BI today is that data warehouses take too long to build and they are too hard to change. According to TDWI, building a data warehouse is among the most labor-intensive and time-consuming activities of BI development. There are so many moving parts—requirements, source data analysis, data quality, source-target mapping, data acquisition, data transformation logic, ETL design, scheduling, error handling—and getting it right the first time isn’t easy. And when you finally do get it right, something changes...

Join data warehouse automation pioneer WhereScape for this presentation to learn how companies like Nike, Costco, Cornell University, WSU, Daimler, Blue Cross, F5 accelerate warehouse development and change cycles while simultaneously assuring quality and consistency. A key aspect of doing automation right is that it should not get in the way of your developers – it should leverage existing skills, add best practices and generate documentation.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: June 15

Time: 1:00 PM - 2:00 PM

Room: WhereScape - #249

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

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. In contrast, COZYROC's Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated into the SSIS package at runtime without the need to change and redeploy the package. Columns and fields are mapped automatically at runtime. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Speaker:

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

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. In contrast, COZYROC's Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated into the SSIS package at runtime without the need to change and redeploy the package. Columns and fields are mapped automatically at runtime. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
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: CozyRoc - #233

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:

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: AWS - #235

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: Attunix - #242

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