Month: April 2020

The New Public Speaking

  By

The need to transition to virtual speaking engagements is not easy for me. As someone who loves public speaking and delivering in person training, not being able to do so right now is very difficult. I struggle with staring at my screen talking to my camera as a teaching mechanism. I get asked all the time to speak at virtual user group meeting and online conferences but usually kindly decline. Now that virtual events are our only avenue to speak, I am forcing myself out of my comfort zone and trying a few on for size. There are a several… Continue Reading

Coding Standards Gone Bad in SQL Server

  By

Knowing your data is very important when it comes to writing code. Now I’ll admit that I am very far from being a developer, however as a DBA, I spend much of my day’s performance tuning code. In doing so, I get to see many ways code can introduce excess database reads. One of the most recent things I have come across has to do with NULLs. The environment I was working in had no default values in their table design, so it was riddled with NULL values. Over the years they had implemented coding standards to try and mitigate… Continue Reading