Category Archives for "SQL Administration"

May 13

In-Memory OLTP (Hekaton)

By Lori Brown | SQL Administration , SQL Server

 Available in SQL Server 2014 Enterprise Edition In-Memory OLTP is a new lock-free, latch-free, optimistic concurrency approach to storing data in memory. While it may seem reminiscent of DBCC PINTABLE is it definitely not the same since data in memory-optimized tables is not organized in pages, and does not use the Buffer Pool. It is […]

Continue reading
Apr 23

Prerequisites for Installing SQL Server AlwaysOn

By Ginger Daniel | Installation , SQL Administration , SQL Server

Before implementing your AlwaysOn Availability Group, make sure you have everything in your environment ready to go. There are several prerequisites that need to be done to ensure a successful deployment. These prerequisites focus on your Windows environment, the SQL instances, and the databases to be included in your AlwaysOn group. Windows: Windows Server 2008 […]

Continue reading