Edit

Share via

SQL Data Developer

  • Article

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: Use Azure SQL to move your database to the cloud
  • 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

  • Azure Data Studio: Use Azure Data Studio on Windows, macOS, and Linux to run SQL Server, Azure SQL Database, PostgreSQL, Jupyter Notebooks and more.
  • 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