When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

Server is a dual 3.4ghz Xeon w/ 4GB of RAM running Windows 2003 and SQL Server 2000 Standard. Nothing runs on the box other than SQL Server. DB-wise, just the db I'm having problems with [we'll call ...

Promising that developers can "save weeks of development effort," Microsoft today answered their request for database project support in Visual Studio to target Azure SQL Data Warehouse projects.

One of the Azure SQL-related announcements that did not get a lot of publicity at May's Microsoft Build conference was the Azure SQL Database local database experience. With all the hype around SQL ...

Peter shows how a Visual Studio database project can make you more productive when making changes to your database. But a database project also gives you a variety of tools to let you keep track of ...

There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version. For database admins working with older (maybe much older) SQL Server systems, here are four ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Vivek Yadav, an engineering manager from ...

After having taken nearly every opportunity so far to push back the release schedule for SQL Server 2005, formerly known as "Yukon," Microsoft is allowing its SQL Server PASS Community Summit to pass ...