Category Archives: Blog

Advice I Like: Focus on what’s important

Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by the urgent of any sort. Focus on the important. The urgent is a tyrant. – from Excellent Advice for Living I try to set my life … Continue reading

Posted in Blog | Tagged , | Comments Off on Advice I Like: Focus on what’s important

Modifying a Trigger to Capture More Info: #SQLNewBlogger

I had someone ask me about using triggers to detect changes in their tables. This is a second post looking at triggers, in this case, modifying my trigger to detect more changes and using that information. Another post for me … Continue reading

Posted in Blog | Tagged , , | Comments Off on Modifying a Trigger to Capture More Info: #SQLNewBlogger

T-SQL Tuesday #187–Solving Problems

This month we have a great invite from Joe Fleming, a first time host of T-SQL Tuesday. Joe reached out when I requested some hosts and I’m glad he did. He’s got a great challenge for people and I’ll answer … Continue reading

Posted in Blog | Tagged , , | Comments Off on T-SQL Tuesday #187–Solving Problems

Monday Monitor Tips: Customizing Data Retention

One of the biggest challenges with monitoring data is managing the volume over time. Lots of bespoke/home-grown solutions don’t do this well, and some commercial products have a gross approach that might not meet your needs. Customers constantly ask me … Continue reading

Posted in Blog | Tagged , , | Comments Off on Monday Monitor Tips: Customizing Data Retention