Advanced Analytics with R and SQL Part II - Data Science Scenarios
Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.
2017-07-27
1,358 reads
Microsoft R Server
Using Power BI and SSRS for visualizing SQL Server and R data (Part 4)
Using R with Power BI, SSRS or RTVS for easier data visualization
2019-02-15 (first published: 2017-01-24)
4,015 reads
Using SQL Server and R Services for analyzing Sales data (Part 3)
Using R integration for analyzing sales data in WideWorldImporters database
2019-02-08 (first published: 2017-01-17)
4,446 reads
Advanced Analytics with R & SQL: Part I - R Distributions
Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.
2017-11-10 (first published: 2016-10-31)
3,039 reads
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.
2016-08-25
2,360 reads
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
RE: programming languages
At the risk of being accused of being facetious, here are the differences between C# and VB.NET:- C# uses { and } to delimit blocks, whereas VB.NET generally uses new lines and tokens that are English wordseg if (condition) { true-block } else { false-block }versusIf condition Then true-block Else false-block End If- […]
2004-12-16
RE: Sql Server dba duties/checks list
Thank you for the input. I was wondering how often DBA's reboot their sql server boxes? Should this be done on a regular basis or only as needed for upgrades, security updates, etc.Juanita
2004-11-16
RE: Populating @Variables dynamically
Farrel,No worries mate. Don't forget though: If you declare the variable within an sql string and exec it, it will generate a new spid and the variable will only have the lifespan of the new spid. It won't be useable anywhere else in your sproc - thats when you get the variable declaration error messages. […]
2004-11-10
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.
2004-10-06
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers