Angela

I started out as a software developer back in 1996 in Denver, CO, doing Client/Server development in PowerBuilder. I am now a Data Architect, living in High Point, NC and I love what I do. I’ve worked with all versions of SQL Server since the infamous split from the Sybase code (a.k.a. version 4.21a). I’ve worn all the hats that come with dealing with SQL Server, developer to data architect and everything in between. Mastodon handle: @SQLSwimmer

All authors

Blog Post

SQLBits 2023

Super excited that I was selected to speak at SQLBits 2023. The conference is taking place 14-18 March 2023 in Wales. I have never been to Wales and am...

2023-01-06 (first published: )

236 reads

Blog Post

Bits Buddies

SQLBits is fast approaching, in fact, Training Days start 2 weeks from today, on March 8, 2022. I’ve attended SQLBits before, as well as other large conferences, but I...

2022-02-22

21 reads

Blog Post

I Still Can’t Believe It!

I received my MVP award letter from Microsoft today. This will make the fourth time I’ve been awarded and I still can’t believe it.  I just wanted to help...

2021-07-01

23 reads

Blog Post

Data Weekender v3.1

I am super excited about this new version of Data Weekender, coming up on Saturday, May 15, 2021.  This will be the third time I have been selected to...

2021-05-08

17 reads

All authors

Blogs

Better Trigger Design: #SQLNewBlogger

By

I had someone ask me about using triggers to detect changes in their tables....

SQL Server in the Cloud – Are DBAs Still Needed?

By

Things your cloud vendor may not tell you   Here’s a common theme I...

ColumnStore Indexes: The Secret to Fast SQL Queries

By

🎥 Columnstore Indexes in SQL Server – A Practical Guide with Real-World Examples 🔍...

Read the latest Blogs

Forums

Dropping a PK constraint.

By stevec883

I will have to test this next week, but will not have a chance...

SQL - Conditional merge join

By SQL Bee

I want to add a condition in the joining columns part of the merge...

Is there a way to implement ROWS between logic?

By water490

Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow...

Visit the forum

Question of the Day

What is Between?

I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned? 

SELECT *
FROM dbo.Products
WHERE ProductID
BETWEEN 4 AND 7;

See possible answers