Descriptive Statistics with SQL and R – 1

I started my re-discovery of statistics with an introduction here. This second post is about descriptive statistics – very basic, simple...

SQL Server CTE – Back to Basics

Of all the fundamental concepts within SQL Server, this one drives me a bit batty from time to time. Think about that statement for just a moment.
Related Posts:

T-SQL Tuesday...

SQL Server CTE – Back to Basics

Quick Flashback
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...

SQL Server Indexing Book Giveaway – Week 6 (Index Myths)

And now for something not so different with week 6 of the Expert Performance Indexing for SQL Server book giveaway.  So far, I’ve sent out five copies of the book based on comments from...

SQL Server Indexing Book Giveaway – Week 6 (Index Myths)

And now for something not so different with week 6 of the Expert Performance Indexing for SQL Server book giveaway.  So far, I’ve...

Getting Table Change Scripts–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Altering a column in a large table: A case study

Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to...

Get Your Email Out of my ETL

Question from someone in one my recent classes: “What tool do you use to send email from ETL processes?” My...

Live From @LearningTree London Backup and Restore - Day 3

This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the LEC in London. Following on from last weeks...

SQL Server Desired Enhancements

SQL Server 2016 has come with a ton of cool features, bells, whistles and well cool stuff (yes redundant). That aside, what are some of the really cool features...