sqlsathistory

Nr: 701

Back to Main list

SQLSaturday #701 - Cincinnati 2018

Start Time (24h) Speaker Track Title
08:15:00 Shannon Lowder BI Platform Architecture, Development Administration Build Your Extract Packages Automatically!
08:15:00 Kevin Feasel Application Database Development Data Cleansing With SQL And R
08:15:00 Hasan Savran Strategy and Architecture What's new in SQL Server 2017
08:15:00 Rie Irish Strategy and Architecture How to Build Your Disaster Recovery Plan
08:15:00 Amy Herold Enterprise Database Administration Deployment Making the Leap from Developer to DBA
09:30:00 Drew Furgiuele Enterprise Database Administration Deployment SQL Server Transactional Replication: A Deeper Dive
09:30:00 Rick Lowe Enterprise Database Administration Deployment Why should I care about ... the plan cache?
09:30:00 David Mellinger BI Platform Architecture, Development Administration SQL Server 2017 New BI Features
09:30:00 Kevin Hill Enterprise Database Administration Deployment SQL Server Security model, in plain English
09:30:00 Britton Gray Analytics and Visualization True Lies: How to create credible fake data
09:30:00 Kevin Goff Application Database Development Implementing Data Warehouse Patterns with the Microsoft BI Tools
10:45:00 Matt Gordon Enterprise Database Administration Deployment How to Keep Your Database Servers Out of the News
10:45:00 Dave Mattingly Advanced Analysis Techniques Word Up: Text Mining in SQL
10:45:00 Pinal Dave Application Database Development Secrets of SQL Server - Database Worst Practices
10:45:00 Peter Shore BI Platform Architecture, Development Administration Analysis Services for the Absolute Beginner
10:45:00 Rie Irish Strategy and Architecture Let Her Finish: Supporting Women's Voices in Technology
10:45:00 Chris Hyde Advanced Analysis Techniques Python in SQL Server 2017
12:00:00 Jim Miller BI Platform Architecture, Development Administration Populating a Data Warehouse with SSIS and Biml Patterns
12:00:00 Vladimir Oselsky Application Database Development Crash Course on Better SQL Development
12:00:00 Maurice Hughes Enterprise Database Administration Deployment #GetModern With Dell EMC
13:15:00 John Deardurff Strategy and Architecture How to get Microsoft Certified
13:15:00 Sayed Saeed BI Platform Architecture, Development Administration The Business Intelligence Side of SQL Server
13:15:00 Drew Furgiuele Enterprise Database Administration Deployment SQL Server and PowerShell: Let's Get Serious
13:15:00 Julie McLain-Harper Application Database Development Improve Your Knowledge of the Optimizer and Statistics!
13:15:00 Kevin Goff Application Database Development SSRS for Developers - attendees choose topics
13:15:00 Josh Burgin Advanced Analysis Techniques Real-time Smart Home Analytics
14:30:00 Ryan Wade Analytics and Visualization R-ternatives in Power BI
14:30:00 Kellyn Pot'Vin-Gorman Enterprise Database Administration Deployment DevOps for the DBA
14:30:00 Slava Trofimov Advanced Analysis Techniques Stream Analytics for a SQL Developer
14:30:00 Warren Sifre Advanced Analysis Techniques Introduction to Azure Machine Learning
14:30:00 Allen White Enterprise Database Administration Deployment Maintain SQL Server Performance Baseline with PowerShell
14:30:00 Shannon Lowder Advanced Analysis Techniques Alexa – Skills Development, Data, and Continuous Improvement
15:45:00 Pinal Dave Application Database Development Performance in 60 Seconds – SQL Tricks Everybody MUST Know
15:45:00 David Patrick Analytics and Visualization Microsoft and Big Data - An Overview of the Power Tools and more!
15:45:00 Eugene Meidinger BI Platform Architecture, Development Administration An (Advanced) Introduction to Dax
15:45:00 John Deardurff Cloud Application Development Deployment Cloudy with a Chance of Data
15:45:00 Deji Akomolafe Strategy and Architecture Successfully Virtualizing SQL Server on vSphere - Straight from the Source

SessionID: 69631

Build Your Extract Packages Automatically!

Back to calendar

Event Date: 17-03-2018 - Session time: 08:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Shannon Lowder

Title: Build Your Extract Packages Automatically!

Abstract:

Automating extract packages is trivial., you simply use INFORMATION_SCHEMA. The problem is not all your data sources have easy to read metadata like SQL Server. How do you create usable metadata from these sources? In this hour, I’ll show you how easy it is to make an educated guess on the schema of flat files and other “semi-structured” data sources.

With that schema, automatically generating your extract package is a matter of seconds! Join me while I share my interrogator project with you and start saving hours at work today!

SessionID: 69770

Data Cleansing With SQL And R

Back to calendar

Event Date: 17-03-2018 - Session time: 08:15:00 - Track: Application Database Development

Speaker: Kevin Feasel

Title: Data Cleansing With SQL And R

Abstract:

On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set.

SessionID: 72773

What's new in SQL Server 2017

Back to calendar

Event Date: 17-03-2018 - Session time: 08:15:00 - Track: Strategy and Architecture

Speaker: Hasan Savran

Title: What's new in SQL Server 2017

Abstract:

SQL Server 2017 has great new additions and features for everybody. If you are a developer, you want to learn about new Graph tables, new M.O.T enhancements, and new functions. If you are a BI developer, you want to learn about how to run R and Python in SQL Server. If you are a DBA, you might want to learn about new features like Resumable Online Indexes, Automatic Query Optimization and how to monitor R and Python scripts. This session will have overall information about new features of SQL Server 2017

SessionID: 73133

How to Build Your Disaster Recovery Plan

Back to calendar

Event Date: 17-03-2018 - Session time: 08:15:00 - Track: Strategy and Architecture

Speaker: Rie Irish

Title: How to Build Your Disaster Recovery Plan

Abstract:

So your boss asked for a copy of your DR plan. Once you've wiped that deer-in-the-headlights look off your face, you realize "We've got database backups," isn't exactly a plan. You need to come up with a plan to recover your business when disaster strikes. This session will help you build this plan by defining what a disaster could be, documenting the business impact, and identifying your limitations. We will show how to use this information to establish metrics (such as RTO and RPO), document current recovery configurations, and design an effective recovery strategy that meets the needs and budget of your business. Attending this session will give you the knowledge and tools to create an effective disaster recovery plan that will make your boss happy and ensure the continuity of your business.

SessionID: 73178

Making the Leap from Developer to DBA

Back to calendar

Event Date: 17-03-2018 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: Making the Leap from Developer to DBA

Abstract:

You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.

SessionID: 69866

SQL Server Transactional Replication: A Deeper Dive

Back to calendar

Event Date: 17-03-2018 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Drew Furgiuele

Title: SQL Server Transactional Replication: A Deeper Dive

Abstract:

Transactional replication in SQL Server is not a new, shiny technology. In fact, a lot of people will tell you it's an old one full of nightmares. But don't be too quick to judge; replication still offers a lot of benefits, and most of the problems you might encounter can be quickly diagnosed and fixed if you have a deeper understanding of replication internals.

In this session, we'll discuss the transactional replication model and what it offers. You'll see plenty of examples of how to monitor transactions as they get from your publishers to your subscribers. There will also be examples of how you can change the behavior of your transactions too, and what benefits (and potential pitfalls) these changes offer.

Finally, you'll see examples on how to configure transactional replication in high availability scenarios.

SessionID: 70782

Why should I care about ... the plan cache?

Back to calendar

Event Date: 17-03-2018 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Rick Lowe

Title: Why should I care about ... the plan cache?

Abstract:

SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this installment of Rick's "Why should I care" series, he lays out a case for why working knowledge of the plan cache is critical for performance tuning efforts in real world environments. A review of relevant views and functions is included for the (newly?) motivated audience.

Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs drink in the morning (allegedly). This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.

SessionID: 71006

SQL Server 2017 New BI Features

Back to calendar

Event Date: 17-03-2018 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: David Mellinger

Title: SQL Server 2017 New BI Features

Abstract:

While SQL Server on Linux is getting the major marketing push for 2017, there are plenty of other new features which will also be included in SQL Server 2017. This session will provide an overview and some demos on new features in SQL Server BI tools. This will include changes to SSAS, SSIS, SSRS (Power BI Report Server), and Machine Learning Services (formerly R Services).

SessionID: 71369

SQL Server Security model, in plain English

Back to calendar

Event Date: 17-03-2018 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Hill

Title: SQL Server Security model, in plain English

Abstract:

What is the difference between a Login and a User? What is a schema? Why can I view one table but not another?

If the security portion of SQL Server is confusing to you, you are not alone. Join me for a short overview of the SQL Server security model, using non-technical terms. We will look at it from the point of view of something we are all familiar with, so that you will remember it 6 months or a year or more down the road.

This will be a highly interactive session, designed for you to be able to absorb the info without having to take notes. Bring coffee and learn!

SessionID: 72131

True Lies: How to create credible fake data

Back to calendar

Event Date: 17-03-2018 - Session time: 09:30:00 - Track: Analytics and Visualization

Speaker: Britton Gray

Title: True Lies: How to create credible fake data

Abstract:

It's data science in reverse! Do you ever need a good large demonstration or benchmarking data set that isn’t off-limits? After looking, I couldn’t find any good large data sets out there. So, I decided to make my own. In this session, we will go through the process of creating believable dummy data that provides (fake) insight with real-world variability. We’ll discuss where to find base information, how to make use of robust randomization, and some geographic coding concepts.

SessionID: 72615

Implementing Data Warehouse Patterns with the Microsoft BI Tools

Back to calendar

Event Date: 17-03-2018 - Session time: 09:30:00 - Track: Application Database Development

Speaker: Kevin Goff

Title: Implementing Data Warehouse Patterns with the Microsoft BI Tools

Abstract:

You’ve read some of the content of well-known Data Warehousing books – now what? How do you take the structures and disciplines inside such books as the Ralph Kimball series and implement them? This session will take several of the key concepts in Data Warehousing and demonstrate some implementations using SQL Server Integration Services and Analysis Services. We’ll look at items such as Type 2 Changing Dimensions, Confirmed Dimensions, Dimension Outriggers, Role-Playing Relationships, Many-to-Many Bridge table relationships, Factless Fact tables, Handling of NULL foreign key values, and more.

SessionID: 69594

How to Keep Your Database Servers Out of the News

Back to calendar

Event Date: 17-03-2018 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Gordon

Title: How to Keep Your Database Servers Out of the News

Abstract:

Every few months the headlines are filled with news of yet another system outage inconveniencing customers and users. As data platform professionals, the systems and servers for which we are responsible generally form the foundation of our companies’ customer-facing applications. In this fast-paced session, we’ll discuss the differences between high availability and disaster recovery as well as the tools and technologies Microsoft provides us within SQL Server to keep our databases up, our users happy, and our DBAs well rested.

SessionID: 69704

Word Up: Text Mining in SQL

Back to calendar

Event Date: 17-03-2018 - Session time: 10:45:00 - Track: Advanced Analysis Techniques

Speaker: Dave Mattingly

Title: Word Up: Text Mining in SQL

Abstract:

Would a database by any other name smell as sweet?

Our databases are filled with words. By mining our text for patterns and meanings, we can extract the emotional content, track changes over time, ferret out plagiarism, find common phrases and usage, and even predict future text.

Learn how to dig through your library of language to make your data better.

SessionID: 71291

Secrets of SQL Server - Database Worst Practices

Back to calendar

Event Date: 17-03-2018 - Session time: 10:45:00 - Track: Application Database Development

Speaker: Pinal Dave

Title: Secrets of SQL Server - Database Worst Practices

Abstract:

“Oh! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. In this session we will focus on some of the common errors and their resolution. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

SessionID: 71429

Analysis Services for the Absolute Beginner

Back to calendar

Event Date: 17-03-2018 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Peter Shore

Title: Analysis Services for the Absolute Beginner

Abstract:

Publications across the globe have called “data the new oil.” However, the value of oil is what the oil can be turned into. Similarly, the value in data is in what you derive from it, not the data itself.

Regardless of the title you carry, DBA, developer, report writer, ETL developer, manager etc., now is the time to make an acquaintance of Analysis Services. Come, join in as we define basic terms, investigate a few uses cases and see some simple examples. You will soon see that if data is the new oil, Analysis Services, on-premises or in the cloud, is a key component in the new refinery.

SessionID: 73140

Let Her Finish: Supporting Women's Voices in Technology

Back to calendar

Event Date: 17-03-2018 - Session time: 10:45:00 - Track: Strategy and Architecture

Speaker: Rie Irish

Title: Let Her Finish: Supporting Women's Voices in Technology

Abstract:

Next time you attend a meeting, watch what happens when women at the table offer ideas. If your office is like most in America, you’ll notice women are interrupted almost three times as often as men. Some interruptions are to assert dominance but sometimes people do it to be helpful offer affirmation. Regardless of the intent, the results are the same. Women are being left out of the conversation. The consequences are real. Male executives that speak more frequently in meetings are rewarded with 10% higher competence ratings from peers better performance reviews from bosses. This translates into $ when raises and bonuses are handed out.

This discussion will cover positive solutions that help women’s voices be heard. Women need to be more assertive. We need to learn to say “Stop interrupting me.” and “I just said that.” However, men can be, no HAVE to be, part of the solution. They can help women become part of the conversation.

SessionID: 73168

Python in SQL Server 2017

Back to calendar

Event Date: 17-03-2018 - Session time: 10:45:00 - Track: Advanced Analysis Techniques

Speaker: Chris Hyde

Title: Python in SQL Server 2017

Abstract:

SQL Server 2017 has finally arrived, bringing with it a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!

In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!

SessionID: 69989

Populating a Data Warehouse with SSIS and Biml Patterns

Back to calendar

Event Date: 17-03-2018 - Session time: 12:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jim Miller

Title: Populating a Data Warehouse with SSIS and Biml Patterns

Abstract:

This session will demonstrate how to leverage Biml Patterns, along with SQL Server Metadata, to rapidly build SSIS packages. The focus of this session will be on populating a data warehouse, however the concepts presented could be applied to most any ETL/ETL scenarios.

The components used during this session:

Attend to see how Biml can revolutionize your SSIS development!

SessionID: 72093

Crash Course on Better SQL Development

Back to calendar

Event Date: 17-03-2018 - Session time: 12:00:00 - Track: Application Database Development

Speaker: Vladimir Oselsky

Title: Crash Course on Better SQL Development

Abstract:

SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.

SessionID: 77769

#GetModern With Dell EMC

Back to calendar

Event Date: 17-03-2018 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Maurice Hughes

Title: #GetModern With Dell EMC

Abstract:

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.

SessionID: 69608

How to get Microsoft Certified

Back to calendar

Event Date: 17-03-2018 - Session time: 13:15:00 - Track: Strategy and Architecture

Speaker: John Deardurff

Title: How to get Microsoft Certified

Abstract:

Microsoft has recently streamlined the certification process and this session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for success.

SessionID: 69615

The Business Intelligence Side of SQL Server

Back to calendar

Event Date: 17-03-2018 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sayed Saeed

Title: The Business Intelligence Side of SQL Server

Abstract:

This session focuses on Microsoft’s BI capabilities within SQL Server and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. Through several releases, Microsoft dramatically enhanced the Microsoft BI platform. During this session Plus Consulting, one of Microsoft's top global BI partners, value from your BI platform. We’ll show you why the combination of Microsoft Office, PowerBI and SQL Server are an excellent solution for creating self-service dashboards, scorecards, KPIs, pivots, data exploration and discovery.will explore the improvements to SQL Server self-service reporting and talk about creating blended

SessionID: 69865

SQL Server and PowerShell: Let's Get Serious

Back to calendar

Event Date: 17-03-2018 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Drew Furgiuele

Title: SQL Server and PowerShell: Let's Get Serious

Abstract:

Whether you’ve dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell isn’t going away. It is definitely something worth learning to make your life as a SQL Server professional easier, and allow you to advance in your career as a DBA.

In this session, you’ll see practical, real-world examples of how you can blend SQL Server and PowerShell together. You’ll also get a look at the SQL Server PowerShell provider and how you can incorporate it into your automation scripts.

Instead of focusing on syntax, the session will plunge straight into examples and highlight various snippets of code and how they work. You can expect to see code examples on how PowerShell can do anything from comparing tables across servers, automating and centralizing your backups, and even doing in-depth security audits.

SessionID: 72984

Improve Your Knowledge of the Optimizer and Statistics!

Back to calendar

Event Date: 17-03-2018 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Julie McLain-Harper

Title: Improve Your Knowledge of the Optimizer and Statistics!

Abstract:

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.

SessionID: 73182

SSRS for Developers - attendees choose topics

Back to calendar

Event Date: 17-03-2018 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Kevin Goff

Title: SSRS for Developers - attendees choose topics

Abstract:

In this presentation, I’ll show over a dozen different SSRS topics, and allow attendees to select which topics to cover. Everything from sparklines to heat maps, from Tablix-drilldown reports to advanced charts, from performance gauges to subreport/drilldown reports to new page/group control features in R2….and even topics like data-driven subscriptions, reports against OLAP cubes, and deploying to SharePoint. There are even topics for integrating SSRS reports into ASP.NET pages, and launching SSRS reports using C#. Since no presentation can cover all the topics, I’ll let the majority of the audience decide which to cover.

SessionID: 77107

Real-time Smart Home Analytics

Back to calendar

Event Date: 17-03-2018 - Session time: 13:15:00 - Track: Advanced Analysis Techniques

Speaker: Josh Burgin

Title: Real-time Smart Home Analytics

Abstract:

There are two types of homes... smart homes and dumb homes. Is your home smart or dumb? If its smart, how are you analyzing its impact? We'll do our best to answer that question. The main inspiration for this session was trying to answer the question "How many times a week does my daughter asks the Echo to play Ed Sheeran?". In this session we'll cover how one can answer both real-time and historical questions about their smart home utilizing a lambda architecture in Azure Data Services. The data is easy to grasp. The reference architecture and implementation are pretty straight forward as well.

SessionID: 69738

R-ternatives in Power BI

Back to calendar

Event Date: 17-03-2018 - Session time: 14:30:00 - Track: Analytics and Visualization

Speaker: Ryan Wade

Title: R-ternatives in Power BI

Abstract:

R is a very powerful statistical programming language that has been gaining a lot of traction in recent years. In early 2015 Microsoft acquired Revolution Analytics, a major provider of software and services for R. Microsoft have since incorporated R in Azure ML, SQL Server 2016, and Power BI.

There are 3 ways you can leverage R in Power BI. You can use it as a data source, you can leverage it in Power Query, or you can use it to create custom visualizations. In this session I present easy to follow examples of those 3 scenarios. I will also provide resources that will enable you to take what you learned to the next level.

SessionID: 70613

DevOps for the DBA

Back to calendar

Event Date: 17-03-2018 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kellyn Pot'Vin-Gorman

Title: DevOps for the DBA

Abstract:

DevOps came out of the Agile movement and the idea that operations needed to be part of the solution for agile development to be successful. The DBA was often the most resilient and robust member of the operations team and most resistant to change. This mentality was essential to the protection of company’s critical production data.

This session discusses common database challenges and how they can be minimized or solved with newer DevOps practices without impacting the DBAs “safe zone”. We’ll discuss how to use these vital skills and motivate everyone towards solutions for more success in agile development environments. Development, testing, provisioning, patching, upgrading and managing will become easier with agile tools, virtualization and collaboration.
The take-aways from this session are to embrace DevOps basics with a “DBA twist” such as: -What DevOps means to the DBA -What tools and methodologies are important to know -The future skills you need to build your career

SessionID: 71486

Stream Analytics for a SQL Developer

Back to calendar

Event Date: 17-03-2018 - Session time: 14:30:00 - Track: Advanced Analysis Techniques

Speaker: Slava Trofimov

Title: Stream Analytics for a SQL Developer

Abstract:

As database developers, we are very familiar with patterns and practices of analyzing data at rest – data that has been loaded into our databases and data warehouses and that allows us to learn what happened a few hours, days or months ago. Yet, we often encounter the need to know and respond to what is happening right now, which requires near-real-time analysis of data in motion.

Fortunately, much of the skillset that we have accumulated in querying data at rest can be applied in querying streaming data with the Azure Stream Analytics service. In this demo-rich session, you will learn the essential architecture and patterns of building streaming analytics solutions and will be introduced to the Stream Analytics Query Language.

SessionID: 71505

Introduction to Azure Machine Learning

Back to calendar

Event Date: 17-03-2018 - Session time: 14:30:00 - Track: Advanced Analysis Techniques

Speaker: Warren Sifre

Title: Introduction to Azure Machine Learning

Abstract:

We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it. This session includes demonstration and use case scenarios. The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.

SessionID: 72461

Maintain SQL Server Performance Baseline with PowerShell

Back to calendar

Event Date: 17-03-2018 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Allen White

Title: Maintain SQL Server Performance Baseline with PowerShell

Abstract:

Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

SessionID: 77115

Alexa – Skills Development, Data, and Continuous Improvement

Back to calendar

Event Date: 17-03-2018 - Session time: 14:30:00 - Track: Advanced Analysis Techniques

Speaker: Shannon Lowder

Title: Alexa – Skills Development, Data, and Continuous Improvement

Abstract:

"Alexa, make Song Quiz smarter and more fun." That command may not work (yet), but this session can give you the tools and knowledge to enhance Alexa's ability to do all kinds of fun and useful things. Alexa is fast growing to be the strongest of the three personal assistants. Much of this growth has come from the fact that Amazon opened up 3rd party development through their Skills program. In this session, we’ll start with the Alexa ecosystem and terminology. We’ll then cover the infrastructure behind skills and development framework We’ll wrap things up with how to implement continuous improvement, by using data to drive it all!

SessionID: 71290

Performance in 60 Seconds – SQL Tricks Everybody MUST Know

Back to calendar

Event Date: 17-03-2018 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Pinal Dave

Title: Performance in 60 Seconds – SQL Tricks Everybody MUST Know

Abstract:

Data and Database is a very important aspect of application development for businesses. Developers often come across situations where they face a slow server response, even though their hardware specifications are above par. This session is for all the Developers who want their server to perform at blazing fast speed, but want to invest very little time to make it happen. We will go over various database tricks which require absolutely no time to master and require practically no SQL coding at all. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

SessionID: 71479

Microsoft and Big Data - An Overview of the Power Tools and more!

Back to calendar

Event Date: 17-03-2018 - Session time: 15:45:00 - Track: Analytics and Visualization

Speaker: David Patrick

Title: Microsoft and Big Data - An Overview of the Power Tools and more!

Abstract:

Come see Microsoft's Power tools demonstrated for advanced analytics and hear about Microsoft's embrace of Open Source and the Hadoop platform. We'll also present on Microsoft's tools for handling Big Data, such as the Parallel Data Warehouse and HDInsights.

SessionID: 71508

An (Advanced) Introduction to Dax

Back to calendar

Event Date: 17-03-2018 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Eugene Meidinger

Title: An (Advanced) Introduction to Dax

Abstract:

Coming from the Excel world, DAX can look like Excel formulas on steroids. However, to be successful with DAX and Powerpivot, you'll need a completely different mental model. In this introduction to DAX, we won't spend too much time on the basics. Instead, we'll focus the concepts that make DAX unique. This will help you avoid the stumbling blocks of working with DAX. We will cover calculated columns, measures, aggregations, filtering, and iterators.

SessionID: 72302

Cloudy with a Chance of Data

Back to calendar

Event Date: 17-03-2018 - Session time: 15:45:00 - Track: Cloud Application Development Deployment

Speaker: John Deardurff

Title: Cloudy with a Chance of Data

Abstract:

This course is intended as an Introductory look at the Cloud and Azure Data Services. We begin our session explaining what the cloud is and the differences between Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS). Then we turn our attention to Azure and the Microsoft Cloud Data Platform to see what solutions are available for Data Archtitects, Developers, and Administrators. Finally, we close the session with a tour of SQL Server in an Azure Virtual Machine as well as an Azure SQL Database.

SessionID: 72816

Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Back to calendar

Event Date: 17-03-2018 - Session time: 15:45:00 - Track: Strategy and Architecture

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

This site is open source. Improve this page.