Just in case you didn’t see any news on this, Microsoft ENDED extended support for SQL Server 2012 on July 12, 2022 – https://docs.microsoft.com/en-us/lifecycle/products/microsoft-sql-server-2012. Do you still have critical databases running on this 10 year old version of SQL Server? […]
Cybersecurity – DEFENSE IN-DEPTH
A recent, real-world project of mine to dramatically mature the information security resources of a client guided this blog. This project, while unrelated to security, identified the current security as deficient. It was a simple consumer-grade antivirus and a solid […]
When do I install SQL Server on a Virtual Server?
This article is one part of a 5 part series highlighting where DBAs can deploy SQL Server databases. The 5 places where your SQL database can live are: Physical server Virtual server Cloud server (IaaS – Azure VM or AWS […]
When do I install the SQL Server database on a physical server?
This is one part of a 5 part series highlighting where DBAs can deploy SQL Server databases. The 5 places where your SQL database can live are: Physical server Virtual server Cloud server :IaaS – Azure VM or AWS EC2 […]
Are my Azure VMs in IaaS available enough?
We frequently hear about Azure Infrastructure-as-a-Service (IaaS) having a 99.95% uptime SLA. Here is the direct quote from Microsoft, “For all Internet-facing Virtual Machines that have two or more instances deployed in the same Availability Set, we guarantee you will […]
The Right Way To Build A “Small” SQL Server
“I just need a ‘small’ SQL server for this production database.” Many CIOs have come to me making this statement, and are immediately set back by licensing costs. This blog series will present several options to meet this requirement and […]
How to Build a Hyper-V VM for SQL Server
There are many design considerations that can dictate how to build your virtual machines (VMs), a major consideration is storage. This blog will focus on using virtual hard disks (VHDs) stored locally on the hypervisor – either through direct-attached disks, […]
Windows Server 2012 – Simpler Storage Administration with Windows Server 2012 Storage Spaces
Windows Server 2012 brings a plethora of features built-in to the OS that once required expensive software and hardware add-on purchases. Several of the Windows Server 2012 improvements regard storage capabilities. Storage Pools combine physical disks into virtual pools to […]
Are You Still Running SQL Server 2005?
Just in case you didn’t see any news on this, SQL Server 2005 was orphaned from Microsoft on April 12, 2016 – https://www.microsoft.com/en-us/server-cloud/products/sql-server-2005/ Do you still have critical databases running on this version? Dare I ask, are they running on […]