Why you should not update Primary Key values

Recently I had the chance to take a look at a problematic query in an application. I caught the query in profiler and it’s the following: [crayon-5e9656615f713397718274/] The query...

More Thoughts on the PASS BAC

Here’s an excerpt from an email from PASS I received on November 4 and also available at this link (bolding added by...

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...