Home

SQL Server

17 Conversations

Latest Activity

Custom List Message Item

Hi..
I have this statement:

UPDATE Table1 SET status = 'DoSomething'

WHERE status = 'Ready' AND TabId IN
(SELECT TabId FROM Table2 WHERE xData IS NOT NULL)
.
If I run only the subselect I get an error:
Invalid column name  'TabId' - and that is correct: TabId is

... Read More
45 Views
0 Reply

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.

403 Views
1 Reply

Does SQL Server all Express Editions are free?

 

Download Links:

SQL Server 2016 Express SP1: https://www.microsoft.com/en-us/download/details.aspx?id=54284

Read More

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

Thanks !

140 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
225 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
793 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
314 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

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
46 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
74 Views
0 Reply

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

273 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
197 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
84 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
886 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
191 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
66 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
83 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
238 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