Sending Trevor love…
As some of you may be aware – fellow SQL family member, PASS Director, SQL Server MVP, founder of SQL Cruise...
2016-10-26
365 reads
As some of you may be aware – fellow SQL family member, PASS Director, SQL Server MVP, founder of SQL Cruise...
2016-10-26
365 reads
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,631 reads
TSQL Tuesday is a monthly blog part hosted by a different blogger every month – it was started by Adam Machanic....
2016-10-11
397 reads
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,943 reads
This is a story of my 11-year association with PASS, and the many ways it helped me grow as a...
2016-09-23
415 reads
I was riding the elevator up from lunch today, at work. I am relatively new at my job and do...
2016-09-23
473 reads
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,401 reads
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
587 reads
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,192 reads
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,463 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers