I'm doing some development on a dev server of ours for a site that's currently live on another server. They have their own server with a SQL Server database holding the data for the live site. So ...

SQL Server can do on-the-fly transaction replication, but it's intensive. You'd need to compare the cost of TS compared to another SQL server box and the amount of work to get it working.

An improved interface and new features make SQL Server 2005 a promising upgrade Microsoft has released the second beta of SQL Server 2005, and it looks to be a major step forward.

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.