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
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
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
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;
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
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.
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
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
This is one of my most closely held DBA secrets.
Do you use PAL? You should.
...but this post isn't about PAL. Lots… Read more
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
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
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.
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