Although log shipping isn’t as widely used as it once was, it’s still a vital tool that has many applications. Here are three techniques that can save you time and make working with log shipping painless.
One of the things people are always trying to figure out is how to get high-speed disks and high availability (HA) all in a single package. A possible solution is the DataKeeper Cluster Edition from SIOS Technology....More
SQL Server 2012 not only carries forward the ability to store user databases on SMB network shares, it adds several new high availability options when used with Windows Server 2012. Unlike early versions, it supports SMB file shares to store SQL Server databases.
Download this whitepaper to learn about the SMB benefits as well as creating development and test environments while minimizing downtime....More
When VMware's vSphere platform is configured within a cluster at the host level, vSphere provides a certain degree of high availability, without any high availability configurations within the guest OS or SQL Server....More
Recently, I've been working with a consulting client to help them tame CPU usage. Typically, they're clocking over 20,000 queries and operations per second on their e-commerce SQL Server, but ran into an issue where CPU started spiking up above 90 percent for sustained periods of time....More
What should most database administrators be doing on a regular basis? Here's a comprehensive list from Michael K. Campbell of many of the things DBAs typically do on a daily, weekly, monthly, and yearly basis....More