SQLServerCentral Editorial

Giving Thanks

My last two months have been packed full of activity. I’ve had the amazing opportunity to be with PostgreSQL friends in New York, Greece, and Seattle. In between, it was a treat to be back in Pittsburgh for the first SQL Saturday since before the pandemic. The strength of the database community at each event […]

5 (1)

You rated this post out of 5. Change rating

2024-11-24 (first published: )

33 reads

SQLServerCentral Editorial

Unstuck

Have you ever been stuck in some area of your life? Maybe at work? That big project. Progressing in your career. The slow query that seems impossible to make faster. Learning new skills to switch careers. Maybe outside of work? The weekend home project that’s been going on for more than a few weekends… possibly […]

You rated this post out of 5. Change rating

2024-09-28

70 reads

SQLServerCentral Editorial

It's Time to Play

Writing editorials every few weeks for a technical mailing list has been one of the more challenging responsibilities in my (nearly) two years with Redgate as an advocate working with Steve, Grant, and Louis. Each week, it’s interesting for me to see the mix of technical insights and everyday life stuff that each of us […]

You rated this post out of 5. Change rating

2024-08-31

383 reads

SQLServerCentral Editorial

What Sport Would You Play?

We’re halfway through the Olympics, with all the usual drama – highs, lows, special interest stories - and even a surprise hero in Yusuf Dikec at the 10-meter air pistol (the memes have been strong with this one). As I was talking with my children this week, one of them asked, “So dad, what sport […]

You rated this post out of 5. Change rating

2024-08-04 (first published: )

47 reads

SQLServerCentral Editorial

Planes, Trains, and Automobiles

I remember going to the theater over the Thanksgiving holiday in 1987 and seeing Planes, Trains, and Automobiles with Steve Martin and John Candy. My family didn’t often take in the holiday weekend movie releases, but Steve was a family favorite actor already, and friends had given it a good review. Having watched it just […]

You rated this post out of 5. Change rating

2024-07-20

157 reads

SQLServerCentral Editorial

Baseball Everywhere

Last week was supposed to be my turn to curate Database Weekly and write an editorial to go along with it. Graciously, Mr. Louis Davidson (@drsql) offered to switch weeks while I was in Cambridge, England with most of the Redgate Marketing team for our yearly global gathering at HQ. As a remote worker on […]

You rated this post out of 5. Change rating

2024-06-15

50 reads

SQLServerCentral Editorial

Honeybee Swarms

I love honeybees. This will be my seventh year as an amateur beekeeper, and aside from family or data, there are few other topics that I could easily spend an afternoon talking to you about. They’re amazing creatures. This past winter I had to move my beehives temporarily to the apiary of a friend. With […]

5 (1)

You rated this post out of 5. Change rating

2024-05-12 (first published: )

68 reads

SQLServerCentral Editorial

There's No Free Lunch with Open-source Software

As a member of the PostgreSQL open-source community, I have been following the recent license change by Redis Labes on March 20, 2024. Redis introduced a dual license model, specifically adding the Redis Source Available License (RSAL), which prevents other vendors from providing Redis as a service without a paid subscription from Redis Labs. The […]

5 (3)

You rated this post out of 5. Change rating

2024-04-13

150 reads

SQLServerCentral Editorial

Give It Away

Tech conference season is in full swing, and it’s only the middle of March. Between Grant, Steve, and I, we’ve attended or presented at about 10 events so far. And within my community of developers and database folks, I’ve seen pictures and posts of many more. As I’ve said a few times in previous editorials, […]

You rated this post out of 5. Change rating

2024-03-17

67 reads

SQLServerCentral Editorial

Software Updates, Outages, Processes, and Protocols

This past Thursday, February 22, AT&T had a major outage on their U.S. network. For upwards of 10 hours, hundreds of thousands of customers could not make phone calls, send or receive texts, or use mobile data for apps or browsing websites. Aside from not being able to communicate as normal, it also appeared to […]

You rated this post out of 5. Change rating

2024-02-24

101 reads

Blogs

Ways to land data into Fabric OneLake

By

Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...

A Very Cool Benefit in SSMS 21

By

I saw a post from Erin that Preview 2 is available. I’d gotten a...

AI Helping with an API

By

Can an AI help me with some database API work? Let’s see. This is...

Read the latest Blogs

Forums

Copy a large table from one table to another

By shivaji

Hi, I have large table with 75 columns and 1.1 billion rows. Want to...

Topic marked as spam - by mistake?

By Phil Parkin

I received the following notification a few hours ago. It seems legit but has...

Getting blockage on Update Statement

By anshu.shikha

Hi, Need your help. I've a SP that is using Update statement on a...

Visit the forum

Question of the Day

The Hash Join III

In a hash join, if all the build input does not fit in memory, what type of hash join is this?

See possible answers