VSTS "How To" videos have gone live

Bookmark this page. For the next several weeks, Scott Golightly (Microsoft Regional Director from Utah) and I will be publishing several instructional videos around Team System. Currently, there are ...

Cool DBA Automation Jobs

I saw a demo of these at Tech-Ed, and thought I would share with my friends. Essentially, the Database Operations team at Microsoft uses a suite of jobs on all their servers for performing ...

Welcome to Portland Code Camp 3.0

Welcome to Camp! Portland Code Camp 3.0 (as was 2.0) is being hosted at the gorgeous WSU Vancouver campus. There are quite a few attendees here. I counted around 90 at this morning’s welco...

Transcript from today”s VSTS Chats

Today’s chats were well attended, with many experts and well over a hundred guests. The quests came fast and furious, with some great answers given by the experts. It seems people are really an...

New, simpler AdventureWorks sample database

Trainers and presenters have been wanting a sample database that is less complex than AdventureWorks, but more interesting than Northwind. Thanks to my friends at SolidQ for letting me know about Adv...

Any SQL Injectors out there?

SQL Injection attacks are a well know exploit of insecure database systems. If you don’t know about SQL Injection, you can change that by visiting Wikipedia.   If you feel like injecting s...

SqlSpec from Elsasoft

We all have our favorite database structure generator or schema reporting tool. Maybe we have built one of them in the past. I always tell my clients that it’s a great “first ap...