Modify SQL Audit for Azure SQL Database

Modify SQL Audit for Azure SQL Database

At SQL Server Live last November, I demonstrated enabling SQL Audit for Azure SQL Database. During the class discussion I explained you must use Powershell to modify SQL Audit for Azure SQL Database. So, that’s my post today, showing you how it is done. By default, SQL Audit for Azure SQL Database will enable the … Read more

Updated Data Services Comparison: AWS vs. Azure

data services comparison aws versus azure

Last year I wrote a post comparing the data services offered by both AWS and Microsoft Azure. Well, there’s been some changes since, so it was time to provide an updated graphic and links. Since both Microsoft Azure and Amazon Web Services offer many data services, I thought it worth the time to create a … Read more

Microsoft Azure SQL Database Data Compression

Back in March there was an announcement that data compression was available for Microsoft Azure SQL Database (MASD). This was met with much rejoicing. You can read more about the announcement here. Oh, wait…that’s right…Microsoft pulled the announcement back for some reason. Three months later, and I still don’t see an announcement regarding data compression. … Read more

The Problem With SQL Azure

The Problem With SQL Azure

The problem with SQL Azure is that it’s not named SQL Azure.  It used to be named SQL Azure, but in May of 2012 Microsoft announced that after 2 years of branding efforts they were going to put all their eggs into the Windows Azure basket. In doing so, SQL Azure became known as SQL Database. … Read more

HOW TO: Connect To A Windows Azure VM Using SQL Server Management Studio

In 2013, right before I was helping to deliver a precon seminar at TechEd on Windows Azure SQL Database, Microsoft made available the ability for customers to use virtual machines running in Windows Azure. This allowed for users to run on-premises version of SQL Server but have the instance hosted in the cloud. The natural … Read more