Recovering SQL Server Databases from a Failed SAN Drive
I was recently cleaning the house when I got a phone call from a client that I hadn’t heard from in a while. Their SAN had decided that it was going to corrupt one of the LUNs. This LUN happened to be the Log drive on one of their SQL Servers. Needless to say, SQL…
The post Recovering SQL Server Databases from a Failed SAN Drive appeared first on SQL Server with Mr. Denny.
Employers shouldn’t be selling employee data
Employers and employees have by their nature a very trusting relationship. The employee trusts that the company will keep paying them, and the employer trusts that the employee will do the job that they are being asked to do. The employee also trusts that the employer will act professionally. This trust includes NOT selling the…
The post Employer’s shouldn’t be selling employee data appeared first on SQL Server with Mr. Denny.
NVMe Storage in the Cloud using the Lsv2-series Azure VMs
There are those cases when VMs need super fast storage in the cloud. Now Azure has an offering to get you that storage speed. With the introduction of the Lsv2-series of VMs, you can now get NVMe storage on your Azure VMs. Like with the other VM sizes, the more CPU that you purchase, the…
The post NVMe Storage in the Cloud using the Lsv2-series Azure VMs appeared first on SQL Server with Mr. Denny.
Should SQL Servers be rebooted weekly
There are people out there that reboot SQL Servers (or all servers) weekly. Usually the argument that I hear for doing this is that SQL Server has memory leaks which can only be resolved by rebooting Windows. My argument against this, is that no SQL Server doesn’t have memory leaks which cause it to need…
The post Should SQL Servers be rebooted weekly appeared first on SQL Server with Mr. Denny.