Database Weekly

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 […]

2021-07-17

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 […]

2021-06-26

249 reads

SQLServerCentral Editorial

What counts for a DBA: Foresight

  • Editorial

Of all the valuable attributes of a DBA, from passion to humility to practicality, perhaps one of the most important attributes may turn out to be the most seemingly nebulous: foresight. According to Free Dictionary, foresight is the "perception of the significance and nature of events before they have occurred". Foresight does not come naturally to most people, as the […]

2021-05-15

187 reads

SQLServerCentral Editorial

Looking Forward to SQL Server vNext

  • Editorial

Releases of on-premises SQL Server arrived quite rapidly for a few years with seven releases during the years spanning 2008 and 2019. While it has technically been less than two years since SQL Server 2019 reached general availability in November 2019, it feels like ages since we have heard any news about what’s coming next. […]

2021-04-24

1,554 reads

SQLServerCentral Editorial

New Options for Training and Learning

  • Editorial

In 2008, I managed to achieve the goal of becoming a Microsoft Certified Trainer. Once I achieved the status, Microsoft shipped me a binder with dozens of DVDs containing lab VMs and class materials for all the current classes. At some point, instead of receiving DVDs, you were expected to download images which was quite […]

5 (1)

2021-03-13

148 reads

SQLServerCentral Editorial

Common Table Expression Misunderstandings

  • Editorial

I frequently use Common Table Expressions (CTEs) when I demo windowing functions and get questions about them. Windowing functions are limited to the SELECT and ORDER BY clause which means that you can’t filter or group on them directly. Using a CTE is one way to separate the logic of the query into multiple steps […]

5 (2)

2021-02-27

676 reads

SQLServerCentral Editorial

Let it go

  • Editorial

I’ve been digging through the 18 years’ worth of articles, editorials, blogs, contests, interviews, promotions, and announcements over at Simple Talk. There are over 5000 posts, and many are quite outdated, especially those announcing beta versions of software or other time-sensitive content. Some articles haven’t seen the light of day for 10 years, yet some […]

2021-02-06

110 reads

Blogs

Daily Coping 26 Sep 2022

By

Today’s coping tip is to enjoy photos from a time with happy memories. On...

Daily Coping 23 Sep 2022

By

Today’s coping tip is to notice what you are feeling without any judgment. Today...

Snowflake – Where is the explain/execution plan?

By

Whatever your database background is you will have heard of an execution / explain...

Read the latest Blogs

Forums

Seggregating access within a database to users

By noobdba

For some folks that have gotten used to working in Oracle where a user...

Replication Error on identity Column : Transactional Replication

By Tom257

  I have manually deleted data from a subscriber replicated table, and broken replication....

Two fact tables related

By Maria

Hi all, I have a couple of modelling questions using several star schemas. There...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Using R apply

See possible answers