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

Microsoft added the option of using the Azure Backup service to provide recovery support for SQL Server 2008 and SQL Server 2008 R2 when those workloads are hosted on Azure virtual machines.

One of the great new features of SQL Server 2008 is called Transparent Data Encryption. Data encryption was introduced into the Database Engine in SQL Server 2005, so why is 2008 so much better?

Policy-based management improves database performance.Beta Man SQL Server 2008: Administration Simplified Policy-based management improves database performance. By Peter Varhol 12/01/2007 The four ...

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

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

With Microsoft SQL Server 2008 R2, Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at ...

Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth ...

And if you install SQL Server 2008 CTP, you should know that you can't read SSCE 3.1 files using the 2008 Management Studio. The point to remember is this: VS/SQL2008 = Compact 3.5, and VS/SQL 2005 = ...

With Microsoft SQL Server 2008 R2, Microsoft begins to fully realize its vision of SQL Server as an information platform and not “just” a database.