This looks interesting, i'll attend the Wednesday talk on this.

does this use the built in compression, or a custom algo? any comparisons (size/time) to the third party competitors?

I want...

What are the current limitations / gotchas around CMS?

Back in 2008, there was some guidance from Microsoft that CMS shouldn't group > 200 servers together. Does anyone know if...

if it's wanted, I can add the mount point support piece; we use those heavily.

there's multiple different methods to do this, depending on if your environments are older than 2k8r2...

I know this is long dead,

but to do this, you have to enable show advanced options first, and then try setting the value.

sp_configure 'show advanced options', 1

reconfigure with override

sp_configure 'Ad...

any chance to post this? im working my way through this as well, and want to see the logic; (did you have to list out all DDLs in the...

So, the one limitation, that I still see with mount points, is still doing any kind of logical detection of free-space.

Say I have a stub drive (drive letter) that's 500mb

xp_fixeddrives...

first great book; thanks for the free download.

I've passed this on to my team for recommended reading.

second question: why does the word Kindle in front of Ebook bump the price...

Is there a way to tag / denote these as ad-articles?

a good link on HT: (but a bit thick...) http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx

Check with your windows tech too. Previous OS's had a different kernel for single / multi proc installs. I remember a while ago that you had to rebuild...

I have run into this personally, and it's a fustrating thing.

try something along the following

declare @sql varchar(256), @Foo int

SET @sql = 'testreturnstatus 0'

...

also, I'm assuming you've run sp_configure on both servers and compared the two? are there any differences? (with show advanced enabled?)

it really depends on what you're using it for. if you have a 1TB database, only (and this is bad!) raid 0 will do. also, how many disks...

Tools are a good thing

Design: ER Studio. Easy to use, allows sub-schema views, etc. Great tool! Cons: the only one I have is price. Wow.

DBA: DBArtisan speeds...

you can set it up in group policy to explicitly define administrators group membership. Every time the gpo's refreshed on the server / workstation, it goes back to whatever's...