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 [...]
Posts from ‘July, 2011’
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 [...]
