Home

SQL Server

31 Conversations

Latest Activity

Custom List Message Item

SQL Server.png

 

 If you're attending Microsoft Ignite be sure to come to the Community Central booth right next to the hangout space for our SQL Server takeover day! 

Please come join us anytime from 12:30 - 5:00pm ET on Monday to connect with fellow SQL Server users w

... Read More
157 Views
1 Reply

what a great day - what a great event.
hope everybody enjoyed and get out as most from that awsome event.
looking forward to MSIgnite 2018

 

Cheers

Markus

Read More

Hi..

i need to Create a View that query data from two tables as follows

Table1 as Project (its contain colums ProjectID, Resource1,Resource2, Resource3, Resource4 etc)

Table2 as ResourceTable (it contain column ResourceID, AccountNO etc)

 

i need to query the

... Read More
56 Views
1 Reply

Hi Mohamed:

 

Frankly speaking, build a view may inappropriate solution against your requirement. You can create a function in database or in your program code instead.

Plea

... Read More

There is an extensive World War II forum that was adminsitered using MSSQL. What are the limitation on trying to convert the MSSQL data schema into either the 2014 or 2016 SQL releases.

40 Views
0 Reply

Somebody have this error about the missing Product Key?

 

With English media works well.

60 Views
0 Reply

SQL Server.png

 

 If you're attending Microsoft Ignite be sure to come to the Community Central booth right next to the hangout space for our SQL Server takeover day! 

Please come join us anytime from 12:30 - 5:00pm ET on Monday to connect with fellow SQL Server users w

... Read More
157 Views
1 Reply

what a great day - what a great event.
hope everybody enjoyed and get out as most from that awsome event.
looking forward to MSIgnite 2018

 

Cheers

Markus

Read More

Dear all,

 

attached you will find a little Document regarding patch management strategies for sql server deployments. Would be great if you would let me know your suggestions and comments about it.

 

Cheers

Markus

 

Read More
76 Views
0 Reply

Execute query "BACKUP DATABASE [CreditSummary] TO DISK = N'R: \\ Ba ..." failed with the following error: "Can not perform differential backup of database" CreditSummary "because there is no current database backup. Please remove the WITH DIFFERENTIAL opt

... Read More
179 Views
2 Replies

It looks like the backup chain got broken at some point and you need to generate a new full backup

Something tells me that you need to perform a full backup before you perform a differential backup...

I am delighted to announce the public preview of our latest security development from the Microsoft SQL product team, the new SQL Vulnerability Assessment (VA). SQL Vulnerability Assessment is your one-stop-shop to discover, track, and remediate potential

... Read More
541 Views
0 Reply

Hello,

 

I am evaluating Windows SQL 2016 Standard and it is just for me. I understand I need a license once the 180 days expire. Do I also need a CAL ? If so can I just buy one and I have seen prices everywhere and in some cases the CAL is almost as much a

... Read More
172 Views
5 Replies
I install the developer edition as well and it's free.

John,

 

You could download SQL Server Developer Edition 2016 from here:

https://www.microsoft.com/en-us/sql-server/sql-server-downloads

 

This has all the features of Enterpri

... Read More

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
202 Views
2 Replies

I recommend that you change the script as below:

 

UPDATE Table1 SET status = 'DoSomething'

FROM Table1 INNER JOIN Table2 ON Table1.TabId = Table2.TabId

WHERE Table1.status =

... Read More

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

Hi,

Is it possible for a in memory optimized table to have partitions? If yes, can you show an example of how it can be achieved. I have seen examples of how it can be done using a hold/cold/staging table.

https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/application-pattern-for-partitioning-memory-optimized-tables

... Read More
80 Views
1 Reply

@Anuradha Banerjee

 

I have moved your post to the SQL Server discussion board, someone here should be able to assist with your query.

Read More

Hi SQL-guys,

 

I'm running into this error during the last days and could not find a solution:

I am trying to import a database .BACPAC file from SQL Azure into my local SQL Server.

When doing so, I get this error on my local machine:

 

Could not import package

... Read More
740 Views
3 Replies
Hi all, I figured out that the reconfiguration works properly with _most_ of my databases (but not all). So it seems, the issue is dependent on the database and the authe... Read More

Execute query "BACKUP DATABASE [CreditSummary] TO DISK = N'R: \\ Ba ..." failed with the following error: "Can not perform differential backup of database" CreditSummary "because there is no current database backup. Please remove the WITH DIFFERENTIAL opt

... Read More
80 Views
0 Reply

I ran into a situation and wonder whether someone knows how to fix it.

 

I am using Microsoft SQL server Management Studio to update the database.  There is one row which I could see but could not update because it is more than 200 rows (I did learn my less

... Read More
124 Views
2 Replies

 


Shih-Hua Fu wrote:

I ran into a situation and wonder whether someone knows how to fix it.

 

I am using Microsoft SQL server Management Studio to update the database.  There

... Read More

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
130 Views
0 Reply

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
62 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.

3,532 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 !

200 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
424 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
846 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
737 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
62 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
105 Views
0 Reply

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

315 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
261 Views
0 Reply