Data Mining announcement
-
Link
Microsoft BI Labs went live today featuring a look into the future of SQL Server Data Mining in the Cloud. The SQL Server Data Mining team presents a set of prototype web services in the cloud that mirror some of the great predictive analytics functionality available in the Table Analysis Tools for Excel add-in from the SQL Server 2008 Data Mining Add-ins for Office package. No installation required.
This blog post provides more details.
Explore these predictive services from your browser - on your own data - and give us your feedback!
-
0 Votessys.sp_databases SP gives me an error on execution.
This is the error I get when I attempt to run this SP: Msg 208, Level 16, State 6, Procedure sp_databases, Line 2 [Batch Start Line 7] Invalid object name ...Answered | 3 Replies | 61 Views | Created by MyCatAlex - 5 hours 5 minutes ago | Last reply by KevinBHill - 4 hours 15 minutes ago -
0 Votesvb net error binding in datagridview
I have 2 tables Table_1 master, Table_2 detail and 2 datagridviews, this code only shows in datagridview2 the detail table which must be the master table and datagridview3 shows ...Unanswered | 1 Replies | 213 Views | Created by kyriakos70 - Saturday, December 21, 2019 6:57 PM | Last reply by Olaf Helper - Friday, December 27, 2019 12:23 PM -
0 VotesFill Up blank spaces based on the cell above
Hi : Currently I perform fill up or fill down in Power Query due to large data size, it takes a lot of time to perform the action. What is the best way to fill blank spaces based on the cell ... -
0 VotesSQL Server 2017 Python package installation failed
Hi community, I just installed the in-database Python with SQL Server 2017. I need to install a Python package so that I followed the instruction listed on ... -
0 VotesGroup By query Error
SELECT Year(glpostdt) as Year, Item, Quantity, Sales, (Sales/Quantity) as ASP FROM ABC Where Seller like ...Unanswered | 2 Replies | 852 Views | Created by SQLC - Friday, December 6, 2019 5:34 PM | Last reply by Guoxiong - Friday, December 6, 2019 5:47 PM -
0 VotesRegarding ADF triggers
Hi, I want to know that once a pipeline is done in ADF in which a csv file is copied ...Unanswered | 5 Replies | 847 Views | Created by Arati kharat - Thursday, November 28, 2019 6:34 AM | Last reply by Vaibhav-Chaudhari - Thursday, November 28, 2019 7:37 AM -
0 VotesLiking netezza to SQL server
I am trying to link a IBM Netezza server to a Microsoft SQL server I have installed the OLE DB driver. I am getting the following error can someone ... -
0 VotesCould not load file or assembly 'Microsoft.DataWarehouse.SQM, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The module was expected to contain an assembly manifest. (SqlMgmt)
I am all of a sudden getting the above error when I tried to backup any database on my server. I am running windows server 2008 R 2 with Microsoft Sql server 2008 R 2 developer edition. I ...Unanswered | 2 Replies | 982 Views | Created by denkyira - Friday, November 22, 2019 4:22 AM | Last reply by denkyira - Monday, November 25, 2019 7:21 PM -
0 VotesSQL 2019 Linux on Docker Machine Learning Services (EULA) fail
Hi, I've installed the following SQL 2019 in a Docker. It's running well and I've access to the database: Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 ... -
0 Voteshow to make one store procedure/ query from following queries
i want to create one store procedure/view/query from the above queries.. i am stuck here from the last week help me out and thanks in ...Unanswered | 2 Replies | 878 Views | Created by hi_khan - Saturday, November 9, 2019 8:09 AM | Last reply by hi_khan - Wednesday, November 20, 2019 7:23 AM -
0 VotesHow to add case condition in sql sub queries
receipt.paid_amount select student.Student_id as [Ac #], case when invoice.invoice_id in (select Recipt.invoice_id from Recipt) and ... -
0 VotesUnknown file extensions
I don't recall now where I got this package SQLServer2016Samples containing much SQL Server useful code. Most likely it was at gitHub. Most of the files there have extensions .sql and they ...Answered | 1 Replies | 1103 Views | Created by MyCatAlex - Friday, November 15, 2019 10:39 PM | Last reply by Olaf Helper - Saturday, November 16, 2019 6:05 AM -
0 Votesdeveloper
='YYYY-MM-DD' and W_dateUnanswered | 1 Replies | 1119 Views | Created by 1Bini eng_and_mus - Monday, November 11, 2019 5:25 PM | Last reply by Guoxiong - Monday, November 11, 2019 6:07 PM -
1 VotesHow to find all records in a many to many relationship
= 3), Psw varchar(64) COLLATE SQL_Latin1_General_CP1_CI_AS not null check (len(Psw) >= 8) ); create table "Projects" ( ProjectID int Primary ...Answered | 3 Replies | 895 Views | Created by avivgood - Thursday, November 7, 2019 7:33 PM | Last reply by Guoxiong - Thursday, November 7, 2019 9:23 PM -
0 Votesdeveloper
='YYYY-MM-DD' and W_dateUnanswered | 1 Replies | 918 Views | Created by 1Bini eng_and_mus - Thursday, November 7, 2019 5:17 PM | Last reply by Olaf Helper - Thursday, November 7, 2019 7:35 PM -
0 VotesParameters of Sequence Clustering
Hi, I'm using Sequence clustering from Data Mining of Analysis Services. From the Sequence clustering Microsoft manual, it says the algorithm ... -
0 VotesRemove rows in table from 300 databases with same structure
HeloI have 300 mssql databases with the same structure and prefix xxx_ I have to delete the same data from the same table in each of ...Unanswered | 2 Replies | 1122 Views | Created by slawekdw - Monday, October 7, 2019 9:02 AM | Last reply by Tom Phillips - Monday, October 7, 2019 1:13 PM -
0 VotesCreate a SQL Table from a View
I know enough to speak some of the language, but probably not enough to be able to describe well what I'm trying to do. So, please be patient with my illiteracy... This is what I'm trying ...Answered | 4 Replies | 2612 Views | Created by martirl3 - Monday, February 4, 2019 2:00 PM | Last reply by martirl3 - Monday, August 19, 2019 2:48 PM -
1 VotesQuery to get payment differences of latest dates per each customer
Hello guys, I have the following table: My aim is to write a query that would get the amount differences for the two latest paymentDates for ...Unanswered | 1 Replies | 1266 Views | Created by FaridGN - Monday, August 5, 2019 7:08 PM | Last reply by José Diz - Friday, August 9, 2019 10:05 PM -
0 VotesWhat is a Data Mining Model and how to develop them?
I work on a Data Warehousing Project. We have a Analytical Layer where we have developed SSAS Cube. Now I need to Develop Data Mining Models , could someone how should I start with ...Unanswered | 1 Replies | 1532 Views | Created by NEERAJ DUBE - Wednesday, July 24, 2019 6:01 AM | Last reply by Olaf Helper - Wednesday, July 24, 2019 6:51 AM - Items 1 to 20 of 3637 Next ›
Data Mining announcement
-
Link
Microsoft BI Labs went live today featuring a look into the future of SQL Server Data Mining in the Cloud. The SQL Server Data Mining team presents a set of prototype web services in the cloud that mirror some of the great predictive analytics functionality available in the Table Analysis Tools for Excel add-in from the SQL Server 2008 Data Mining Add-ins for Office package. No installation required.
This blog post provides more details.
Explore these predictive services from your browser - on your own data - and give us your feedback!
