Brexit – Economic Impact Simulation
The following simulation shows why the Brexit may not be a good idea. Assume you have several hundred projects across europe and a few experts in each country to deliver them. Companies usually try to model and optimize the assignment of experts to projects. It is quite interesting to see that adding new political constraints
Automated Tracing with BAT File
The following script can be used to start an extended event trace and start the workload at the same time. (copy past to a workload.bat file) START cmd.exe /C sqlcmd -S.\SQL2016 -iscript1.sqlSTART /MIN /WAIT cmd.exe /C sqlcmd -S.\SQL2016 -itrace.sql START cmd.exe /C sqlcmd -S.\SQL2016 -iscript1.sqlSTART /MIN /WAIT cmd.exe /C sqlcmd -S.\SQL2016 -itrace.sql
SQL 2016 R Integration – Install Custom Packages – unable to access index for repository
To install custom packages like ggplot2 in the RTM Version of SQL Server 2016 as described in the R Script below you have to disable the following Outbound Firewall Rule on the SQL Server! “Block network access for R local users accounts in SQL Server instance SQL2016” Create procedure [dbo].[get_iris_plot1] asbegin — Demonstrate how
Use Power BI to trace SQL Server RPC Calls and correlate them with Wait_info
The following code creates an extended event session that correlates wait_info and stored procedure (RPC calls) and allows you to analyze the data using Power BI. Make sure to configure your right logfile path (where the Extended Event file is written) Also enable xp_cmdshell to allow the script to cleanup the logfiles after the trace