SQL Server 2008 End of Support D-Day
As the saying goes, time flies when you are having fun. We are already on the 2nd half of June in 2019 and if you were not aware, extended support for Microsoft SQL Server 2008 SP4 and 2008 R2 SP3 ends on July, 9th, 2019. Previous service packs for each product have already since expired […]
Don’t Forget RoboCopy
On occasion you have to find means to get around an issue. Recently at a client I discovered that an unknown SQL Server that wasn’t being properly cared for. This particular instance wasn’t taking backups and it was deemed as a critical production server. You can begin to see the problems that were arising. However, […]
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 scripting languages it may support. […]
Function Fn_PageResCracker Internals
In a previous blog post, I discussed two new methods to determine exactly which page a request might be waiting for when there is contention. One of these new methods involves a new function, fn_pagerescracker. Naturally, I wanted to see how this function operates. Let’s look at the Master database to investigate how it works! […]