A Rickety Stairway to SQL Server Data Mining, Part 10.2: DMX DML
by Steve Bolton
The three introductory posts in this series of self-tutorials on SQL Server Data Mining (SSDM) and the...
2013-03-26
2,219 reads
A Rickety Stairway to SQL Server Data Mining, Part 10.1: DDL with DMX
by Steve Bolton
As users become more familiar with software, they typically follow a progression that begins with learning the...
2013-03-14 (first published: 2013-03-11)
3,127 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 9: Time Series
by Steve Bolton
The data mining method known as Time Series is aptly named, because it seems to take a...
2013-02-26
3,123 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 8: Sequence Clustering
by Steve Bolton
In last week’s edition of this amateur series of self-tutorials[i] on SQL Server Data Mining (SSDM), we...
2013-02-21
2,015 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 7: Clustering
by Steve Bolton
In last week’s installment of this amateur series of self-tutorials on SQL Server Data Mining (SSDM), we...
2013-02-19 (first published: 2013-02-12)
3,291 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 6: Association Rules
by Steve Bolton
In last week’s installment of this series of self-tutorials on SQL Server Data Mining (SSDM), we covered...
2013-02-07
2,547 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 5: The Neural Network Algorithm
by Steve Bolton
Anyone who has been following this series of self-tutorials has probably grown accustomed to me adding some...
2013-01-30
2,947 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 4: Logistic Regression
by Steve Bolton
In the last installment of this series of self-tutorials on SQL Server Data Mining (SSDM), A Rickety...
2013-01-23
2,727 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 3: Decision Trees
by Steve Bolton
This series of self-tutorials is an elementary-level introduction to SQL Server Data Mining (SSDM), not the product...
2013-01-16
2,943 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 1: Not-So-Naïve Bayes
Thankfully, the simplest of SQL Server’s algorithms is not quite as naïve about data mining as I am.
As mentioned...
2013-01-09 (first published: 2013-01-04)
6,689 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers