CTS – Your Technology Partner

An Introduction to Microsoft SQL Server 2016 Service Pack 1

Written by Scott Fountain on January 17, 2017

In November 2016, Microsoft released SQL Server 2016’s first service pack (SP1). SP1 includes new functionality along with typical improvements and fixes. With SP1, features exclusive to SQL Server’s Enterprise Edition are now available to lower editions (Standard, Web, and Express). In this post, we will discuss the following SP1 highlights: Enterprise-level features available to…

Continue Reading


4 Strategies to Improve Performance Time with SAP Data Services

Written by Dwight McCants on December 14, 2015

SAP Data Services delivers a single enterprise-class solution for data integration, data quality, data profiling, and text data processing that allows you to integrate, transform, improve, and deliver trusted data to critical business processes. It has many advantages but there are some challenges that can occur.  In this blog, I will give an overview of…

Continue Reading


How A Challenging BI Project Succeeds Pt. 2

Written by Radha Mukkai on November 30, 2015

As promised in my earlier blog post, here is Part 2 of How A Challenging BI Project Succeeds.  In my first post, I discussed our many challenges.  This post will focus on how we overcame those challenges. Simply put, we were successful because of solid project leadership, talent, and process (discipline). Let us walk through each factor….

Continue Reading


How a Challenging BI Project Succeeds Pt. 1

Written by Radha Mukkai on November 16, 2015

In case you have not heard yet, big BI projects can have a high rate of failure. I could tell you the many reasons why these projects can fail, but I’d rather explain why this one didn’t.  I think we can learn a lot more from what went right in this project instead of what…

Continue Reading


The Times They Are A Changin’

Written by Matt Jones on June 23, 2015

The Times They Are A Changin’, by the great Bob Dylan, was the anthem of social and musical change in the 1960s. This song signaled the start of a social revolution whose effect we still feel today. If you do not already realize it, we are in the midst of change within the IT and…

Continue Reading


Informatica PowerCenter: Indirect File Source

Written by Kaiesha Ford on June 30, 2014

In the Informatica PowerCenter, there are two ways to load a flat file into a Target definition: Direct and Indirect. You can set the Source File type to ‘Direct’ when loading a single flat file. ‘Indirect’ Source File type is when you need to load multiple flat files. When implementing the ‘Indirect’ file type, users…

Continue Reading


SQL Server 2014 – Columnstore Indexes

Written by Kathleen Kennedy on June 27, 2014

The columnstore index, a feature in SQL Server’s Database Engine, received updates and a major addition in SQL Server 2014. Columnstore indexes debuted in SQL Server 2012 as a solution for slow data warehouse queries. What is a columnstore index? A columnstore index is a technique for storing, retrieving, and managing table data that is…

Continue Reading


SQL Point and Business Intelligence

Written by Elizabeth Hutson on February 10, 2014

What on Earth is SQL Point? SQL Point is a word that we at CTS like to use to describe the marriage of SQL 2012, SharePoint 2013, and all the new BI features therein to provide rich, graphical data visualization that helps end users quickly analyze and understand their business. The features include data visualizations,…

Continue Reading


Data Discovery Enablement

Written by Matt Jones on January 30, 2014

“Our $$$$$$$$$$$ Data Warehouse sucks and it does not have the information I need to do my job!” “It will take HOW long to add that information to my report?” Unfortunately, today these are sentiments expressed or felt by many business users across the world. For years, IT has been getting a black eye for…

Continue Reading


Big Data: Not Really a Hard Concept

Written by Matt Jones on January 30, 2014

Friday, January 17, 2014 1,160,000,000 Google results in just the last month . . . If you are like me every time I pick-up a magazine or browse technology / business news it seems like someone is talking about “BIG DATA”. Whether you’re looking for trends, tools, ideas, training, false promises, hype, IT nightmares and…

Continue Reading