Polybase (SQL2016 CTP2)

Question

Polybase (SQL2016 CTP2)

psingla

Hall of Fame

Points: 3840
More actions
July 10, 2015 at 12:12 am

#299890

Comments posted to this topic are about the item Polybase (SQL2016 CTP2)
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
July 10, 2015 at 5:41 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Great question! Keep those SQL 2016 questions coming!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ed Wagner SSC Guru Points: 287026 More actions · Answer 2

Koen Verbeeck (7/10/2015)
Great question! Keep those SQL 2016 questions coming!

Do you have it installed or are you gearing up for an installation?

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

Ed Wagner (7/10/2015)
Koen Verbeeck (7/10/2015)
Great question! Keep those SQL 2016 questions coming!
Do you have it installed or are you gearing up for an installation?

I have a HyperV VM spinning with SQL 2016 CTP2.1.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

Koen Verbeeck (7/10/2015)
Ed Wagner (7/10/2015)
Koen Verbeeck (7/10/2015)
Great question! Keep those SQL 2016 questions coming!
Do you have it installed or are you gearing up for an installation?
I have a HyperV VM spinning with SQL 2016 CTP2.1.

Very nice. Have fun with it. It'll be a while before I get to play around with it. Honestly, given history, I wouldn't even consider it for production until at least SP1 comes out. Then again, I'm slightly paranoid about stability.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Ed Wagner (7/10/2015)
Koen Verbeeck (7/10/2015)
Ed Wagner (7/10/2015)
Koen Verbeeck (7/10/2015)
Great question! Keep those SQL 2016 questions coming!
Do you have it installed or are you gearing up for an installation?
I have a HyperV VM spinning with SQL 2016 CTP2.1.
Very nice. Have fun with it. It'll be a while before I get to play around with it. Honestly, given history, I wouldn't even consider it for production until at least SP1 comes out. Then again, I'm slightly paranoid about stability.

It's not for putting in production. As consultant I like to know most of the features so that I can use them at clients whenever they install SQL 2016.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

psingla Hall of Fame Points: 3840 More actions · Answer 6

Koen Verbeeck (7/10/2015)
Ed Wagner (7/10/2015)
Koen Verbeeck (7/10/2015)
Ed Wagner (7/10/2015)
Koen Verbeeck (7/10/2015)
Great question! Keep those SQL 2016 questions coming!
Do you have it installed or are you gearing up for an installation?
I have a HyperV VM spinning with SQL 2016 CTP2.1.
Very nice. Have fun with it. It'll be a while before I get to play around with it. Honestly, given history, I wouldn't even consider it for production until at least SP1 comes out. Then again, I'm slightly paranoid about stability.
It's not for putting in production. As consultant I like to know most of the features so that I can use them at clients whenever they install SQL 2016.

+1

Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/

TomThomson SSC Guru Points: 104773 More actions · Answer 7

Good question. I got it wrong, so learnt something.

I wonder why it isn't documented in the Max Capacity specs page for CTP2.

Tom

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 8

Thanks Pramod for the nice question!!!!

Just to give everyone a bit more detail about "polybase" :

PolyBase allows you to use T-SQL statements to access data stored in Hadoop or Azure Blob Storage and query it in an adhoc fashion. It also lets you query semi-structured data and join the results with relational data sets stored in SQL Server. PolyBase is optimized for data warehousing workloads and intended for analytical query scenarios.

Thanks.

Ken SSCoach Points: 17191 More actions · Answer 9

Nice question Pramod! I'm looking to install a test copy of 2016 sometime soon and I may have to play around with this feature.

Revenant SSC-Forever Points: 42467 More actions · Answer 10

Revenant

SSC-Forever

Points: 42467

July 10, 2015 at 11:18 am

#1811703

Wow - we are getting into 2016! Thanks, Pramod!

xsevensinzx One Orange Chip Points: 25560 More actions · Answer 11

SQL-DBA-01 (7/10/2015)
Thanks Pramod for the nice question!!!!
Just to give everyone a bit more detail about "polybase" :
PolyBase allows you to use T-SQL statements to access data stored in Hadoop or Azure Blob Storage and query it in an adhoc fashion. It also lets you query semi-structured data and join the results with relational data sets stored in SQL Server. PolyBase is optimized for data warehousing workloads and intended for analytical query scenarios.

I only got this right because I was reading about it the other night. It sounds amazing and I can't wait to use it with Hadoop.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 12

akljfhnlaflkj

SSC Guru

Points: 76202

July 13, 2015 at 7:33 am

#1811965

Thanks for the new question.

Arno Kwetters Hall of Fame Points: 3727 More actions · Answer 13

Never heard of this functionality.

Learned again something.

Thanks.