The Empirical Rule
I am resuming technical blogging after a gap of nearly a month. I will continue to blog my re learning...
2017-03-02 (first published: 2017-02-27)
2,485 reads
I am resuming technical blogging after a gap of nearly a month. I will continue to blog my re learning...
2017-03-02 (first published: 2017-02-27)
2,485 reads
As some readers may know, I am a regular attendee on SQL Cruise s for 8 years now. SQLCruise is...
2017-02-19
610 reads
I have always maintained a private bucket list. I have not had the courage to actually put it down in...
2017-01-13 (first published: 2017-01-02)
1,912 reads
This article is a case study and an attempt to explain an interesting phenomenon with data anomalies that is commonly called Simpson's Paradox.
2017-01-10
3,681 reads
2016 has undoubtedly been a landmark year in my life. To me it marked my first conscious entry into mid...
2016-12-31
799 reads
SQL Server 2016 does not allow computed columns to co exist with columnstore indexes and clustered btree indexes on same table.
2016-12-29
860 reads
So far I’ve worked on simple analytical techniques using one or two variables in a dataset. This article is a...
2016-12-05
920 reads
In the previous post we looked at a one way T-Test. A one way T Test helped us determine if...
2016-11-25 (first published: 2016-11-21)
2,472 reads
2016 is going to be a special year in my life. There was an article on Oscar awards a while...
2016-11-04 (first published: 2016-10-31)
1,709 reads
Today is Thursday, October 27th already. For some of us the summit begins monday – with precons and PASS Volunteering related meetings...
2016-10-27
392 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