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
603 reads
Mala's Data Blog
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
281 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,096 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
666 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
439 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
291 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
249 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
679 reads
Blogs
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Monday Monitor Tips: Lots of Postgres Options
By Steve Jones
Redgate Monitor is growing to include more than just Microsoft SQL Server monitoring. We...
Forums
Diagnosing and Resolving High Remote Query Costs in Local Stored Procedure Execu
When a remote query consumes 99% of the cost of a local stored procedure...
Hash Joins IV
Comments posted to this topic are about the item Hash Joins IV
How to Load a Fabric Warehouse: Data Engineering with Fabric
Comments posted to this topic are about the item How to Load a Fabric...