Associative Statistics – One sample T-Test with TSQL and R
In this post am going to attempt to explore a statistical procedure called ‘One Sample T Test’.
A T-Test is used...
2016-09-30 (first published: 2016-09-21)
1,949 reads
Mala Mahadevan
11 years of PASS Summit
This is a story of my 11-year association with PASS, and the many ways it helped me grow as a...
2016-09-23
426 reads
Why SQL Cruise?
I was riding the elevator up from lunch today, at work. I am relatively new at my job and do...
2016-09-23
485 reads
Statistics with TSQL and R: Chi Square Test
As I move on from descriptive and largely univariate (one variable based) analysis of data into more multivariate data – one...
2016-09-21 (first published: 2016-09-13)
4,590 reads
Budgeting for SQL Saturdays
We’ve been doing SQLSaturdays for eight years at Louisville now. We’ve had a quite a wide range of budgets depending on...
2016-09-13
593 reads
Statistics with T-SQL and R – the Pearson’s Correlation Coefficient
In this post I will attempt to explore calculation of a very basic statistic based on linear relationship between two...
2016-09-08 (first published: 2016-09-05)
3,200 reads
Calculating odds ratio with T-SQL and R
Simple steps towards understanding what is an Odds Ratio, and how do we arrive at it using TSQL and R scripts.
2016-08-30
2,532 reads
Script for creating test data for odds ratio
Make sure you have a working version of SQL Server 2016.
USE [master]
GO
/****** Object: Database [WorldHealth] ******/
CREATE DATABASE [WorldHealth]
CONTAINMENT = NONE
ON PRIMARY
(...
2016-08-16
401 reads
TSQL Tuesday #081 – Sharpening something
This TSQL tuesday is hosted by my good friend Jason Brimhall – Jason has put forth a creative challenge – plan to...
2016-08-10
295 reads
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
613 reads
Blogs
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
Forums
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers