Blog

Host SQL Server Database in a Windows Azure Virtual Machine

A new feature in SQL Server 2014 and above allows you to deploy a database directly to a Windows Azure Virtual Machine, enhancing the organization’s hybrid-cloud experience.

By Admin

Buffer Pool Extension in SQL SERVER 2014

The Buffer Pool Extension (BPE) uses your hard drive to improve the way data moves around. This feature targets nonvolatile storage devices (e.g. SSD drives) as an extension for SQL Server Buffer Pool.

By Admin

Storing SQL Server Data Files in Windows Azure

If you need a highly available, disaster-proof and secure way to store your media or documents, consider adding your SQL Server Data Files to Windows Azure.

By Admin

Memory Optimized Tables

When creating a database, it is a common practice to link tables that are related. However, when large or complex data is populated into these tables, the query speed may begin to decrease.

By Admin

Data Recovery

One of the SQL Server benefits is the presence of built-in tools to manage data and database backups. Imagine if you had a Microsoft Access database and it was deleted. There is no good way to get your information back. With SQL Server, you have the ability to schedule regular backups of the database. These back-ups could be stored in a separate location for disaster recovery.

By Admin