Regular readers of Data Quality Pro will know that we have created a free pattern analyser that currently works with Excel, Microsoft Access and Oracle formats.

Thanks to one of our members this has been extended to included SQL Server, the code is now available in T-SQL format.

Free Data Quality Pattern Analyser Now Available for SQL Server

Steven Peirsman, a BI consultant from ICT specialists RealDolmen has kindly converted the script into the new format and we have now loaded this into the free software folder in the download centre:

http://www.dataqualitypro.com/download-centre/software/

You need to be a registered member and logged in to access this folder. If you're not already a member than don't worry this is completely free and it takes about 30 seconds to register.

• Register (free)
• Login
• Free Data Quality Software Directory

Please note, if you modify or improve the function at all then why not let us know so we can pass on the benefits to other members.

Want to see a video of how to use pattern analysis on some real data? Check out this recent video tutorial:

Using Pattern Analysis to Detect and Prevent Defective Product Codes

Have you used any of our free data quality tools? How have they helped you? We would really like to hear how members are benefiting from these type of tools so please add your comments below or contact us.

Useful Resources

Free Data Quality Pattern Analyser for Oracle: Update Available

Need to trap data defects in Oracle? Download this free data quality pattern analyser

Using Pattern Analysis to Detect and Prevent Defective Product Codes

Free pattern analysis tool for Excel

Data Quality Assessment Tutorial: Pattern Analysis in Excel

Data Quality Pattern Analyser for Microsoft Access

Data Profiling Tutorial, includes full free software

Data Quality Skills Tutorial: Learn how to profile and validate data (for free) using this DataCleaner tutorial