Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards

Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the ShardsMAY 28, 2015
For those of you who have...

Dynamic Data Masking

Dynamic Data MaskingFEBRUARY 26, 2015

Have you ever wanted to only show parts of a field to certain sets of users...

Fantasy Football - A League of Our Own - Want to Play?

It feels daft me saying the football season is only 9 days away, when in fact The Ashes cricket series is only starting today at Edgbaston. The Ashes are...

Index Fragmentation in Azure SQL Database

Index Fragmentation in Azure SQL DatabaseFEBRUARY 4, 2015
Recently, I read the articles Stop Worrying About SQL Server Fragmentationand When Does...

Life Support 2008 – Audit Logons

Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...

Salaries in Job Ads

Hiring at Basecamp is interesting. I caught this interview and think it’s a good look at a process most of us have gone through, but perhaps not thought about....

Setting Up Alerts in Azure SQL Database

Setting Up Alerts in Azure SQL DatabaseSEPTEMBER 8, 2015
Introduction
If I've learned one thing with my on premise versions of SQL...

SQL Azure has T-SQL Jobs - Well Almost

SQL Azure has T-SQL Jobs - Well AlmostJUNE 25, 2015
Introduction
One thing that has been lacking in Azure SQL Database is the...

Using AzCopy in a SQL Job to Upload Files to Azure Blob Storage

Using AzCopy in a SQL Job to Upload Files to Azure Blob StorageNOVEMBER 11, 2015
Introduction
In my next series of posts,...

Validating Replication (All or Just One Article)

You may sometimes have reports or other processes that are dependent on transactional replication being current.  If that is the case, you will probably need a mechanism to check...