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. I ...
I've been playing around with the new SQL Server Data Tools, and although many have complained about missing features compared to the "Data Dude" Visual Studio projects and other tools that SSDT ...
In this second delve into data cleanliness (read the first, How clean is your data?, here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server. Other profiling tools have ...
Having spent the last article showing how we can use WMI to perform a query for the current space on a drive, we need to take a it a step forward and begin tracking this data in a way that we can then ...
Microsoft on Wednesday announced the release of SQL Server 2019 release candidate (RC), but it was later updated to a new "refresh" verions (called "RC 1.1") per an August 29 post. The bits can be ...
JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...
Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target. Logging is an essential feature for any application, as it is ...
The daily routine of an IT professional remains largely reactive. A lot of time and budget is spent responding to tickets, limiting the time that we spend creating systems that drive growth and ...
At Microsoft's Ignite digital event this week, the company is announcing the private preview of SQL Server 2022, the next version of its three-decades-old relational database management system (RDBMS) ...