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

And with that, SQL 2005 is out of support

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 you. However we will be happy to help you. Do we love working on 10+ year old versions,…

The post And with that, SQL 2005 is out of support appeared first on SQL Server with Mr. Denny.

Read more


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

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 become a Gold Partner for Data Platform as well. We were able to achieve this status…

The post Microsoft Gold Partner was so much fun, we did it again. appeared first on SQL Server with Mr. Denny.

Read more

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

First rule of backups: Backup can’t depend on the production data. SAN snapshots, and I don’t care who your vendor is, by definition depend on the production LUN. We’ll that’s the production data. That’s it. That’s all I’ve got. If that production LUN fails for some reason, or becomes corrupt (which sort of happens a…

The post Why aren’t SAN snapshots a good backup solution for SQL Server? appeared first on SQL Server with Mr. Denny.

Read more

How many NUMA nodes should I have if I have lots of RAM and just a few cores?

There are some systems out there which have a lot of RAM, but only a few processors and these machines may need a non-standard NUMA configuration in order to be properly setup. For this example, let’s assume that we have a physical server with 512 Gigs of RAM and two physical NUMA nodes (and two…

The post How many NUMA nodes should I have if I have lots of RAM and just a few cores? appeared first on SQL Server with Mr. Denny.

Read more

Still Time To Register For Internals for Query Tuning

There is still time to register for the fantastic class Internals for Query Tuning Class with Kalen Delaney.  This fantastic three day class will teach what you need to know in order to better understand how SQL Server uses indexes, and how SQL Server uses indexes in order to process queries. After taking this class…

The post Still Time To Register For Internals for Query Tuning appeared first on SQL Server with Mr. Denny.

Read more