Database Weekly

SQLServerCentral Editorial

PASS Data Community Summit 2021 Report

  • Editorial

The 2021 virtual PASS Data Community Summit was held from November 8th through the 12th. PASS Summit has always been the biggest yearly conference for database professionals, and this year’s virtual conference had over 18,000 individuals registered! If you signed up for the event, you may now stream the sessions on-demand. This is an exclusive […]


211 reads

SQLServerCentral Editorial

Do presenting and writing really matter?

  • Editorial

I’m sure you’ve heard the adage that people are more afraid of public speaking than they are of death. On the other hand, some folks can’t get enough public speaking and look forward to opportunities to get up in front of a group and talk. Writing is not so scary since it’s a solitary activity, […]

5 (2)


126 reads

SQLServerCentral Editorial

All the Tools in Your Toolbox

  • Editorial

I recently began writing an article to compare the performance of several window functions to traditional query methods. I began with my favorite function, LAG, but soon found that there were so many other ways to write the query that the article never covered the additional window functions. The article was quite fun to write, […]


177 reads

SQLServerCentral Editorial

What to do with more free time

  • Editorial

Many data professionals have begun working remotely over the past year and a half which translates to less time spent commuting. In my own case, I’ve been a remote worker for almost ten years, but before that I spent two hours on the road each day. This got me wondering what folks have done with […]

5 (2)


240 reads

SQLServerCentral Editorial

What Counts for a DBA: Skill

  • Editorial

Practice makes perfect:” right? Well, not exactly. The reality of it all is that this saying is an untrustworthy aphorism. I discovered this in my “younger” days when I was a passionate tennis player, practicing and playing 20+ hours a week. No matter what my passion level was, without some serious coaching (and perhaps a […]

5 (1)


180 reads

SQLServerCentral Editorial

Deploying SQL Server Automatically

  • Editorial

I've had to install SQL Server many times over the years. Often it has felt that most of these installs were one-offs, a dev server, a new QA instance, a production server for a brand new application. A few times I've had to recover from disaster, including restoring master, but often, I just installed SQL […]

2 (1)


272 reads

SQLServerCentral Editorial

Taking time off

  • Editorial

Time is a precious commodity, and so much of our time is dedicated to working. IT professionals often have jobs with good benefits, including generous paid time off. It’s important to get away from work to relax and recharge, but, sometimes, it’s difficult to take those days that belong to us. Even when we do […]


95 reads

SQLServerCentral Editorial

What Counts For a DBA: Ego

  • Editorial

Leaving aside, for a second, Freud’s psychoanalytical definitions, the term “ego” generally refers to a person’s sense of self, and their self-esteem. In casual usage, however, it usually appears in the adjectival form, “egotistical” (most often followed by “jerk”). You don’t need to be a jerk to be a DBA; humility is important. However, ego is important […]


249 reads


Slides from SQL Saturday Los Angeles 2022


If you attended my talk at SQL Saturday Los Angeles 2022, then you can...

Creating a HEAD utility for Windows 10


One of the things I did often in my first career job was create...

Distributed Replay: The Little Engine That Almost Could


Honestly, sincerely, no kidding, I love Distributed Replay. Yes, I get it. Proof positive...

Read the latest Blogs


SELECT * FROM ( ... ) X

By FatsGordon

Hi all! I'm trying to understand how does this work. I've read a thread...

Would like to understand a better way of updating data that a cursor if possible

By bswhipp

I have a need to update some data and also create a record of...

SQL Question - Column References

By rjdpa2

Hi. Looking for someone to help with a query I'm tring to run. I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers