Just released new build of ExpressProfiler.
No major changes, just cosmetic improvements - shortcut here, confirmation dialog there, new captured events (SQL:StmtStarting/Completed,...

2014-08-11 (first published: 2014-08-04)

8,818 reads

Keep it simple.... you know.

by sqlcodeguard

SQL Code Guard

Twice a week I am asked "why don't you add new cool feature to ExpressProfiler?"
The answer is as simple as...

2014-07-22

491 reads

[BP017] DELETE statement without WHERE clause

by sqlcodeguard

SQL Code Guard

Sometimes people ask me: "What wrong with following code? Why issue BP017 is registered?"
delete d
from dbo.Data d innerjoin #ids i...

2014-07-07

657 reads

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

by sqlcodeguard

SQL Code Guard

Imagine that you have a huge collection of Hello Kitty images (I do).
One day you make a decision to organize...

2014-06-30

1,913 reads

ExpressProfiler: Yet another "when and why" story.

by sqlcodeguard

SQL Code Guard

Core of ExpressProfiler was born about 8 years ago when I worked for a company whose mission was the migration...

2014-06-23

745 reads

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

by sqlcodeguard

SQL Code Guard

When surfing SQL Server forums you might notice a lot of questions like "How do I script my data and...

2014-06-17 (first published: 2014-06-15)

3,605 reads

Don't mess with success or Everybody lies.

by sqlcodeguard

SQL Code Guard

Imagine that you have a table of customers
createtable Customer
(
Name varchar(30),
LastName varchar(30),
Title varchar(30)
);
go
insertinto Customer values('Alex','Smith','Mr.');
insertinto Customer values('John','Doe','Dr.');
goNow you selecting list...

2014-06-10 (first published: 2014-06-09)

1,881 reads