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

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:

Read more

0 comments, 106 reads

Posted in SQL Code Guard on 20 May 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.

Read more

0 comments, 153 reads

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

Read more

0 comments, 4,072 reads

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

Read more

0 comments, 175 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, 221 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,102 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, 218 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,557 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, 203 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, 261 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,612 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,983 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, 213 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, 242 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, 296 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, 199 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,745 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,519 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, 418 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, 425 reads

Posted in SQL Code Guard on 26 May 2014

Older posts