Tag Archives: T-SQL

TSQL for Beginners–#RGCommunityCircle

As a part of the Redgate Community Circle, giving back in this strange time, each of the advocates for Redgate is teaching a free course. We’re doing this live each week, according to this schedule: Mondays – Intro to SSRS … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Choosing Sequences Over Identity

When I was building software as a full time job, the choices for automatically generating surrogate keys were the identity property and the NEWID() function. At that time, GUIDs were too cumbersome to deal with, and I often used identity … Continue reading

Posted in Editorial | Tagged | Leave a comment

T-SQL Context Switching

Studies have shown that reading someone else’s code can be both stressful and time consuming. Developers that pick up unfamiliar code find themselves spending much more time comprehending the code than with more familiar projects. I think this might be … Continue reading

Posted in Editorial | Tagged ,

Lengthen a Primary Key–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a post recently where someone needed to increase the size of a PK and was getting a … Continue reading

Posted in Blog | Tagged , , | 1 Comment