Early discussions on SQL Server 2008 seemed to suggest that it would really only be a point release, quite unlike what occurred with SQL Server 2005. Anyone looking at the new and upgraded features in ...

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 ...

I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users.

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.

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 ...

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.

Have you implemented SQL Server 2000 Reporting Services since it became available earlier this year? If so, we’d love to hear about your experiences, both good and bad.

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.

Microsoft Corp. will make one of its most lucrative products, a version of its SQL Server database program, available to users of the Linux operating system, a move beyond the company’s own ...