In a previous post I told you about how I got a Synology DS920+ on loan to play around with. The device comes with 4 drive bays so there is a wide range of combinations that you can do in terms of drives. Since this is my first entrance into […]
Is 18TB of Storage Enough?
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 […]
Quickly Determining Azure SQL Database Size
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 […]
Understanding NUMA in SQL Server VMs
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 […]
Issues When Using Temporary Tables in Nested Stored Procedures
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 […]
Happy New Year!
Happy New Year!! Looking back at my Happy New Year! post from the start of 2020, I of course, didn’t realize the brute force of the global pandemic that was about to hit. Even with the dumpster fire that was 2020, good things still occurred even in the midst of […]
Merry Christmas
Christmas is this week so not a technical post for this week. Just a simple post wishing you and your family as many blessing as possible (especially in the year 2020) and good tidings during this holiday time. I hope that 2020 wasn’t too harsh on you or anybody close […]