Data Mining Part 24: SQL Profiler and Data Mining
In this chapter we will detect the Data Mining activity using SQL Server Profiler.
2015-02-09
3,050 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
Data Mining Part 23: Security
In this chapter we will talk about security recommendations for SQL Server Data Mining.
2015-01-27
2,280 reads
Data Mining Part 23: Security
In this chapter we will talk about security recommendations for SQL Server Data Mining.
2015-01-27
2,173 reads
Data Mining Part 22: Analyze the Data Mining Data with Excel
This is the last article related to Data Mining in Excel. This last chapter will cover the Analyze section.
2014-11-24
3,057 reads
Data Mining Part 22: Analyze the Data Mining Data with Excel
This is the last article related to Data Mining in Excel. This last chapter will cover the Analyze section.
2014-11-24
2,793 reads
Data Mining Part 21: Excel and Data Mining,validation methods
This article is part of the lesson 18 to 20 related to SQL Server Data Mining with Excel.
2014-11-18
3,280 reads
Data Mining Part 21: Excel and Data Mining,validation methods
This article is part of the lesson 18 to 20 related to SQL Server Data Mining with Excel.
2014-11-18
3,266 reads
Data Mining Part 20: Excel and Data Mining,accuracy, forecasting
In the lesson 18 and 19 we worked with Data Mining Models.
In this new chapter we will work with more algorithms and show how to test the accuracy of the model.
2014-11-11
3,849 reads
Data Mining Part 20: Excel and Data Mining,accuracy, forecasting
In the lesson 18 and 19 we worked with Data Mining Models.
In this new chapter we will work with more algorithms and show how to test the accuracy of the model.
2014-11-11
3,644 reads
Data Mining Part 19: Excel and Data Mining, Samples, Queries
This lesson explains how to Clean Data, Explore Data, get Samples of Data, Classify and query a Data Mining Model.
2014-10-28
16,481 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers