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 …

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 …

SQL University

I can’t speak for anyone else, but I am at a point in my career development where I have narrowed myself down to either becoming a DBA or a Business Intelligence Developer. As I was doing more research in to Read More …