The Microsoft SQL Server organization (along with its parent, the Microsoft Azure Data Team) has several useful references we have created. While not an exhaustive list, here are a few we think you'll find useful.
(Note: These scripts, tools and information site are a not guarenteed to work in every situation, or to be placed into production without thoroughly testing on your own. Microsoft assumes no risk associated with your use of these tools. These sites have adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.)
These PowerPoint Decks deal with SQL Server in general, for many different versions and editions. If you find a dead link, hit up the Issues link above to report it.
| Deck Location | Description |
|---|---|
| OneDrive | Bob Ward's Presentations - Source Slide Decks |
| GitHub | Tiger Team Presentations - Source Slide Decks and Demonstrations |
These references deal with SQL Server code samples from our courses and other uses, for many different versions and editions. If you find a dead link, hit up the Issues link above to report it.
| Code Sample Location | Description |
|---|---|
| http://aka.ms/bobsqldemos | Bob Ward's Demonstrations and Sample Code |
| http://aka.ms/bw-presentations | Buck Woody's Demonstrations and Sample Code |
| http://aka.ms/annalytics | Anna Hoffman's Demonstrations and Resources |
| GitHub | SQL Server Samples - Sample Code |
These references deal with SQL Server in general, for many different versions and editions. If you find a dead link, hit up the Issues link above to report it.
| Resource | Description |
|---|---|
| http://aka.ms/AID | Adaptive Index Defrag for intelligent management of indexes and statistics |
| http://aka.ms/AzureSQLTeam | Azure SQL Team blog |
| http://aka.ms/BPCheck | Performance and Best Practices Check for SQL Server and Azure SQL |
| http://aka.ms/DBCompat | Compatibility Certification for SQL Server and Azure SQL |
| http://aka.ms/ESUFAQ | Extended Security Updates program FAQ |
| http://aka.ms/IQP | Intelligent Query Processing in SQL databases |
| http://aka.ms/IQPDemos | Intelligent Query Processing Demos |
| http://aka.ms/InternationalTSQL | Write International T-SQL Statements |
| http://aka.ms/SQLCapacityLimits | Capacity Limits for SQL Server |
| http://aka.ms/SQLConventions | T-SQL Conventions and Syntax |
| http://aka.ms/SQLErrors | Errors and Events Reference (Database Engine) |
| http://aka.ms/SQLFeedback | Submit feedback to the SQL Server team |
| http://aka.ms/SQLIaaSPerf | Performance guidelines for SQL Server in Azure Virtual Machines |
| http://aka.ms/SQLLifecycle | SQL Server Lifecycle Dates |
| http://aka.ms/SQL2019Notebooks | Azure Data Studio Notebooks for evaluating the NEW features of SQL Server 2019 |
| http://aka.ms/SQLOperators | Showplan Logical and Physical Operators Reference |
| http://aka.ms/SQLPerfCenter | Performance Center for SQL Server Database Engine and Azure SQL Database |
| http://aka.ms/SQLPerfCounters | SQL Server Performance Counters reference |
| http://aka.ms/sqlprivacy | SQL Server privacy supplement |
| http://aka.ms/SQLServerGuides | All official SQL Server Guide publications containing information on Database Engine internals |
| http://aka.ms/SQLServerSamples | SQL Server Samples Repository that demonstrate how to use Microsoft's SQL products including SQL Server, Azure SQL Database, and Azure SQL Data Warehouse |
| http://aka.ms/SQLServerTeam | SQL Server Team blog |
| http://aka.ms/SQLStandards | SQL Server Standards Support |
| http://aka.ms/SQLUnicode | Collation and Unicode support |
| http://aka.ms/SQLUpdates | Latest SQL Server Builds |
| http://aka.ms/SQLWorkshops | In-Depth Training from the Azure Data Services Team |
| http://aka.ms/SSMS | SQL Server Management Studio (SSMS) |
| http://aka.ms/TigerToolbox | SQL Server Tiger Team Toolbox |
| http://aka.ms/TraceFlags | SQL Server Trace Flags |
| http://aka.ms/uspWhatsUp | Report all you need to know about in-flight queries and any blocking in SQL Server. Also available as SQL Notebook |