Author: KenpoDBA

This is a live class I gave at the NTSSUG (North Texas SQL Server User Group). Let me just say now that it was a disaster from the start.  My laptop wouldn’t  work with the projector so I had to use someone else’s box at the last minute so I hadn’t tested my demos on […]

Here I show you how to trouble a DB connection issue to eliminate the firewall as a suspect. Using telnet you can tell pretty clearly whether or not the access is being blocked by the firewall or not. One thing I didn’t mention in the video is that this works for all DBs and not […]

Continuing with schemas, here I talk about ownership chaining and how schema ownership effects them. I start with the basics of chaining and then get into the meat of the topic right after that.  Here’s the vid.