I often get asked to provide some data from SQL Server to someone in another department. These are typically one-off requests and the people asking for the data usually don’t have database experience, so I put the data into an Excel spreadsheet and email it to them. Occasionally, that person will come back to me […]
One of the items on my checklist of things a DBA should check for when starting at a new company is internal log file fragmentation – log files that have too many virtual log files (VLFs) in them. (See Step 8 of this post for more info on virtual log files.) This is something I […]
A while back, I wrote an article that appeared on SQLServerCentral.com that presented a routine to gather disk usage data for all the SQL Servers in an organization. One of the pieces of data that routine gathered was the size of the SQL Server data and log files and the total size of the drives […]
I’ve already admitted I’m a fan of pop music. In particular, Eighties pop music holds a dear spot in my heart. I’ve spent the last week working with database mirroring and I’ve had this Human League song going through my head the whole time. Ah, the 80s.. Such music.. Moving along… Last week, I wrote […]
Last week, I spent some time testing database mirroring as part of our disaster recovery strategy. I have to say, I am very impressed with the concept. It was incredibly easy to set up and worked like a charm. It is so much easier than log shipping or replication. And mirroring failovers are faster than […]