There used to be few good options for a DBA with a bunch of systems stuck on SQL Server 2008. But thanks to one easy trick, businesses on aging infrastructure can take advantage of Microsoft's modern ...

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

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

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.

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

Poke around the infrastructure of any startup website or mobile app these days, and you’re bound to find something other than a relational database doing much of the heavy lifting. Take, for example, ...

You don't tug on Superman's cape, you don't spit into the wind, you don't pull the mask of that old Lone Ranger, and you don't run Microsoft SQL Server on Linux (with apologies to the late Jim Croce).

If you’re building a Microsoft .NET network and you have an Oracle database, you should migrate it to SQL Server. It is not a question of which is better but of which one is the right tool for you. In ...