According to a recent press release, “Resecurity today announced that its six-year effort to create the first comprehensive index of the dark web is on track for completion by 2020. The project, which began in stealth mode in 2014 and dives deeper into the hidden recesses of the internet than any previous undertaking, is expected […]
My Stock Market Index Dashboard with R, Plotly, and the Plotly Cloud
Click here to learn more about author Steve Miller. It’s been difficult for me to ponder my 2016 stock index dashboard this week, the markets roiled by the turmoil of Brexit taking a toll on my fragile investment psyche. Alas, I dutifully update the underlying data and run the visualization daily, hoping for the best […]
Foreign Keys and the Delete Performance Issue
Eventually you’ll run into a simple delete instruction that takes minutes (I mean, years!) to get executed. It’s just a hundred-row table, and, still, it takes a lifetime to get the rows deleted. Here’s a small tip: you’re probably missing some indexes. Foreign Keys and their dirty secrets There is a very basic, yet very […]