We limit GOTO to a single use-case: DEADLOCK Mitigation loops.  We have two SSMS templates: TRAN-bound multi-statement, and Atomic.  Commented boilerplate TRY-CATCH code gets the retry loop controls from persisted...

Hoping the broken links can be mended... please...

Thanks for re-posting as an editorial - may just be at the right time for a hell-hole of an "unknown" attributes per customer...

Excellent extension of Conway's Law - precisely the word used here to describe the c*** frequently encountered, authored by devs at customer sites.  But why?  Perhaps a major contributor is...

LMA was a solution proposed by a Red Gate tech, as SSMS since day 1 of SSMS 2016, let alone 2017, has regularly crashed.  I'm not alone with these crashes...

Yes, this is a slightly negative post!
SIX "SSMS has stopped working" events in succession, just because I need twenty script windows open, and connected to 3 instances, and, and,...

Win7 to Win10 - faultless, even on a 2010 Lenovo T61p that accepted a Samsung SSD after a BIOS upgrade. Go the whole hog, said I.

Set it to defer...

We sadly lost our original customer and the loss seems irrevocable. Thus, why leave their millions of records in our 10Bn row raw-data table?

So I'm building a somewhat intelligent...

This saved the day for a SQL2012 need.

Many thanks!

Steve Jones - SSC Editor (2/27/2015)

---

I've seen this,...

Will there be a 14.x article that shows Configuration Properties being converted to Parameters, please?

Or is there already somewhere that this is adequately dealt with on a.n.other site?

Thanks.

BigSam (5/23/2013)

---

I've found this tool very helpful, in automating too many tasks, we've been doing manually or with a combination of tools. Having everything in one place is wonderful.

We also...

Adding a CERTIFICATE causes the Schema Tracking trigger to fail - red ink everywhere... SQL2005, but syntax is unchanged for SQL2012. SQLCmd cannot be NULL.

michaelrounds (4/16/2013)

---

If the CellList field...

Question, Michael: How do I stop the text version being emitted, please? I've disabled the SQL_DBA_vtext Operator but I still get the text notifications.

Thanks.