Teaching Transact-SQL at University of Denver, University College

Starting this week on Wednesday night, I will be teaching a special five-week condensed version of ICT 4462, Transact-SQL Programming...

Which database is using all my CPU #2

A few weeks back we wrote about a query to tell you which database is using up most CPU time....

2011 SQL Rally Evaluations - Reporting Services Boot Camp

I wrote this early in June, but lost it in my blog pile again and just found it…

First and foremost,...

5 Ways to Be a More Effective DBA Today

Regular readers will now that I like to talk (quite a lot) about how we can be more effective as...

Can you delete from a view?

I have seen this question come up several times over the last few months. Can you delete from a view?...

Denali’s Skeletons in the closet (and workaround), Part II

I continued to check SQL Server 2011 “Denali” for few things I dislike on 2008 R2 and tried to find...

Environment variable in SSIS not being recognized

If you are using environment variables in SSIS when using package configuration, chances are you will run into a situation...

Foreign Key Hierarchy Update

Today I would like to revisit a post of mine that is rather old.  More precisely, the script in that post needs revisiting.  This is one of my more...

Foreign Key Hierarchy Update

Today I would like to revisit a post of mine that is rather old.  More precisely, the script in that...

How to move the Master database

The catch to moving the Master database is that you must also move the Resource database.  Microsoft states that the...