Wednesday, March 4, 2020

Amazon Seller Central Customer Search Term Keyword Performance

›
Amazon has used data science and machine learning to a great benefit for themselves but has not shared those tools down to the seller to ...
Thursday, November 21, 2019

Rapid Query Store Growth

›
I recently had a problem that our Query Store size growth increased dramatically. Our initial size was 512MB and this was sufficient for ...
Thursday, November 14, 2019

Maximize Resumable Indexes

›
Resumable Indexes were a new feature introduced with SQL 2017. At first glance it didn't make sense why I would want to modify our ma...
Friday, October 18, 2019

R Market Basket Analysis for Product Recommendations

›
After attending the Data Science Dojo boot camp I was looking for projects to give a quick return on the investment in training. Since there...
Thursday, August 23, 2018

SQL 2017 R Insert Into Database Table

›
I've recently been down the data science path and integrating R and some measures into our analysis stack. Moving from R Studio to SQL...
Tuesday, March 21, 2017

Microsoft Performance Dashboard Reports for AWS RDS

›
We have recently made our first foray into AWS for running SQL server. My first impression was, " What happened to my sa account!?!?...
Monday, November 7, 2016

Change Power BI Report from DirectQuery to Import

›
I have a report that I wanted to quickly publish to share with our CEO as a Power BI dashboard. The problem is that we do not have a gateway...
1 comment: