What is normal? Finding outliers with R
How do you currently set alerting thresholds? What is normal? And more importantly, what is truly abnormal? We will explore these questions.
2017-06-13
1,489 reads
Nick Burns
Combining R and SQL Server to diagnose performance bottlenecks
Using clustering algorithms to analyse index usage data from SQL Server’s DMVs & simplify complex performance investigations.
2017-05-29 (first published: 2015-12-07)
9,568 reads
Using R to Identify Key Features Quickly
Typical BI dashboards display data summaries like counts and averages. We use R to extend on these to identify key associations in a dataset.
2017-01-09
2,313 reads
Beyond prediction with R & SQL Server
Predictive / prescriptive analytics is regarded the highest level of advanced analytics. In this post, we emphasise the importance of exploratory analytics to derive meaningful insight.
2016-08-18
2,102 reads
Adding an Article Without a Full Snapshot
Have you got transactional replication in your SQL environment? Do you need to add a new table to your publication, but can't afford the time necessary to create a full new snapshot? Here is a step-by-step guide. Thankfully, adding a single table is easier than I thought.
2015-01-05
12,218 reads
Blogs
Enabling an Index: #SQLNewBlogger
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers