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