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

Speaking at #DataWeekender 6.5

Super excited to share that I have been selected to speak at Data Weekender 6.5 on Saturday, November 4, 2023. I will be presenting my session, Can Microsoft Purview...

2023-10-23

14 reads

Blog Post

Speaking at Live! 360

I am super excited to announce that I have been selected to speak at SQL Server Live! in Orlando in November. I have selected to present two sessions, which...

2023-07-03

8 reads

Blog Post

No In-Person SQLBits For Me

I am saddened to report that I will not be able to attend SQLBits in person this year as originally planned. I was involved in a terrible car accident...

2023-02-24

13 reads

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: )

229 reads

All authors

Blogs

Non-Functional Requirements

By

I have found that non-functional requirements (NFRs) can be hard to define for a...

Degrees and Trade Schools

By

Can we normalize a couple of things? 1 – Trade Schools. Back in the...

Unlock the Power of Your Data: From Basic to Advanced Data Analysis

By

Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...

Read the latest Blogs

Forums

Remove comma inside Comma Delimited File csv in SSIS Using Script task

By hongho2

Hi, I have two tables: one for headers with 9 fields and another for...

Inserting 100K rows Performance - Baseline Performance

By MichaelT

We're trying to understand how quick new versions of SQL server can be.  Obviously...

plugging a repo version number into the tabular model

By stan

hi we run 2019 std.  we saw this week that someone hid 3 important...

Visit the forum

Question of the Day

The "ORDER BY" clause behavior

Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records: 

create table t1 (id int primary key, city varchar(50));

insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);
If we execute the following query, how will the records be sorted in both environments? 
select city

from t1

order by city;

See possible answers