A collection of resources for the Mode community, including SQL and Python tutorials and examples of custom data visualizations.
Install and connect (WSL2) Run and connect (containers) Deploy SQL Server container cluster Deploy to Azure VMs with Ansible playbook Provision a SQL Server VM in Azure > Run and connect - Cloud Tutorials Concepts Samples Resources SQL on Azure ...
Products Architecture Develop Learn Azure Troubleshooting Resources Portal Free account Version Azure SQL Search Azure SQL Documentation Azure SQL Shared SQL DB & SQL MI docs Azure SQL Database (SQL DB) Azure SQL Managed Instance (SQL MI) Documentation Overview Quickstarts Tutorials Migrati...
Tutorials Concepts Back up and restore Data ingestion and preparation Development Overview Best practices serverless SQL pool Best practices dedicated SQL pools Distribution Advisor Materialized view Ordered clustered columnstore index Result set caching ...
Diagnosing latch contention Diagnosing spinlock contention Database connection network trace Installation Migrate & load data Manage, monitor, & tune Query data Reporting & Analytics Security Tools Tutorials SQL Server on Linux SQL on Azure Azure Arc Big Data Clusters Resources Reference ...
Stored procedures Tables Track changes Triggers User-defined functions Views XML data Development Internals & architecture Installation Migrate & load data Manage, monitor, & tune Query data Reporting & Analytics Security Tools Tutorials SQL Server on Linux SQL on Azure Azure Arc Resources Reference ...
Distribution Agent Publisher and subscriber <machine_name>\repl_distribution Merge Agent Publisher and subscriber <machine_name>\repl_mergeNote In the replication tutorials, the publisher and distributor share the same instance (NODE1\SQL2016) of SQL Server. The subscriber instance (NODE2\...
Tutorials Concepts How-to guides Connect Data exploration and modeling Data type conversions Python to SQL R to SQL Deploy Predictions Package management Administration Security Performance Reference Resources Save Add to Collections Add to Plan
Connect and query a dedicated SQL pool in Azure Synapse Analytics Tutorials Concepts How-to References Resources SQL projects SqlPackage SQL Server Profiler Visual Studio native helpers Extended Features Visual Studio Code extensions Tutorials SQL Server on Linux SQL on Azure Azure Arc Resources Reference...
Learning SQL can be done efficiently. And it should not be expensive either. You can find many resources around the internet. For your convenience, I’ve listed four free online SQL tutorials: Codecademy— Codecademy is a great interactive programming school. It’s not only for SQL – it lis...