sqlrus.com // dba // bat whisperer
One of the reasons that I enjoy having a Synology DS920+ around is that that I can use it to experiment with virtualization. In this experiment, I’m going to move a virtual machine that I configured through VMWare’s Fusion which is running on my Mac laptop. This is just a […]
Last week, on Wednesday August 11, 2021 at approximately 3:45PM Eastern, my Father left this world. Much too early. Covid took my Father from me, my family, and his grandchildren. He had some underlying issues, but Covid is what pushed him over the edge. Covid put him on a ventilator […]
Come to find out, nope, probably not. My good friend Jim Donahoe (blog|twitter)was very nice to tell me that he’s running 100TB of storage in his house across multiple Synology devices. I also know for a fact that another good friend, David Klee (blog|twitter), utilizes enough storage in his house to […]
Recently I needed to determine how much storage space each database on a logical server was consuming. I was doing some DR testing and I need to give the client a rough estimate on how much each database was going to cost. You can do this through the Azure portal […]
What really is NUMA and why do we as database administrators care? NUMA stands for “Non-uniform Memory Access” and allows for increased CPU & memory performance. This is because a memory bank is physically adjacent to a CPU socket on the motherboard of the server. Each combination of memory and […]
SQL Server offers a lot of flexibility when working with objects like stored procedures and temporary tables. One of the capabilities is to allow for stored procedures to call other stored procedures. This is called “nesting” one stored procedure within the context of the calling stored procedure. In addition, you […]