Configure Windows IIS FTP Server
Create new Windows user. 2. Go to IIS -> Select FTP Site FTP Authentication -> Enable Basic Authentication FTP Authorization -> Allow Read, Write Connect via FTP Client
.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Installing FTP on Windows Desktop
On Windows Desktop (Windows 10, Windows 8, Windows 7 and Windows Vista) Go to Control Panel > Programs > Program and Features > Turn Windows features on or off. On a Windows Features window: Expand Internet Information Services > FTP Server and check FTP Service. Expand Internet Information Services > Web Management Tools and check IIS Management Console, if it is not checked yet.... » read more
Create CSV file
For tab delimited… For tab delimited and exact position…
BI – Business Intelligence
Business intelligence, or BI, is a decision support system. Its aim is to help make business decisions, strategic as well as operational/tactical. Business intelligence is viewed differently by the two groups that use it—business and IT. While IT usually views it as a tool, business views it as information. Concepts and methods to improve business... » read more
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