This article collects useful data profiling SQL queries for SQL Server that allow you to discover data and test its quality. Those queries can be used by anyone that has access to the database and has ...

To use profiling tools and optimize SQL queries: Choose a suitable profiling tool for your database system. Connect to the database through the tool. Configure the tool to capture relevant data ...

Query profiling is a technique that helps you analyze the performance and resource consumption of your database queries. It can help you identify and fix database inefficiencies, such as slow ...

SQL Server 2008 Integration Services ships with the wonderful new Data Profiling Task. Much as the name implies, it profiles the data in a given table and returns a ton of useful information. The task ...

The profiling should complete successfully – indicated by a green box in SQL Server 2008, or a green tick in SQL Server 2012. If you see a red box or a red cross, then the Progress tab can help ...

Once you receive source data extracts, you’re ready to prepare the data for profiling. As a tip, loading data extracts into a database structure will allow you to freely write SQL to query the data ...

As of the November update of Power Query, it’s now possible to write your own SQL query when you’re moving data out of SQL Server into Excel using Power Query. So I got thinking… if you can write your ...

In Control Panel, double-click Administrative Tools and then double-click Data Sources (ODBC). (Alternatively, you can run odbcad32.exe from the command prompt.) Click the User DSN, System DSN, or ...