Forum Replies Created

Viewing 13 posts - 16 through 29 (of 29 total)

  • RE: Using Power BI and SSRS for visualizing SQL Server and R data (Part 4)

    can you run R code using sp_execute_external_script on your SQL Server from SSMS? Try to run the code there, before going into Power BI and SSRS.

    best,tomaž

    Tomaž Kaštrun | twitter: @tomaz_tsql | Github: https://github.com/tomaztk | blog:  https://tomaztsql.wordpress.com/

    February 11, 2017 at 4:44 am

    #1927936

  • RE: Using Power BI and SSRS for visualizing SQL Server and R data (Part 4)

    Hi,

    thanks for your reply.

    So you get error with the PowerBi file that is available with the article?
    Which sheet does the problem?

    What you...

    Tomaž Kaštrun | twitter: @tomaz_tsql | Github: https://github.com/tomaztk | blog:  https://tomaztsql.wordpress.com/

    February 11, 2017 at 3:58 am

    #1927933

  • RE: Using SQL Server and R Services for analyzing Sales data (Part 3)

    Jonathan Mallia - Saturday, January 21, 2017 6:49 AM

    Amazing article!

    Can you please shed some light on confidence and support for the last...

    Tomaž Kaštrun | twitter: @tomaz_tsql | Github: https://github.com/tomaztk | blog:  https://tomaztsql.wordpress.com/

    January 21, 2017 at 9:02 am

    #1924222

  • RE: Using SQL Server and R Services for analyzing Sales data (Part 3)

    Jonathan Mallia - Saturday, January 21, 2017 6:58 AM

    Hi,

    I was wondering why you did not use the CustomerKey when you created the...

    Tomaž Kaštrun | twitter: @tomaz_tsql | Github: https://github.com/tomaztk | blog:  https://tomaztsql.wordpress.com/

    January 21, 2017 at 8:35 am

    #1924220

  • RE: Using SQL Server and R Services for analyzing Sales data (Part 3)

    RonKyle - Tuesday, January 17, 2017 12:43 PM

    I'll be testing against that database.  I have it set up, but have only started...

    Tomaž Kaštrun | twitter: @tomaz_tsql | Github: https://github.com/tomaztk | blog:  https://tomaztsql.wordpress.com/

    January 17, 2017 at 11:14 pm

    #1923333

  • RE: Using SQL Server and R Services for analyzing Sales data (Part 3)

    RonKyle - Tuesday, January 17, 2017 7:53 AM

    This looks like a great article.  I'm going to try this over the weekend on...

    Tomaž Kaštrun | twitter: @tomaz_tsql | Github: https://github.com/tomaztk | blog:  https://tomaztsql.wordpress.com/

    January 17, 2017 at 12:39 pm

    #1923260

  • RE: Installing R packages in SQL Server R Services

    🙂 And what is your point of view on this topic, regardless of different point of views (or not).

    best

    Tomaž Kaštrun | twitter: @tomaz_tsql | Github: https://github.com/tomaztk | blog:  https://tomaztsql.wordpress.com/

    October 1, 2016 at 12:05 am

    #1904286

  • RE: Installing R packages in SQL Server R Services

    INCREDIBLEmouse (9/30/2016)

    tomaz.kastrun (9/30/2016)

    Hi,

    you can install package in RTVS (VS R IDE).

    IMHO IDE should be prepared for e.g.: client machine with all packages pre-installed (compatible with version), so data...

    Tomaž Kaštrun | twitter: @tomaz_tsql | Github: https://github.com/tomaztk | blog:  https://tomaztsql.wordpress.com/

    September 30, 2016 at 1:09 pm

    #1904248

  • RE: Installing R packages in SQL Server R Services

    Iwas Bornready (9/29/2016)

    This is a whole new area for me. Thanks for the lesson.

    Great to hear. Hope you enjoyed it.

    Best, Tomaž

    Tomaž Kaštrun | twitter: @tomaz_tsql | Github: https://github.com/tomaztk | blog:  https://tomaztsql.wordpress.com/

    September 30, 2016 at 4:40 am

    #1904113

  • RE: Installing R packages in SQL Server R Services

    Hi,

    you can install package in RTVS (VS R IDE).

    IMHO IDE should be prepared for e.g.: client machine with all packages pre-installed (compatible with version), so data wrangled, data...

    Tomaž Kaštrun | twitter: @tomaz_tsql | Github: https://github.com/tomaztk | blog:  https://tomaztsql.wordpress.com/

    September 30, 2016 at 4:40 am

    #1904111

  • RE: Using Microsoft R in Enterprise Environments

    Hi David,

    Thank you for pointing out the model DB is not a one of the system database, but a new database for modelling purposes.

    Well model can not only...

    Tomaž Kaštrun | twitter: @tomaz_tsql | Github: https://github.com/tomaztk | blog:  https://tomaztsql.wordpress.com/

    August 26, 2016 at 11:35 am

    #1897881

  • RE: Welcome to R Services Section

    Thanks you for spreading the word 🙂

    best, Tomaž

    Tomaž Kaštrun | twitter: @tomaz_tsql | Github: https://github.com/tomaztk | blog:  https://tomaztsql.wordpress.com/

    August 3, 2016 at 2:27 am

    #1893420

  • RE: Logic in a default constraint?

    Hi,

    you can use this:

    create table #temp

    (

    id int identity(1,1)

    ,name varchar(50)

    ,calc as char(65) + convert(varchar(10), getdate(),112) + convert(varchar(20), id, 0)

    )

    and it should work.

    Best, Tomaž

    Tomaž Kaštrun | twitter: @tomaz_tsql | Github: https://github.com/tomaztk | blog:  https://tomaztsql.wordpress.com/

    March 11, 2015 at 4:17 am

    #1783187

Viewing 13 posts - 16 through 29 (of 29 total)