Microsoft today announced the general availability of the open source Data API builder (DAB), which provides REST and GraphQL endpoints for Azure databases, some three years in the making.
PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client connection software.
You've carefully crafted a concurrent application taking advantage of all the latest and greatest language features. It scales magnificently and it's the jewel of the cloud. But what about the database? What happens when simultaneous queries are executed against the same data?
The open source project lets developers and data pros to use its Semantic Kernel SDK to experiment and test the abilities of LLMs to generate SQL queries based on natural language expressions.
While ledger is a game-changer for security, SQL Server 2022 also introduced new functionality around Dynamic Data Masking (DDM), T-SQL enhancements and more.
Microsoft, apparently trying to enhance every product it has with an AI-powered Copilot, announced a new one for the latest release of SQL Server Developer Tools (SSDT) in Visual Studio.
The new ledger feature in SQL Server 2022 provides blockchain-based security to ensure data isn't tampered with.
Visual Studio 2022 has been out for some eight months now, but it still lacks full support for SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS), a top feature request.
Microsoft has open sourced a .NET 5 C# Language Extension for SQL Server, allowing developers to work with relational data in the company's flagship programming language.
SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships.
Research firm GigaOm compared throughput performance between SQL Server on Azure Virtual Machines and SQL Server on AWS EC2, finding the former enjoyed a definite speed edge.
The mssql extension for Visual Studio Code, used to support SQL Server connections and T-SQL editing, has been updated with IntelliCode functionality and a new Object Explorer, among other new features.
Microsoft announced a new data access driver for SQL Server that should be the path forward for data developers in the era of .NET Core.
With the March update of Azure Data Studio, Microsoft added preview support of the popular PostgreSQL database, along with a new PostgreSQL extension for the Visual Studio Code editor.
The October release of Azure Data Studio includes preview support for SQL Server 2019 and more.
If, in your "need for speed," you're looking to access and update your data as fast as possible, you can get to that goal by combining memory-optimized tables with compiled procs.
If screaming speed in data access is the most important thing in your life, SQL Server's durable in-memory, memory-optimized tables are your answer. They were good in SQL Server 2014 and they're even better in SQL Server 2016, 2017 and Azure.
You're not a DBA but you're responsible for managing your organization's SQL Server installation. Here are some tips on what you can do to speed up all your data access.
If you want to speed up your SQL Server queries you need to know how your application and your users actually use your database.
Scott Klein, CTO at Cloud and Devices, explains how enterprises can leverage the built-in intelligence features of SQL Server 2017 to ensure DevOps pays off.