Home SQL Server

SQL Server

13 Conversations

Latest Activity

Custom List Message Item

I am evaluating SQL Server 2016 in-database integration with R on Windows 10. I have followed the steps installed all components and scripts. Now I have following questions:

Where does sp_execute_external_script reside? I can’t find it. When I run script,

... Read More
85 Views
1 Reply

I see this is a rather old thread but I thought I would share a link from an article that addresses your question.  Enabling sp_execute_external_script to run R scripts in SQL Server 2016

... Read More

You can use a 3rd party tool and just enter the connection strings to keep SQL Server data queries in sync with SharePoint lists (on-prem or Online). The tool runs as a Windows Service locally. It works one-way (e.g. for reporting or forms) or even two-wa

... Read More
32 Views
0 Reply

Hi,

 

I hope you can help me out. I've set up a virtual BI User Group on meetup, and I hope to do webinars every 2 weeks, and the challenge for me now is to find SQL Server communities where I can share the events, so people actually know about it ;)

 

Sam (M

... Read More
30 Views
0 Reply

Hi all,

I would like to develop a stored procedure using excel's functions FORECAST.ETS.SEASONALITY but I cannot find the formulas, in particular of SEASONABILITY.

Someone can help me?

Thx

stefano 

Read More
29 Views
0 Reply

I'd like to redirect the access denied page in SSRS 2014 to an customized web page

234 Views
2 Replies

As 2016 ends, here are some of the highlights from a memorable year! 

 

  • General availability now across 23 regions world wide
  • Industry Leading Performance for Analytic Queries
  • Fast Loading with ADF and PolyBase
  • Enhanced migration, monitoring, and SQL too
... Read More
174 Views
0 Reply

Microsoft is excited to share that Azure SQL Data Warehouse has introduced updates to the Azure portal and SQL Server Management Studio (SSMS) to provide a seamless experience when loading, monitoring, and developing your SQL Data Warehouse. The updates i

... Read More
55 Views
0 Reply

Lead engineer, Travis Wright demonstrates SQL Server on Linux, including how you can: download and install SQL Server on a Linux Virtual Machine; run your SQL Server-based apps inside of Docker containers and improve the performance of your applications u

... Read More
816 Views
1 Reply

So awesome to see SQL Server come to Linux.

 

Note that Travis is demoing using a Mac running a Red Hat Enterprise Linux VM that gets a SQL Server installed. And importan

... Read More

RTVS provides project system, R Interactive window, plotting, and more for the R programming language. I am running version 0.5.21019.1228 and thus far this Technology Preview version ROCKS.

 

I have run into very few issues, one however has gotten under my

... Read More
140 Views
0 Reply

Currently the Microsoft R family currently includes 5 products:

1 - Microsoft R Server

     ... R intrepreter

     ... Installation option from SQL2016 CD 

     ... as R Services in SQL Server 2016

     ... from DEV perspective same as CRAN R

2 - Microsoft R Cl

... Read More
39 Views
0 Reply

 

Make building and maintaining applications easier and more productive. With built-in intelligence that learns app patterns and adapts to maximize performance, reliability, and data protection, SQL Database is a cloud database built for developers. Get started

... Read More
63 Views
0 Reply

Hi,

 

I have been using DAX in Excel Powerpivot and PowerBI, and I'm astonished the ease of use and the power. I read that we can use DAX in Analysis Services to build tabular Models but I still don't find good material to get me started on this.

 

Do you use

... Read More
167 Views
4 Replies

Hi Urbano,

 

The new Tabular Modeling in SSAS book by Marco Russo and Alberto Ferrari will likely be considered a primary authority on this topic but it's not yet released.

... Read More
Best Response