Data Mining Part 29: Programming with C# and AMO
In this article, we will show some debugging tips for working with C# and the AMO code for working with Analysis Services and the Data Mining Models.
2015-06-16
2,440 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
Data Mining Part 28: Programming with AMO and VB
In this article we will use VB.NET to connect to our Mining Models.
2015-06-04
4,369 reads
Data Mining Part 28: Programming with AMO and VB
In this article we will use VB.NET to connect to our Mining Models.
2015-06-04
4,154 reads
Data Mining Part 27: Microsoft Data Mining with Cubes
In the chapter 26 we created a cube. Now, we are going to create the Data Mining Model from it.
2015-04-27
3,756 reads
Data Mining Part 27: Microsoft Data Mining with Cubes
In the chapter 26 we created a cube. Now, we are going to create the Data Mining Model from it.
2015-04-27
3,556 reads
Data Mining Part 26: Introduction to Cubes
In this tutorial we will explain what are the SSAS cubes to use them in Data Mining.
2015-04-21
4,393 reads
Data Mining Part 26: Data Mining and Microsoft Azure
This article shows a step by step tutorial to create a virtual machine in 15 min on Windows Azure.
2015-03-12
2,692 reads
Data Mining Part 25: Microsoft Visio Add-Ins
In the chapter 18-22 we explained how to work with Microsoft Excel to Access to the Data Mining information. This time, we will explain how to work with Microsoft Visio.
2015-03-05
4,267 reads
Data Mining Part 25: Microsoft Visio Add-Ins
In the chapter 18-22 we explained how to work with Microsoft Excel to Access to the Data Mining information. This time, we will explain how to work with Microsoft Visio.
2015-03-05
3,853 reads
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
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
Comments posted to this topic are about the item Faster Data Engineering with Python...
Which Result II
Comments posted to this topic are about the item Which Result II
JSON Has a Cost
Comments posted to this topic are about the item JSON Has a Cost, which...
Question of the Day
Which Result II
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
exec('SELECT ProductName FROM product;')
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers