In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Of course, the most popular class is likely to be “Administering Microsoft SQL Server 2012 Databases” which includes the usual suspects: Install, Configure, Backup, Restore and Troubleshoot ...

By now, you've heard that Microsoft has publicly released SQL Server 2012. I have to be honest in telling you that it came sooner than I expected, despite my many inside connections at Microsoft. I ...

PowerShell offers a lightweight and efficient solution for backing up SQL Server Express databases on local workstations without the need for full system backups.

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.

ExaGrid, the industry's only Tiered Backup Storage solution with Retention Time-Lock that includes a non-network-facing tier (creating a tiered air gap), delayed deletes, and immutability for ...

Microsoft is making available for download a test build of Service Pack 1 for its SQL Server 2012 database, as well as new SQL Azure cloud-database additions.