Wednesday, March 9, 2016

New developer build of SQL Code Guard released

Issues fixed since last developer build
[*] fixed incorrect binding of MI008 to MI007
[*] fixed xtra EI028 in case with named default constraint
[*] fixed error with IncludeIssues method when issues were not actually marked as Warning except ALL issue
[*] fixed extra MI003 Unqualified column name on xml methods
[*] fixed several CGUNP on CREATE/ALTER database (rarely used/new options)

Full list of issues fixed since last release you can find here -

Have fun!

Tuesday, December 1, 2015

SQLSaturday 426, Lviv, Dec 05 - only few days left!

Last changes and preparation for SQLSaturday in Lviv -
You still have a time to register and attend it.
Great city, great people, great event - don't miss it!

Wednesday, November 11, 2015

Support for SSMS 2016 now available

Good news!
Red-Gate published new version of its SIPF framework with support of SSMS 2016!
Now you can simply download and install SIPF from Red-Gate's site - and you'll be able to use SQL Code Guard and ExpressProfiler from SSMS 2016!

Great job, Red-Gate! Awesome as always!
Thank you, David!

Friday, October 30, 2015

Catching specific statements using new MI008 "Statement used" rule

Imagine that you want (for some reason) prohibit usage of some statement (or statements), eg - CURSOR
How can you find if this statement is used in the script? To perform this task you should use newly added rule MI008 "Statement used"

Monday, September 21, 2015

I'm alive!!!!

Hi all!
Sorry for long delay but i was a pretty busy preparing SQLSat
Now mission is accomplished and i'll return to development in the nearest future.

Thursday, June 25, 2015

ExpressProfiler: say "Hi!" to new developer!

I glad to introduce new member of Express Profiler team - Chris Moore!
He has many ideas and eager to implement them.
Welcome onboard, Chris!

Wednesday, June 24, 2015

SQL Code Guard - Developer build: just as planned

Well, not exactly just as planned, but at last!
Few minor fixes
[*] fixed unparsed with CONTAINS condition
[*] fixed xtra "ST010 Use alias for all table sources" for UPDATE/DELETE statements with single FROM clause item
[*] fixed xtra MI003 "Unqualified column name" on DATENAME(MONTH, GETDATE())
You can download Developer Build at
Enjoy! At your own risk, of cours ;)