SQL Profiler

File Folder Location: PROFILER.EXE C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\ Running under a different domain… If you create a cmd file, you might need to copy over the cmd file to the profiler directory and run it from there. To filter to only Stored Procedures… Events -> Check... » read more

Run SSMS Under A Different Domain

SQL Server Management Studio interface will prevent you from using domain other than the one you are currently login as. To use another domain, use a .bat file runas. SSMS 17 SSMS 18 Profiler

Good BI Dashboard Design

1. The 5 Second Rule Your dashboard should provide the relevant information in about 5 seconds. Your dashboard should be able to answer your most frequently asked business questions at a glance. This means that if you’re scanning for the information for minutes, this could indicate a problem with your dashboard’s visual layout. When designing... » read more

BI Scorecards

Whereas a dashboard informs users what they are doing, a scorecard tells them how well they are doing. In other words, a dashboard records performance while a scorecard charts progress. In short, a dashboard is a performance monitoring system, whereas a scorecard is a performance management system. Scorecards offer organizations a snapshot of their current performance when compared to their goals. They are useful tools... » read more

BI Dashboards

A dashboard is a visual display of the most important information needed to achieve one or more objectives that has been consolidated on a single computer screen so it can be monitored at a glance. Dashboards often provide at-a-glance views of key performance indicators relevant to a particular objective or business process.  A dashboard’s objective... » read more

Tableau Products

Tableau Desktop Stand-alone. Called “the gold standard” in visual analytics, Tableau Desktop upended the business intelligence industry and ushered in a new paradigm of self-service insight. Tableau Prep Builder: Prepare your data for analysis Confidently combine, shape, and clean your data with Tableau Prep Builder. Tableau Prep empowers more people to get to analysis faster by... » read more

C# internal

The internal keyword is an access modifier for types and type members. Internal types or members are accessible only within files in the same assembly. The type or member can be accessed by any code in the same assembly, but not from another assembly.

C# enum

In C#, enum is a value type data type. The enum is used to declare a list of named integer constants. It can be defined using the enum keyword directly inside a namespace, class, or structure. The enum is used to give a name to each constant so that the constant integer can be referred using... » read more

Do While Loop

The do-while loop executes the block of code repeatedly. The do-while loop execute the code at least once. It includes the conditional expression after the code block and the increment/decrement step should be inside the loop. Use the break keyword to stop the execution and exit from a do-while loop. An nested do-while loop is allowed.