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

PASS Summit 2019 or Microsoft Ignite 2019?

It turns out that the 2019 Summit and Ignite will be held the same week in 2019, see this post...

Register for my upcoming session on digital transformation

I’m excited to have a session accepted to GroupBy, a free online conference targeting the Microsoft data platform community. The conference is sponsored by Brent Ozar Unlimited, and sessions...