SQL Data Developer

Use Microsoft's SQL data platform to create data-centric solutions across mobile devices and desktops for web servers, enterprise servers, and the cloud.

SQL Data storage

• SQL Server Database Engine: Use the SQL Server Database Engine to create relational databases for online transaction processing or online analytical processing data.
• Azure SQL Database and Azure SQL Managed Instance: Use Azure SQL Database or Azure SQL Managed Instance to start development or move your database to the cloud.
• SQL database in Fabric: Based on the same engine as Azure SQL Database and integrated in your Microsoft Fabric workspace, SQL database in Microsoft Fabric is a developer-friendly transactional database that allows you to easily create your operational database in Fabric. Many features are common between SQL Server and Azure SQL Database and SQL database in Fabric.
• SQL Compact: Use SQL Server Compact to build standalone and occasionally connected applications for mobile devices, desktops, and Web clients.
• LocalDB: Use LocalDB during development to write and test Transact-SQL code without having to manage a full server instance of SQL Server.

SQL Data tools

• mssql extension for Visual Studio Code: Use the mssql extension in VS Code on Windows, macOS, and Linux to manage SQL Server, Azure SQL Database, SQL database in Fabric.
• SQL Server Data Tools: Use SSDT inside Visual Studio to build relational databases, Azure SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services reports.
• SQL Server Management Tools: Use SSMS on Windows to configure, monitor, and administer instances of SQL Server.

SQL Data access

• SQL Client Drivers: Use SQL drivers to connect, query, update, insert, or delete data from a SQL database.
• Entity Framework: Use the Entity Framework to easily access databases using LINQ, with direct access to SQL Server and the option to control the mapping between an Entity Data Model (EDM) and raw relational structures.
• Windows Communication Foundation (WCF): Use Data Services for a near-turnkey solution to easily create and consume OData services on both the web and intranet
• Sync Framework: Use the Sync Framework to enable offline access to any data type, any data store, any transfer protocol, and any network topology.
• Reactive Extensions: Use the Reactive Extensions (Rx) to perform event stream programming and simplify asynchronous programming using observable sequences and LINQ-style query operators. Use the Reactive Extensions for JavaScript (RxJS) to simplify asynchronous callback-based and event-driven programming on the web using observable sequences.
• CLR Integration: Use CLR Integration to write stored procedures, triggers, user-defined types, user-defined functions, user-defined aggregates, and streaming table-valued functions, using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#.
• SQLXML 4.0: Use SQLXML 4.0 to export relational data to XML.

Data collection, processing, and visualization

• Analysis Services
• Integration Services
• Master Data Services
• Replication Services
• Reporting Services
• Service Broker