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


Some dude named Chuck.

Carry On

Sometimes the answer is to keep going.

Forget words, figuring things out, and circumstances. Just keep moving your feet.


"Nothing in the world can take the place of Persistence. Talent will not; nothing is more common than unsuccessful men with talent. Genius will not; unrewarded genius is almost a… Read more

0 comments, 328 reads

Posted in @chuckboycejr on 9 April 2013

how to get ahead

Many people have ideas as to how to do well in life. Of course, many people do not even agree on what success even means. I found one piece of advice many years ago that has been motivating and I share it with you for you to consider:

"Do… Read more

0 comments, 1,138 reads

Posted in @chuckboycejr on 5 December 2012

should I use clustering on a VM?

ok, I'm going to keep this high level and simply share my opinion.

I am not prescribing anything.

If you want prescriptive advice, read Allan Hirt (that's what I do) and go to #sqlhelp.

read more Read more

0 comments, 421 reads

Posted in @chuckboycejr on 28 November 2012

thanks for Bud

My Dad died horribly three weeks ago in a fall after the power got knocked out during Hurricane Sandy. I am barely able to talk about it and may never be for all I know.

My Dad was a very special man. One that I did not appreciate until I… Read more

0 comments, 442 reads

Posted in @chuckboycejr on 22 November 2012

blogging fun: dealing with spammers like Psychz Networks

@PsychzNetworks is spamming me non-stop. Every minute of every day.

I googled them and it seems Psychz Networks are famous for spamming people.

I have removed non-moderated comments (I didn't want to do this and have since added non-moderated comments back) - didn't stop Psychz Networks' spam.

I have… Read more

1 comments, 720 reads

Posted in @chuckboycejr on 21 November 2012

[video] Inside Tempdb - Bob Ward

Boris Hristov shared this with me ages ago and I still haven't watched it yet (it is a few hours long).

Maybe today or sometime this slow holiday week I will find the time to enjoy this TEMPDB knowledge feast.

If you have the time, do yourself a favor and… Read more

0 comments, 678 reads

Posted in @chuckboycejr on 20 November 2012

Bob Duffy

ok, everyone has their favorite SQL guru and favorite SQL tips. There are some people whose names you associate with insight and good advice. Sentences that begin with "So and so says..." make you take notice when you might otherwise be too distracted to listen as you should.

Well, I… Read more

0 comments, 480 reads

Posted in @chuckboycejr on 19 November 2012

circle of trust

I have heard it said that a former US President once remarked "People tell you who they are by their actions. When people tell you who they are - believe them."

I believe (and rely) on the concept of grace and forgiveness. This post is not about that. A famous… Read more

0 comments, 416 reads

Posted in @chuckboycejr on 16 November 2012

"fail fast" vs calligraphy

If you are a person inspired by ideas, you have probably encountered the concept of "fail fast". You probably also have read the Steve Jobs' commencement speech where he illustrated how a random calligraphy class that he attended in college influenced the ways computers were designed throughout the world. Read more

0 comments, 423 reads

Posted in @chuckboycejr on 15 November 2012

problem solving: sometimes you need to walk away from a problem to solve it

If anyone is a believer in solving challenges through sheer force of will, it's me. I'm a stubborn man and I am the son of an even more stubborn man. I don't believe in the word "quit" and I don't believe in giving up. I am however - as are… Read more

1 comments, 391 reads

Posted in @chuckboycejr on 14 November 2012

How to obtain the version and license for a Red Gate SQL BACKUP install


here is a little script I've hobbled together that I use to get version and license info for a Red Gate install




DECLARE @version nvarchar(32) DECLARE @edition int DECLARE @SerialNumber VARCHAR(30);

exec master..sqbutility 21, @edition OUTPUT, @version OUTPUT, @SerialNumber OUTPUT;

read more Read more

0 comments, 449 reads

Posted in @chuckboycejr on 13 November 2012

DR: SQL installed on new path, master restored, and SQL can't find resource database or start jobs!?!

If you ever need to perform a DR install of SQL to a new path and then restore the system databases, you may encounter these gotchas.

I share these gems that google (and the authors) have wrought:

For SQL 2005 you may learn that the instance cannot find the resource… Read more

0 comments, 330 reads

Posted in @chuckboycejr on 12 November 2012

Geographic Failover/Redundancy (and DR)

Today we await the arrival of a 100 year storm that threatens to surge New York harbor and the Long Island Sound by 6-11 feet!

In light of Hurricane Sandy barreling through the East Coast, I thought I'd review some of the very basics of DR.

read more Read more

0 comments, 500 reads

Posted in @chuckboycejr on 29 October 2012

[off topic] I crossed a milestone today

Hey everyone,

I have been nearing this goal for some time (a few times coming within fractions) so this is somewhat anti-climactic, but it's always nice when we cross the finish line of a goal we have placed for ourselves.

On July 24, 2011 - I stepped on a scale… Read more

6 comments, 400 reads

Posted in @chuckboycejr on 26 October 2012

SQL won't start because there's not enough space to create TEMPDB

SQL Server will not start.

You open up the ERRORLOG (...which I would only do with a text editor like gVim that creates a cache of the files it opens and can safely read files that have the possibility of being written to while you are reading it...) and you… Read more

0 comments, 692 reads

Posted in @chuckboycejr on 25 October 2012


This is one of my most closely held DBA secrets.

Do you use PAL? You should.

Clint Huffman is a golden god and the wonder he has brought forth to the world in PAL is worthy of a statue in his honor.

...but this post isn't about PAL. Lots… Read more

0 comments, 599 reads

Posted in @chuckboycejr on 24 October 2012

"malpractice" in IT?

Through most of my career, I believed that at some point I would be able to learn enough and master my profession to such an extent that I would be able to prescribe and guide my clients both internal (if I was a full-time employee) or external (if I was… Read more

0 comments, 422 reads

Posted in @chuckboycejr on 23 October 2012

Red Gate log shipping

Log shipping is great.

It's basically the act of beginning a restore with no recovery, and then restoring logs (with no recovery) indefinitely up until the moment your DR needs require you to need a warm standby.

What's even better than log shipping?

Red Gate log shipping.

Red Gate SQLBackup… Read more

0 comments, 931 reads

Posted in @chuckboycejr on 22 October 2012

this is what I do when I install SQL. How about you?

Whenever I install a standalone SQL instance (installing on a failover cluster adds a few more steps) on a x64 host (who would install SQL on a x86 in 2012?), I always do the following:

I install the latest version of Red Gate SQLBackup.

read more Read more

0 comments, 530 reads

Posted in @chuckboycejr on 19 October 2012

UDL files with TRUSTED authentication - a security risk?

Hi everyone,

So the other day on twitter in #sqlhelp and privately with some friends at Microsoft and elsewhere I had a lively and surprising conversation about UDL files.

We all know that we should be using Windows authentication, but if you're an Ops DBA like me you know that… Read more

0 comments, 423 reads

Posted in @chuckboycejr on 18 October 2012

Newer posts