Year: 2019

Recently I had to do some debugging of a WCF service. I used trace logs for this, but the output format of the tracelogs is a wall-of-text xml file.

Luckily, Microsoft has created a viewer that facilities working with these …

Read More

Recently I’ve completed the Microsoft 70-761 and 70-762 certifications. I’ve been using SQL Server for years now, since version 6.0, and I’ve seen it evolve a lot.

There’s a lot of debate about the value of certifications. Forums abound with …

Read More

It’s October.

One of the tasks I’ve set for myself this month is to document an application that is complex and undocumented. Not only is there no technical documentation for this application, but the specifications and requirements that determine whether …

Read More

I have some coworkers that haven’t worked a lot with sql subqueries. Subqueries are a great tool, but can be confusing for folks who have limited sql experience. It’s my opinion that, like any code, good naming, proper formatting and …

Read More