A Rickety Stairway to SQL Server Data Mining, Algorithm 2: Linear Regression
An algorithm that starts with the word “regression” seems an unlikely candidate to move forward with this series of self-tutorials...
2013-01-08
4,423 reads
A Rickety Stairway to SQL Server Data Mining, Part 0.2: How to Dig Out of a Data Mining Cave-In
This third part in my series of self-tutorials in SQL Server Data Mining (SSDM) was delayed for several weeks due...
2013-01-03
1,911 reads
A Trip Down the Rickety Stairway…
I’ve had to delay my series of self-tutorials on data mining for a few weeks following an antibiotic resistant infection...
2012-12-24
758 reads
A Rickety Stairway to SQL Server Data Mining, Part 0.1: Data In, Data Out
In the first of a series of amateur tutorials on SQL Server Data Mining (SSDM), I promised to pull off...
2012-11-28
7,129 reads
A Rickety Stairway to SQL Server Data Mining, Part 0.0: An Introduction to an Introduction
As I mentioned in my column in June, one of the many lessons I learned at the first-ever SQL Saturday...
2012-11-15
5,497 reads
Another Stop-Gap Solution for the SQL Server 2012 Identity Crisis
I haven’t seen this many fake ID’s since I was in college.
Back on April 26, Grant Fritchey (of execution...
2012-10-24 (first published: 2012-10-16)
5,123 reads
A Novel Workaround for an Infamous SSAS Connection Error
For months I’ve been itching to get the latest version of SQL Server, thanks to the addition of new functionality...
2012-08-28
1,884 reads
SQL Saturday in Rochester Exceeds Expectations
After being forced to deliver sour grapes in my last few columns – thanks to some unexpectedly negative experiences with Oracle...
2012-05-29
1,761 reads
Thank God I Chose SQL Server part II: How to Improperly Install Oracle 11gR2
As part of my ongoing effort to teach by bad example and pass on what little I’ve learned about programming...
2012-05-01
3,545 reads
Thank God I Chose SQL Server part I: The Tribulations of a DB2 Trial
My last column, Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong, described a comedy of...
2012-03-31
3,666 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