Blog : What’s On Our Mind?

Sharing Our Point of View
By Bill Mitalski | On May 21st 2015
DBA 101: What’s the Difference Between a Table and a Heap?
If you are a database administrator working in a SQL environment, and are also intent on becoming a proficient or power SQL user, there is one very basic concept you’ll need to understand: what is the difference between a table and a heap? Knowing the difference between these two objects will help you understand how SQL works. When you understand what tables and heaps are, you will understand the very foundations of how data is stored. This…
By John Kaufling | On May 20th 2015
Tuning ETLs
Coming up on Thursday, May 28, our senior applications tuner Chuck Ezell will present a webinar on Tuning Your ELTs for Better BI. His presentation offers high level ideas on how to tune ETLs to reach the two main goals for tuning your ETLs for better performance; enhance speed and consistency. Here is a sneak peek at what some of the presentation will cover. What is ETL? Extract data Transform data Load transformed data An ETL extracts data from a variety of sources, often performing…
By Craig Mullins | On May 19th 2015
Sometimes I will use this blog to post answers to questions that have been sent to me. The question being answered today, is this: I have a select query that returns 1000 rows and I want to display the rows from 200 to 500. Could you please let me how to code after the where clause? I know how to get the first 100 rows using — FETCH FIRST 100 rows only clause.  If you are using DB2 V7 or…
By Owens Gollamandala | On May 4th 2015
Integrating SharePoint with Microsoft Project
In addition to using SharePoint for creating a flexible corporate intranet, you can also use it as a bridge to Microsoft Office products and files. Many users don’t realize how seamlessly SharePoint integrates with other Microsoft products, yet it is precisely this integration and interoperability across the Microsoft technology ecosystem that makes it useful for completing all sorts of tasks and projects efficiently within an organization. With Microsoft Project, for example, you can take a list of tasks already in Project and sync those…