News
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.
SQL Server 2008 R2 gave us data-tier applications ("DACs") and yet another Visual Studio project type All these database project types can get pretty confusing. And the funny part is that you're still ...
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 ...
Microsoft has released the first release candidate for SQL Server 2025, touting AI capabilities and experimental features ...
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.
As the name implies, the Vulnerability Assessment feature scans Azure SQL databases for a wide variety of security issues, system misconfigurations, superfluous permissions, unsecured data, firewall ...
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.
If you have accidently deleted data from database tables in MS SQL Server, you can restore the deleted data (tables) using Log Sequence Number (LSN). But for this, you need the transaction backup file ...
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 ...
Microsoft announced late last month that it'll be ending support for two SQL Server capabilities, with cloud services and SQL Server 2022 typically proposed as replacements.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results