In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

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.

To start the Local SQL Server on your computer, open the Services app by searching it out of the Start Menu. Now, search for SQL Server, right-click on it, select Properties, set the Startup type ...

Unlike the previous version of SQL Server, SQL Server 2000 lets you specify collations for almost any task, at virtually every level within a database — from table column to SELECT statement.

Can you restore the backup to a local SQL server, then export the data from there? Can you connect to the SQL server using Management Studio?

More from Microsoft's lead SQL architect about how telemetry data is helping the company deliver regular, highly requested and targeted feature improvements at a massive scale.