Subscribe to this blog
@chuckboycejr
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.
0 comments, 371 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, 326 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, 442 reads
Posted in @chuckboycejr on 25 October 2012
perfcollect
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, 470 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, 345 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, 643 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.
0 comments, 423 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, 320 reads
Posted in @chuckboycejr on 18 October 2012