Tuesday, December 1, 2015

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

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!

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 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!

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 http://sqlcodeguard.com/
Enjoy! At your own risk, of cours ;)

Tuesday, June 16, 2015

SQL Code Guard - developer builds

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.

Wednesday, May 20, 2015

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

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!

Monday, May 4, 2015

SQL Code Guard v2.8 released

Main change - SCG moved back to .Net framework 3.0 to restore support of SSMS 2008/2008R2
Few small fixes, additional logging, nothing critical.

Saturday, May 2, 2015

Using SQL Code Guard TFS Checkin Policy with VS2013

To use TFS Checking policy the first thing that you must do - is to add policy to your TFS source control
The process itself is pretty simple

  1. Install SQL Code Guard at target computer. Please remember that you will need to have SCG installed on each computer on which you will do checkin to project with SCG policy enabled.
  2. Register SQL Code Guard with VS - devenv /setup
  1. add checking policy
    1. select TFS collection / project
    2. open menu TEAM -> Team Project Settings -> Source Control
    3. Select Check-in Policy tab
    4. click Add button
    5. select SQLCodeGuard.CheckinPolicy policy and press OK button
    6. Press OK to close "Source control settings" dialog

Now you can try to use/test checkin policy
  1. add (or edit) sql file in TFS
  2. select "Pending changes"
  3. If you didnt placed SQL Code Guard settings file in project directory then you will get message "Unable to find settings"
  4. if there are issues in script file - you will see warning message

You can doubleclick on message and error list window with full set of of issues will appear

Doubleclick on issue will navigate you to location of issue.
That's all, folks!

Wednesday, March 18, 2015

24HOP Russian Edition

Spoke at 24HOP Russian edition.
Interesting experience.
It is difficult to determine mood of audience if there is no visible audience  :)
And looks like that 90 minutes is too less for me.

Wednesday, March 4, 2015

SQL Code Guard v2.7 and SQL Server 2008R2: bad news and good news

Hi all!
Bad news: SQL Code Guard v2.7 is not working with SSMS from SQL Server 2008R2 (and below).
Good news: I know about this issue, already fixed it in my development environment and will release fix in nearest possible future.
Bad news (again) : integration will not work with SSMS from SQL Server 2005. Even in next release.

Tuesday, February 17, 2015

SQL Code Guard v2.7 released

SqlCodeGuard v2.7 is just released.
To be brief - major changes:
1. Added command line utility
2. Added scgallow(issue)/scgignore(issue`)to control which issues should be registered
3. Added [SC004] Found todo item. You can use "--# todo <text>", "--# bug <text>", "--# fix <text>" or "--# warning <text>" marks in your scripts.
4. Added support for VS2013
5. SQL Code Guard moved to .Net Framework 4.0

Full list of changes can be found here 
Bon app├ętit!

Monday, February 9, 2015

ExpressProfiler - new build published

Just published new signed build of ExpressProfiler - few nice improvements like advanced search, stay on top window, transparency - just to make life easier
Actually there is no change since last august, i simply build, sign and publish version that already was in CodePlex's TFS, but now you can get binaries.