• SQL Server 2019 | Query faster from any database. (Microsoft Ignite)
    Articles,  Blog

    SQL Server 2019 | Query faster from any database. (Microsoft Ignite)

    (logo sliding) (upbeat music) – Welcome to Microsoft Mechanics Live. (audience clapping) Hoo. Coming up, we take a closer look SQL Server 2019, now generally available. We’ll look at its expanded role as a data integration platform allowing you to bring in data from any source including on the Edge for analysis. In fact, we’ll show you how data location becomes irrelevant with a scenario that goes from the ground to the cloud, and introduce you to Azure SQL Database Edge. So, I’m please to be joined today by Buck Woody, an applied data scientist from the SQL engineering team. Welcome! Thanks for having me on the show. – It’s…

  • InAccel FPGA acceleration of Spark ML on SQL Server 2019 Big Data Cluster on Azure Data Studio
    Articles,  Blog

    InAccel FPGA acceleration of Spark ML on SQL Server 2019 Big Data Cluster on Azure Data Studio

    This is a demonstration of InAccel accelerated solution for Spark ML on Microsoft Big Data Cluster 2019. InAccel manages all the FPGA resources in the cluster… …and can be deployed as a Kubernetes DaemonSet app. InAccel resource manager is attached to every FPGA node, ready to orchestrate acceleration tasks. Data scientists can now accelerate their ML pipelines, seamlessly… …using common Azure Data Studio notebooks. In this example we will train a Logistic Regression model, for a handwritten-letters recognition problem. Our pipeline includes a hyperparameter tuning stage… …in which 20 evaluation models will be calculated. Using InAccel monitoring system users can inspect in real-time… …the utilization of every FPGA in the…

  • New Feature Offerings in SQL Server 2019
    Articles,  Blog

    New Feature Offerings in SQL Server 2019

    >>Hello everyone, I’m Rony Chatterjee, a senior program manager on Microsoft SQL Server team. Today, I’m going to show our SQL Server 2019 product offerings in Azure Data Studio. A cross platform multidatabase tool designed to empower data engineers and data scientists. SQL Server 2019 is deployed on Kubernetes providing the flexibility to run on premises or in the cloud. In this instance of Azure Data Studio, I’m connected to two SQL Server instances and to the Spark HDFS endpoint in the Kubernetes cluster. SQL Server 2019 provides a unified view over enterprise data. Whether it’s relational data stored in databases or big data stored in HTFS clusters. SQL Server…

  • SQL Server 2019 meets AI and Big Data | Ignite 18
    Articles,  Blog

    SQL Server 2019 meets AI and Big Data | Ignite 18

    (upbeat music) – Hello, and welcome back to Microsoft Mechanics Live! Coming up next, we’re gonna have a leap and we’re gonna have a look at the leap forward in SQL Server, its next leap, and we’re gonna show you big data capabilities that are now built into SQL with HDFS and Apache Spark, as well as our new approach for data virtualization that allows you to easily integrate data across multiple data sources without even needing to move it or perform ETL. So, very cool stuff. And to join me, I’ve got Travis Wright from the SQL Server team. Give a big, warm welcome. – Hey. (audience applauds) Thanks,…

  • SQL Server 2019 Top 3 New Features and PolyBase Demo!
    Articles,  Blog

    SQL Server 2019 Top 3 New Features and PolyBase Demo!

    – What’s up everyone and welcome to Josh Burns Tech. In today’s video, we’re going to be looking at the top three feature in SQL Sever 2019 and do a live demo of PolyBase external tables as well. Coming right up. (electronic bass music) If you’re here for the first time, be sure to hit the subscribe button to stay up-to-date on all the videos coming to the channel. The main focus is on how-to videos and tech reviews as well. So alright, let’s get into the video! So SQL Server 2019, being a public preview, there are a lot of new and exciting features that have been added into…