Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: May 2014

SQL Code Guard. New release 2.5.5257

Today we released new version of SQL Code Guard, 2.5.5257
Main changes:
  1. SQL Code Guard is digitally signed now to satisfy corporate security policies.
  2. Added editor for exclusion lists.
  3. Some information messages added in order to make user experience more convenient
Full list of changes you can see at http://sqlcodeguard.com/index-database-changelog.html

Read more

0 comments, 235 reads

Posted in SQL Code Guard on 26 May 2014

ExpressProfiler now is digitally signed.

Today I've replaced download package for ExpressProfiler with digitally signed version of standalone application and Ecosystem installation.
Unfortunately I did something wrong and reset download statistics to zero :( Hope that Codeplex's guys can help.
However this is not a big deal - ExpressProfiler looks popular and can reach big…

Read more

0 comments, 184 reads

Posted in SQL Code Guard on 24 May 2014

Complexity. How it is calculated.


What are the magic pink numbers you can see in Code Outline window?
The answer is very simple - these are Code Complexity numbers. Each number represents complexity of outlined node, something like Cost in query execution plan. The same numbers you can see after Complexity check - but for…

Read more

0 comments, 150 reads

Posted in SQL Code Guard on 23 May 2014

Varchar "miracle" and best practice

I've just spent fifteen minutes helping colleague to find "miracle in t-sql code".
- There should be rows, definitely! I can run simple query and voila! 4 thousands of rows selected! So why there are no rows when I'm doing a simple left join with small filter expression?
There is…

Read more

2 comments, 192 reads

Posted in SQL Code Guard on 20 May 2014

ExpressProfiler: The New Kid on the Block

I'm pleased to inform you that yet another of my pet-projects, ExpressProfiler, joined the rapidly growing family of Ecosystem-based tools for SQL Server.
You may ask me, "why should I use ExpressProfiler if there is standard profiler supplied with SQL Server?"
There are a number of reasons:
First…

Read more

1 comments, 115 reads

Posted in SQL Code Guard on 15 May 2014

Psst! Wanna some API?

If you have already visited SQL Code Guard's website you might notice a reference to an "API for custom tool development". Pretty cool sounding, isn’t it? SQL Code Guard can not only find issues as a standalone tool, but also exposes its capabilities to be used in your own solutions!

Read more

0 comments, 92 reads

Posted in SQL Code Guard on 11 May 2014

A few words about simplicity: Using Red-Gate Ecosystem framework

In my first blog post I briefly covered when and why I created SQL Code Guard (SCG).
To be honest, the first version of SCG was a standalone application, but supporting a GUI took too much time so I decided to convert it to an SSMS plugin –…

Read more

0 comments, 68 reads

Posted in SQL Code Guard on 4 May 2014