Author
Microsoft Power BI vs Tableau
Power BI Tableau Cost Power BI Pro: $9.99/monthPower BI Premium: $4,995/month Tableau Creator: $70/month Desktop Yes, Free Yes, Free for Students Cloud Yes, Power BI Pro Yes, Tableau Online On-Premises Yes, Power BI Premium Yes, Tableau Server Embedded Yes, Power BI Embedded Yes, Tableau Embedded Analytics
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
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