How To Choose a SQL Server Expert
By Lee Markum, guest blogger for SQL Tailor Consulting How To Choose a SQL Server Expert Much of the time, SQL Server just works. It’s easy to install and use as a database for applications. That’s a wonderful thing, until customer growth causes performance to start sporadically hitting a wall, or until there’s a series […]
NOLOCK is Not the Devil
NOLOCK is not the devil. Wow, that felt weird to say. The subject of NOLOCK hints (also known as the Read Uncommitted isolation level in SQL Server) is one that can spark very heated arguments. The arguments typically revolve around concurrency — how many processes can simultaneously access your data at once — and data reliability […]
How Often Should SQL Transaction Logs Be Backed Up?
The correct answer is: it depends. That may seem like a cop out, but there are myriad considerations when deciding how often the transaction log for each SQL Server database should be backed up. The Value of a Transaction Log and Transaction Log Backups What is a SQL Server transaction log, and how does it […]
Top 6 Questions for Effective SQL Database Troubleshooting
Database administrators don’t often get to be heroes, but if there is a time when they’re hailed as such, it’s when they can solve a problem like a slow-running query or error message for a user. It’s not that DBAs pull out their magic wands or even that they know everything about how the database […]
Ultimate Guide: SQL Server Disaster Recovery
What would happen if you went to work today to find that your data center was hit by a major power outage and you couldn’t access your servers? Or that a hacker had installed malware, corrupting your data? What would you do in these database disaster situations? Do you know? Most people think backing up […]