This week on the SQL Data Partners Podcast Episode #59 we discussed Mirroring, Availability Groups, Replication and Log Shipping. There were 4 of us on the podcast, two guests Mariano Kovo and Andy Mallon, along with Carlos Chacon and I. …
Episode 59: Mirroring, Availability Groups, Replication, and Log shipping Read more »
With over 7500 downloads worldwide to date, I have just released the next installment of the FREE Database Health Monitor application. Here what one person had to say about it “Excellent – It’s the first tool I open every morning …
As a DBA you regularly schedule backups you might have regular full backups, incremental backups and hopefully regular backups. Over time you might realize that your error log is not longer filled with errors, but instead a majority of your …
Database corruption repair with SQL Server is one of those things that you generally don’t see every day, but as a DBA, you are expected to be able to fix it quickly without any data loss. From the risk analysis …
Being the middle of the summer in the northern hemisphere, and with the Database Corruption Challenge over, I thought I would cover something a bit lighter, and not as hard core as database corruption. Share Your DBA on Vacation Stories …
Almost a month ago Brent Ozar did a blog interview with me regarding the Database Corruption Challenge so I thought I would return the gesture and do the same for him. I ended up going to the Bellingham SQL Server …
Do you need some help with your SQL Server, but perhaps don’t need another full time DBA? Do you need some help to cover your DBA being out on vacation? Do you need help assessing the health of your SQL …
As the DBA, you get a call from the IT Team who monitors disk space and they tell you the following: “One of our server that has SQL Server running on it is running low on disk space. It has …
If you owned a convenience store, or other business that was likely to get robbed you would likely have surveillance cameras with the intention of having evidence to provide the police with the information that they need in order to …
Monday: Using FILESTREAM and FILETABLES in SQL Server Configuring and Using FILESTREAM and FILETABLES in SQL Server. Developers love to use SQL Server to store files, but this causes headaches for the DBA, finally a reasonable solution for file storage in …