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

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, 120 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

0 comments, 109 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.

Enjoy!

Read more

0 comments, 6,461 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,818 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, 145 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 d.id = i.id
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, 145 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, 137 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, 116 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,494 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)
);
go
insert into Customer values('Alex','Smith','Mr.');
insert into Customer values('John','Doe','Dr.');
go
Now you selecting list…

Read more

0 comments, 1,385 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, 224 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 http://sqlcodeguard.com/index-database-changelog.html

Read more

0 comments, 249 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, 195 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, 158 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, 212 reads

Posted in SQL Code Guard on 20 May 2014

ExpressProfiler: The New Kid on the Block

I'm pleased to inform you that yet another of my pet-projects, ExpressProfiler, joined the rapidly growing family of Ecosystem-based tools for SQL Server.
You may ask me, "why should I use ExpressProfiler if there is standard profiler supplied with SQL Server?"
There are a number of reasons:
First…

Read more

1 comments, 122 reads

Posted in SQL Code Guard on 15 May 2014

Psst! Wanna some API?

If you have already visited SQL Code Guard's website you might notice a reference to an "API for custom tool development". Pretty cool sounding, isn’t it? SQL Code Guard can not only find issues as a standalone tool, but also exposes its capabilities to be used in your own solutions!

Read more

0 comments, 101 reads

Posted in SQL Code Guard on 11 May 2014

A few words about simplicity: Using Red-Gate Ecosystem framework

In my first blog post I briefly covered when and why I created SQL Code Guard (SCG).
To be honest, the first version of SCG was a standalone application, but supporting a GUI took too much time so I decided to convert it to an SSMS plugin –…

Read more

0 comments, 78 reads

Posted in SQL Code Guard on 4 May 2014

When issue is not exactly "issue"

In last release of SQL Code Guard (2.4.5222) I've added few issues which can cause confusion.
Eg - ST012 "Consider using temporary table instead of table variable"
You can ask me - "What is wrong with table variable? Everyone suggests to use it! Even…

Read more

0 comments, 65 reads

Posted in SQL Code Guard on 27 April 2014

New release 2.4.5222

Today we released new version of SQL Code Guard - 2.4.5222
There are many fixes and improvements, some new rules were added.
Full list of changes you can view at http://sqlcodeguard.com/index-database-changelog.html
But there is a few more important things.
First, we introduced new type of issues - "Script…

Read more

0 comments, 71 reads

Posted in SQL Code Guard on 20 April 2014

Older posts