Message from MarkTab
After years of graduate education and even more years of professional experience (with SAS and Microsoft), I still find data mining an awesome and challenging topic. I use this blog to share my best tips and achievements learned sometimes through great struggle. Today, I provide data mining advice to leading companies and industries in the United States and around the world. I share my journey and insights at leading conferences like SAS Global Forum, Microsoft TechEd, and Predictive Analytics World.
As I continue learning, my hope is to inspire you to not just learn more but also apply mathematics through technology. Data mining is a powerful tool for leaders of leaders of leaders. If you like this blog, click the "About" page to find out how to go deeper. -- Mark Tabladillo ("MarkTab")- by
Category Archives: Integration Services
MarkTab Reviews Data Mining Chapter
I was happy to receive my copy of Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 in the mail last weekend. The book is about using the entire Microsoft BI (Business Intelligence) stack to build enterprise-level … Continue reading
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 enterprise, SQL Saturday, SQL Server
Leave a comment
Setting Windows 7 and Windows 2008 R2 Firewall for SQL Server 2008 R2
I discovered that, in upgrading my home network, I had not set SQL Server 2008 R2 to allow for remote connections. Opening Windows Firewall in Windows 7 (any version) or Windows 2008 R2 requires making some choices. Having searched for … Continue reading
Data Mining with SQL Server Integration Services (SSIS)
Data Mining with Microsoft SQL Server 2008 Review Chapter 14 So last week was about Analysis Services, and the most relevant cousin technology to data mining within the Microsoft BI stack. This week is about Integration Services, what I conisder … Continue reading
Using SQL Server Integration Services to Load Data
Microsoft SQL Server 2008 Analysis Services Unleashed Review Chapter 22 This chapter discusses leveraging SQL Server Integration Services to load data into a cube. If you have Analysis Services you also have Integration Services, no additional licensing required. However, you may have … Continue reading
Posted in Analysis Services, Integration Services
Tagged dimension, optimization, partition, SSIS
Leave a comment
English