Failed Installation of SQL Server Cumulative Updates Debugged

Background
Our customer has recently experienced an issue during the installation of the latest cumulative updates in their SQL Server environment....

Identifying delays between SQL calls using SQL profiler

One of the common goto methods for query specific slowness which can be replicated via an application can be to...

SQL work-vacation, Monday (#Workation #PASSSummit)

Hello again! Sunday, I wrote that we’re here in Seattle for the PASS Summit, and that it’s my tenth year. AND that...

What Is Happening, Right Now, At the PASS Summit?

Honestly, that’s a very hard question to answer. I mean, first of all, you can look at the schedule. There...

Last week reading (2018-11-04)

Good morning folks! I wish you very good week at work, at home or wherever you are/will be. Last week...

PASS Summit: Planting Seeds of Knowledge

On the eve of this year’s PASS Summit, I find myself reflecting on my first Summit in 2012. My employer was generous enough to pay for not only Summit...

SQL work-vacation, T-2 days (#Workation #PASSSummit)

We are at PASS Summit 2018 in Seattle, and I will write a bit about each day I'm here, just...

SMO "leaks" SQL login passwords (in memory) and (some) SecureStrings in clear-text

Updated 2018-11-04: Expanded test code, renamed the
title of the post so it's clearer.
SMO (SQL Server Management Objects) are the .NET...

DBCC CLONEDATABASE issue: Duplicate key row in sys.sysschobjs

I ran into this error recently while trying to clone a production database:
Msg 2601, Level 14, State 1, LineNumber

Cannot insert duplicate...

How I Work: Data Professionals at Work

It has been a busy year so far. Last March, I did a review, as a Technical Reviewer, for a...