sqlsathistory

Nr: 855

Back to Main list

SQLSaturday #855 - Albany 2019

Start Time (24h) Speaker Track Title
08:30:00 John Miner Data Science Extend Power BI with Python
08:30:00 Alex Grinberg Database Development Advanced T-SQL Development with latest features.
08:30:00 Mike Walsh Data Security 4 Threats to your SQL Servers - Become Default: Secure
08:30:00 Matt Cushing Professional/Personal Development Networking 101: Getting Ready for a SQL Event
08:30:00 Paul Stanton Database Development SQL DevOps Simplified with Production Databases
08:30:00 Andy Yun Database Development Let's Dive Into SQL Server I/O To Improve T-SQL Performance
08:30:00 Bryan Cafferky Data Science Azure Databricks = Azure + Spark + Machine Learning Collaboration
10:00:00 Alex Grinberg Database Administration XML and JSON, does the DBA need it?
10:00:00 Steve Simon Business Intelligence SQL Server Reporting Services 2017 on Steroids!!
10:00:00 Christian Cote Big Data Feeding the modern data warehouse (Power BI, Azure Data Factory and Databricks)
10:00:00 John Wells Database Development Fundamentals That Will Improve Your Query Performance!
10:00:00 Elizabeth Noble Database Development Overcoming Challenges with Source Control and Continuous Integration.
10:00:00 Deborah Melkin Data Architecture Design Looking "Normal" and Seeing "Stars": Table Designs Working Together
10:00:00 Bryan Cafferky Business Intelligence Python with SQL: A Winning Combination
12:30:00 Kevin Feasel Database Development Approaching Zero: Minimizing Downtime During Deployments
12:30:00 Thomas Grohser Professional/Personal Development Why candidates fail the job interview in the first minute
12:30:00 Taiob Ali Cloud Application Development Deployment Performance Optimization with Azure SQL Database
12:30:00 Kathi Kellenberger Data Science Azure Machine Learning 101
12:30:00 Michelle Gutzait Optimization/Tuning Top 10 FREE performance troubleshooting tools for SQL Server
12:30:00 Paresh Motiwala Database Administration Moving to SQL 2019- A primer for the unaware!
14:00:00 Greg Moore Database Development Pocket-sized Server: SQL Server for under $200!
14:00:00 Guy Glantser Database Development The Complete Guide to Temporary Tables and Table Variables
14:00:00 Rayis Imayev Business Intelligence Power BI with Maps: Choose Your Destination
14:00:00 Kathi Kellenberger Database Administration What is DevOps and Why Should DBAs Care?
14:00:00 Liz Amador Analytics and Visualization Designing Accessible Power BI Reports
14:00:00 Andy Levy Database Administration dbatools for the Uninitiated
14:00:00 Paresh Motiwala Lightning Talks Lightning Talks
15:30:00 Ray Kim Professional/Personal Development Blogging for Success: Advancing your career by blogging
15:30:00 John Miner Cloud Application Development Deployment Staging data for Azure SQL services
15:30:00 Sunil Kadimdiwan Business Intelligence Add Time Intelligence to Power BI
15:30:00 Mohamed Mawla Cloud Application Development Deployment From Zero to Hero: Start Machine Learning using Azure ML studio
15:30:00 Deji Akomolafe Cloud Application Development Deployment Successfully Virtualizing SQL Server on vSphere - Straight from the Source
15:30:00 Guy Glantser Panel Ask the Experts Panel

SessionID: 88921

Extend Power BI with Python

Back to calendar

Event Date: 20-07-2019 - Session time: 08:30:00 - Track: Data Science

Speaker: John Miner

Title: Extend Power BI with Python

Abstract:

Most developers use Power BI desktop to design the visuals and publish to the Azure service for production.

Out of the box, Power BI has 29 visuals. There are 208 custom visuals that can be down loaded from Appsource.Microsoft.com.

While there are many choices, the business problem might not have an out of the box visual that can be customized the way you want. How do you solve this problem?

This is where the custom scripting with Python visual comes in.

At the end of the presentation you will know which libraries that you can use to extend your toolbox for both on premise and the azure service.

SessionID: 89511

Advanced T-SQL Development with latest features.

Back to calendar

Event Date: 20-07-2019 - Session time: 08:30:00 - Track: Database Development

Speaker: Alex Grinberg

Title: Advanced T-SQL Development with latest features.

Abstract:

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

SessionID: 91731

4 Threats to your SQL Servers - Become Default: Secure

Back to calendar

Event Date: 20-07-2019 - Session time: 08:30:00 - Track: Data Security

Speaker: Mike Walsh

Title: 4 Threats to your SQL Servers - Become Default: Secure

Abstract:

In our connected world, the threat landscape is rapidly increasing. Phishing is leading to severe and crippling ransomware attacks. Malicious outsiders (and insiders) have cost much downtime. Not to mention the "traditional" threats such as "oops deletes" or site crashes. How do we protect against all of this? Is this even the DBA's role?

In this session, we'll explore 4 types of active threats to your data and organization. We'll talk about the various solutions available and help you see which threats you are vulnerable to if you've not gone far enough as we match threats and answers. Sadly, we'll share real stories of folks who've lost it all from these threats.

It's more than "take your backups, verify them, and periodically test them!" Ransomware and malicious outsiders (or insiders) eat your online backups for breakfast.

Leave prepared, not scared, as you adopt a "Default: Secure" posture and lead the charge, even if we are "only" DBAs.

SessionID: 91782

Networking 101: Getting Ready for a SQL Event

Back to calendar

Event Date: 20-07-2019 - Session time: 08:30:00 - Track: Professional/Personal Development

Speaker: Matt Cushing

Title: Networking 101: Getting Ready for a SQL Event

Abstract:

Looking to get the most out of your SQL Saturday, PASS Summit, or local user group meeting? Plan ahead! Events aren't just about learning new things, they're about meeting new people, networking with peers, and learning different approaches to common issues.

In this session, we'll go over steps you can take before, during and after the event to maximize the amount of great stuff you'll take away at the end (besides cool vendor swag). Not just keeping up on new technologies, but meeting new people, getting leads on solutions/opportunities, and an appreciation for the community you're in and what it has to offer.

SessionID: 91917

SQL DevOps Simplified with Production Databases

Back to calendar

Event Date: 20-07-2019 - Session time: 08:30:00 - Track: Database Development

Speaker: Paul Stanton

Title: SQL DevOps Simplified with Production Databases

Abstract:

DevOps is based on building an application binary (immutable artifact) that supports a highly reliable, repeatable engineering process. In the case of SQL Server, however, a database is already in production, and isn’t simply replaced (as an app binary), but is upgraded. Current SQL Server DevOps methods use source control to build a “development” database, with schema and objects and static data needed for functional testing. "Near production data" is used in Staging, and finally production is upgraded. This approach involves complexity, and breaks the principle of working with immutable artifacts throughout the process. Our session introduces a new approach to SQL Server DevOps, with production databases used in all stages. Production database clones are delivered more quickly than "built" databases, are more easily integrated with source control, and produces higher fidelity outcomes. Learn how leading enterprises are simplifying SQL DevOps.

SessionID: 93222

Let's Dive Into SQL Server I/O To Improve T-SQL Performance

Back to calendar

Event Date: 20-07-2019 - Session time: 08:30:00 - Track: Database Development

Speaker: Andy Yun

Title: Let's Dive Into SQL Server I/O To Improve T-SQL Performance

Abstract:

Do you understand how SQL Server handles I/O? If not, you should. Understanding I/O is more important than ever with increasing cloud adoption, due to cloud costing models. But even on-premises, I/O has a direct impact on T-SQL performance.

Join me for a deep dive into the storage engine to understand how SQL Server handles I/O. Concepts will be paired with T-SQL examples to illustrate the practical impacts.

When you leave, you'll be able to optimize your T-SQL reduce I/O and improve performance across the board.

SessionID: 93778

Azure Databricks = Azure + Spark + Machine Learning Collaboration

Back to calendar

Event Date: 20-07-2019 - Session time: 08:30:00 - Track: Data Science

Speaker: Bryan Cafferky

Title: Azure Databricks = Azure + Spark + Machine Learning Collaboration

Abstract:

Azure Databricks is the hottest new service being offered on Azure! Designed in collaboration with Microsoft and Databricks, the creators of Apache Spark, Azure Databricks combines the best of Databricks and Azure to help customers accelerate innovation with one-click set up, streamlined workflows and an interactive workspace that enables collaboration between data scientists, data engineers, and business analysts. Databricks was founded by the creators of the Spark big data platform to make creating creating and managing clusters a snap and provide a first class secure data science team collaboration environment. In this presentation, we'll explain key concepts and features while demonstrating this amazing service.

SessionID: 89231

XML and JSON, does the DBA need it?

Back to calendar

Event Date: 20-07-2019 - Session time: 10:00:00 - Track: Database Administration

Speaker: Alex Grinberg

Title: XML and JSON, does the DBA need it?

Abstract:

This session explains internal SQL Server XML processes and demonstrates how XML shredding could help to solve issues, speed up daily performance monitoring and detect problems. The difference between XML and JSON will be demonstrated, with an in-depth look at the SQL Server - JSON integration. During the session, the audience will be provided with plenty of code examples.

SessionID: 89759

SQL Server Reporting Services 2017 on Steroids!!

Back to calendar

Event Date: 20-07-2019 - Session time: 10:00:00 - Track: Business Intelligence

Speaker: Steve Simon

Title: SQL Server Reporting Services 2017 on Steroids!!

Abstract:

Reporting requests that are required ‘yesterday or sooner’, oft times necessitate working more efficiently and effectively. We have all been through this at one time or another.

In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.

SessionID: 91244

Feeding the modern data warehouse (Power BI, Azure Data Factory and Databricks)

Back to calendar

Event Date: 20-07-2019 - Session time: 10:00:00 - Track: Big Data

Speaker: Christian Cote

Title: Feeding the modern data warehouse (Power BI, Azure Data Factory and Databricks)

Abstract:

When it comes to feed the modern data warehouse in Azure, we're facing new challenges. This session will explain what id the modern data warehouse and how it can be fed using ETL 2.0 methodologies. Topics like Common Data Model and services will also be talked and demonstrated.

SessionID: 91258

Fundamentals That Will Improve Your Query Performance!

Back to calendar

Event Date: 20-07-2019 - Session time: 10:00:00 - Track: Database Development

Speaker: John Wells

Title: Fundamentals That Will Improve Your Query Performance!

Abstract:

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!

SessionID: 93039

Overcoming Challenges with Source Control and Continuous Integration.

Back to calendar

Event Date: 20-07-2019 - Session time: 10:00:00 - Track: Database Development

Speaker: Elizabeth Noble

Title: Overcoming Challenges with Source Control and Continuous Integration.

Abstract:

Have you tried implementing source control? How has your continuous integration (CI) process gone?

This session is for developers, database administrators, database engineers, and data architects that want to automate their database deployments. Particularly for those individuals that have hit roadblocks along that way. We will discuss the differences between migration and stated-based deployment methods. We will also discuss options with branching and merging.

At the end of the session, attendees will know how to select the best deployment method for their environment. In addition, attendees will be familiar with branching and merging strategies that can be used as part of their continuous integration strategy.

Attendees should be familiar with general concepts about source control and be comfortable with Visual Studio or VS Code.

SessionID: 93228

Looking "Normal" and Seeing "Stars": Table Designs Working Together

Back to calendar

Event Date: 20-07-2019 - Session time: 10:00:00 - Track: Data Architecture Design

Speaker: Deborah Melkin

Title: Looking "Normal" and Seeing "Stars": Table Designs Working Together

Abstract:

Most database professionals know there are two different database design patterns - normal forms for OLTP databases and star schemas for data warehouses. We tend to discuss these separately. But these two designs actually work together when we create our table schemas.

In this session, we will review the basics of both normal forms and star schemas. We'll compare and contrast the two designs. We will then discuss how a normalized database design influences a star schema design and vice versa.

By the end of the session, you will better understand how using the two designs together gives you a greater insight to how you use your data throughout its lifecycle.

SessionID: 93783

Python with SQL: A Winning Combination

Back to calendar

Event Date: 20-07-2019 - Session time: 10:00:00 - Track: Business Intelligence

Speaker: Bryan Cafferky

Title: Python with SQL: A Winning Combination

Abstract:

You want to learn Python but don't know where to start? You already know SQL, and data wrangling is one of the most critical use cases for Python. Why not start with that? Good news! Python provides many ways to use good old SQL as a first class query and data manipulation language. In this session, we'll show you how easy it is to use SQL with Python to query non relational and relational database data, to load data from SQL Server, and write it back. It's so easy, you'll feel like a Python pro before you know it!

SessionID: 89147

Approaching Zero: Minimizing Downtime During Deployments

Back to calendar

Event Date: 20-07-2019 - Session time: 12:30:00 - Track: Database Development

Speaker: Kevin Feasel

Title: Approaching Zero: Minimizing Downtime During Deployments

Abstract:

Negotiating a downtime for a release can be difficult in this modern, 24x7 world. When downtime means lost revenue, the price of taking a downtime to deploy code can run up quickly. This talk will show you a way to reduce the cost of deployment by reducing or even eliminating required downtime for database code deployment. We will show how to release new database code, update existing stored procedures, refactor and restructure tables, and even perform systemic re-architecture with no downtime and minimal blocking. We will use as a case study one release in which we modified the primary key column on 180 tables and updated over 550 stored procedures without end users noticing a thing. If you want to hit that three nines (or better) service-level agreement, this talk will help get you on the road to reduced downtime.

SessionID: 89314

Why candidates fail the job interview in the first minute

Back to calendar

Event Date: 20-07-2019 - Session time: 12:30:00 - Track: Professional/Personal Development

Speaker: Thomas Grohser

Title: Why candidates fail the job interview in the first minute

Abstract:

Thomas will share what he misses in resumes and how to respond to questions better.

SessionID: 91201

Performance Optimization with Azure SQL Database

Back to calendar

Event Date: 20-07-2019 - Session time: 12:30:00 - Track: Cloud Application Development Deployment

Speaker: Taiob Ali

Title: Performance Optimization with Azure SQL Database

Abstract:

The cloud is just using someone else's compute. You still need to care about and optimize for performance.  Just as a dropped call frustrates cellular customers, an app with data issues, high latency, connection timeouts will create the same frustration for users.  Do you want to catch the performance issues before your customers?  Do you want to automatically identify database issues and quickly drill down into details? Azure provides built in tools just to do that. 

In this session I will show you 4 of those tools.  You will learn how these tools can provide Performance overview of a database and recommendations that can improve workload performance.  Find top resource consuming queries, deeper insight into your databases resource (DTU) consumption and learn when to let Azure  automatically optimize your database.    At the end of this session you will walk out knowing how to identify and tune Azure SQL database performance  issues with built in tools in Azure Portal.

SessionID: 92038

Azure Machine Learning 101

Back to calendar

Event Date: 20-07-2019 - Session time: 12:30:00 - Track: Data Science

Speaker: Kathi Kellenberger

Title: Azure Machine Learning 101

Abstract:

There are several ways to create a machine learning model. You can use R or Python or even other languages such as C#. Advanced coding skills are required no matter which language you choose. Once the solution is created, it’s often difficult to deploy.

Microsoft addresses those problems with Azure Machine Learning, or Azure ML. Azure ML has built-in transforms for cleansing and munging data. It also contains a variety of configurable machine learning models that can be used without coding. Deploying the model is easy, and users can link to it directly with Excel or a custom application can be written.

If you are experienced in machine learning but haven’t seen Azure ML or if you are curious about machine learning and data science, this session is for you.

SessionID: 93519

Top 10 FREE performance troubleshooting tools for SQL Server

Back to calendar

Event Date: 20-07-2019 - Session time: 12:30:00 - Track: Optimization/Tuning

Speaker: Michelle Gutzait

Title: Top 10 FREE performance troubleshooting tools for SQL Server

Abstract:

Many DBAs and IT professionals are not aware of the greatness and strength of some of the FREE performance tools that are out there! Those tools, used individually or combined, can help us improve performance significantly by assisting in identifying bottlenecks. In this session I will discuss the top 10 FREE Performance Troubleshooting tools for Windows and SQL Server and will show how to use them, also providing real-world examples.

SessionID: 94612

Moving to SQL 2019- A primer for the unaware!

Back to calendar

Event Date: 20-07-2019 - Session time: 12:30:00 - Track: Database Administration

Speaker: Paresh Motiwala

Title: Moving to SQL 2019- A primer for the unaware!

Abstract:

SQL 2019 is here to stay. Do you know how to move to SQL 2019? In this riveting session we will learn about

  1. New Features of SQL 2019
  2. Why you need to migrate?
  3. How to upgrade/move to SQL 2019
  4. Certifying your application for SQL 2019- A tricky question and discussion
  5. Compatibility level and things you normally wouldn't care for!
  6. Changes in functionality and caveats
  7. The holy trinity: "Database Migration Guide", "Database Experimentation Assistant" and "Query Tuning Assistant"; tools that make your life easy.
  8. A direct look into the "MAP Toolkit" Time permitting we will demo these.

SessionID: 88634

Pocket-sized Server: SQL Server for under $200!

Back to calendar

Event Date: 20-07-2019 - Session time: 14:00:00 - Track: Database Development

Speaker: Greg Moore

Title: Pocket-sized Server: SQL Server for under $200!

Abstract:

With a growing focus on large data solutions that span terabytes and use dozens of CPUs and vast amounts of memory, sometimes the smaller solutions are overlooked, especially when considering the Internet of Things where often you may want data collection close to the data you're collecting.

At the other end of the spectrum there's an amazing amount of power available in very small form-factors. This session will explore what can be done with cheap off the shelf "computers on a board" form factors and Linux to build cheap and easy to deploy small SQL solutions that can be useful for a variety of data collection activities.

SessionID: 88675

The Complete Guide to Temporary Tables and Table Variables

Back to calendar

Event Date: 20-07-2019 - Session time: 14:00:00 - Track: Database Development

Speaker: Guy Glantser

Title: The Complete Guide to Temporary Tables and Table Variables

Abstract:

It is very common to use temporary data structures in the database. In SQL Server, we can choose between temporary tables (#MyTable) and table variables (@MyTable). There are many differences between these two structures, some are obvious and well known, and some might surprise you.

The main difference in terms of performance is statistics, which exist for a temporary table, but do not exist for a table variable. For that reason, there can be a huge difference in performance of a stored procedure that uses one data structure or the other. In this session, we will demonstrate the differences and analyze performance for various use cases. We will cover all kinds of ways to work with these data structures, such as OPTION (RECOMPILE) and trace flag 2453. By the end of this session you will know exactly when and how to use each one in order to achieve the desired functionality with the best performance. This is a must session for every SQL Server developer.

SessionID: 89834

Power BI with Maps: Choose Your Destination

Back to calendar

Event Date: 20-07-2019 - Session time: 14:00:00 - Track: Business Intelligence

Speaker: Rayis Imayev

Title: Power BI with Maps: Choose Your Destination

Abstract:

A childhood dream to travel around the world fueled by reading Gulliver's Travels stories and Robinson Crusoe attempts to survive on a deserted island. Those books were filled with geographical description and map locations. I think I always loved working with maps and I still do! There is something that could captivate your mind and propel your imagination for traveling when you immerse yourself in maps.

Power BI itself a great tool that could feed your appetite for an adventure using built-in and custom map visualizations. Let's explore them!

SessionID: 92040

What is DevOps and Why Should DBAs Care?

Back to calendar

Event Date: 20-07-2019 - Session time: 14:00:00 - Track: Database Administration

Speaker: Kathi Kellenberger

Title: What is DevOps and Why Should DBAs Care?

Abstract:

You may have heard the term “DevOps” a lot lately, but is this just one of those buzzwords that gets thrown around and means something different depending on who’s talking? While traditional software methodologies pit developers and operations folks like DBAs against each other, DevOps requires that they work together for a common goal. And, ultimately, shouldn’t the software project’s success be everyone’s goal?

Attend this session to learn how DevOps is changing the DBAs world for the better.

SessionID: 93138

Designing Accessible Power BI Reports

Back to calendar

Event Date: 20-07-2019 - Session time: 14:00:00 - Track: Analytics and Visualization

Speaker: Liz Amador

Title: Designing Accessible Power BI Reports

Abstract:

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.

SessionID: 94679

dbatools for the Uninitiated

Back to calendar

Event Date: 20-07-2019 - Session time: 14:00:00 - Track: Database Administration

Speaker: Andy Levy

Title: dbatools for the Uninitiated

Abstract:

You’ve just inherited a large SQL Server estate, and next month’s merger will double the number of instances you’re responsible for. Or maybe you have one big instance with thousands of databases on it. Are there backups? Are they good? Are your systems in good health?

The department just decided to reorganize and consolidate databases to prepare for an upgrade to the next release of SQL Server. How are you going to manage all this?

It's time to automate with the dbatools Powershell module. We’ll briefly talk about the project itself, then take a tour of functions commonly used to manage SQL Server environments and data. When you leave, you’ll be ready to level up your administration toolkit and start reducing your daily workload.

SessionID: 95321

Lightning Talks

Back to calendar

Event Date: 20-07-2019 - Session time: 14:00:00 - Track: Lightning Talks

Speaker: Paresh Motiwala

Title: Lightning Talks

Abstract:

Seven fast-paced 10-minutes-or-less sessions on a variety of topics:

Paresh Motiwala: Use of three free MS tools for DB migration Taiob Ali: Extended Events - How to collect the first 10 or every 4th event Andy Yun: SQL Server Performance Troubleshooting: Bottom to Top... or Top to Bottom? Ray Kim: Business Cards: The most important networking tool! Michelle Guzait: How to be a rockstar resolving almost any SQL Server emergency issue. Deborah Melkin: The Solution Isn't the Problem Bryan Cafferky: Azure Machine Learning service and why the s is lower case

SessionID: 88741

Blogging for Success: Advancing your career by blogging

Back to calendar

Event Date: 20-07-2019 - Session time: 15:30:00 - Track: Professional/Personal Development

Speaker: Ray Kim

Title: Blogging for Success: Advancing your career by blogging

Abstract:

Ever wanted to start a 'blog, but have no idea how to do it? It's easier than you think! A number of people have become successful by writing 'blog articles. I originally started my 'blog to supplement my presentations. Since then, it's taken on a life of its own.

In this presentation, I'll tell you how I got started with 'blogging, where it's taken me since then, and lessons I've learned along the way. We'll discuss 'blog platforms, how to get started, what to write about, and what to do (and what NOT to do) when writing articles.

SessionID: 88920

Staging data for Azure SQL services

Back to calendar

Event Date: 20-07-2019 - Session time: 15:30:00 - Track: Cloud Application Development Deployment

Speaker: John Miner

Title: Staging data for Azure SQL services

Abstract:

Most companies are faced with the ever-growing big data problem. There have been two schools of thought on how to solve this problem.

Schema on write is represented by the traditional relational database table. Only a small portion of the total data owned by the company resides in the database.

Schema on read is represented by technologies such as Hadoop or PolyBase. All data owned by the company can reside in simple storage.

Today, we will learn how to stage data using Azure blob storage which can be ingested by both techniques.

1 – Grab some big data. 2 – Create blob storage account. 3 – Copy data to container. 4 – Azure SQL database plumbing. 5 – Loading data with BULK INSERT. 6 – Azure SQL data warehouse plumbing. 7 – Loading data with POLYBASE. 8 – Azure automation with RUNBOOKS.

SessionID: 93551

Add Time Intelligence to Power BI

Back to calendar

Event Date: 20-07-2019 - Session time: 15:30:00 - Track: Business Intelligence

Speaker: Sunil Kadimdiwan

Title: Add Time Intelligence to Power BI

Abstract:

When is Time Period based calculations useful in Power BI? Quick answer - ALWAYS! Business users need to know measures such as: What was Sales, what was the change compared to last-year, year-to-date? Did our Expenses go down, compared to similar period last year? etc.

In this session you will learn how to use and apply DAX functions in Power BI, to develop Time and Date based dimensions and measures that will help answer such questions.

SessionID: 93603

From Zero to Hero: Start Machine Learning using Azure ML studio

Back to calendar

Event Date: 20-07-2019 - Session time: 15:30:00 - Track: Cloud Application Development Deployment

Speaker: Mohamed Mawla

Title: From Zero to Hero: Start Machine Learning using Azure ML studio

Abstract:

The session aim is to get people excited and curious more about ML without digging in coding or deep concepts.

We will explore ML Azure offering, Some ML concepts, ML Studio, create an experiment from Scratch and show how ML can target common business challenges like demand projection or price targeting

Lots of hands-on

SessionID: 94171

Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Back to calendar

Event Date: 20-07-2019 - Session time: 15:30:00 - Track: Cloud Application Development Deployment

Speaker: Deji Akomolafe

Title: Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Abstract:

Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. quot;Virtualize Firstquot; is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too quot;criticalquot; to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments. Got an SQL virtualization or performance question? Bring i

SessionID: 95053

Ask the Experts Panel

Back to calendar

Event Date: 20-07-2019 - Session time: 15:30:00 - Track: Panel

Speaker: Guy Glantser

Title: Ask the Experts Panel

Abstract:

This is an open session where you may show up any time and ask any technical or professional questions of our panel of speakers.

Ask the Experts is an opportunity to find answers and resources to address ongoing challenges, learn more about our speakers, and maybe stump them : )