Microsoft announced a roadmap shift, indicating that it will focus on supporting Open Database Connectivity for SQL Server application programming interfaces in the near future. The shift is of ...

Microsoft's early embrace of advanced AI in its dev tooling continues apace with the new public preview of SQL database in Microsoft Fabric, the company's analytics/data platform. Fabric is a ...

For as long as I can remember, I have always configured the computers within my own organization to store data on network servers as opposed to the data being stored on workstations. That way, if one ...

As mentioned in my post on VLDBs, one of the key pieces of a high performing solution is the use of Read-only Filegroups. If a significant part of your data is not changing, then why not tell SQL ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

CAMBRIDGE, United Kingdom--(BUSINESS WIRE)--Red Gate Software has released a new tool called SQL Object Level Recovery Native that enables individual database objects to be recovered from native SQL ...

Use the Microsoft Sync Framework to synchronize data changes between SQL Server 2008 Standard, SQL Server 2008 Express and SQL Server Compact Edition 3.5. Despite the availability of wireless and ...

Pity the poor modern DBA, now that SQL Server gets attacked by some of the same scripts that PCs do. Pity the poor modern DBA who has to keep building Microsoft SQL Servers because some idiot vice ...

Microsoft has released a temporary fix for a known issue impacting Windows apps using ODBC database connections after installing the November 2022 Patch Tuesday updates. As the company revealed in ...