Jason McKittrick's Blog

SQL RDBMS

AlwaysOn Availability Group Capacity Planning

There are a number of factors to consider when undertaking the capacity-planning phase for your AG environment. One such factor is the amount of resources each replica will require to provide appropriate performance for the system. To work this out, you need to take into account not only the normal activity that your environment will…

AlwaysOn 2014 Enhancements from AlwaysOn 2012

Recently one of my customer was looking for detailed information on SQL Server AlwaysOn 2014 Enhancements.  Below is a good list of product enhancements that I put together listing enhancements in SQL 2014 AlwaysOn from what was available in SQL 2012. If you are looking to install a new version of SQL to get AlwaysOn setup from…

SQL Server 2014 CTP 1 – Hekaton

Hekaton is the new SQL Server 2014 In-Memory database technology.  It is going to change the way we architect databases going forward. Decisions about which data or tables go into memory and which ones will function in the SQL Inter-Op mode.   Until we get a ton of detail here is a simple Hekaton ST-SQL Script…

SSIS Logging Framework

The need for a Logging Framework for SSIS packages to track and log activity within ETL (Extract, Transform, Load) processes. This blog outlines the database schema, stored procedures and implementation practices within SSIS packages to be utilized for the SSIS packages used for the data applications.  I will build and use a sample package load of Regions…