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!
Found 3652 threads
-
0 VotesCharacter Field Length
Recently SQL changed something. For over 13 years this code has worked and now suddenly is wrks differently. isnull(MAX(CASE WHEN ftr_opts.ftrcode = 'rpt_OutsideEdge' AND ...Proposed | 1 Replies | 316 Views | Created by CNC_Macros_ - Tuesday, June 23, 2020 4:57 PM | Last reply by Tom Phillips - Tuesday, June 23, 2020 7:20 PM
-
0 Votes
Ways to compare distribution by bin?
Hi I have a table, which has 4 columns with |Device_Model | Device_Id | Bin | DurationInBin| The ...Unanswered | 3 Replies | 474 Views | Created by Niel1 - Wednesday, June 17, 2020 5:50 PM | Last reply by Laxmidhar sahoo - Thursday, June 18, 2020 11:27 AM -
1 Votes
Automated uploading raw data with cleansing
Hi I'm looking for a tool that automated uploading data to the SQL server and I also need to clean data before uploading. Do you have any suggestions tools except ...Answered | 3 Replies | 713 Views | Created by ZaraJ - Friday, June 12, 2020 6:20 PM | Last reply by DBA_Atul - Friday, June 12, 2020 11:23 PM -
0 Votes
2 questions
Hi Eeveryone. I have a pretty simple test to do, just want to make sure i got it right! Attaching the test with my results, please ... -
0 Votes
Clustered Columnstore indexes on SQL Server 2016
Hi SQL Gurus, We are trying to enable change tracking on a DW table with a Clustered Columnstore index on it. The version of SQL Server we have ...Unanswered | 1 Replies | 861 Views | Created by SQLNewbieNY - Wednesday, April 29, 2020 9:07 PM | Last reply by SQLNewbieNY - Friday, May 1, 2020 9:09 PM -
0 Votes
Classification of tweets in to categories
Hi ! Is it possible to categorize tweets into categories using Microsoft SQL server and without any coding. If yes, Kindly tell me the procedure to do the same. I want to categories ... -
6 Votes
Data Mining Add-ins for Excel 2016 where are they?
We currently use SQL server enterprise edition, we leverage the BI stack including the Data mining capabilities. Excel 2013 has working data mining add ins found here: ...Proposed | 16 Replies | 21888 Views | Created by DSqlAnalytics36 - Friday, August 11, 2017 5:33 AM | Last reply by Philip Wiest - Sunday, April 12, 2020 9:31 PM -
0 Votes
Replace XML Element key and value
Dear Experts, I have a XML as follows <items> <item key = "some text1" value = "some ...Answered | 2 Replies | 1088 Views | Created by Momen Azmath - Sunday, April 12, 2020 12:08 PM | Last reply by Momen Azmath - Sunday, April 12, 2020 1:51 PM -
0 Votes
Disable Data Mining
Can anyone point me in the direction of a solution, or step by step to completely disable Data Mining on an SQL server? I am assuming ports can be blocked, services disabled but I can not find a ...Unanswered | 1 Replies | 1189 Views | Created by Ryan Lashway - Tuesday, March 17, 2020 3:39 PM | Last reply by Yuri Fadeev _ Open for MS BI contracts, B2B, Ltd - Thursday, April 9, 2020 4:24 PM -
1 Votes
15 Minute Groupings of data
I am trying to select data points in 15 minute intervals. I get the data I need but am unable to display a usable label (I am graphing the data on an ASP.net page). What I want to do is ...Proposed | 4 Replies | 12848 Views | Created by Garmon648 - Friday, May 21, 2010 2:16 PM | Last reply by Zoltán Horváth - Wednesday, April 8, 2020 5:54 PM -
0 Votes
Convert Bigint (18 Character) into Datetime2 and Datetime2 to Bigint
Dear Experts, I have a requirement to convert a Bigint to Datetime2 and datetime2 to bigint. I have been using the below @bigint ...Unanswered | 2 Replies | 998 Views | Created by Momen Azmath - Monday, April 6, 2020 5:28 AM | Last reply by Momen Azmath - Monday, April 6, 2020 10:44 AM -
1 Votes
SQL backup job failed
Hi Guys, could you help me please resolved next Error: Error: 823, Severity: 24, State: 3. The operating system returned error 1450(Insufficient system ...Unanswered | 3 Replies | 1504 Views | Created by Mooner09 - Thursday, February 27, 2020 2:17 PM | Last reply by TiborK - Saturday, March 21, 2020 4:47 PM -
0 Votes
Can an SQL Query have an equivalent to a "IF" "then" statement? If so, do I use it ?
0 then find the matching IDs description and put in the group_description column, else leave both blank. my code (amended for brevity) looks like INSERT ...Unanswered | 3 Replies | 1323 Views | Created by G-Oker - Thursday, March 5, 2020 2:11 PM | Last reply by G-Oker - Friday, March 6, 2020 8:44 AM -
0 Votes
The equivalent of this Linq to SQL.
p.Bid).Max(), Low = DataSeries.Select(p => p.Bid).Min(), Close = DataSeries.Last().Bid, Volume = DataSeries.Sum(p => p.Volume) ... -
0 Votes
install new Python package in SQL server 2017
Hi, I downloaded the sqlmlutils,. sqlmlutils-0.7.2.zip. but i do not success to install it. I got the error SSL module is not available in ... -
0 Votes
JOIN two SQLCMD tables
Hello. I just found out about SQLCMD today, and how to use it to connect to different servers. The query I have is working (see below) and I can see the results from two different tables ... -
0 Votes
Error while performing TechNet Tutorial for Data Mining
Hi there I am performing the TectNet Basic Tutorial on the data mining. I cautiously followed the steps in the lessons. But while performing 1rst step in ...Answered | 2 Replies | 10460 Views | Created by Mahesha999 - Tuesday, November 1, 2011 4:11 PM | Last reply by Alejandro Uribe Rodriguez - Thursday, February 13, 2020 12:49 AM -
0 Votes
Error while deploying the project Structure and process all the mining models in SQL Data Tools (Visual Studio 2017)
I’m following Basic Data Mining Tutorial for SQL Server 2017 Data Mining in Visual Studio (SSDT) 2017. Please advise on how clear next Error while deploying the project ...Unanswered | 0 Replies | 960 Views | Created by Alejandro Uribe Rodriguez - Thursday, February 13, 2020 12:37 AM -
0 Votes
Unique Values
HI I have a table with 36 different column headings and 100k rows, see below. The column name "Count_01" has only three different values ...Unanswered | 3 Replies | 1566 Views | Created by Mogagabe - Friday, January 17, 2020 11:29 AM | Last reply by Mogagabe - Friday, January 24, 2020 12:21 PM -
0 Votes
SQL stored procedure for Merge update records
Hi All, I am working on one application, in which i want to read unique records from SQL database and send it to other application. i have unique field name ...Unanswered | 1 Replies | 1622 Views | Created by Nitin Surya - Thursday, January 9, 2020 10:56 AM | Last reply by Nitin Surya - Thursday, January 9, 2020 11:01 AM - Items 1 to 20 of 3652 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!
