Kendra’s Top 3 Tips for Working Remotely
A guest editorial today from Kendra has a few tips for working from home.
2024-04-15 (first published: 2020-03-12)
1,226 reads
A guest editorial today from Kendra has a few tips for working from home.
2024-04-15 (first published: 2020-03-12)
1,226 reads
In this episode of Dear SQL DBA, I talk about how Redgate runs "Down Tools Week," what I'm working on as part of the project, and how this has...
2020-08-21 (first published: 2020-08-06)
186 reads
Many people use entrenched processes for database development that have been in place so long that it’s hard to imagine doing it any other way. In this episode, I...
2020-08-11 (first published: 2020-07-30)
728 reads
I'm not an expert on collation in SQL Server, but there are a few important facts which I've had to learn the hard way.
In this episode I share...
2020-07-27 (first published: 2020-07-16)
918 reads
No matter what I write in this post, some of y'all are going to tell me I'm wrong. That's inevitable, because I'm writing about tempdb: a database so complex...
2020-07-24 (first published: 2020-07-15)
614 reads
Today Kendra discusses the advantages of using a command line interface for Git.
2020-01-16
391 reads
Today we have a guest editorial from Kendra Little that looks at choosing a version control system as you adopt a Database DevOps software development process.
2019-04-19
535 reads
2019-03-05
867 reads
Kendra Little explains why Redgate would like to hear your stories of how the database has been left behind.
2019-02-14
230 reads
2019-01-21
108 reads
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
By Kevin3NF
Can we normalize a couple of things? 1 – Trade Schools. Back in the...
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
hi we run 2019 std. we saw this week that someone hid 3 important...
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