We use cookies and other similar technologies (Cookies) to enhance your experience and to provide you with relevant content and ads. By using our website, you are agreeing to the use of Cookies. You can change your settings at any time. Cookie Policy.

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 wmcknight@mcknightcg.com.

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

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 |


Enhancement of data mining tools, with five more algorithms having been added.

These five new additions are:

Naive Bayes
Association Rules
Sequence clustering
Time Series
Neural Networks

making data mining tools available and usable to SQL Server DBAs as the original Decision Trees and Clustering algorithms were there but not much usable.

Leave a comment


Search this blog
Categories ›
Archives ›
Recent Entries ›