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