SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: June 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, 1,592 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, 721 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, 3,441 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,865 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, 1,650 reads

Posted in SQL Code Guard on 2 June 2014