Month: February 2016

Getting Started with Polybase—Incorrect Syntax near ‘EXTERNAL’ Error

I was playing around with configuring Polybase this morning. Nothing to exotic, just installing the feature getting started. I got everything installed and was about ready to created my data source. The command to that is as follows: CREATE EXTERNAL DATA SOURCE AzureStorage WITH (            TYPE = Hadoop,         LOCATION = ‘wasb://polybase@mystorageaccountnamehere.blob.core.windows.net’, CREDENTIAL = AzureStorageCredential); Unfortunately, […]

Using SQL Sentry Plan Explorer to Shed Light on Estimated Execution Plans

Note: While I do have business relationships with many vendors, I do not have one with SQL Sentry aside from attending their great annual party at the PASS Summit. SQL Server allows us to have access to two types of execution plans, estimated and actual. Actual execution plans give us the real row counts and […]