Hi,

This solution isn't going to work if you lose msdb. To mitigate this, you could add a final step to any SQL Agent backup jobs and call sp_RestoreGene for the...

Thanks Phil,

I've been following you on twitter for years, your articles on simple talk are an absolute benchmark in excellence so your enthusiasm is really appeciated 🙂

If you have any...

Hi Woody,

This update has fixed the issue as it is described in the article, I am no longer able to trigger the transmission queue problem 🙂

Best wishes

I think there may be a bug in the SQL Server views sys.data_spaces and sys.destination_data_spaces when you run the switch out/merge statements in certain circumstances.

http://www.sqlservercentral.com/Forums/Topic1548437-2799-1.aspx

The problem is documented in...

I don't think so, no. SQLDiablo identified the problem in the RTM release, we found it again in SP1. While describing the problem to a Microsoft support engineer, he told...

Are there any clues in the default availability group extended event sessions or sql server logs, primary and standbys, about why recovery is pending?

There are many operations you cannot do...

The T-SQL procedure can generate restore scripts for either:

1. A single user database (this is how the PoSh driver script calls it)

2. All user databases (the default if you just...

Hi Micheal,

It's bug free to the best of my knowledge, and used frequently.

This link contains an update to the documentation.

Best wishes

Paul

Great article, the first I've read that clearly and simply explains what Hadoop is. Thanks

It might be related to some sort of OS memory leak triggered by some random event, rebooting the server often resolves and stablizes it (based on experience rather than insider...

I work on a busy, highly transactional database server running SQL Server 2008 R2. There were performance problems last year which were wrongly attributed to SAN replication. Replication was switched...

Why not just use Policy Based Management and a Central Management Server? It's quick and easy to setup!

You have to take your hat off here to RedGate and SQLServerCentral. They develop monitoring tools but are happy to publish free, but less feature rich, alternatives on their website!

Prometric are no longer involved in the lab exams, you have to sit them from home using a Lync client and remote proctoring. Thats a signiificant change (for the better...

Hi Tim,

The WHERE [Device_Type] = 2

could probably be

WHERE [Device_Type] <> 7

All our backups at work are device type 2, same at home in my virtual lab at home....