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,694 reads
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,694 reads
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,779 reads
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,320 reads
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,142 reads
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
17,007 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers