Data profiling refers to the process of examining, analyzing, reviewing and summarizing data sets to gain insight into the quality of data. Data quality is a measure of the condition of data based on ...

Power BI experts discuss ways to preserve data types with queries, optimize CPU usage, and connect with Power BI Premium User with SQL Profiler. Chris Webb built off a recent blog topic about enabling ...

The much-used Microsoft SQL Profiler is a tool headed toward obsolescence. What options are available once the tool is deprecated? We examine SQL Server Extended Events as a possibility. The ...

One of the dreaded error codes we get in the SQL log is the “1205”. It represents the infamous deadlock where two transactions are locking each other out. No way ...