Tag Archives: T-SQL

Creating a New Sequence–#SQLNewBlogger

Posted on June 3, 2020 by way0utwest

I wrote about sequences in an editorial recently and decided to start using them. Creating one turned out to be surprisingly easy. I had a table I’d been logging some data in, with a PK, but no natural key or … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Creating a New Sequence–#SQLNewBlogger

Using WAITFOR to Test Slow Code–#SQLNewBlogger

Posted on May 27, 2020 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One thing I needed to do lately was test how a calling program would respond to slow code. I … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Using WAITFOR to Test Slow Code–#SQLNewBlogger

TSQL for Beginners–#RGCommunityCircle

Posted on May 8, 2020 by way0utwest

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 , , , , | Comments Off on TSQL for Beginners–#RGCommunityCircle

Choosing Sequences Over Identity

Posted on May 5, 2020 by way0utwest

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 | 2 Comments