Backing Up Your Old Systems
I am currently on a project to review some older servers (SQL 2000 and 2005) for SIMPLE recovery (and therefore...
2012-02-16
398 reads
I am currently on a project to review some older servers (SQL 2000 and 2005) for SIMPLE recovery (and therefore...
2012-02-16
398 reads
The #Meme15 assignment from Jason Strate (Blog/@StrateSQL) for February is to describe how and why we use LinkedIn. I felt...
2012-02-15
389 reads
http://vimeo.com/33411604
This is a talk given by Thomas LaRock (@SQLRockstar to you Twitter-folk) at an event last fall in NYC called...
2012-02-15
372 reads
This Christmas if I could get one thing from Microsoft it would be recognition that DBA's are not developers. This...
2011-12-05
735 reads
As I have previously written about in this space, I have recently moved to House of Brick Technologies. Part of...
2011-11-15
374 reads
Steve Jones (blog/@way0utwest) from SQLServerCentral posted his daily editorial today titled "The Industry Problem" in which he describes an article he...
2011-11-14
1,014 reads
Steve Jones (Blog/@Way0utWest) recently wrote a great blog post proposing that Microsoft should go from having edition-only features (most of...
2011-10-21
420 reads
Starting Halloween Monday I will be a Technical Consultant for House of Brick Technologies.
To everyone out there saying "Didn't you...
2011-10-19
510 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
I have had a hard time to understand how to use EXISTS. I Always...
Dears, We are using Azure Data factory pipes to run some stored procedures against...
Hi, I have SQL Server 2019 installed and when go the Clear Trace database...
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