90 Days to MCSA Program: How come you’re not already doing this?

I hope your answer was “Josh, I haven’t heard of that program, but please tell me more.” . Well I would be glad to. 90 Days to MCSA is the brain child of the great people in the “Born to Read More …

Deploying Database changes to multiple databases Part 2: Powershell

Here we are again. A little longer since Part 1 than I wanted to be, but I’ll do my best to make it worthwhile. When we spoke last, I said there were certain times when a TSQL cursor won’t work Read More …

Deploying database changes to multiple databases Part 1: Cursors

As a DBA, no matter where you work, there will come a time that you will need to deploy changes to multiple databases at a time. If you are lucky, it will be the same change, multiple times. For me, Read More …

What are CTE’s?

I was chatting with someone last week and they wanted to know how much or how little I knew about T-SQL. They asked me what a CTE was. Now for a lot of people who have been around T-SQL for Read More …