Standard Deviations with CTE in SQL

I was working with a client recently getting the number of standard deviations a student was off the average number...

R skills attract the highest salaries #r #getpaid4stats

Two recent salary surveys have shown that R language skills attract median salaries in excess of $110,000 in the United...

SQL Saturday OKC 309!

SQL Saturday OKC is coming up!
The event will be August 23rd, 2014!

Now is the time to get signed up. We...

Oracle Tips for MSBI Devs #5: Working with Oracle on Windows Azure

As you have likely noticed in my series, Oracle Tips for MSBI Devs, I have done a lot of work...

February '14 Acadiana SQL Server User Group

I am honored to be the very first presenter of the new PASS chapter in Lafayette, Louisiana this Tuesday, presenting...

February '14 Data Architecture Virtual Chapter Meeting

I will be speaking and whiteboarding for Data Architecture Virtual Chapter meeting on February 27, 2014 on the fitting topic...

Deep learning might make your Netflix recommendations a lot better

Streaming video giant Netflix is experimenting with the advanced artificial intelligence method commonly known as deep learning, it explained on...

Rebuild all indexes on all tables in the SQL Server database

One of the key tasks of a DBA is to maintain the database indexes and make sure they are not...

AzureCAT Chalk Talks at Strata 2014 #azure #Azurecat #strata

This week the AzureCAT team is excited to make our first team appearance at the Strata conference. For those of you...

Removing part of string before and after specific character using Transact-SQL string functions

Problem
Today, one of the developers come to me and asked me the question that is there any T-SQL function that...