Basic Data Manipulation for Relational Data in R
In this post I will attempt to explore simple commands to manipulate data pulled in from a SQL database into R.
2016-10-20
1,669 reads
Mala Mahadevan
TSQL Tuesday #83 – The Stats update solution
TSQL Tuesday is a monthly blog part hosted by a different blogger every month – it was started by Adam Machanic....
2016-10-11
416 reads
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,952 reads
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
439 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
492 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,607 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
603 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,202 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,542 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
414 reads
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Forums
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers