blogs.conchango.com

Browse by Tags

• Books Online
• Data Profiling
• Dataflow Task
• fuzzy
• fuzzy logic
• Grouping Sets
• katmai
• lookup
• Microsoft
• Microsoft Connect
• Scripting
• SQL Server
• SQL Server Integration Services
• SQL Server Management Studio
• SSIS
• SSMS
• T-SQL
• video
• Web Services

• Fuzzyness

  SQL Server 2008 is introducing some interesting querying and storage enhancements such as the introduction of spatial data and the FILESTREAM attribute on VARBINARY(MAX) columns and my thoughts have recently turned to what querying enhancements we are Read More... Posted 21 May 2008 07:57 by jamie.thomson | 6 Comments Filed under: SQL Server, SSIS, Microsoft, sqL server 2008, fuzzy, fuzzy logic

• SSIS: Data Profiling Task: Part 9 - Value Inclusion

  In this blog entry I am going to outline the function of the Value Inclusion profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Computes the overlap in the values between two columns or sets of columns. Read More... Posted 07 March 2008 05:23 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• SSIS: Data Profiling Task: Part 8 - Candidate Key

  In this blog entry I am going to outline the function of the Candidate Key profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports whether a column or set of columns is a key, or an approximate Read More... Posted 04 March 2008 04:21 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• SSIS: Data Profiling Task: Part 7 - Functional Dependency

  In this blog entry I am going to outline the function of the Functional Dependency profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports the extent to which the values in one column (the dependent Read More... Posted 03 March 2008 03:44 by jamie.thomson | 5 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• SSIS: Data Profiling Task: Part 6 - Column Value Distribution

  In this blog entry I am going to outline the function of the Column Value Distribution profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports all the distinct values in the selected column and Read More... Posted 03 March 2008 02:19 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• SSIS: Data Profiling Task: Part 5 - Column Statistics

  In this blog entry I am going to outline the function of the Column Statistics profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports statistics, such as minimum, maximum, average, and standard Read More... Posted 02 March 2008 22:49 by jamie.thomson | 4 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• SSIS: Data Profiling Task: Part 4 - Column Pattern

  In this blog entry I am going to outline the function of the Column Pattern profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports a set of regular expressions that cover the specified percentage Read More... Posted 02 March 2008 21:24 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• SSIS: Data Profiling Task: Part 3 - Column Null Ratio

  In this blog entry I am going to outline the function of the Column Null Ratio profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports the percentage of null values in the selected column. This Read More... Posted 02 March 2008 20:58 by jamie.thomson | 6 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• SSIS: Data Profiling Task: Part 2 - Column Length Distribution

  In this blog entry I am going to outline the function of the Column Length Distribution profile request in the new Data Profiling Task in SQL Server 2008. BOL states about this profile request: Reports all the distinct lengths of string values in the Read More... Posted 02 March 2008 20:18 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• SSIS: Data Profiling Task: Part 1 - Introduction

  The February CTP of SQL Server 2008 delivered a usable version of the Data Profiling Task that is being introduced into SQL Server Integration Services 2008. I am putting together a series of blog entries that highlights the functionality available with Read More... Posted 02 March 2008 20:13 by jamie.thomson | 17 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, katmai, sqL server 2008, Data Profiling

• Katmai bug fixes

  There's some good news filtering into my inbox today about SQL Server bugs that have been fixed in the upcoming CTP (i.e. CTP6). Title: SSIS: Raw files throw an error at 4GB Description: It is not possible to load more than 4GB of data into a raw Read More... Posted 19 December 2007 18:41 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, SSMS, SQL Server Management Studio, katmai, sqL server 2008

• Why datetime2?

  In SQL Server 2008 a new datatype will be introduced that can support storing of date values from the year 0001 to 9999. This new datatype is called datetime2 . OK, so tell me what's wrong with the following picture: smallint, int, bigint smalldatetime, Read More... Posted 24 October 2007 15:32 by jamie.thomson | 7 Comments Filed under: SQL Server, sqL server 2008

• SSIS: Big improvements to Lookup in SQL Server 2008

  I awoke this morning to find my inbox full of automated replies from msftconn@microsoft.com thus indicating that someone on the SSIS team has been busy updating many of my submissions to Connect . Generally it was the usual "Closed, Won't Fix" update Read More... Posted 21 August 2007 20:25 by jamie.thomson | 9 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task, sqL server 2008, lookup

• More T-SQL Goodness in SQL Server 2008 (codename katmai)

  Back in June I talked about some T-SQL enhancements that are coming our way in SQL Server 2008. One of those things is the ability to define multiple rows in an INSERT statement like so: insert t1 values (@i),(@i+1); Very cool stuff. Some people seem Read More... Posted 17 August 2007 20:33 by jamie.thomson | 2 Comments Filed under: katmai, Microsoft Connect, sqL server 2008, SQL Server, T-SQL

• SSIS: new enhancements in Katmai CTP4

  The fourth Community Technology Preview (CTP4) of SQL Server 2008 (nee Katmai) has been released. Taken straight from BOL, there are some new SSIS data types in CTP4 of katmai: DT_DBTIME2 A time structure that consists of hour, minute, second, and fractional Read More... Posted 01 August 2007 05:46 by jamie.thomson | 4 Comments Filed under: SSIS, katmai, sqL server 2008