I’ll be honest -- AI inside SQL Server feels a bit odd to me. I’ve spent a couple decades making SQL Server do exactly what I tell it to do, and now Microsoft wants me to let the engine 'think for itself' -- semantic search, AI calls from T-SQL, even Copilot in SSMS. Databases are supposed to be deterministic and predictable. Aren't they? Now we’ve got fuzzy features like vector search, Copilot in SSMS, and T-SQL calling external AI models.
Weird? Absolutely. But is it usable?
- A search that knows 'red shoes' ≈ 'scarlet trainers' ? Useful.
- Survey results summarized without leaving the database? Very tempting.
- A query draft when I’m too tired to type JOINs? There have been some nights...
Yes, it’s weird, and maybe risky -- but it’s here. The challenge for us old-school DBAs isn’t to love it, but to test it, cage it, and identify when it’s worth the ride.
No comments:
Post a Comment