sqlrus.com // dba // bat whisperer
Sometimes what you have just isn’t enough to get the job done. In certain workloads, having additional CPU might be beneficial for the immediate workload, especially when discussing SQL Server. In the old days, dynamcially adding more CPU horsepower wasn’t an option unless you magically had another physical server with […]
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 […]
In my opinion, SQL Server 2019 is one of the greatest releases of the product that Microsoft has ever produced. The amount of improvements across the platform really allows data professionals to have better and faster queries while simultaneously minimizing effort. One of the many things that it fixes is […]
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 […]
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 […]
Microsoft offers several options for moving your SQL Server workloads to Azure. If you’re looking to host modern cloud applications, your best option is Azure SQL Database Service. For an overview of the business benefits of using data infrastructure services in the cloud, download “Future-Proof Your Data Infrastructure with Azure: […]
One of the new phrases coming out of Microsoft is that “SQL is just SQL” regardless of what operating system it resides on. This was echoed during the keynote at SQL Bits 2019 by the Microsoft team, which you can watch here. Later that weekend, I gave a session about […]
With the hurricane bearing down on the east coast of the United States last week, making sure you have a good disaster recovery plan in place should have been a top priority for you. If you happen to be using Azure SQL DB, adding geo-replication is a simple and easy […]