A series...

Ed Wagner (6/8/2016)

---

djj (6/8/2016)

---

Ed Wagner (6/8/2016)

---

Jeff Moden (6/7/2016)

---

Lynn Pettis (6/7/2016)

---

Hugo Kornelis (6/7/2016)

---

GilaMonster (6/7/2016)

---

What I've advised for years is to notify on lack of success (eg: have a monitoring server check...

Wow, I'm back. Five months in the wilderness and there was a lot of The Thread to catch up on.

I've learned a valuable lesson - when I'm not happy...

Not yet.

Have you been playing with DBCC TIMEWARP again?

The discussion about AWS/Azure - I've just had this link sent to me, which may interest UK people - free all-day AWS presentations.

https://aws.amazon.com/events/awsome-day-roadshow-2016/

SQLPass in Manchester (UK) have a meeting on Wednesday 3rd. Will anybody from this place be there?

GilaMonster (1/28/2016)

---

You use it when you want to take a log backup and ensure that no more transactions can be made to the DB after the backup finishes, for example...

The main purpose is for restoring the data to the latest point in time possible as part of disaster recovery - if your existing log backups don't take you to...

I've just discovered Redgate's 'Tab History' button.

Where was that at my last place of work? That little gem could have saved me hours of agony.

Hunting through tabs, closing tabs that...

GilaMonster (1/26/2016)

---

Mirroring...

You can't restore a database from a higher version of SQL Server to a lower version. There are various properties/structures at each version that are not recognised in the lower...

Best article I've read on the subject - https://www.simple-talk.com/sql/t-sql-programming/how-to-confuse-the-sql-server-query-optimizer/

Steve Jones - SSC Editor (1/19/2016)

---

I think you've hit it. Each test runs as a separate tsqlt.run call rather than a larger call with all results.

At the end of the...

BL0B_EATER (1/19/2016)

---

Oh sorry forgot to mention they also asked me who Paul Randal is / what a MVP is? ( Only because I put down my mentoring / training relationship...

Apparently it's by design. Each individual test writes to the TestResult table, having cleared that table first. So if you run 49 tests (as you do if you run the...