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 ...

When using SQL Server Profiler, keep in mind: Only database events are available for a Power BI Premium workspace. Server events are not available. Trace definitions are stored with the Analysis ...

When it comes to performance impact, Query Store and Profiler have different footprints on SQL Server. Query Store has a relatively low impact on database performance because it collects data ...

A few months ago a new option was added to the Sql.Database and Sql.Databases functions in Power Query in Power BI and Excel which allows Power Query queries that combine data from different SQL ...

Leveraging query profiling is crucial for identifying and addressing database inefficiencies. By employing tools like MS SQL Server Profiler,MySQL's EXPLAIN statement or PostgreSQL's EXPLAIN ...

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 ...

Other profiling tools have richer features (which you’ll pay for); but a SQL Server licence allows you to use this modest profiling tool at no extra cost.. Let’s explore the tool by profiling ...