Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

Use saved queries as opposed to SQL statements as the data sources for Access objects. The wizard will create a corresponding SQL Server object for each saved query.

A new SQL Server 2025 feature lets organizations run vector-based semantic searches on their own data, connecting to local or cloud-hosted AI models without relying on massive general-purpose LLMs.

An interesting session I attended at the PASS Summit in Seattle was one concerning dealing with VLDBs in SQL Server. It was called “Big Data – Working with Terabytes in SQL Server” presented ...

We have an ancient AS/400 730 system that still houses some old budget/financial data. We'd like to decommission this box, and migrate the data to a SQL server. The data won't be modified or ...

The next-gen SQL Server is Microsoft’s most feature-rich database offering to date, boasting almost completely retooled business intelligence innards, including a revamped ETL capability (the new SQL ...

As the name implies, the Vulnerability Assessment fea­ture scans Azure SQL databases for a wide variety of security issues, system misconfigurations, superfluous permissions, unsecured data, firewall ...