Series and Other Blog Contributions

This page provides links to series I am working on in my blog. It also contains any postings to other blogs that I regularly contribute to.

Blog Series on DataOnWheels

Series Name	#	Title/Link	Date
X on XMLA	0	Introducing “X on XMLA”	1/19/2012
	1	i. Using XMLA	1/26/2012
	2	ii. Basic Structure of XMLA	3/27/2012
	3	iii. Basic DDL Functions in XMLA (Create, Alter, Delete)	4/10/2012
	4	iv. Deploying Databases with XMLA	6/19/2012
	5	v. Creating XMLA Script from Visual Studio and Deploy the Database	6/26/2012
	6	vi. Processing and Out-of-Line Bindings in XMLA	9/19/2012
	7	vii. Partition Management with XMLA	10/10/2012
Oracle Tips for MSBI Devs	1	Executing an Oracle Stored Proc with No Parameters in SSIS Execute SQL Task	3/4/2012
	2	Keyword compare between Oracle and SQL Server	4/17/2012
	3	Choosing Drivers	4/24/2012
	4	Executing an Oracle Stored Proc with IN Parameters in SSIS Execute SQL Task	5/1/2012
Excel 2013 BI Tips		Exploring Excel 2013 as Microsoft’s Business Intelligence Client	2/4/2013
	1	Quick Explore	2/8/2013
	2	Show Details	2/13/2013
	3	Flash Fill	3/15/2013
	4	Adding a Slicer	3/28/2013
	5	Cleaning Up Slicers	3/29/2013
	6	GeoFlow-The Latest Excel Visualization	4/11/2013

Blog Posts on Magenic.com

Post Title	Post Date
Microsoft Data Appliances Lower the Entry Bar for MSBI Adoption	1/26/2012
Why I Am So Excited about SQL Server 2012 (Part 2)	3/28/2012
Excel 2013′s Impact for BI Users	7/17/2012
BI Summit Recap and BI Twitter Updates	8/27/2012
Business Intelligence for Financial Services (Video)	11/1/2012
Magenic at PASS Summit 2012	11/26/2012
Excel 2013 – Microsoft’s BI Tool and Why You Should Use It	1/30/2013
Magenic Takes SQL Server Training International	3/4/2013
SQL Saturday in the Philippines Follow Up	3/15/2013

Blog Posts on LessThanDot.com

Post Title	Post Date
Choosing an Analysis Engine	6/21/2012
T-SQL Window Functions – Part 1: The OVER Clause	9/6/2012
T-SQL Window Functions – Part 2: Ranking Functions	9/11/2012
T-SQL Window Functions – Part 3: Aggregate Functions	9/17/2012
T-SQL Window Functions – Part 4: Analytic Functions	9/25/2012