Okay… so here's the scenario. I have two different tables in a SQL Database, where I need to compare both tables, and find all values in Table B that do not exist in Table A. There are two ways to do this. One with a JOIN, and one with a "NOT EXISTS" Clause:
FROM DBName.dbo.tblB b
LEFT OUTER JOIN DBName.dbo.tblA a
ON b.[ColumnName] = a.[ColumnName]
WHERE a.[ColumnName] IS NULL
GROUP BY b.[ColumnName];
WHERE NOT EXISTS
WHERE a.[ColumnName] = b.[ColumnName]
I hope this helps someone! My malformed queries have been driving me nuts all week…
As part of my role here at Microsoft, I spend a significant amount of time in LiveMeeting doing presentations to Gold Partners. Sometimes it is a small meeting with only a few attendees, and sometimes the meetings involve hundreds of Partners at a time. LiveMeeting scales very well for both scenarios, and the experience on both sides (presenter and attendee) is usually quite nice. The audio portion of the session can be conducted via an audio conferencing bridge, or via "Internet Audio Broadcasting" where LiveMeeting dials into the Phone Bridge and then broadcasts the audio to attendees so that they can listen with their computer speakers. This is really the preferred method once you have a large number of attendees, as you will INVARIABLY have several folks that don't remember to keep their phone on mute (or that puts the entire conference on hold), which really ruins the experience for all involved. With that in mind, the following are some Best Practices that I use when preparing for and giving my presentations:
You will of course have to modify the above rule to fit your specific scenario, but do not enter the trap of giving a presentation with 100 slides and 16 point font. It will put your audience to sleep and force you to read from your slides, which is the cardinal sin of presenting!
Alright- I have the Technet Blog account setup, and the "New Blog" window open in Word 2007. This initial post will be to make sure that everything is working as expected.
A little bit about myself and what I hope to cover on this blog…
I am a Technical Service Coordinator on the Gold Certified Partner team, where I work with Gold Certified Partners in an advisory capacity. As I serve in a technical generalist role, I have the fortune of coming across technical issues (and solutions) on a wide variety of topics. I intend to post the various useful tidbits that I come across, and hopefully they can expand the sea of knowledge on the internet! My interests include Network Security, as well as playing with the latest and greatest technologies (which is why Microsoft is the greatest place in the world to work!).
I'll keep the first posting short, and my next posting will contain some useful information relating to best practices for presenting via Live Meeting.