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
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
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
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
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
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
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
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
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
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
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
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
We recently had to rebuild servers that were configured with AG. I built everything...
Hi there I have a problem with a dynamicSQL Statement. In this code, I...
Hi, is there are way using sql that brings a list of the ssis...