Note – This book abbreviates SQL Server 2008 Reporting Services as SSRS and SQL Server 2005 Reporting Services as SSRS2K5. New features available in SSRS and not in SSRS2K5 are labeled with “New in ...

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

If you are a SQL programmer, learning recursive SQL techniques can be a boon to your productivity. A recursive query is one that refers to itself. I think the best way to quickly grasp the concept of ...

Distributed SQL is an evolution of the database for cloud native, distributed transactions. It can implement a standard SQL interface, ease operational complexity of scale, is geo-replicated, always ...

Microsoft made a series of database announcements at the Ignite conference, including the general availability of SQL Server ...

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work ...

While SQL Server 2008 was little more than a service-pack level upgrade, the 2012 version of Microsoft’s database has a boatload of new features and delivers solid performance improvements.

Microsoft Corp. today announced new cloud-hosted versions of its SQL Server database service as two older on-premises varieties finally will see the end of extended support Tuesday. Having transformed ...

As SQL Server 2005 approaches its scheduled end of life, higher ed must decide what to do with existing SQL Server databases. Brien M. Posey is a freelance technical writer who has contributed to ...