Connecting SQL Server Profiler to Power BI Desktop

Connecting SQL Server Profiler to your Power BI Desktop Analysis Services Instance One of my favorite methods of better understanding any database structure or application is to connect SQL Profiler and inspect the events being executed. Now that I’ve been using Power BI Desktop extensively over the past couple months, I have started to run…

1

Windows Server 2012 / 2012 R2 – Logon restricted to members of Local Administrators group

Within one of the SQL Server environments that I support, we recently experienced a Windows Server 2012 operating system crash followed by a situation where the SQL Server 2012 service was unable to start with the following error message: Error message 7038 – The MSSQLSERVER service was unable to log on as NTSERVICE\MSSQLSERVER with the currently configured password…

0

Transparent Data Encryption (TDE) stuck in State 2 – Encryption in Progress

Another day, another interesting troubleshooting scenario with SQL Server 2012.  In this case, a customer was attempting to enable Transparent Data Encryption (TDE) on a couple SQL Server 2012 databases.  The process went smoothly until they encountered an issue with a single database.  The problem database in this case was about 50 GB in size,…

5

SQL Server 2014 Service Pack 1 Unattended Setup Error – "The specified value ‘Upgrade’ is invalid"

SQL Server 2014 Service Pack 1 Unattended Setup Error – “The specified value ‘Upgrade’ is invalid”   I was recently sent a question regarding a failed unattended install of SQL Server 2014 Service Pack 1.  The customer had spent some time searching online for the error message, but found surprisingly little detailed information for unattended…

4