|
| 1 | +### YamlMime:Hub |
| 2 | +title: Microsoft SQL documentation |
| 3 | +summary: Learn how to use Microsoft SQL Server to address your database needs, both on-premises, and in the cloud! |
| 4 | +brand: sql |
| 5 | +metadata: |
| 6 | + title: Microsoft SQL documentation | Microsoft Docs |
| 7 | + description: Learn how to use Microsoft SQL Server to manage your database needs, both on-premises, and in the cloud! |
| 8 | + ms.topic: hub-page |
| 9 | + |
| 10 | +highlightedContent: |
| 11 | + items: |
| 12 | + - title: Try SQL Server 2019 (Preview) |
| 13 | + itemType: download |
| 14 | + url: https://www.microsoft.com/evalcenter/evaluate-sql-server-2019-ctp |
| 15 | + - title: Get an Azure VM with SQL Server |
| 16 | + itemType: overview |
| 17 | + url: https://azure.microsoft.com/services/virtual-machines/sql-server/?wt.mc_id=sqL16_vm |
| 18 | + - title: Download query data tools |
| 19 | + itemType: download |
| 20 | + url: tools/overview-sql-tools.md |
| 21 | + - title: SQL Server Education Center |
| 22 | + itemType: learn |
| 23 | + url: lp/sql-server/sql-education-center.md |
| 24 | + |
| 25 | +productDirectory: |
| 26 | + items: |
| 27 | + - title: SQL on Azure |
| 28 | + imageSrc: media/index/azure.png |
| 29 | + links: |
| 30 | + - url: https://docs.microsoft.com/azure/sql-database/ |
| 31 | + text: Azure SQL Database |
| 32 | + - url: https://docs.microsoft.com/azure/sql-data-warehouse/sql-data-warehouse-overview-what-is/ |
| 33 | + text: Azure SQL Data Warehouse |
| 34 | + - title: SQL Server on Windows |
| 35 | + imageSrc: media/index/windows.png |
| 36 | + links: |
| 37 | + - url: sql-server/sql-server-technical-documentation.md |
| 38 | + text: On-premises |
| 39 | + - url: https://docs.microsoft.com/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-server-iaas-overview/ |
| 40 | + text: On an Azure VM |
| 41 | + - url: https://docs.microsoft.com/previous-versions/sql/ |
| 42 | + text: Previous Versions (SQL 2005 - 2012) |
| 43 | + - title: SQL Server on Linux |
| 44 | + imageSrc: media/index/linux.png |
| 45 | + links: |
| 46 | + - url: linux/sql-server-linux-overview.md |
| 47 | + text: On-premises |
| 48 | + - url: linux/quickstart-install-connect-clouds.md |
| 49 | + text: On an Azure VM |
| 50 | + |
| 51 | + |
| 52 | +conceptualContent: |
| 53 | + items: |
| 54 | + - title: Getting started |
| 55 | + links: |
| 56 | + - text: SQL Server Management Studio |
| 57 | + url: ssms/tutorials/tutorial-sql-server-management-studio.md |
| 58 | + itemType: overview |
| 59 | + - text: Azure Data Studio |
| 60 | + url: azure-data-studio/quickstart-sql-server.md |
| 61 | + itemType: overview |
| 62 | + - text: Writing Transact-SQL |
| 63 | + url: t-sql/tutorial-writing-transact-sql-statements.md |
| 64 | + itemType: overview |
| 65 | + - text: SQL Server on Ubuntu |
| 66 | + url: linux/quickstart-install-connect-ubuntu.md |
| 67 | + itemType: overview |
| 68 | + - title: What's New |
| 69 | + links: |
| 70 | + - text: SQL Server big data cluster |
| 71 | + url: big-data-cluster/big-data-cluster-overview.md |
| 72 | + itemType: overview |
| 73 | + - text: Azure Data Studio |
| 74 | + url: azure-data-studio/what-is.md |
| 75 | + itemType: overview |
| 76 | + - text: Azure Database Migration Service |
| 77 | + url: https://docs.microsoft.com/azure/dms/dms-overview |
| 78 | + itemType: overview |
| 79 | + - text: SQL Machine Learning Services |
| 80 | + url: reporting-services/install-windows/upgrade-and-migrate-reporting-services.md |
| 81 | + itemType: overview |
| 82 | + - title: Release notes |
| 83 | + links: |
| 84 | + - text: SQL Server 2019 |
| 85 | + url: sql-server/what-s-new-in-sql-server-ver15.md |
| 86 | + itemType: overview |
| 87 | + - text: SQL Server on an Azure VM |
| 88 | + url: /azure/virtual-machines/windows/sql/virtual-machines-windows-sql-server-iaas-release-notes |
| 89 | + itemType: overview |
| 90 | + - text: Azure SQL Database |
| 91 | + url: /azure/sql-database/sql-database-release-notes |
| 92 | + itemType: overview |
| 93 | + - text: Azure SQL Data Warehouse |
| 94 | + url: /azure/sql-data-warehouse/release-notes-10-0-10106-0 |
| 95 | + itemType: overview |
| 96 | + - title: Install |
| 97 | + links: |
| 98 | + - text: SQL Server |
| 99 | + url: database-engine/install-windows/install-sql-server.md |
| 100 | + itemType: overview |
| 101 | + - text: Analysis Services (SSAS) |
| 102 | + url: analysis-services/instances/install-windows/install-analysis-services.md |
| 103 | + itemType: overview |
| 104 | + - text: Integration Services (SSIS) |
| 105 | + url: integration-services/install-windows/install-integration-services.md |
| 106 | + itemType: overview |
| 107 | + - text: Reporting Services (SSRS) |
| 108 | + url: reporting-services/install-windows/install-reporting-services.md |
| 109 | + itemType: overview |
| 110 | + footerLink: |
| 111 | + text: See more |
| 112 | + url: lp/sql-server/install-sql-and-services.md |
| 113 | + - title: Migrate |
| 114 | + links: |
| 115 | + - text: Azure Database Migration Service (DMS) |
| 116 | + url: https://docs.microsoft.com/azure/dms/dms-overview |
| 117 | + itemType: overview |
| 118 | + - text: Database Migration Assistant (DMA) |
| 119 | + url: dma/dma-overview.md |
| 120 | + itemType: overview |
| 121 | + - text: Database Experimentation Assistant (DEA) |
| 122 | + url: dea/database-experimentation-assistant-overview.md |
| 123 | + itemType: overview |
| 124 | + - text: SQL Server Migration Assistant (SSMA) |
| 125 | + url: ssma/sql-server-migration-assistant.md |
| 126 | + itemType: overview |
| 127 | + footerLink: |
| 128 | + text: See more |
| 129 | + url: lp/sql-server/load-move-data.md |
| 130 | + - title: Business continuity |
| 131 | + links: |
| 132 | + - text: Always On availability group |
| 133 | + url: database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server.md |
| 134 | + itemType: overview |
| 135 | + - text: Backup & restore |
| 136 | + url: relational-databases/backup-restore/back-up-and-restore-of-sql-server-databases.md |
| 137 | + itemType: overview |
| 138 | + - text: Database mirroring |
| 139 | + url: database-engine/database-mirroring/database-mirroring-sql-server.md |
| 140 | + itemType: overview |
| 141 | + - text: Failover cluster instance |
| 142 | + url: sql-server/failover-clusters/windows/always-on-failover-cluster-instances-sql-server.md |
| 143 | + itemType: overview |
| 144 | + footerLink: |
| 145 | + text: See more |
| 146 | + url: lp/sql-server/business-continuity.md |
| 147 | + - title: Security |
| 148 | + links: |
| 149 | + - text: Always Encrypted |
| 150 | + url: relational-databases/security/encryption/always-encrypted-database-engine.md |
| 151 | + itemType: overview |
| 152 | + - text: Authentication & access |
| 153 | + url: relational-databases/security/authentication-access/managing-logins-users-and-schemas-how-to-topics.md |
| 154 | + itemType: overview |
| 155 | + - text: Permissions |
| 156 | + url: relational-databases/security/permissions-database-engine.md |
| 157 | + itemType: overview |
| 158 | + - text: Transparent Data Encryption (TDE) |
| 159 | + url: relational-databases/security/encryption/transparent-data-encryption.md |
| 160 | + itemType: overview |
| 161 | + footerLink: |
| 162 | + text: See more |
| 163 | + url: lp/sql-server/secure-sql-server.md |
| 164 | + - title: Manage & monitor |
| 165 | + links: |
| 166 | + - text: Maintenance plans |
| 167 | + url: relational-databases/maintenance-plans/maintenance-plans.md |
| 168 | + itemType: overview |
| 169 | + - text: Policy-based management |
| 170 | + url: relational-databases/policy-based-management/administer-servers-by-using-policy-based-management?view=sql-server-2017 |
| 171 | + itemType: overview |
| 172 | + - text: Transaction log management |
| 173 | + url: relational-databases/logs/the-transaction-log-sql-server.md |
| 174 | + itemType: overview |
| 175 | + - text: xEvents |
| 176 | + url: relational-databases/extended-events/extended-events.md |
| 177 | + itemType: overview |
| 178 | + footerLink: |
| 179 | + text: See more |
| 180 | + url: lp/sql-server/manage-monitor-tune.md |
| 181 | + - title: Tune |
| 182 | + links: |
| 183 | + - text: Automatic tuning |
| 184 | + url: relational-databases/automatic-tuning/automatic-tuning.md |
| 185 | + itemType: overview |
| 186 | + - text: Database tuning Advisor |
| 187 | + url: relational-databases/performance/database-engine-tuning-advisor.md |
| 188 | + itemType: overview |
| 189 | + - text: In-memory OLTP |
| 190 | + url: relational-databases/in-memory-oltp/in-memory-oltp-in-memory-optimization.md |
| 191 | + itemType: overview |
| 192 | + - text: Query data Store |
| 193 | + url: relational-databases/performance/monitoring-performance-by-using-the-query-store.md |
| 194 | + itemType: overview |
| 195 | + footerLink: |
| 196 | + text: See more |
| 197 | + url: lp/sql-server/manage-monitor-tune.md |
| 198 | + - title: Load & move data |
| 199 | + links: |
| 200 | + - text: BCP |
| 201 | + url: tools/bcp-utility.md |
| 202 | + itemType: overview |
| 203 | + - text: Import or Export Wizard |
| 204 | + url: integration-services/import-export-data/import-and-export-data-with-the-sql-server-import-and-export-wizard.md |
| 205 | + itemType: overview |
| 206 | + - text: Integration Services |
| 207 | + url: integration-services/sql-server-integration-services.md |
| 208 | + itemType: overview |
| 209 | + - text: Replication |
| 210 | + url: relational-databases/replication/sql-server-replication.md |
| 211 | + itemType: overview |
| 212 | + footerLink: |
| 213 | + text: See more |
| 214 | + url: lp/sql-server/load-move-data.md |
| 215 | + - title: Database design |
| 216 | + links: |
| 217 | + - text: Databases |
| 218 | + url: relational-databases/databases/databases.md |
| 219 | + itemType: overview |
| 220 | + - text: Indexes |
| 221 | + url: relational-databases/indexes/indexes.md |
| 222 | + itemType: overview |
| 223 | + - text: Statistics |
| 224 | + url: relational-databases/statistics/statistics.md |
| 225 | + itemType: overview |
| 226 | + - text: Stored procedures |
| 227 | + url: relational-databases/stored-procedures/stored-procedures-database-engine.md |
| 228 | + itemType: overview |
| 229 | + footerLink: |
| 230 | + text: See more |
| 231 | + url: lp/sql-server/database-design.md |
| 232 | + - title: Query Data |
| 233 | + links: |
| 234 | + - text: Joins |
| 235 | + url: relational-databases/performance/joins.md |
| 236 | + itemType: overview |
| 237 | + - text: Scripting |
| 238 | + url: ssms/scripting/database-engine-scripting.md |
| 239 | + itemType: overview |
| 240 | + - text: Subqueries |
| 241 | + url: relational-databases/performance/subqueries.md |
| 242 | + itemType: overview |
| 243 | + - text: User-defined functions |
| 244 | + url: relational-databases/user-defined-functions/user-defined-functions.md |
| 245 | + itemType: overview |
| 246 | + footerLink: |
| 247 | + text: See more |
| 248 | + url: lp/sql-server/query-data.md |
| 249 | + |
| 250 | +additionalContent: |
| 251 | + sections: |
| 252 | + - items: |
| 253 | + - title: Development |
| 254 | + summary: | |
| 255 | + [Azure SQL DB applications](https://docs.microsoft.com/azure/sql-database/sql-database-develop-)<br /> |
| 256 | + [Azure SQL DB connectivity libraries](https://docs.microsoft.com/azure/sql-database/sql-database-connect-query#libraries)<br /> |
| 257 | + [SQL Server client connectivity](connect/homepage-sql-connection-programming.md)<br /> |
| 258 | + - title: Reporting |
| 259 | + summary: | |
| 260 | + [Power BI Report Server](https://docs.microsoft.com/power-bi/report-server/get-started)<br /> |
| 261 | + [Power BI Service](https://docs.microsoft.com/power-bi/service-get-started)<br /> |
| 262 | + [SQL Server Reporting Services (SSRS)](reporting-services/create-deploy-and-manage-mobile-and-paginated-reports.md)<br /> |
| 263 | + - title: AI & Machine Learning |
| 264 | + summary: | |
| 265 | + [Azure Machine Learning](https://docs.microsoft.com/azure/machine-learning/)<br /> |
| 266 | + [SQL Machine Learning Services (R & Python)](advanced-analytics/what-is-sql-server-machine-learning.md)<br /> |
| 267 | + [SQL Server R Services](advanced-analytics/r/sql-server-r-services.md)<br /> |
| 268 | + - title: Data Analytics |
| 269 | + summary: | |
| 270 | + [Azure Analysis Services](https://docs.microsoft.com/azure/analysis-services/)<br /> |
| 271 | + [Azure SQL Data Warehouse](https://docs.microsoft.com/azure/sql-data-warehouse/sql-data-warehouse-overview-what-is/)<br /> |
| 272 | + [Microsoft Analytics Platform System](analytics-platform-system/index.md)<br /> |
| 273 | + [Polybase](relational-databases/polybase/polybase-guide.md)<br /> |
| 274 | + [SQL Server Analysis Services (SSAS)](analysis-services/analysis-services.md)<br /> |
| 275 | + [SQL Server 2019 big data clusters](big-data-cluster/big-data-cluster-overview.md)<br /> |
| 276 | + - title: Reference |
| 277 | + summary: | |
| 278 | + [Azure SQL CLI](https://docs.microsoft.com/cli/azure/sql)<br /> |
| 279 | + [Azure SQL REST API](https://docs.microsoft.com/rest/api/sql/)<br /> |
| 280 | + [Azure SQL PowerShell](https://docs.microsoft.com/powershell/module/az.sql/)<br /> |
| 281 | + [Database Management Views (DMVs)](relational-databases/system-dynamic-management-views/system-dynamic-management-views.md)<br /> |
| 282 | + [Database samples](samples/sql-samples-where-are.md)<br /> |
| 283 | + [SQL PowerShell](powershell/sql-server-powershell.md)<br /> |
| 284 | + [System catalog views](relational-databases/system-catalog-views/catalog-views-transact-sql.md)<br /> |
| 285 | + [Transact-SQL (T-SQL)](t-sql/language-reference.md)<br /> |
| 286 | + [xQuery](xquery/xquery-language-reference-sql-server.md)<br /> |
| 287 | + - title: Tools |
| 288 | + summary: | |
| 289 | + [Azure Data Studio](azure-data-studio/download.md)<br /> |
| 290 | + [Distributed replay](tools/distributed-replay/sql-server-distributed-replay.md)<br /> |
| 291 | + [SQL Server Data Tools (SSDT)](ssdt/download-sql-server-data-tools-ssdt.md)<br /> |
| 292 | + [SQL Server Management Studio (SSMS)](ssms/download-sql-server-management-studio-ssms.md)<br /> |
| 293 | + [SQL Server Profiler](tools/sql-server-profiler/sql-server-profiler.md)<br /> |
| 294 | + [See more tools](tools/overview-sql-tools.md)<br /> |
| 295 | +
|
| 296 | +
|
| 297 | +
|
| 298 | +
|
0 commit comments