In this post, I discuss about not forgetting to allow for additional head room when planning out new hardware, especially for HA/DR needs.
Azure SQL Offers Manual Failover for PaaS Resources
Sometime having the right command in place opens up new doors to test things, like a failover for example. In this post we will take a look at a new ability that has recently surface within the Azure eco-system to help manage fail-overs. Let’s jump to it. High availability is […]
Using Docker Volumes for SQL Server in Linux
No, not that kind of volume! Over the past couple of blog posts, I have been talking about the versatility of deploying SQL Server with Docker. This combination is a great way to quickly and easily spin up local SQL Server instances. In the most recent post, I talked about […]
Quickly Blocking Inbound Connections to SQL Server
In this post we’ll examine a quick and easy way to block all inbound connections to SQL Server. Sometimes the brilliance of a solution is lost in its simplicity. Full disclaimer, this was Joey D ’Antoni’s (B|T) idea, however, he has given me permission to blog about it. Recently, Joey […]
Azure SQL DB Failover Group Orphaned Users
I have a client that resides in the Azure data platform arena, focusing mainly on Platform as a Service (PaaS) and Azure SQL DB. They have a decent landscape of Azure resources and currently utilize failover groups within SQL DB to facilitate high availability. Under the covers, failover groups are […]
Gathering VMWare Metrics
Anytime that you a large environment, gathering metrics in any form can be daunting and cumbersome. Using scripting languages can usually greatly improve the efficiency of this process as well as be more accurate. Whether it’s VMWare, SQL Server, or some other platform, it would behoove you to see what […]
Modern Hardware with 64 CPUs
In today’s world, more often then not you might run into systems that have large beefy hardware. Hundreds of gigabytes of memory, ultra fast solid state disks and many CPUs to push your workloads. These types of systems are no longer unicorns in the wild but are becoming more and […]