SQL Server with Mr. Denny:

April, 2017

April 26, 2017  4:00 PM

Partitioned Tables and ColumnStore

Denny Cherry Denny Cherry Profile: Denny Cherry

ColumnStore indexes are all the rage with data warehouses. They're fast, they're new(ish) and they solve all sorts of problems when dealing with massive amounts of data.  However they can cause some issues as well if you aren't very careful about how you setup your partitions on the ColumnStore...

April 19, 2017  3:00 PM

Correcting the Outbound Email Address for Office 365 Users When Using AD Connect

Denny Cherry Denny Cherry Profile: Denny Cherry
Office 365

That's one hell of a long title isn't it? I ran across a little issue in our Office 365 account recently. That problem was users having the wrong outbound email address in Office 365. I was trying to figure out why a new account that I had setup in our dcac.co domain kept showing up in Outlook at...

April 12, 2017  2:00 PM

ZyXEL with client VPN and Azure Site to Site VPN Configuration

Denny Cherry Denny Cherry Profile: Denny Cherry
Azure, VPN

I'm going to start out by saying that I'm not a networking guy, at all. But that said sometimes I have to pretend to be a networking guy. In our lab we have a decent set of machines. We also have our...

April 5, 2017  4:00 PM

Compare Plans in Query Store

Denny Cherry Denny Cherry Profile: Denny Cherry

Have you ever been looking at an execution plan in the SQL Server Query Store reports and wanted to be able to see what the differences between that plan and another plan were? Did you know that you can? It's a couple of step process, but you can compare the plan in the Query Store to any...

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: