Editorials

SQLServerCentral Editorial

The Pervasive Nature of Open Source

This week there was a headline that said "Open Source Software Powers 96% of Modern Applications, New Study Finds" and if you stopped reading there, you might think, hey, it's not in the apps I work on. Or you might think that because you use OSS software, most of the world also does. Microsoft, Oracle, […]

You rated this post out of 5. Change rating

2024-12-07

16 reads

SQLServerCentral Editorial

Doing a Little Research

I've been very pleased with the direction of SSMS the last few years. As it's been separated from SQL Server releases and gets updated more often, I think the changes from v17 though v20 have been improvements. There are still issues, but it's been better. Now we finally have SSMS moving to a modern shell […]

You rated this post out of 5. Change rating

2024-12-02

116 reads

SQLServerCentral Editorial

Lies You Should Believe - Anything is possible

We have all heard the saying I based this week's editorial on. It has been credited to Benjamin Franklin and goes like this, “You can do anything you set your mind to”. This is such a powerful way of thinking when you are starting a task. “I can do it, no matter what anyone says.” […]

You rated this post out of 5. Change rating

2024-11-30

80 reads

Blogs

Big Queries, Big Money

By

I had been meaning to post this, so as I finished a piece that...

A New Word: Fardle-dun

By

fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...

Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch

By

The post Lukáš Karlovský: I got the green light from management and built Fabric...

Read the latest Blogs

Forums

Trigger After Update to Update the Updated Table

By Dennis Jensen

Okay I can easily see how to update a table field after an Insert...

The Pervasive Nature of Open Source

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Pervasive Nature of Open...

Group Delete

By Bruin

I have 2 tables which I need to cleanup old costkeys, based upon a...

Visit the forum

Question of the Day

Subqueries II

What is wrong (if anything) with this code?

SELECT *
 FROM Sales.SalesOrderHeader AS soh 
 WHERE customerid IN (SELECT soh.CustomerID 
                       FROM Sales.Customer AS C
   WHERE soh.CurrencyRateID = 1
   ORDER BY c.ModifiedDate)

See possible answers