My Build and Deploy Process (as Requested by Bill Fellows)

Recently I attended Reg-Gate’s SQL in the City event in Seattle, WA. I was in Seattle for the annual PASS...

New FileTable Questions Posted on SQLServerCentral

I’m late posting this, I wrote six questions after doing a refresh of what I knew (or should have known) about...

Poor Data Modeling – T-SQL Tuesday #72

This month Mickey Stuewe hosts the T-SQL Tuesday and she has a great topic. Data Modeling is something few people...

Redundancy Options in Azure Blob Storage

So you have data in Azure Blob Storage and are concerned about reliability.  Have no fear!  There are four replication options...

Renewed as MVP

I was renewed for another year as a SQL Server – now Data Platform – MVP, always pleasant news. My plan for...

T-SQL Tuesday No.72 - Is Your Data Model, Normal?

Well I’m not
a data modeler, nor do I play one in the corporate world.  But it is TSQLTuesday No. 72,...

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 Storage
NOVEMBER 11, 2015

IntroductionIn my next series of posts, I am going to look into processing files in...

Get valuable Virtual Log File (VLF) information for all your databases log files

I had this problem where I needed to gather Transaction Log information on multiple databases and check for valuable statistics on...

Implementing Partition Aware Index Optimisation Procedures

[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 6. The partitioning includes several major components of work (and can be linked...

Implementing Partition Aware Index Optimisation Procedures

[read this post on Mr. Fox SQL blog]
Continuing on with my Partitioning post series, this is part 6.
The partitioning includes several major...