In Part 1 we got to see what Visual Studio Database Edition 2010 Static Code Analysis does for us. In Part 2 I’d like to take a look at what it doesn’t. Unfortunately for those who read my previous reviews…
Mike Fourie
Visual Studio ALM MVP of the Year 2012, 13. Distinguished ALM Ranger (Champion of Champions 2011, 12, 13)
Blog Archives
What version of SQL Server are you running?
A handy reference can be found here: http://www.sqlteam.com/article/sql-server-versions
T-SQL Static Analysis 2005 & 2008 — Analysis and Review
In October 2007 I wrote a review on the T-SQL Static Analysis feature provided in the Visual Studio Team Edition for Database Professionals Power Tools. In February this year Microsoft released Version 2 of the Power Tools, Visual Studio® Team…
T-SQL Static Analysis — Analysis and Review
UPDATE: 16 May 08 – This is available here. I’m working on a review for Version 2 and will update my original review soon…
T-SQL Static Analysis — Analysis and Review
In the middle of August 07, Microsoft released the Visual Studio Team Edition for Database Professionals Power Tools (available here). T-SQL Static Analysis is one of the features in this first release. There are fourteen rules that it currently uses…
The rise of TOP, and fall of ROWCOUNT
In SQL Server 2005, TOP has gained a few new capabilities. SELECT TOP (scalar expression | variable | subquery) [PERCENT] *FROM aTable TOP can also be used in DML statements. Previously you may have used ROWCOUNT to limit the affected…
SQL Query Analyzer 2005
No such thing unfortunately. If you have moved to SQL server 2005, your world of Enterprise Manager and SQL Query Analyzer has been replaced with SQL Server Management Studio (SSMS). This is a great new IDE, but now I need…
Planning ahead… Deprecation
Spending a little time planning and researching can often extend a products economically sustainable lifespan by a substantial amount. Let’s take a quick look at this from a SQL perspective in this fictional example: Project A comes along and you…
New SQL Blog – Optimise Optimize Optimise
Love query optimisation? The SQL Server Query Processor team have started a new blog “Tips, Tricks, and Advice from the SQL Server Query Processing Team”. They also link to an old blog I hadn’t come across before which appears to…
#Tables, Table Variables, CTE’s – what’s the difference?
Here is a handy table that explains some of the differences between the three. The full sized version is available here. I’d say that in the past I’ve used Table Variables about 60 to 70% of the time when I’ve…
