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

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 Machines can have NUMA configurations as…

The post How can you tell how many NUMA nodes your SQL Server has? appeared first on SQL Server with Mr. Denny.

Read more

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

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 comment which was left. The…

The post Move on Brogrammers, your comments aren’t welcome anywhere. appeared first on SQL Server with Mr. Denny.

Read more


Recommended reading from mrdenny for May 13, 2016

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. Oracle V. Google Being Decided By Clueless Judge and Jury Amazon and Microsoft Directors Charged in Prostitution Sting Fascinating EMC World 2016 vLab stats…

The post Recommended reading from mrdenny for May 13, 2016 appeared first on SQL Server with Mr. Denny.

Read more

Viewing task status for related objects in the Azure Portal

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…

The post Viewing task status for related objects in the Azure Portal appeared first on SQL Server with Mr. Denny.

Read more

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

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 ticket…

The post When using Always Encrypted in SQL Server 2016, how do I as the DBA view the data? appeared first on SQL Server with Mr. Denny.

Read more


Differences between data types between SQL Server and Oracle

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) you get an error message…

The post Differences between data types between SQL Server and Oracle appeared first on SQL Server with Mr. Denny.

Read more

Does your User Group need a free WordPress hosting platform?

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 theme, and any…

The post Does your User Group need a free WordPress hosting platform? appeared first on SQL Server with Mr. Denny.

Read more

“The Tuesday Night Fire Code Violation”

It was July 19, 2005. At least, I’m pretty sure it was. Based on IndyPASS’s meeting history, that second meeting way down at the bottom (use your keyboard’s End key; that’s what it’s there for) was basically a “here’s what’s new/awesome in SQL Server 2005” presentation. I’ve long since lost most of my email from […]

Read more