Archives: November 2012
ok, I'm going to keep this high level and simply share my opinion.
I am not prescribing anything.
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
@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
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
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
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