With end of support looming for Windows Server 2008 and SQL Server 2008, Microsoft has a new option for those users to keep getting security updates: By moving workloads to Azure.

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server.

Practical App SQL Q&A: Users Questions Answered Exploring distributed transactions, performance counters and SQL backups. By Paul S. Randal 04/01/2010 Q: We use a lot of distributed transactions ...

Some Microsoft users say that the ability to write code for SQL Server 2005 in general-purpose .Net languages may lead them to change their approaches to database programming. But other IT ...

SQL Server 2008 R2 will be available as part of Microsoft’s Small Business Server package. That version has the same features as the standard edition, but is limited to 75 users.

Only three of Nasdaq Stock Market Inc.'s 30 developers have expertise in using the native programming language for Microsoft Corp.'s SQL Server database. So for two major upcoming IT projects, the New ...