Learn SQL 2016 Polybase with HDP – Part 1 – Build the Environment

I have been working with Polybase in Parallel Data Warehouse for a few years now, so I was quite excited to hear about this great feature making it into SQL 2016. It is a great was to use tools and a language you already know (TSQL) to be able to access data stored in Hadoop….

0

What Does Installing Polybase Add to My SQL Server?

In this post, I want to show you some of the components that are added to your SQL Server when you install the Polybase feature and where they reside. Introduction: Polybase is a new feature with SQL 2016 that allows you to query external Hadoop data and data in Azure Blob Storage. It has been…

0

Azure SQL Database Migration Performance

TLDR -> If you are like me, this section will be all your read: Use the P11 Service Tier or higher when you Migrate your database to Azure SQL DB. Once you have completed your migration, drop down the database to the tier you want to run at if you aren’t interested in running at…

0

How Many Tables Can I Have In SQL Azure DB & SQL Server

Hello Dear Reader!  This is my first full fledged blog for my friends here at the PFE blog.  I wanted to start off with something interesting.  A friend asked a very intriguing question yesterday.  “How many tables can a SQL Azure Database have?”.   The context was a migration from MySQL to SQL Server and they…


Quickly create A LOT of SQL Instances

Recently I delivered a demo on Policy Based Management for a customer.   To show this off well, I really wanted to have a larger number of SQL servers to show how PBM can be used to manage SQL Server sprawl.  I can only fit a few VMs in my laptop and Azure would burn though my…

1

SSDT BI Gotcha on VS2015 – New Target Server Version Added to Project Properties

If you are upgrading your SSIS packages to SSDT on Visual Studio 2015, you may not notice the TargetServerVersion project property that is new. There may be some odd side effects due to this, so I wanted to present awareness of this new feature. Please note that the sample below is just showing one particular…

0

Find users under a specific database role for all the servers in my environment

Recently I was working with a customer who wanted to know all the users in their environment who had ssis_admin permissions within their Integration Services environment. In SQL Server 2008 R2, a new catalog view was introduced that allows us to bridge between database_roles and their associated members, under sys.database_role_members. With this simple bridge table,…

0

Azure RM: SQL Server AlwaysOn Availability Groups Listener configuration with Azure External Load Balancer

I want to thank to Ruben Gonzalez for his guidance.   This blog post explains how to configure SQL Server AlwaysOn AG with an External Listener in Azure VMs running in Resource Manager model. Pre-requisites Before to start ensures that the environment is ready, deploy VMs in Azure RM model: Create a Resource Group. Create a Virtual…


Easier SQL Server Cluster Upgrades with Windows Server 2016!

One of the major complaints that I hear from the field has to do with how hard and time consuming it is to upgrade Windows Server versions and SQL Server versions in a clustered environment. In the entire history of clustering with SQL Server, there were very limited ways to accomplish the upgrade of the…

0

Load Testing SSAS with PowerShell

Over the years, there has been much confusion as to the best way to load test Analysis Services. I have seen solutions ranging from as simple as using ascmd to completely custom console apps in Visual Studio. One of the challenging aspects of Business Intelligence solutions has been unit testing in the past, and I…

3