Fuzzy Lookups (Matching) and Fuzzy Grouping using Microsoft Integration Services (SSIS)

A beginner’s guide to SQL: An introduction to the 5 most commonly used pieces of SQL code

Managing Type 1 Slowly Changing Dimensions (SCD) Using T-SQL

Merge Statements in T-SQL

Window Functions in T-SQL

Temporary Tables in T-SQL

Creating Association Rules using the SQL Server Data Mining Addin for Excel

Creating Subqueries in Microsoft SQL Server (T-SQL)

Logical query processing in SQL Server

Table Joins in Microsoft SQL Sever

Indexes in SQL Server -- making queries run faster

Cloud Based Scorecards using Tibco Spotfire Sliver - Tutorial 2

Introduction to spatial queries in SQL Server 2012

Stored Procedures in SQL Server

Applying Data Mining Models with SQL Server Integration Services (SSIS)

Tuning SQL Server Integration Services (SSIS) packages so they run faster.

Building a Tabular Data Warehouses in SQL Server Analysis Services (SSAS) 2012

Creating Cloud Based Scorecards & Dashboards Using Tibco Spotfire Sliver Tutorial 1- The basics

Creating a Subreport using Microsoft SQL Server Reporting Services (SSRS)

Adding Grouping and Drill down to SQL Server Reporting Services Reports (SSRS)

Adding Totals and Subtotals to Microsoft Reporting Services Reports (SSRS)

Introduction to Transact SQL (T-SQL) using Microsoft SQL Server

Business Intelligence Demonstration using Microsoft SQL Server & PowerPivots

Using SQL Server Integration Services (SSIS) to load a SQL Azure table

Creating a SQL Server Reporting Services (SSRS) report that contains a Parameter Query

Creating a SQL Server Reporting Services (SSRS) report with drill down functionality.

Creating a Cluster Model using the Excel Addin for SQL Server

Creating prediction queries using the SQL Server data mining add in for Excel

Using Profit Charts in SQL Server 2008 to Optimize Marketing Campaigns.

Using Lift (Accuracy/Gains) Charts to Evaluate Data Mining Models in SQL Server 2008