Home SQL Server

SQL Server

17 Conversations

Latest Activity

Custom List Message Item

Hello everyone,

 

Appreciated if you could share with me an offline installer for SQL Server 2016 Express edition to me for download.

 

Thank you in advance.

15 Views
0 Reply

Whether the MS SQL Server 2016 Ent contains the SAP Bundle function?

Thanks !

32 Views
0 Reply

Hi Team,

 

I mostly working with Excel.

 

Some of excel files having large amount of data (Eg. Around 8 lakh rows and 52 Columns)

 

For getting some results, excel is hanging or taking more time and more functions.

 

But SQL is very fine to get results within sec

... Read More
74 Views
1 Reply
Try downloading and installing the Microsoft.ACE.OLEDB.12.0 Data Provider that is part of the Microsoft Access Database Engine.

Link:
https://www.microsoft.com/en-us/download/details.aspx?id=13255

... Read More

Since SQL Server 2016, a new function called R Services has been introduced. Microsoft recently announced a preview for the next version of SQL Server, which extends the advanced analytical ability to Python. This new capability of running R or Python in-

... Read More
573 Views
0 Reply

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
166 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
52 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
36 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
49 Views
0 Reply

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

255 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
180 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
65 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
849 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
159 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
47 Views
0 Reply