Koen Verbeeck

Forum Replies Created

Viewing 15 posts - 2,356 through 2,370 (of 11,678 total)

RE: How To Give SQL Agent Permission To Access Oracle 11g db?

lindsayscott23 (7/8/2014)
Koen Verbeeck (7/8/2014)
You need to store the connection information into a package configuration.
Hi, Thank you for the response. I've read the article and had a look at creating a...

July 9, 2014 at 1:12 am

#1727953
RE: Want to Convert PRIMARY KEY from NONCLUSTERED TO CLUSTERED pls Advice !!

Hardy21 (7/8/2014)
The clustered index has an advantage over all other indexes: since it always includes all columns, is always covering. Therefore queries that can leverage the clustered index certainly do...

July 8, 2014 at 6:11 am

#1727734
RE: Power BI Limitations with External users

An example:
http://www.microsoft.com/en-us/powerBI/solutions/demo/business-demos.aspx?WT.mc_id=Blog_PBI_General_DI#fbid=SZnSmRn2cxI

July 8, 2014 at 6:09 am

#1727732
RE: Power BI Limitations with External users

I've seen blog posts by the Power BI team where a Power View visualization is embedded into the blog post itself. Probably with HTML5.
Anonymous users can play with the visualization,...

July 8, 2014 at 6:07 am

#1727731
RE: How To Give SQL Agent Permission To Access Oracle 11g db?

You need to store the connection information into a package configuration.
Understanding Integration Services Package Configurations

July 8, 2014 at 5:26 am

#1727715
RE: Transpose rows into one column

MariusC (7/8/2014)
I have just read that and tried some queries but I can`t obtain the right result.
I`ll apreciate a little help 😀
How about some sample data and desired output?
Check the...

July 8, 2014 at 2:35 am

#1727675
RE: Problem with SSIS connection manager while running from SQL job

Are there any configuration warnings?

July 8, 2014 at 2:15 am

#1727668
RE: getting null values while imporing from excel

Where do you get this error? In Excel itself?

July 8, 2014 at 2:11 am

#1727666
RE: T-SQL Syntax Gotchas

Great question, thanks!

July 8, 2014 at 2:10 am

#1727665
RE: getting null values while imporing from excel

visu.viswanath (7/8/2014)
this is the message i got in catch block...
Can you post a screenshot?

July 8, 2014 at 1:50 am

#1727660
RE: getting null values while imporing from excel

visu.viswanath (7/8/2014)
Thanks for replay, i have one more doubt ...
Is there any limitation for file size through query not from SSIS package.
it gives error message as
"server is not responding...

July 8, 2014 at 1:29 am

#1727652
RE: Transpose rows into one column

http://stackoverflow.com/questions/1002989/sql-server-include-null-using-unpivot

July 8, 2014 at 1:25 am

#1727650
RE: Are the posted questions getting worse?

patrickmcginnis59 10839 (7/7/2014)
Koen Verbeeck (7/7/2014)
patrickmcginnis59 10839 (7/7/2014)
Koen Verbeeck (7/7/2014)
patrickmcginnis59 10839 (7/7/2014)
Luis Cazares (7/7/2014)
I'll start using Oracle :sick: at my job. As a SQL/BI Developer, it seems that most of the...

July 7, 2014 at 3:04 pm

#1727585
RE: 70-462: Can the Hyper-V environment be downloaded somewhere?

If you can't use HyperV, then VirtualBox is a good alternative.

July 7, 2014 at 3:03 pm

#1727584
RE: Are the posted questions getting worse?

Luis Cazares (7/7/2014)
EDIT: I had forgotten the need of TNSNAMES.
God I hate that.
And the Oracle home as well.

July 7, 2014 at 1:46 pm

#1727556

Viewing 15 posts - 2,356 through 2,370 (of 11,678 total)