SQL Server Team
SQL Server Team
  • 7
  • 21 394
Automate management with the SQL Server IaaS Agent extension
In this video, learn how to easily manage your Azure SQL virtual machines using the SQL IaaS Agent Extension. Whether you are using an Azure Marketplace image or a custom image with self-installed SQL Server, the SQL IaaS Agent Extension offers a number of features to discover and manage your SQL Server VMs quickly and easily through the Azure Portal.
SQL Server IaaS Agent Extension
docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-iaas-agent-extension-automate-management?tabs=azure-cli
Register SQL Server VM with SQL Server IaaS Agent Extension
docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-agent-extension-automatic-registration-all-vms?tabs=azure-cli
zhlédnutí: 3 356

Video

[DPS 2020 Teaser] TRAINING CLASS:- SQL SERVER: ADVANCED TRAINING FOR AZURE VM DEPLOYMENTS4:35[DPS 2020 Teaser] TRAINING CLASS:- SQL SERVER: ADVANCED TRAINING FOR AZURE VM DEPLOYMENTS
[DPS 2020 Teaser] TRAINING CLASS:- SQL SERVER: ADVANCED TRAINING FOR AZURE VM DEPLOYMENTS
zhlédnutí 54Před 3 lety
This workshop will be an engaging, real-world examination of modernizing your most critical SQL based platforms. We look forward to seeing you there! Booking link: dataplatformgeeks.com/dps2020/product/training-class-sql-server-advanced-training-for-azure-vm-deployments-by-microsoft/ Speakers: AMIT KHANDELWAL ADITYA BADRAMRAJU DAVID PLESS TEJAS SHAH PAM LAHOUD Many customers are looking to migr...
SQL Server 2019 querying 1 trillion rows in 100 seconds0:57SQL Server 2019 querying 1 trillion rows in 100 seconds
SQL Server 2019 querying 1 trillion rows in 100 seconds
zhlédnutí 8KPřed 4 lety
We recently performed a performance test on a SQL Server 2019 instance running on a Windows Server 2016 running on an 8-Socket (224 cores, 12TB RAM and 200TB SSD storage) Lenovo Server (ThinkSystem SR950) using Intel Cascade Lake processors. We generated data and loaded a single table (LINEITEM, TPCH database schema with 145TB raw data). This table had 54TB compressed data with 1 Trillion rows....
Azure SQL Database Edge - PASS Summit 2019 Keynote Demo1:45Azure SQL Database Edge - PASS Summit 2019 Keynote Demo
Azure SQL Database Edge - PASS Summit 2019 Keynote Demo
zhlédnutí 134Před 4 lety
Rohan Kumar, Azure Data CVP, showing a live demo of how Azure SQL Database Edge can be used to show live streaming data. The edge devices were being used to capture every instance when the audience clapped and that information was streamed live onto a PowerBI dashboard.
SQL Server 2017 Intelligent Diagnostics Builtin - Adaptive QP23:49SQL Server 2017 Intelligent Diagnostics Builtin - Adaptive QP
SQL Server 2017 Intelligent Diagnostics Builtin - Adaptive QP
zhlédnutí 223Před 7 lety
SQL Server 2017 comes with best built-in diagnostics in the industry coming from our cloud first engineering experience. The diagnostics enable SQL Server to be adaptive, automatic and drive intelligent actions. In this video, Joe Sack who is our principal PM for query processors showcases and demos how optimizer got smarter and intelligent to learn, adapt and auto-correct to produce fast and e...
SQL Server 2017 Intelligent Diagnostics Builtin26:43SQL Server 2017 Intelligent Diagnostics Builtin
SQL Server 2017 Intelligent Diagnostics Builtin
zhlédnutí 380Před 7 lety
SQL Server 2017 comes with best built-in diagnostics in the industry coming from our cloud first engineering experience. The diagnostics enable SQL Server to be adaptive, automatic and drive intelligent actions. In this video Bob Ward and Parikshit Savjani from SQL Server tiger team demonstrates how customers and community can use the diagnostics to make life easy for DBAs and DevOps audience.
SQL Server Performance Troubleshooting made easier with SSMS Performance Dashboard31:19SQL Server Performance Troubleshooting made easier with SSMS Performance Dashboard
SQL Server Performance Troubleshooting made easier with SSMS Performance Dashboard
zhlédnutí 9KPřed 7 lety
With upcoming release of SSMS 17, Microsoft SQL Server Performance Dashboard is available out of the box for DBAs allowing to diagnose and resolve their performance issues quickly and easily for all supported versions of SQL Server from SQL Server 2008 to SQL Server 2016.

Komentáře

  • @AM-sd7iz
    @AM-sd7iz Před 4 měsíci

    Lol Wtf 😂😂😂

  • @DanielWillen
    @DanielWillen Před 6 měsíci

    Cool, right about 0.00001% of the world's businesses will afford the licensing costs so if this is supposed to be a flex I am not impressed.

  • @johnsa3567
    @johnsa3567 Před rokem

    8 CPU Sockets? Thats Insane! I love it!

  • @taqhima4889
    @taqhima4889 Před rokem

    Hi there, iam new to sql environment ,still confusing in few topics like performance tuning. after watching this i came to know few things.

  • @black7ak553
    @black7ak553 Před 2 lety

    how to maximize processor performance so that it can be used 100% on my query running slow but usage can't reach 100%

  • @alexeys1723
    @alexeys1723 Před 3 lety

    Awesome information

  • @tpi8965
    @tpi8965 Před 3 lety

    12TB of RAM? OMG

  • @vutrongquangful
    @vutrongquangful Před 3 lety

    Many Thank! Very helpful

  • @a_red_panda
    @a_red_panda Před 3 lety

    Me reading memory: 12gb only??? Wtf how. Jump back and realized the t (tb). I Got the best laugh flash in a long time.

  • @hiranyey
    @hiranyey Před 4 lety

    What kind of machine is this????

    • @TheFearmonger
      @TheFearmonger Před 4 lety

      read the desc: (224 cores, 12TB RAM and 200TB+ SSD storage). its a massive distributed system

  • @learndatabending182
    @learndatabending182 Před 4 lety

    what if 1,000 concurrent user czcams.com/video/ZGiR2Am3gqY/video.html

  • @Common_man_views
    @Common_man_views Před 4 lety

    Hi i have one question . How to so select query for 100 million recordset from mssql with rapidly. It's possible?

  • @arbcoll
    @arbcoll Před 5 lety

    Great presentation!