Brent Ozar Unlimited had a post recently noting that it appears Microsoft has seemed to move away from releasing service packs for SQL Server and instead is only releasing cumulative updates. Given that Microsoft itself warns against installing cumulative updates unless it solves a specific problem you are encountering, most DBAs, including myself, are somewhat […]
Microsoft released SP2 for SQL Server 2008 R2 a couple weeks ago and I’ve been applying it to my servers. Most of the time it installed without problems, but I encountered a very puzzling error on one server. When I ran the service pack installation, I saw a DOS window pop and and disappear quickly […]
We recently had a problem where someone modified a stored procedure on one of our production systems and, the next time it ran, it caused an outage that lasted for about an hour while we tracked down what had happened. We we never able to figure out who made the change or when it was […]
I recently had to apply SQL Server 2008 SP2 to some of our SQL Servers, three of which are involved in a database mirroring configuration (as the principle, mirror, and monitor servers). Or so I thought. When I looked a bit deeper, I realized I mis-read my spreadsheet and the servers using mirroring were running […]