Kimball ETL (subsystem 1) – Data Profiling via TSQL
This script will generate a report providing all normally expected statistics for data Profiling .(ie.. Min, Max, Unique Count, Pattern etc....)
2014-02-12 (first published: 2012-05-21)
4,147 reads
Ira Whiteside
Advanced SSIS Fuzzy Matching via Record Linkage Methodology
Greatly improve SSIS Fuzzy Grouping performance by using a Conditional Split and Multi Cast.
2012-07-05
7,970 reads
Master Data Services - SSIS MDM Load
The article will provide an overview of Master Data Services and a sample SSIS Package.
2010-03-02
10,273 reads
Dynamically Map Column Data Based on Column Pattern Profiling
Tutorial on using Script Component, Regular Expression and derived Column Transform to dynamically map different source column types into the appropriate target column for address data.
2010-02-23
3,374 reads
Roll Your Own Fuzzy Match / Grouping (Jaro Winkler) - T-SQL
Roll Your Own Fuzzy Match / Grouping (Jaro Winkler) - T-SQL
2009-06-10
45,462 reads
Providing Operational Analytics via Microsoft Analysis Services, Infor
This article will review the processes for providing Operational Analytics via Microsoft Analysis Services, Informatica and Qlikview
2009-06-03
2,003 reads
Data Profiling Column Functional Dependency T-SQL
This article demonstrates Data Profiling Functional Dependency
2009-05-20
4,557 reads
Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)
Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)
2009-03-04
11,384 reads
Extending SSIS Part 2 - SSIS Programmatically / Dynamically Building Packages
We bring you part 2 of a series on SSIS programming from Ira Whiteside and Actuality Business Intelligence. This article shows you how to dynamically build a package using code.
2008-10-10
18,555 reads
Extending SSIS Part 1 - Creating a Custom Data Flow Transformation Component
In part one of this series from Actuality Business Intelligence, Ira Whiteside brings us a look at building your own SSIS transformation.
2008-07-30
17,371 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers