Blog

6 min read

Standards for SQL Server Configuration and Maintenance

Standardization of common SQL Server maintenance tasks is a crucial aspect of efficient management of a MS SQL environment.

4 min read

Hekaton Helps Build Faster Databases In 3 Ways (Part 3)

One nifty thing about Hekaton in SQL2014 is its seamless integration into the existing SQL Server product.

6 min read

Hekaton Helps Build Faster Databases In 3 Ways (Part 2)

Think back to a time before Google, Wikipedia, and the internet -a time even before computers- and imagine a library.

3 min read

Hortonworks Data Platform for Windows Bridges Hadoop, Windows

The Hortonworks Data Platform for Windows — commonly known as HDP for Windows — was created by Hortonworks and Microsoft.

4 min read

Hekaton Helps Build Faster Databases In 3 Ways (Part 1)

In SQL Server 2014 Microsoft introduces In-Memory-OLTP, also known as Hekaton.

3 min read

Extending the Buffer Pool in SQL Server 2014 Increases Performance

One means of increasing your database’s performance is integrating high-speed solid-state drives with the data buffer pool extension found in Microsoft SQL Server 2014.

7 min read

Max Server Memory and the 300 Second Rule

Up until recently the commonly understood and accepted ideal number for page-life-expectancy (PLE) for a SQL Server instance was 300 seconds (5 minutes) or greater.