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
Multidimensional Mayhem
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,122 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,011 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,286 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,542 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,946 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,726 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,941 reads
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,420 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers