@SQLRockstar (Tom LaRock) recently asked the SQL bloggers in his “Meme Monday” series to write about what the term “SQL Family” means to them. It’s amazing how many thoughts/ideas come into your head when you hear the term #SQLFamily. I was able to breakdown what #SQLFamily means to me into 3 categories: Technology Professional Development [...]
Posts under ‘General’
Happy Halloween From Benchmark IT Consulting
If you’d like to chat with me about this or anything else (SQL or other) please leave a comment or hit me up on my Twitter: @ColinStasiuk
Turn the Page
Something that has been problematic at best for developers to deal with historically is the idea of “paging”. Basically being able to say that if I was assuming 10 rows per page, I want to see what the contents of page 250 would be. In order for you to work with my example (which uses [...]
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 [...]
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 [...]
