Rotating Header Image

Posts from ‘July, 2011’

Being a DBA – I Love What I Do

I’m proud to announce that I am a finalist for this years Exceptional DBA Award from Red Gate.  It is an honor to be selected as a candidate to receive this award because being an exceptional DBA is something that I take very seriously.  If you don’t “know” me or haven’t chatted with me in the […]

EDMPASS Presents: The Jubilee Jitterbug in July with Jen McCown Jackpot

On July 27th 2011 the Edmonton Chapter of PASS is having it’s next meeting. Details below: Date:  July 27th 2011 Time: 5:45 pm – 7:00 pm Location: Virtual – Live Meeting Speaker: Jen McCown Topic: Unraveling Tangled Code – A Spellbinding Tale of Victory Over Chaos You will need the Attendee URL: https://www.livemeeting.com/cc/usergroups/join?id=PW3NMB&role=attend&pw=J%3D%3Fb88*Ms  Meeting ID:  […]

Temp Tables and Primary Keys

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 […]

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.