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
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Forums
Where Your Value Separates You from Others
Comments posted to this topic are about the item Where Your Value Separates You...
Fixing the Error
Comments posted to this topic are about the item Fixing the Error
T-SQL in SQL Server 2025: Encoding Functions
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Fixing the Error
On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:
SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error? See possible answers