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

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

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

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

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

Your browser does not support the audio element. SQL Profiler is a great tool that allows you to see what’s going on inside SQL Server. You can find out what your ...

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