Impact of Reading from the Transaction Log

Impact of Reading from the Transaction Log

I read a book on data warehousing the other day. The author claimed reading from the transaction log had no impact on the source system. The author might have meant reading from the log doesn't have a significant impact. Reading…

Optimize Data Mining Models with doAzureParallel

Optimize Data Mining Models with doAzureParallel

Neural networks are an awesome modeling technique for finding complex patterns in our data. Most Neural Network R packages will have levers for customizing the model architecture. For example, the R package RSNNS (Stuggart Neural Network Simulator) contains a multi-augment…

Data Mining Workflow

A prerequisite for any data mining project is to understand data flows. The process illustrated below has five basic steps: Pull data Prepare data Split data into training and test sets Train the model Evaluate model Pull Data The data…

In-database Analytics with SQL-Server and R

Starting with SQL server 2016 we can now run our advanced statistical models right where the data lives. The increased proximity increases the efficiency of the resource intensive computations. It’s also a nice feature for developers who want to…

Align TempDB Files with Core Count

If you're suffering from tempDB contention then it may be time to add files to tempDB. The rule of thumb is to have one file per logical processor on servers with <= 8 logic procs. For severs with more than…

Privacy Policy