You can use [!INCLUDE[ssSqlProfiler](../../includes/sssqlprofiler-md.md)] to create templates that define the event classes and data columns to include in traces ...

SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our current ...

Notifications You must be signed in to change notification settings The first script SP_ReplaceFileOrDirNames.sql has to be ran first in order for the main script to work This first Script creates a ...

Any serious Power BI developer should have it installed already, but if you have an older version you may need to update it to get the features I talk about in this post. You can generate SQL Server ...

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

Back in December when I wrote a series of posts on testing the performance of Power BI reports in the browser, I mentioned that it was important to test in the browser because some aspects of the ...

"For years, DBAs asked for a simple way to gather and view SQL events data in real-time," said Josh Stephens, Vice President of Product Strategy at Idera. "We're excited to give DBAs a free solution ...