Today I released the June 2017 version of Database Health Monitor, you can get it on the download page at http://DatabaseHealth.com. Here is what it… Read More »Database Health Monitor June 2017 Version Released Today
Here is a question that I received from a friend today and I thought it would be a good post explaining the details: Steve, I… Read More »DBCC FREEPROCCACHE – What is the impact.
I am excited to announce that I will be speaking at (and helping organize) the SQL Conference called Companero Conference in Norfolk VA on October 4th… Read More »I’m Presenting at the Compañero Conference In October
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 tasks. This was a fun episode with the panel of Chrissy, Rob, Constantine, and Aaron who were super excited to talk with us and we loved their energy.
We all want an easy button. It is human nature. We heard quite a bit about how easy PowerShell will make everything, but for those of us who aren’t programmers, it can be a bit intimidating to get started. The PowerSHell tools from dbatools.io are shaping up to be the closest thing to an easy button for DBAs. On this episode we invited some of the team to chat with us about their tool, how they got started and the types of problems they are looking to solve.
“The features that are now inside of DBA tools, honestly, I would describe them as really awesome.” – Constantine
“I promised you this is the best code ever used and that you will ever have.” – Aaron
“It is important to us that people do feel welcomed and that their codes gets merged in.” – Chrissy
Read More »Podcast Episode 91: DBA Tools – Listen and find out what you are missing.
On March 18th I will be attending SQL Saturday 610 in Richmond Virginia and the day before I will be presenting a pre conference session… Read More »Pre-con at SQL Saturday Richmond in March – Emergency Preparation for Database Disasters
For a couple of months we have had requests on the SQL Data Partners Podcast to do an episode on indexing. It is my pleasure… Read More »Podcast Episode – The Long Awaited Index Episode
On Wednesday January 25th at 6:00pm we will be hosting the monthly meeting of the Bellingham SQL Server Users Group. January SQL Server Users Group… Read More »Bellingham SQL Server Users Group – January 25th
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 turn you into a paying customer, I can help.
That’s all a good if you are familiar with what database corruption is. But based on the occasional phone call that I receive based on my outreach to help with database corruption, it makes me think that I haven’t done the best job describing what corruption is.
A few minutes ago at 12:15am, my phone rings, I was sound asleep but it woke me up and I answered it. Still a bit groggy I hear a voice on the other end asking “Are you the one who can help with database corruption removal?” to which I answer yes. He then goes into a story about how he has just been fingerprinted and he wasn’t supposed to be arrested. He goes on to describe how he didn’t feel that he should have been arrested, but the police officers have told him that now that his fingerprints are in the database, there isn’t anything they can do to undo it. I break in with “sorry that’s not the type of work I do”, and he continues to request my help to to get his fingerprints out of the database and remove his arrest record. I end the call, and hope that this wasn’t his one phone call that he is allowed when he was being booked.
Here is a quick update on the last 3 podcast episodes that we have published, ending up 2016, and starting out 2017 with some great… Read More »Latest Podcast Episodes
Today I had the opportunity to present on TempDB to the Spokane SQL Server users group (PASS Chapter). The session was titled TempDB – Do This… Read More »TempDB – Do This and Don’t Do That