I'll disagree.

Port scanners can be blocked, especially simple ones. Are there targeted, distributed scanners that use lots of IPs over time? Sure, but those aren't necessarily what many...

Frosty morning today, foggy and chilly. Need to ride a motorcycle home today for my kid (he's buying one). Gonna have to dig out some cold weather gear.

I would say your mileage may vary. This might help, it might not. It really depends on the IOPS and latency you are getting from your tempdb drive.

Lots...

What's in the execute_as_principal_id column in the sys.sql_modules DMV?

Execute as self is supposed to be execute as user_name, with the user ID being who created the proc.

This is based on the underlying Windows host policy. You need to check the security settings there.

Steve testing notifications of Rob's post testing notifications.

Another test to subscribe.

If there are simple queries, and it's a bulk set of data, I'd use bcp to pull out the data and then push it back in.

I think it's going to take some time to get used to the new look. I admit that some of the things bother me, but it's more that the interface,...

Added a FAQ post. To be udpated over time.

FAQ

Note if you want to build a cluster, you won't likely be able to upgrade an instance in place. The install is different. You'll need to install SQL Server as...

Mobile is much better, but it does seem like there are some issues. Keep noting them here, but it would be good to test them a bit and note post...

The only concern I'd have is ensuring no one can access your password database. I'd be careful that admins don't accidentally add a user to this from another login. Perhaps...