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

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.

Read more

0 comments, 164 reads

Posted in SQL Code Guard on 18 March 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…

Read more

0 comments, 208 reads

Posted in SQL Code Guard on 4 March 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…

Read more

0 comments, 1,080 reads

Posted in SQL Code Guard on 17 February 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…

Read more

0 comments, 200 reads

Posted in SQL Code Guard on 9 February 2015

How to fix: Visual Studio 2012 startup problem: The 'HDIProjectPackage' package did not load correctly.

After installing Community Edition of VS2013 with some additional packages i've noticed that my VS2012 starts failing to start with message like "The 'HDIProjectPackage' package did not load correctly. The problem may have been caused by a configuration change or by the installation of another extension. You can get more…

Read more

3 comments, 1,458 reads

Posted in SQL Code Guard on 15 November 2014

SQLSaturday 311, Sofia, October 11

Making last changes before sqlsat 311.
By the way, did you ever visited SQL Saturday? No? Why?
SQL Saturday is fun, SQL Saturday is free, SQL Saturday is just what you need!
Good place to meet famous speakers from all around the world, ask them question that cannot…

Read more

0 comments, 192 reads

Posted in SQL Code Guard on 5 October 2014

To be brief. What to do when PATH variable is too long to be real PATH.

Sometimes after installing pretty useful addins when starting SSMS you can see error message like "Exception has been thrown by the target of an invocation"

That can mean that your PATH variable is tooooo long to fit some system functions - and SSMS crashes.
Question "Why one function allows to…

Read more

1 comments, 239 reads

Posted in SQL Code Guard on 15 September 2014

SQL Code Guard v2.6 released

Today we released new version of SQL Code Guard, 2.6
Main changes:
1. Bug fixing
2. Small GUI and usability improvements
3. Fixed support of SQL2014
4. Changed behavior of some issues.


Read more

0 comments, 6,588 reads

Posted in SQL Code Guard on 18 August 2014

ExpressProfiler - new release

Just released new build of ExpressProfiler.
No major changes, just cosmetic improvements - shortcut here, confirmation dialog there, new captured events (SQL:StmtStarting/Completed, Blocked Process report), descriptions for events/columns.
Still digitally signed, still 2 options - installation package (including Red Gate Ecosystem registration ) and standalone application.

Also do not…

Read more

0 comments, 7,966 reads

Posted in SQL Code Guard on 4 August 2014

Keep it simple.... you know.

Twice a week I am asked "why don't you add new cool feature to ExpressProfiler?"
The answer is as simple as ExpressProfiler itself - you should always keep things as simple as you can.

Should be balance.
On one hand you have nothing that requires nothing and does nothing -…

Read more

0 comments, 206 reads

Posted in SQL Code Guard on 22 July 2014

[BP017] DELETE statement without WHERE clause

Sometimes people ask me: "What wrong with following code? Why issue BP017 is registered?"
delete d
from dbo.Data d inner join #ids i on =
As you can see, rows to be deleted are limited by joining with temporary table named #ids which apparently contains a list…

Read more

0 comments, 226 reads

Posted in SQL Code Guard on 7 July 2014

I like to move it, move it. Upload and download binary data to or from SQL Server using standard tools

Imagine that you have a huge collection of Hello Kitty images (I do).
One day you make a decision to organize your collection - sort it, label it, tag it, remove duplicates and so on. The first thing you need - sophisticated data storage, of course. And it is obvious…

Read more

2 comments, 258 reads

Posted in SQL Code Guard on 30 June 2014

ExpressProfiler: Yet another "when and why" story.

Core of ExpressProfiler  was born about 8 years ago when I worked for a company whose mission was the migration of Oracle and Sybase to SQL Server. We used a tool for automated database code conversion and migration (a pretty good tool btw - SSMA).
If you already know…

Read more

0 comments, 177 reads

Posted in SQL Code Guard on 23 June 2014

Script, store and transfer data using XML, XQuery and clipboard

When surfing SQL Server forums you might notice a lot of questions like "How do I script my data and transfer it to another server?". Of course these questions always have answers,  from "Nohow" to "Use SSMS 2012/ SSMSBoost/ SSMS Toolpack". But what can you do if you…

Read more

3 comments, 2,717 reads

Posted in SQL Code Guard on 15 June 2014

Don't mess with success or Everybody lies.

Imagine that you have a table of customers
create table Customer
Name varchar(30),
LastName varchar(30),
Title varchar(30)
insert into Customer values('Alex','Smith','Mr.');
insert into Customer values('John','Doe','Dr.');
Now you selecting list…

Read more

0 comments, 1,486 reads

Posted in SQL Code Guard on 9 June 2014

How to easily automate SQL Code Guard.

It may happen that you have a need to check the scripts that you have on your disk.  For example, it may be part of your build process.
So how you can run SQL Code Guard as a command-line tool?
If you are a TRUE programmer then the…

Read more

0 comments, 380 reads

Posted in SQL Code Guard on 2 June 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

Read more

0 comments, 406 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, 253 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, 232 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, 316 reads

Posted in SQL Code Guard on 20 May 2014

Older posts