Database Recovery

In-depth Understand of Vertical Partitioning in SQL Server

The article explains in depth the use of Vertical Partitioning in improving the performance and maximizing I/O operations on a SQL server. Vertical Partitioning in SQL Server, an important feature introduced in SQL 2005 Enterprise Edition, is often used to improve the Server’s performance in cases of large data in tables. When a query is used to retrieve all columns form a table that contains wide texts, vertical partitioning comes into picture. So basically vertical partitioning...

Read more »

6 Effective Tips to Protect Your SQL Server from Malicious Ransom-ware

The article explores the potential threats and Ransom-ware issues which endanger the Data on SQL Server and provides a safety guide to overcome such threats. One of the biggest problems enterprises face these days is ransom-ware and the practical consequences of ransom-ware are severe. It is important to be conscious of such threats to maintain the security of the database and protect critical data of your organization from such malicious programs. One should implement a careful strategy to...

Read more »

How Azure SQL Data Warehouse is Redefining Elasticity

The article focuses on Azure SQL Data Warehouse and how it is redefining Elasticity and has become the best choice for leading enterprises. Elasticity is one of the most prominent features of Cloud Computing. It’s the ability to release resources and promptly providing the requirements of workload. Such level of provisioning can save user resources and money in critical situations. It can be achieved with the help of Azure SQL Data Warehouse which is generally available and promises to...

Read more »