I wholeheartedly agree with Brad on this. It's a tool that provides a smell that should be further investigated. The code coverage "score" is arbitrary, but using it to baseline...

What problem do you think it might solve?

A better link to the SQL Cop tSQLt tests would be:

http://dl.dropbox.com/u/58229865/SQLCop%20Tests.zip

(links directly to a zip file containing all the tSQLt SQL Cop tests)

Or

http://documentation.red-gate.com/display/SQT1/SQL+Cop+static+analysis+tests

(contains links to web pages describing each of...

Ed Elliott (7/2/2015)

---

Yet Another DBA (7/2/2015)

---

This is so true, we have had years and years of bad or incorrect...

Alex Friedman (6/30/2015)

---

Hmm, Red Gate's DLM dashboard is indeed an interesting development -- but it's still in beta, and does not integrate with source control. It simply compares databases.

I've...

There's a tSQLt course on Pluralsight that might be worth a look.

http://www.pluralsight.com/courses/unit-testing-t-sql-tsqlt

I've had a go at compiling a list of tools/add-ins that attempt to identify potential T-SQL code issues.

SQL Cop (free) [/url]

This tool from George Mastros[/url] is reviewed on Simple Talk[/url].

SQL...

I guess I meant one's own best practices rather than...

Is anyone actively using any tooling (free or commercial) to help with T-SQL best practices?

SQL Mad Rafi (6/12/2012)

---

Is there a way to open a .sql file in SSMS always towards a particular sql server instance.

because, when i open a new .sql file, by default...

You might want to check with support@red-gate.com, but I suspect it's just being overly paranoid and refreshing the view "just in case".

Craig - just wondered whether anything came of this? I was asked recently whether there was a good forum for discussing agile database development topics and I couldn't think of...

Did you get this up and running? If so, I'd be interested to know what your setup is.

If you have Red Gate tools, such as SQL Source Control and/or SQL...