Something like
SELECT * FROM Entry WHERE EntryID NOT IN (SELECT EntryID FROM Items WHERE Status <> 7)

Looks even worse at the...

Loving the practical example for Out-Gridview -PassThru.  Never seen that demoed before (so have never used it), and am now wondering why not?  Great post, Aaron, thanks.

Looking at the poll results...

Apart from my obvious disappointment, there's one thing that's really winding me up...  a bar saying 66.67% taking up about half the width, rather...

Another one.  On the "Latest" / "Unseen" views, we used to see which group a thread was in.  Can we get that back?  because a question may look as though...

Looks from my first response as there may also be an issue with posts not trimming blank space

I'll put ten blank lines at the end of this response.

Also, there's a lot of blank / sparsely populated space at the top of the screen.  I know there's this trend towards wider-spaced metro-style interfaces, but it's a bit annoying...

It's that "Multiquote" button.  Click on that (and, presumably, several...

We can change font and write questions in Comic Sans?  Really?

Good point.

Mind you, this sort of formatting should be done away from...

You could also use

SELECT FORMAT(10.500,'N1')

See documentation for the FORMAT function.