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

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

11. SQL Azure Enhancements -- These don't really go directly with the release of SQL 2012, but Microsoft is making some key enhancements to SQL Azure. Reporting Services for Azure will be available, ...

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.

If you have not created backup or the backup file is not readable, then read this article to know the ways to recover deleted data from MS SQL Server without backup. Ways to Recover Deleted Data from ...