Executing an R Script

Installing R packages in SQL Server R Services

This article shows four ways you can use when installing missing R packages for Microsoft R Services.

Getting Ready for R

Using Microsoft R in Enterprise Environments

This article talks about using the the positive aspects of setting up R in enterprise environment and give instructions on first steps how to do it.

Recursion and Cursors

Hi All,I have this problem with related items and updating a pair of tables.I have 2 tables,table 1 - ColorID         Description 0          None 1          Red 2          Blue 3          Green 4          Black 5          White 6          Bright Red 7          RoseTable 2 - Matching ColorColorID     MatchingColorID 1             6 1             7in order to keep the table data as small as […]

How to determine Default Database Permissions

The Public Role captures default database permissions. How can I determine what are those default database permissions?Thanks in advance, Kevin 

RE: Easy administration of hundreds of SQL servers?

Hi Steve,we do monitor all the servers with CA TNG Unicenter. That work perfectly by the way. So the DBA-on-24/7-call guy gets the call when something happens to one of the servers and takes care of business.What we really would like is make checking the jobs and logs quicker. Now it takes quite some time to surf […]

RE: Update with insert of zero

How about something like this:select CASE PATINDEX( '%[a-Z]%', col1)  WHEN 0 THEN      stuff('000',4-len(col1),len(col1),col1)  ELSE   stuff('000',4-PATINDEX( '%[a-Z]%', col1)+1,len(col1),col1)  END from test1Where test1 is the table in question and col1 is the column you are working on.