SQL Server with Mr. Denny:

SQL Server


May 25, 2016  4:00 PM

How can you tell how many NUMA nodes your SQL Server has?

Denny Cherry Denny Cherry Profile: Denny Cherry
NUMA, SQL Server

Back in the good old days (the late 1990s) you didn’t need to worry about things like NUMA unless you were running the top 0.001% of workloads. Today however even a fairly small server can have multiple NUMA nodes. NUMA configurations aren’t just for physical SQL Servers either. Virtual...

May 18, 2016  2:00 PM

Move on Brogrammers, your comments aren’t welcome anywhere.

Denny Cherry Denny Cherry Profile: Denny Cherry
Behavior, Communication, community, SQL Server

Recently Jen McCown received a speaker evaluation form from a SQL Saturday attendee.  Now normally this wouldn't be a blog worthy event as this happens several times a year as there are easily 100 SQL Saturday's a year..  The reason that this speaker evaluation form is blog worthy is due to the...


May 13, 2016  10:00 AM

Recommended reading from mrdenny for May 13, 2016

Michael Tidmarsh Michael Tidmarsh Profile: Michael Tidmarsh
SQL Server

Recommended reading from mrdenny for May 13, 2016. This week, I've found some great things for you to read. These are a few of my favorites that I've found this week.


May 11, 2016  4:00 PM

Viewing task status for related objects in the Azure Portal

Denny Cherry Denny Cherry Profile: Denny Cherry
Azure, Windows Azure

When working in the Azure portal finding task information when performing tasks against an object that is related to an object can be tough.  Before I dive into the how, let me demystify what I'm talking about a little more, as that first statement is a little vague.  In the case of my example I...


May 4, 2016  4:00 PM

When using Always Encrypted in SQL Server 2016, how do I as the DBA view the data?

Denny Cherry Denny Cherry Profile: Denny Cherry
Data Encryption, SQL Server

The short answer is, you don't. The entire point of Always Encrypted is that the DBA can't view or modify the data using SQL Server Management Studio. The only way to view and change the data is by using the front end application that created the data. This means that if someone submits a...


April 27, 2016  4:00 PM

Differences between data types between SQL Server and Oracle

Denny Cherry Denny Cherry Profile: Denny Cherry
Data Types, Oracle, SQL Server

Recently there has been some talk online about how SQL Server processes data type conversions compared to how Oracle’s method for type conversion. I figured that I would clear up some of the confusion that’s out there. When concatenating a number (like an INT) to a string (like a VARCHAR)...


April 20, 2016  4:00 PM

Does your User Group need a free WordPress hosting platform?

Denny Cherry Denny Cherry Profile: Denny Cherry
community, Community service, SQL Server, User groups

Is your user group currently hosting their website that isn't giving you the features that you need? Is your user group currently paying to much (or anything) for your website? Would your user group to be able to be hosted for free, on a WordPress platform where you can have basically any...


April 12, 2016  4:00 PM

And with that, SQL 2005 is out of support

Denny Cherry Denny Cherry Profile: Denny Cherry
performance tuning, SQL Server, SQL Server 2005

As of today (April 12, 2016) Microsoft no longer supports SQL Server 2005. If something goes wrong with your SQL 2005 database server at this point, there's not going to be anyone at Microsoft who can help...


April 1, 2016  6:15 PM

Microsoft Gold Partner was so much fun, we did it again.

Denny Cherry Denny Cherry Profile: Denny Cherry
Microsoft Partner Network, Microsoft partners, Partner programs, SQL Server

A while back we at Denny Cherry & Associates Consulting became Microsoft Gold partners for the Microsoft Cloud Platform.  Well, we've had so much fun being a Gold Partner for Cloud Platform that we decided that we needed to...


March 30, 2016  4:00 PM

Why aren’t SAN snapshots a good backup solution for SQL Server?

Denny Cherry Denny Cherry Profile: Denny Cherry
SAN, Snapshot, SQL Server, Storage arrays

3190462946_339cfc3345_z 1 Comment     RSS Feed     Email a friend


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: