I’m curious by nature and many have shown interest when I connect Power BI to the SQL Profiler to collect performance information, but if you can do that, what happens when you connect it to the SQL Server Management Studio, (SSMS)? That can seem quite foreign, but if you can connect it to the SQL Profiler, you can connect it to the SSMS. Why you can do this is clearly understood when you begin to look underneath the covers of the PBIX file and the processes that run from your desktop. The PBIX File All Power BI files end with…
-
-
Since I reformatted my Surface Pro 4 so I could have my Docker running again, I also needed to recover my local SQL Server instance I like to have available on my PC. This was a perfect time to get everything up and running, but instead of my standard way of doing this, use SQL Server Operations Studio, (SSOS). The Lesson Most SQL Server DBAs have a GUI took to assist in managing their database environment and unlike Oracle DBAs, (at least before multi-tenant and the cloud) it was common for SQL Server DBAs, (on average) to have considerably more…