Data Mining Part 39: Azure Machine Learning vs Microsoft Data Mining
In earlier chapters, we talked about the Microsoft Data Mining enemies. We will talk now about Microsoft Azure Machine Learning.
2016-05-04
1,956 reads
Machine Learning (ML)
An Age of AI?
The age of artificial intelligence seems to be here, but it's a little different to what we were promised.
2019-07-22 (first published: 2016-02-15)
328 reads
Combining R and SQL Server to diagnose performance bottlenecks
Using clustering algorithms to analyse index usage data from SQL Server’s DMVs & simplify complex performance investigations.
2017-05-29 (first published: 2015-12-07)
9,650 reads
RE: Need Guidelines For Using SELECT INTO
Large tables is relative. How do you define "large table"?Like Allen, I would be interested in knowing what blocking issues have been observed. And I would also be interested in the statements those analysts want to use. Will this be stored procedures? Do they *really* need the most recent data or might they be able to […]
2005-04-29
RE: Scripting question
For the database, create a user-defined database role. Assign it the permissions currently granted to AcmeCorp\SalesUsers. Then make the AcmeCorp\SalesUsers user a member of that role. You can use sp_helprotect to list out all the permissions AcmeCorp\SalesUsers currently has and with some text manipulation you should be able to create the GRANT EXECUTE statements needed […]
2005-04-08
RE: Can all permissions to Public role be safely removed?
Short answer, no. Microsoft made minimal changes to earn a C2 compliance standard. Public was largely unaffected. SQL Server 2000 C2 Administrator's and User's Security Guide If you want more details, my GSEC practical looked at this issue... SQL Server 2000: Permissions on System Tables Granted to Logins Due to the Public Role
2005-03-29
RE: nvarchar formatting?
You might want to check out this page to verify that you are actually using Unicode http://mysecretbase.com/ColdFusion_and_Unicode.cfmAlso, storing a resume in a nvarchar column might be a tight fit. You can try ntext for more space.You also might want to research collations in the SQL Server manual. It may provide you with some key insight.Good luck.
2005-03-03
Database Location query
Morning AllWhen I run the following TSQLselect * from sysdatabasesit give me the location for my master Database asd:\mssql\MSSQL\data\master.mdfHowever, if I check the Db properties through Enterprise Manager, it reports it asd:\sql\MSSQL\data\master.mdfBoth files exist, have virtually the same timestamp, and are the same size. How do I establsh which is correct?ThanksGary
2005-01-31
DBO_DDLADMIN Role
I am currently experiencing some problems using the database role of dbo_ddladmin in SQL2K. I am adding an NT user group/ad group to the ddladmin role and the users are telling not only can they not add new objects they can't even do a simple select statement. I am not too familiar with SQL2K but […]
2005-01-21
2 reads
Strange problem with extended property
Hello, I have a problem with extended property MS_ConstraintText. MS_ConstraintText property is not shown to other end users except for my own login (which have created the extended property). Another extended property, caption, is displayd correctly for all users. Here is example code: -------------------------- CREATE table T1 ( id int identity not null primary key […]
2005-01-16
2 reads
Blogs
Daily Coping 3 Feb 2023
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
Daily Coping 2 Feb 2023
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Forums
Re-creating AG after server loss
We recently had to rebuild servers that were configured with AG. I built everything...
Cannot run DynamicSQL Statement to merge table with JSON
Hi there I have a problem with a dynamicSQL Statement. In this code, I...
find connection details for all ssis jobs
Hi, is there are way using sql that brings a list of the ssis...
Ask SSC