![SQL Server Team](/img/default-banner.jpg)
- 7
- 21 394
SQL Server Team
United States
Registrace 5. 11. 2016
The CZcams channel of the SQL Server engineering team.
Follow us on Twitter at @mssqltiger | mssqltiger
Blog: aka.ms/sqlserverteam
GitHub repository: tigertoolbox | github.com/Microsoft/tigertoolbox
Follow us on Twitter at @mssqltiger | mssqltiger
Blog: aka.ms/sqlserverteam
GitHub repository: tigertoolbox | github.com/Microsoft/tigertoolbox
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
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 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 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 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 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 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 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.
Lol Wtf 😂😂😂
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.
8 CPU Sockets? Thats Insane! I love it!
Hi there, iam new to sql environment ,still confusing in few topics like performance tuning. after watching this i came to know few things.
how to maximize processor performance so that it can be used 100% on my query running slow but usage can't reach 100%
Awesome information
12TB of RAM? OMG
Many Thank! Very helpful
Me reading memory: 12gb only??? Wtf how. Jump back and realized the t (tb). I Got the best laugh flash in a long time.
What kind of machine is this????
read the desc: (224 cores, 12TB RAM and 200TB+ SSD storage). its a massive distributed system
what if 1,000 concurrent user czcams.com/video/ZGiR2Am3gqY/video.html
Hi i have one question . How to so select query for 100 million recordset from mssql with rapidly. It's possible?
Great presentation!