SSMS may also be used to build our database projects, which involves creating or altering database objects as well as viewing and modifying the data stored in these databases. You can simply design database components and view/modify data in database tables with Azure Data Studio. * Profile SQL Server on-premises and in the cloud, and without installing anything on the profiled instances.We used to utilize SQL Server Management Studio( SSMS) as the most common Graphical User Interface tool for administering our SQL Server instances in our data center or in the cloud. Import this file into applications such as Microsoft Excel with minimal user interaction. Save the chosen settings and options, and the results of the profiling to a tab-delimited plain text file. For a selected column, display the list of unique values, their count, and their relative occurrence. Profile the distribution of the values in each column. View Summary of Value Distribution per Column These recommendations refer to modifying the data type to accommodate the data better, handling sparse columns, migrating columns to reference or lookup tables, adding foreign key constraints, and more for a total of 37 recommendations. Receive Recommendations Based On Data per Columnĭisplay recommendations based on the data contained in a selected column. For each column, show the name, data type, statistics, and more for a total of 19 properties. For the table, display the number of columns and rows, the last modification date of the data and schema, and the size of the table. Display Summary of Data in Selected Table and Its Columnsĭisplay a summary of the data contained in a selected table and each of its columns. Set the thresholds for suggesting reference tables, possible anomalies, and different data types. Modify the settings of the profiling operation. Adjust Profiling Thresholds to Customize the Analysis For example, initially only profile core elements and subsequently analyze specific areas of interest. Focus on these data types to reduce the time to analyze large data sets and the number of displayed results. Select the types of data to include in the profiling of the database table. Export results to plain text file formatĬonnect to an instance of SQL Server, select a database, and select a table to profile the data contained in the table and its columns.View summary of value distribution per column.Receive recommendations based on data per column.Display summary of data in selected table and its columns.Adjust profiling thresholds to customize the analysis.Analyze subsets of data types at a time.Consequently, data profiling can eliminate costly errors in databases. Data profilers analyze and summarize data to produce valuable insights into data patterns. As such, data profiling tools can turn raw data into business intelligence. Analyze data patterns in database columnsĭata profiling is an important component to ensure data quality to maintain the value of the data.

Azure data studio sql profiler