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

Learn how to use SQL Server Profiler to export a trace template as a template file so you can use the template with another instance of SQL Server Profiler. This topic describes how to export an ...

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

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

SQL Trace and [!INCLUDE ssSqlProfiler] are deprecated. The Microsoft.SqlServer.Management.Trace namespace that contains the Microsoft SQL Server Trace and Replay objects are also deprecated. [!INCLUDE ...

In an earlier blog I talked about the difference in mentality between the typical developer and the typical DBA. One of the characteristics of the DBA is the distrust of the Microsoft Wizards. “Give ...

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

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.3! Download SSMS 17.3 and review the Release Notes to get started. SSMS 17.3 provides support for almost all feature ...