Data Profiling with T-SQL
Need to understand new data? This article explains why - and how you can profile it efficiently
2013-02-25
18,947 reads
Data Profiling
2014-01-28 (first published: 2013-01-16)
2,229 reads
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,046 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,100 reads
Using The Data Profiler Task and FTP Task in SQL Server 2008 Integration Services
See how the data preparation tasks within SSIS can be used to retrieve data or to validate the quality of data.
2009-05-28
2,252 reads
Data Profiling Column Functional Dependency T-SQL
This article demonstrates Data Profiling Functional Dependency
2009-05-20
4,197 reads
New data profiling tools in SQL Server 2008
New data-profiling tools native to SQL Server 2008 Integration Services such as the Data Profiling task and the Data Profiler Viewer help manage a business intelligence strategy.
2009-02-06
3,213 reads
Viewing the Data Profiling Task Data - SQL School Video
It can be helpful in ETL operations to know what the distribution of your data is. Brian Knight shows how to use the Data Profiling task in this video.
2009-01-27
5,110 reads
Data Quality and Data Profiling
David Loshin describes the benefits of the combination of the bottom-up aspects of data profiling with a top-down analysis phase for establishing criteria for data quality management.
2009-01-01
2,313 reads
RE: Select from system object from the msdb database
i don't know what do you think ?you could limit him futher to just the sysjobs(*) tables ...
2004-05-06
Blogs
Daily Coping 2 Feb 2023
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Why Managed Identities are Awesome
For the first workdays of this new year, I had the pleasurable task of...
Forums
Can you help me understand what this stored procedure call returns?
Definition of stored procedure create procedure [dbo].[smGetMinDate] @O_dMinDate datetime = NULL output as...
Restrict available values from one parameter per othr parameters selected values
Hello Have created a simple 9 column report where there are 7 (multi valued)...
Dimensional table and Stored Procedure
To meet these requirements below, I came up with this SQL. Please evaluate my...
Ask SSC