Descriptive Statistics with SQL and R – II
In the previous post I looked into some very basic and common measures of descriptive statistics – mean, median and mode,...
2016-07-24
614 reads
Mala Mahadevan
Script to create demo database and load data for statistics and R
Make sure you have a working install of SQL Server 2016. The size of the database is only 8 MB.
USE...
2016-07-15
296 reads
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...
2016-07-14
1,105 reads
Basic Statistics with SQL – Introduction
I was a student of statistics in school and college. I didn’t get to use much of anything I learned...
2016-07-10
675 reads
TSQL Tuesday #75 – PowerBI
This month’s TSQL Tuesday post is from one of my favorite people in the community – Jorge Segarra a.k.a. SQL Chicken. It...
2016-02-17
446 reads
Advent of Code – Day 2 – Using Cross apply
For this post i worked on second puzzle in the Adventofcode series. This wasn’t as challenging as the first one, but...
2016-02-02
298 reads
Advent of Code – Day 1 – Parsing a variable
I have been following the series of posts written by my friend and SQL MCM Wayne Sheffield on some TSQL...
2016-01-19
260 reads
Comparing data in two identical tables
Continuing with the recipes in SQL Server 2012 T-SQL recipes book – I was drawn to this puzzle that asked for...
2015-12-14
822 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers