A small social media poll from Visual Studio guru Mads Kristensen split respondents over whether the IDE should add more database tooling, while the discussion quickly turned to existing SQL project support, SDK-style SQL projects and the broader state of Microsoft's database developer tooling.
At the upcoming Visual Studio Live! Las Vegas developer conference, SQL expert Denny Cherry will share essential indexing strategies to boost performance in SQL Server databases--from 2000 to 2025. Here, Denny explains more about his session in which .NET devs can learn best practices, common mistakes, and how to optimize apps with smarter indexing.
Managing SQL Server across hybrid and multi-cloud environments has long posed a challenge for database administrators. To help meet that challenge, Gilda Alvarez will explain the nuts and bolts at the upcoming Live! 360 dev/tech conference
Microsoft PM Carlos Robles previews his Live! 360 Orlando session on how recent updates to the MSSQL extension—like GitHub Copilot integration, Schema Designer, and local SQL containers—are transforming SQL development inside Visual Studio Code. Designed for developers, not DBAs, the session showcases how VS Code can streamline database work and unify application and SQL workflows in one tool.
Microsoft updated the free MSSQL extension for Visual Studio Code with public preview support for browsing Microsoft Fabric workspaces and provisioning SQL Database in Fabric from within VS Code, plus GitHub Copilot slash commands and reliability fixes; the extension also supports connecting to SQL Database in Microsoft Fabric via the standard connection experience.
Bring AI to your database! Learn how to build smarter apps with vector search in SQL Server & Azure Cosmos DB -- no extra AI stack required.
SQL development is evolving fast, and Microsoft's Drew Skwiers-Koballa will explain it all in a featured session at the VS Live! @ Microsoft HQ developer conference being held at the company's Redmond campus in August.
Microsoft experts are making the rounds educating developers about the company's new, opinionated, cloud-ready stack for building observable, production ready, distributed, cloud-native applications with .NET.
In announcing SSMS 21 Preview 1 this week, Microsoft revealed Copilot AI for the tool is also being previewed, privately.
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.