drsql@hotmail.com


SQLServerCentral Editorial

Do you listen to music when you work?

I want to make this a participation topic. When you are working, do you listen to music or do you need quiet? And if it isn’t music, do you do something else? TV, movies? For me, it is almost always music. As I write my first Database Weekly newsletter editorial in a few months, I […]

You rated this post out of 5. Change rating

2024-04-20

128 reads

SQLServerCentral Editorial

Sharing the Work You Do 

During one my yearly review, I got one particularly interesting piece of feedback. “You need to share the work you are doing and share with the company.” This is basically a matter of letting people know about the stuff we are putting out on Simple-Talk.com. It is something that is regularly done here, but to […]

You rated this post out of 5. Change rating

2024-01-27

81 reads

SQLServerCentral Editorial

Being A Bit Less Comfortable in 2024

I hate coming up with ideas for editorials, but my last editorial of the year gives me a very simple topic just staring me in the face: New Year’s Resolutions. Love them or hate them (or it we are honest, a good bit of both,) this end of one year and the start of another […]

You rated this post out of 5. Change rating

2023-12-30

144 reads

SQLServerCentral Editorial

Love

Love is many a splendored thing. It is also a much-abused word with many different (and twisted) meanings. The type of love I wish to speak about today is not friendship, nor the kind of thing that makes your heart go pitter patter in the springtime, but rather the type of love known as storge, […]

You rated this post out of 5. Change rating

2023-12-09

63 reads

SQLServerCentral Editorial

You Are An Inspiration

Hero, Champion, Inspiration. These are words that are bantered around about people regularly. Joe was a hero when he saved that puppy. Betty was the champion runner and won the race. Pat was an inspiration; they work so hard. Hero and champion are universally understood as positive things. Inspiration is typically used as a positive, […]

You rated this post out of 5. Change rating

2023-11-25

80 reads

SQLServerCentral Editorial

A rose by any other name would not be a rose

William Shakespeare once wrote in the play Romeo and Juliet: “What's in a name? That which we call a rose, by any other word would smell as sweet.” It is a beautiful sentiment in that context, and even still you might say that there is some truth to this saying in a lot of ways.  […]

You rated this post out of 5. Change rating

2023-11-04

698 reads

SQLServerCentral Editorial

Confidence

Today, I want to blog about something I have only limited knowledge of … confidence. Okay, I understand what confidence is, and I have seen it before in the real world and not just in biographical movies. In fact, I have met quite a few highly confident people. In almost every case, it was immediately […]

5 (1)

You rated this post out of 5. Change rating

2023-10-07

72 reads

SQLServerCentral Editorial

What Counts For a DBA: Manners

When most people were young, they had someone telling them to "Mind your manners." Such classics as: "Keep your elbows off of the table," "Use a fork," "Put on deodorant," as well as "Don't chew with your mouth open" were bandied about like there were laws of nature. However, manners differ significantly from laws in […]

5 (2)

You rated this post out of 5. Change rating

2023-08-12

122 reads

SQLServerCentral Editorial

Keep your Resume Reasonable

The other day, I was in a Twitter discussion interviewing people for technical positions. This reminded me of one of my favorite things to do in interviews… reading the list of qualifications/skills and asking questions about its contents. If you put it on the resume, I assume you know something about it and are willing […]

You rated this post out of 5. Change rating

2023-07-15

121 reads

SQLServerCentral Editorial

Software Flexibility (Avoiding the next hack)

As computer scientists, it often feels like our job is to tell the business user, "No, we can't do that because the software you asked for, and we built, doesn't allow it ..." Then, after a long and relatively silly meeting where your soul dies a little, the business user typically gets 80% of what […]

5 (2)

You rated this post out of 5. Change rating

2023-06-10

93 reads

Blogs

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...

FIRST_VALUE vs. Min: #SQLNewBlogger

By

I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...

Read the latest Blogs

Forums

CPU Performance Advice in SQL Server 2005

By JoeLee

I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...

CPU Performance Advice in SQL Server 2005

By JoeLee

I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently...

Duplicate Documents

By VastSQL

Hi Experts, I am trying to find duplicate documents stored in our Filestream database....

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