great article, can't wait for part 2

sorry I should have been more specific, I was referring to availability groups, not database mirroring

Nice article Perry, very informative. Maybe you can help me with a question I have. I'm looking for a way (in a DMV) to see how far the secondary replica...

Thanks for the quick response. I'm looking for a way (in a DMV) to see how far the secondary replica has fallen behind under heavy database load (inserts, updates, deletes)...

great script! Could you explain what the Low Water Mark for Ghosts column means?

This is a great article (I have rated it excellent), I have been looking for this exact information. One thing I'm not clear about (maybe its just the name of...

I am struggling with key mgmt in our organization as well. We store backups along with the data but keep the passwords on a central system seperate from the backups...

I was thinking about something along those lines, I guess I was hoping somebody already had something they would could share that I could use a starting point or maybe...

That is do you want a file you would import into the remote SQL server (perhaps as...

After doing some more research online, I was only able to get the install to work after logging on to the box using a user account that had Admin privileges...

I am having the same problem? Any solutions?

Thank you kramaswamy! I am rewriting to use ANSI style joins at the moment.

Yes but in my case with MAX(TOCTX_CARDTEXT.EXPN_DTE) being the only value in the select statement, I dont't see how a GROUP BY on PNCDH_CARDHOLD.ENR_NBR is changing the output at all....

fantastic article! easy to read, great examples, and right to the point. Now I am off to read Paul's article on what DBCC CHECKDB actually deletes when a REPAIR_ALLOW_DATALOSS is...

in the past I've used a standard error step in all jobs that is only executed when 1 step fails. This error step contains the database mail call to send...