Azure

Featured

Provision Resources in Microsoft Azure Like a Champion

What do you do when you want to continuously test your code in environments that match your production environment in a way that is cost-effective? Or, what do you do…

Understanding your Dynamics CRM instance with Application Insights

Over time working with a multiverse of different crm instances, you begin to see recurring questions. Many of you have probably asked some of these questions; should you own your…

Case Study: Azure Disaster Recovery Configuration

The cloud enables new opportunities for organizations to build, grow and sell at unprecedented scale. It also means that companies no longer have immediate, tangible control over the servers that…

How to connect Microsoft Azure SQL to Office Access

In my previous post here, we discussed how to assign Office 365 permissions to Azure SQL databases. In this post, I will explain how to setup a ODBC connection with…

How to setup Azure Active Directory/Office 365 Authentication with Azure SQL database (PaaS)

As more users are starting to move their SQL workloads to the cloud, one of the common questions is how to setup user authentication with their Office 365/Azure Active Directory…

Use CREATE OR ALTER For New SQL Object Scripts

When scripting out SQL Server objects in earlier versions of SQL Server, you’ve historically had the option to do so with “CREATE”, “DROP and CREATE”, or as “ALTER” scripts. Each…

Azure Managed Disks – What you need to know

Earlier last month, Microsoft announced the general availability of managed disks. This has been one of the most heavily requested Azure features in the past for many reasons. Below are some…

"In-line Comment Block" Trick in SQL Server T-SQL

In Transact-SQL (T-SQL) there are two ways to comment SQL code that are similar to comment options in many programming languages. First, there’s the “slash star” (/*) comment block that…

Are All Azure Virtual Machine Cores Created Equal?

A series, D series, DS series, F Series, G series, H Series. Azure offers many different types of SKUs at different price points. As you start to leverage the cloud…

Using AzCopy to migrate Azure storage blobs that have multiple containers

Microsoft seems to be constantly enticing us to migrate our classic Azure Service Manager (ASM) resources by adding new features to the Azure Resource Manager (ARM) portal and not back-porting them…