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

Getting Started with Always Encrypted Part 2

In this blog post I am going to continue discussing the new Always Encrypted feature in SQL Server 2016.  There are 2 main aspects to Always Encrypted – first is generating the Column Master Key and Column Encryption Keys in the database where the encrypted database will be stored.  Second is the usage of a…

0

Getting Started with Always Encrypted Part 1

New to SQL Server 2016 are several new security features, each aimed at protecting your data in a very specific way.  Dynamic Data Masking allows you to create rules to mask data that you choose so that lower-security users do not see the actual data in the table but rather a mask of it instead. …

0

SSIS Tip: Using a Filepath Parameter for Multiple Flat Files

SSIS with SQL 2012 and above brought a lot of great enhancements to SSIS that ease deployment and reconfiguration of packages. The project deployment model, SSIS Catalog, and parameters make it a lot easier to manage SSIS. It also helps decouple environmental configurations from the SSIS code. This way DBAs don’t need to be modifying…

0