"It's really about choice," Rohan Kumar, Microsoft's General Manager, Database Systems, told me yesterday as he briefed me on the new offerings. Kumar further explained: "if you're a developer, you ...

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 ...

There are times as a developer that you will want to be able to delete all the data from a database as efficiently as possible. Unfortunately, doing so may not be as easy as it seems. There are times ...

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 changed ...

Hey All,<BR><BR>Got a question regarding 2 sprocs I need to make (once I get the first one done the other will be easy cause its just the opposite). Here's the deal: I have a database with table ...

Microsoft recently updated SQL Server Data Tools (SSDT) with support for Visual Studio 2012, improved LocalDB functionality and new SSDT Power Tools. SSDT, if you're unfamiliar with it, is a ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...