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


Some dude named Chuck.

Archives: October 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, 1,045 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, 753 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, 1,313 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, 1,220 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, 662 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, 2,008 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, 840 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, 827 reads

Posted in @chuckboycejr on 18 October 2012