Opinionsql serverllmembeddingsenterprise databases
SQL Server Adds App-Level Features Increasing Costs
7.4
Steve Jones argues that SQL Server 2025's new features, including REST endpoints and built-in vector/LLM capabilities, enable application-style tasks such as sending emails and generating embeddings. He warns that triggers and in-database LLM calls can overload expensive database cores—given Standard Edition limits (24/32 cores) and high per-core Enterprise pricing—and recommends offloading such workloads to app servers.
Key Points
- 1Introduces REST endpoints and vector/LLM integration in SQL Server 2025 for in-database AI.
- 2Raises licensing and CPU-cost concerns because Standard Edition core limits and per-core pricing are expensive.
- 3Encourages offloading emails, LLM calls, and embedding generation to app servers to avoid bottlenecks.
Scoring Rationale
Highlights cost and scaling risks for in-database AI, but relies on editorial perspective and limited empirical data.
Sources
Public references used for this report.
Practice with real Logistics & Shipping data
90 SQL & Python problems · 15 industry datasets
Used by DS/ML engineers at top companies
High-Value Overnight OrdersEasyDelivered International ShipmentsMediumOn-Time Delivery Rate by CarrierHard
250 free problems · No credit card
See all Logistics & Shipping problems
