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!

Recently in Microsoft SQL Server 2005 Category

Microsoft has so many components to their SQL Server family, the standard pitch on SQL Server never gets old. Awareness is paramount to Microsoft's success as it tries to integrate acqusitions (latest: Tetris, FAST) and keep spreading its wings within existing clients and, really, aren't we all Microsoft clients at some level?

Microsoft's philosophy is "BI should be like electricity, it's just there" and "integrating bi into the world in which people work." This philosophy makes sense in Microsoft's world because Microsoft products are like electricity (i.e., Office). Therefore, BI will surface within the Office environment. For example, there are users of Performance Point who don't know they're using it and think they're just using Excel.

Furthermore, they promote BI in 3 contexts: personal (built by me, used by me), team (built by team, for team) and organizational BI (built by IT for use in company) whereas most vendors only focus on the last context.

Sharepoint is going to be increasingly important for BI. Kristine put it this way: Sharepoint is for delivery, Office/Office PPS 2007 is for end user tools and performance management applications and SQL 2005 is for the RDBMS, ETL, OLAP and reporting.

Finally, I was glad to see some emphasis on, and apparent uptick in usage of, data mining in SQL Server, which could be instrumental in taking information exploitation to new levels.

Technorati tags: Business Intelligence, Independent Analyst Platform, Microsoft, SQL Server

Posted July 11, 2008 8:37 AM
Permalink | No Comments |

Leave it to Microsoft to make technology inexpensive and easy. Quite possibly (i.e., link) Office 14 will begin to include the Stratature Master Data Management (MDM) acquisiton. Microsoft has helped to demystify data warehousing and data mining and now begins to do the same with MDM.

For the MDM market, this is a partial verification and will expose MDM to a wider audience. Those who are opposed to Microsoft philosophically or don't believe it will scale will go elsewise for their tool.

Tools are a start, but can obfuscate the need to address data quality, still the largest impediment to information management success.

Technorati tags: MDM, Microsoft, Office 14, Stratature

Posted September 27, 2007 1:31 PM
Permalink | No Comments |

At the Information Management Conference 2007 in Copenhagen this week, Marin Bezic, SQL Business Intelligence product manager, Microsoft EMEA, provided the following timetables:

Performance Point Server:
April 2007: CTP2
Summer 2007: CTP3
2H2007: GA

SQL Server “Katmai”:
June ’07 (at TechEd US): Public disclosure
Every 60 days thereafter: Public CTPs
2008: GA

The themes for Katmai are mission critical platform, dynamic development and end-to-end business insight.

Posted May 25, 2007 9:21 AM
Permalink | No Comments |

At the Information Management Conference 2007 in Copenhagen yesterday, in response to the question “Will we see Master Data Repository and Data Quality tools from Microsoft?”, Marin Bezic, SQL Business Intelligence product manager, Microsoft EMEA replied, after a pause, “yes.”

Something to look forward to.

Technorati tags: Microsoft, SQL Server, Master Data Management, Data Quality

Posted May 24, 2007 1:26 PM
Permalink | No Comments |

My latest white paper is available at The title is "Choosing Microsoft SQL Server 2005 for Data Warehousing" and it is about choosing Microsoft SQL Server 2005 for data warehousing. ;-)

If you're looking at building a data warehouse, or the rearchitecture of an existing data warehouse, and may consider the Microsoft solution, I go through the various components of Microsoft SQL Server 2005 and place them into a data warehouse environment.

Posted January 23, 2007 12:56 PM
Permalink | 2 Comments |

File this one under the "who didn't see this coming?" category. Or maybe if you have an "it's about time" category, it could go there. Microsoft SQL Server, especially with SQL 2005, is very focused on business intelligence. However, they have been unable to completely provide end-to-end capability. Their Analysis Services cubes need a front-end to be useful to users and the basic one provided with SQL Server was never quite enough.

ProClarity has always focused on this market and have created quite a few different data access and analytical offerings over the years that work with Analysis Services. So, yesterday, Microsoft announced its acquisition of ProClarity. ProClarity offerings have long been recommended to SQL Server clients by Microsoft. Now, it just got easier.

Posted April 4, 2006 10:06 AM
Permalink | No Comments |

As a couple of comments have indicated (link1, link2), the data mining capabilities of SQL Server 2005 are much improved. SQL Server 2000 had decision tree and clustering algorithms.

SQL Server 2005 adds these 5:
Time Series
Sequence Clustering
Naive Bayes
Association Rules
Neural Nets

Through the efforts of Microsoft in SQL Server 2005 as well as others before them like Polyvista, data mining is well on the way to being out of the back room with the scientists and into the hands of the analyst end-user.

Data mining is often the true analytical end result desired, yet many fear the complexities involved and do patchwork mining step-by-step, often bailing out before achieving the desired result or accepting a result with only the limited data that was able to be included without using true data mining.

Both data mining and desktop OLAP should be presented as first alternatives for end users, depending on the requirements of course. Education of end users will be key to acceptance,

Posted October 24, 2005 1:32 PM
Permalink | 2 Comments |

Occassionally, a vendor will come up with a new feature that you didn't think of, but once you see it, you find immediate application for it. Such is the case with 2 new features in SQL Server 2005's SSIS (Integration Services, the successor to Data Transformation Services). They're called fuzzy lookup and fuzzy grouping.

Many of the transformations in the warehouses I've been associated with are lookups. These range from simple matching to the use of some pretty complex rules for data cleansing. While many of these lookups require complete accuracy, many can accept "close enough". Actually, the right answer is often the close match and determining close requires the most complex logic.

Fuzzy lookup searches for "close" matches using its own logic. It creates similarity and confidence scores. Some combination of the 2 can be used to determine your acceptance systemically.

Fuzzy grouping looks at a group of potential records for loading and determines the probability that two (say, customer names) are actually duplicates.

Lookups and de-duplication is a huge ETL effort and I'm sure many Microsoft DW/BI shops will benefit from fuzzy lookup and fuzzy grouping in SQL Server 2005.

Posted October 19, 2005 8:40 PM
Permalink | 1 Comment |

At CSI, we have a Center of Excellence where we put new releases of BI products through the paces in order to stay on top of the market for our clients.

Microsoft SQL Server 2005 is about to live up to its title and get released here in 2005. There are quite a few important advances in this release. For those primarily involved with other database management systems, these enhancements may seem like "it's about time." However, some of these, especially the scalability-related items like 64-bit and addressable memory support and reliability items like security controls and improved failover clustering, that have been used to rule out SQL Server for upper-mid and large (i.e., terabyte) mission critical data warehouses are no longer limitations in SQL Server.

Here's some initial points of interest on SQL 2005.....

· 64-bit platform availability (Intel Itanium2 and AMD x64) maximum addressable memory is 32TB although physical RAM has only been tested to 512 GB – still a significant increase!
· XML data types
· Mirroring
· Triggers
· .NET integration allowing object creation with C#, VB.NET and C++
· Partitioning (with automatic recommendations)
· Failover clustering on up to 8 nodes
· Rebuilding the clustering (table ordering) index no longer causes rebuild of other indexes; incidentally indexes are the topic of my most recent column in DM Review Magazine: “Achieving BI Query Performance”· Bulk loading
· Text Searching with FULLTEXT index
· More granular security controls
· SQL Server Management Studio (combination of former SQL Server Enterprise Manager and Query Analyzer components) allows multiple dialog windows (this is seemingly unimportant on the surface, but adds to usability)

I'll continue this topic in later blogs with more feedback. If you have any feedback or anticipatory comments about SQL Server 2005, post them here.

Posted October 10, 2005 6:59 PM
Permalink | 2 Comments |

One of my assertions recently has been that the business intelligence industry is momentarily distracted by the high end deals. Recent titan acquisitons (Ascential, Siebel) are clearly focused on bringing in the Fortune level customer. We now see some balance being brought into the equation. Microsoft has never neglected the lower end BI customer. Actually, you could say they have not neglected the lower end anything customer.

Microsoft is "on the hunt for SMBs" according to a recent article.

As well, their SQL Server product has always had appeal to SMBs for business intelligence. SQL Server 2005 has a launch on November 7 in San Francisco. Every major city will have an event related to this launch. SQL Server should be released on or about that date. I have been analyzing SQL 2005 for business intelligence and will provide that analysis here at a later date. But I can say that I'm excited about the BI possibilities for SMBs.

Posted September 27, 2005 8:49 AM
Permalink | 1 Comment |

Search this blog
Categories ›
Archives ›
Recent Entries ›