Tag Archives: SQL Server

Time Series Forecasting and Performance

A SQL Server expert asked me a question last February about time series (forecasting) and performance.  I ask other experts all the time about questions I have, and I enjoy answering questions that people send me.  I have not blogged about … Continue reading

Posted in Analysis Services, Query and Response, SQL Server Data Mining | Tagged , | Leave a comment

SQL Saturday 70 Columbia SC Post Event Wrap-Up

I had a good trip to Columbia, SC on March 19.  At the event I presented on the topic “Enterprise Data Mining for SQL Server Professionals”, whose slides and demos are now online.  Based on the free dataset called Contoso … Continue reading

Posted in Analysis Services, Integration Services, SQL Server Data Mining | Tagged , , | Leave a comment

Data Mining Answers for SQL Server Professionals

I received detailed feedback based on my December 6, 2010 presentation Data Mining for SQL Server Professionals. As I posted on this blog, the whole presentation has been archived for video. I intend to continue this type of presentation for … Continue reading

Posted in Analysis Services, Data Mining, SQL Server Data Mining | Tagged | Leave a comment

SQL Server Data Mining and Apollo Columnstore Indexes

Note: This post was revised November 12, 2010 to clarify the brand names Apollo and VertiPaq (thanks Denny Lee of SQLCAT) — and I extended comments on Amir Netz’s C++ versus C# analogy which I believe clarifies the discussion between what … Continue reading

Posted in Analysis Services, Microsoft Business Intelligence, SQL Server Data Mining | Tagged , , , , , , , , | Leave a comment

Migrating to SQL Server 2008

Microsoft claims “SQL Server 2008 delivers exceptional value in Database Management and Business Intelligence causing many customers to choose SQL Server over other database solutions.” — retrieved from http://www.microsoft.com/Sqlserver/2008/en/us/migration.aspx The phrase I agree with is “exceptional value” — though what … Continue reading

Posted in Microsoft Business Intelligence | Tagged , , , | Leave a comment

Introduction to Data Mining in SQL Server 2008

Data Mining with Microsoft SQL Server 2008 Book Review Chapter 1 This book is an essential reference for anyone wanting to use SQL Server for production data mining.  It  overall includes instruction, tips and information which builds on the excellent documentation … Continue reading

Posted in SQL Server Data Mining | Tagged , | Leave a comment