sqlcodeguard - SQLServerCentral

SQL Code Guard 2.9 released

sqlcodeguard — Wed, 22 Feb 2017 22:50:00 +0000

Nothing special - just signed with renewed code sign certificate, small fixes, etc
Have fun!

Wait a minute! Almost forgot.
More great news coming soon, stay tuned, subsribe to twitter https://twitter.com/SQLCodeGuard if you don't want miss somthing fun.

The post SQL Code Guard 2.9 released appeared first on SQLServerCentral.

New developer build of SQL Code Guard released

sqlcodeguard — Wed, 09 Mar 2016 23:07:00 +0000

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 - http://sqlcodeguard.com/index-database-changelog.html#R2_9_developer

Have fun!

The post New developer build of SQL Code Guard released appeared first on SQLServerCentral.

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

sqlcodeguard — Tue, 01 Dec 2015 22:53:00 +0000

Last changes and preparation for SQLSaturday in Lviv - http://sqlsaturday.com/426/EventHome.aspx
You still have a time to register and attend it.
Great city, great people, great event - don't miss it!

The post SQLSaturday 426, Lviv, Dec 05 - only few days left! appeared first on SQLServerCentral.

Support for SSMS 2016 now available

sqlcodeguard — Wed, 11 Nov 2015 12:49:00 +0000

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 http://documentation.red-gate.com/display/MA/SSMS+ecosystem+project - 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!

The post Support for SSMS 2016 now available appeared first on SQLServerCentral.

Catching specific statements using new MI008 "Statement used" rule

sqlcodeguard — Fri, 30 Oct 2015 15:23:00 +0000

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"

First you must mark this rule as "Warning" on the "Issues" tab of settings window

Second - you must specify which statement you want to catch.
Each statement (and event most parts of statement) can be identified by tag. Full list of tag is pretty big and I'm not yet ready to publish it. But here are some of tags:
CREATE INDEX: index-statement
DROP INDEX: drop-index
CREATE TABLE: create-statement-table
DROP TABLE: drop-table
TRUNCATE TABLE: truncate-table
DECLARE CURSOR: cursor-declaration
If you need more tags please contact me, i'll help you.

Ok, imagine that you want to catch DECLARE CURSOR and CREATE TABLE statements
You need to add appropriate tags to MI008 Statements list on "Options" tab of Settings window, one tag per line.

Now you can process script or database to find if statements you find is really used.
Column "Additional info" of issues list will contain tag of found statement.

That's all, folks!
Have fun!

The post Catching specific statements using new MI008 "Statement used" rule appeared first on SQLServerCentral.

I'm alive!!!!

sqlcodeguard — Mon, 21 Sep 2015 09:47:00 +0000

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.

The post I'm alive!!!! appeared first on SQLServerCentral.

ExpressProfiler: say "Hi!" to new developer!

sqlcodeguard — Thu, 25 Jun 2015 12:52:00 +0000

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

The post ExpressProfiler: say "Hi!" to new developer! appeared first on SQLServerCentral.

SQL Code Guard - Developer build: just as planned

sqlcodeguard — Wed, 24 Jun 2015 11:36:00 +0000

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 http://sqlcodeguard.com/

Enjoy! At your own risk, of cours

The post SQL Code Guard - Developer build: just as planned appeared first on SQLServerCentral.

SQL Code Guard - developer builds

sqlcodeguard — Tue, 16 Jun 2015 10:36:00 +0000

Hi all
Unfortunatelly I'm pretty busy now and will be busy till end of the year
So I have not so much time for development and feature implementation.
It may take a lot of time while I implement enough features or fix enough bugs to make "release".
So i've decided to esatblish "developers build" - build that i'll publish every week/2 weeks or when i decide that changes worths to be published.
Same installation package, still digitally signed, but may contains some untested code.
Use it at your own risk. Well... Everything as before so nothing changes except of more frequent builds.

The post SQL Code Guard - developer builds appeared first on SQLServerCentral.

SqlSaturday 377, Kiev, May 23 - only 3 days left

sqlcodeguard — Wed, 20 May 2015 12:16:00 +0000

Hello everyone!
As you may already know - on 23rd May in Kiev will be held SqlSaturday 377.
Hurry up!
You can meet many famous speakers, including Kevin Boles, Benjamin Nevares, Dmitri Korotkevitch, Satya Jayanty, Mihail Mateev, Boris Hristov, Dmitry Piliugin and other.
Also you can attend 3 Pre-cons:
Kevin Boles. Tune Like A Guru! - https://sqlsaturday-377-precon-kevin-boles.ticketforevent.com/
Dmitri Korotkevitch. SQL Server Internals from the practical angle. - https://sqlsaturday-377-precon-dmitr.ticketforevent.com/
Benjamin Nevarez. SQL Server Query Tuning & Optimization. - https://sqlsaturday-377-precon-benjamin-nevarez.ticketforevent.com/
Session schedule can be found here http://www.sqlsaturday.com/377/Sessions/Schedule.aspx
Follow SqlSaturday 377 at Twitter - #sqlsatkiev
See you in Kiev at SqlSaturday 377!

The post SqlSaturday 377, Kiev, May 23 - only 3 days left appeared first on SQLServerCentral.