Home

SQL Server

19 Conversations

Latest Activity

Custom List Message Item

Just wondering if it is possible to have claims based authentication with Power BI Server? Been asking in the MVP DLs but no response.

I know it is not supported out of the box, perhaps possible with with WAP and ADFS which I have setup with SP only.

I cam

... Read More
45 Views
0 Reply

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
112 Views
1 Reply

you need to fully qualify the query to get the error, like below.   Because it's not fully qualified, it tries to auto-resolve, by referencing the outer query.  

 

UPDATE T

... Read More

Hello, can someone assist me to locate the Tutorial.SSISDeploymentManifest file listed as step number 2, under the "To install the Packages" heading on the url below? Thank you, jdbooze

 

https://docs.microsoft.com/en-us/sql/integration-services/lesson-3-2-running-the-package-installation-wizard

Read More
34 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.

814 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 !

165 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
281 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
815 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
424 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
51 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
84 Views
0 Reply

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

286 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
223 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
102 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
911 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
200 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
88 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
87 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
270 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