Tag: DBA

Podcast Episode 91: DBA Tools – Listen and find out what you are missing.

Today Episode 91 released and it is our pleasure to present this episode on DBA Tools.  DBA Tools is an open source project (http://DBATools.io) that provides a number of powershell scripts to better help the DBA perform common SQL Server

Tagged with: , , , ,

The On Call DBA For Corruption

  One of those services that I offer is on call help for DBA’s who encounter database corruption. Call me anytime 24/7 and as long as you are an existing customer, or we can work out a billing arrangement to

Tagged with: ,

Database Health Monitor – January 2017 Version Released

Today we released the Database Health Monitor January 2017 version. You can download it for free at http://DatabaseHealth.com/Download. This update includes  some new branding with new logos, new icons, and a new splash screen, as well as the usual feature

Tagged with: , , , , ,

Temporary Stored Procedures #sproc

Yes, you can create temporary stored procedures by prefixing the name of the sproc with a #. The temporary stored procedure is sort of a “leave no trace” stored procedure that is only good for your session. If you use

Tagged with: , , , , , , ,

Episode 59: Mirroring, Availability Groups, Replication, and Log shipping

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.

Tagged with: , , , , , , ,

Database Health Monitor – Version 2.3 Released

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

Tagged with: , , , , , , ,

Silencing Backup Messages with Trace Flag 3226

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

Tagged with: , , , , , ,

SQL Server Database Corruption Repair

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

Tagged with: , , ,

DBA on Vacation… Share your stories

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

Tagged with: , , , ,

Interview with Brent Ozar

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

Tagged with: , , , ,
Top