Blog: William McKnight Subscribe to this blog's RSS feed!

William McKnight

Hello and welcome to my blog!

I will periodically be sharing my thoughts and observations on information management here in the blog. I am passionate about the effective creation, management and distribution of information for the benefit of company goals, and I'm thrilled to be a part of my clients' growth plans and connect what the industry provides to those goals. I have played many roles, but the perspective I come from is benefit to the end client. I hope the entries can be of some modest benefit to that goal. Please share your thoughts and input to the topics.

About the author >

William is the president of McKnight Consulting Group, a firm focused on delivering business value and solving business challenges utilizing proven, streamlined approaches in data warehousing, master data management and business intelligence, all with a focus on data quality and scalable architectures. William functions as strategist, information architect and program manager for complex, high-volume, full life-cycle implementations worldwide. William is a Southwest Entrepreneur of the Year finalist, a frequent best-practices judge, has authored hundreds of articles and white papers, and given hundreds of international keynotes and public seminars. His team's implementations from both IT and consultant positions have won Best Practices awards. He is a former IT Vice President of a Fortune company, a former software engineer, and holds an MBA. William is author of the book 90 Days to Success in Consulting. Contact William at

Editor's Note: More articles and resources are available in William's BeyeNETWORK Expert Channel. Be sure to visit today!

January 2008 Archives

On March 10, I will be giving my Introduction to Data Warehousing course and on March 11, I will be giving my Introduction to Master Data Management for the Enterprise course. Both are full-day courses. Both will be held live at SetFocus in Parsippany, NJ. However, they will both be available on "The GRID", which means you can be ANYWHERE in the world and attend remotely. It's very cool technology - you will feel "in the class." Information on The GRID can be found at this link.

Posted January 26, 2008 10:00 AM
Permalink | No Comments |

It's occurred to me that there are 2 areas that continually need work in my clients' data governance/steering (and data stewardship) programs. This work comes AFTER the participants are selected and usually after the programs are engaged.

1. The IT team really has no interest in being advised on what to do in the first place
2. No 2 governance members can agree on what that advice should be anyway

Make sure the IT team is accountable to the advisement from governance and make sure that governance includes a sponsor attuned to this (#2) reality and empowered to foster collaborative advice.

Posted January 16, 2008 12:41 PM
Permalink | 2 Comments |

Continuing the awards for the “best of” information management tools for 2007, I move to the proverbial “back end” and offer up some “best of” products that provide the foundations of our environments. Thinking back over the products I’ve worked with in 2007, I have to repeat my belief that it was the “Best of” year in information management.

Best Open Source DBMS

MySQL Enterprise Fall 2007 Release – This is the commercial subscription offering for the popular MySQL open source database (which makes it “low cost” not free – for those who associate open source with free). It includes a comprehensive set of production-tested software, proactive monitoring tools, and premium support services for corporate developers and DBAs. MySQL provides a full suite of database drivers and graphical tools to help developers and DBAs build and manage their MySQL applications.

Best Data Warehouse Appliance

I take this opportunity to say there is no ‘best’, only best for a given situation because indeed there are many with good value propositions.

Best Federated Query Facilitator

SQL Farm Combine 1.9 – While I still believe a proper data warehouse is necessary in modern information architecture, as a stopgap or bridge measure, you may need to query multiple SQL Server databases without co-habitating the data. With SQL Farm, users can query multiple databases and SQL servers or instances, receive one result set from all data sources, and save the aggregated results to relational databases or data warehouses.

Best Data Warehouse SMB storage

Sun StorageTek 2530 array – I like it’s Common Array Manager software, which was designed to be an un-intimidating implementation for an unseasoned administrator and leverage the same look and feel from Sun’s server management software.

Best Data Warehouse Prototyping Tool

WhereScape 24 - WhereScape 24 is installed on data warehouse developer PCs and connects to both data sources and the target data warehouse database and generates native Teradata, Oracle and SQL Server scripts.

Best “Next Product I need right now” – Email me. Architecture and Tool Selection, Development and Planning is one of our offerings.

Technorati tags: data-warehouse, data-warehouse-appliance, wherescape,mysql,sql-farm,2530,open-source,dbms

Posted January 2, 2008 1:50 PM
Permalink | 2 Comments |

Search this blog
Categories ›
Archives ›
Recent Entries ›