Blog

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

List View and Data Pager Control in Asp.net

Paging in a website plays a vital role in web application development. The default paging supports in asp.net are Grid View and DataGrid. The page control “Datapager” was introduced in asp.net 3.5 version. Datapager will work only when the IPageableItemContainer interface is implemented.

By Admin