Finding duplicates was an interview question for me years ago, and I’ve never forgotten it. Recently I got asked how to easily do this and delete them, so I...
2026-04-01 (first published: 2026-03-18)
227 reads
I come to Heathrow often. Today is likely somewhere close to 60 trips to this airport in my lifetime. After over 19 years of working with Redgate (plus a...
2026-03-18 (first published: 2026-03-17)
18 reads
I had a great time at SQL Saturday Atlanta 2026 this past weekend. I had some good comments and a few questions. I’ll write a bit more on this,...
2026-03-16
4 reads
Learn how to tie a bowline knot. Practice in the dark. With one hand. For the rest of your life, you’ll use this knot more times than you would...
2026-03-13
15 reads
One of the things I’ve tried hard to do in database development situations if ensure I could easily refresh dev and test environments on demand. In a small startup,...
2026-03-20 (first published: 2026-03-11)
323 reads
This month we have a new host, James Serra. I’ve been trying to find new hosts over the last few years to keep this party going and to expand...
2026-03-10
12 reads
AI is everywhere. It’s in the news, it’s being added to every product, management wants everyone to be more productive with AI. Redgate Monitor isn’t immune from this wave....
2026-03-09
23 reads
This is kind of a funny page to look at. The next page has more detail. This is the text from the facing page: What we do is very...
2026-03-06
37 reads
One of the nice things about Flyway Desktop is that it helps you manage your database code as a project and see what changes are being built. However, many...
2026-03-16 (first published: 2026-03-04)
154 reads
It’s a day off for Redgate today. This is our annual wellbeing day, where everyone gets the day off. Well, not everyone, but anyone that has to work today...
2026-03-02
12 reads
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
hi, we couldnt get our upstream data source developers to supply what is sometimes...
Are there any good articles on all the trace flags that are enabled on...
Comments posted to this topic are about the item The Data Model Matters
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers