Just a quick little post today on a little “gotcha” that may getcha. Let’s say you’re creating a stored procedure that needs to create a #temp table that has a PRIMARY KEY. You will want to be careful about how you create this #temp table and here is why: Open SQL Server Management Studio and run the [...]
Posts under ‘General’
My New Job
So if you read my last blog post: Wind of Change you were both subjected to some 80s “rock” care of Scorpions and my announcement that I was leaving my then current gig for a new contract. I’m now happy to formally announce that I’m the new Senior DBA for Invidi. This is an exciting opportunity [...]
Wind of Change
I know as an independent contractor change is constant but sometimes it hits you alot more than others. I’ve been at my current “gig” for almost 3 years so deciding to wind down and leave comes with it’s fair share of emotions, emotions that I haven’t felt since I was a full-time employee. The team [...]
Jobs Jobs Jobs
If a job fails in production and nobody is there to see it, does it get noticed? Deep huh? Well if the job actually does something important of course it will get noticed. So the bigger question is: What can you do to make sure that YOU know about it before anyone else does? Cause [...]
Meme Monday
Welcome to the first Meme Monday! Today’s meme is “Write a SQL blog post in 11 words or less”, and here is my entry: Taking backups is half the job, don’t forget to restore them Tag Time Grant Fritchey (blog @GFritchey ) Aaron Bertrand ( blog @AaronBertrand ) Jorge Segarra ( blog @SQLChicken ) Great idea [...]
