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

The No-Election PASS Election

I was disheartened to read the post that shows we have three candidates for three positions this year. Started with...

Watch: The single question to predict success for DevOps (31 minutes)

What if you could assess the performance level of your team by asking one simple question? In his recent webinar with Redgate, Gene Kim (@realgenekim) suggests that you can....

Azure SQL Database – Who Changed My Auto Tuning Settings?

One of the features Microsoft wants us to use for Azure SQL Database  is Automatic Tuning. Automatic Tuning is a...

Keeping Large Table Statistics Current -TF2371

Statistics are the magic ingredient that helps the query optimizer create its best guess for generating an execution plan. Keeping...

Moving a Google Form Between Google Domains

If you are anything like me, you might have a few different Google accounts that you work with on a...