Database Weekly

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

134 reads

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

128 reads

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

5 (2)

2021-02-27

304 reads

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

104 reads

Who is my customer?

  • Editorial

My final job in my previous career was at a hospital. I worked there for five years in the 90s before getting my first position as a developer. While I didn’t love the career I was leaving, I did appreciate what I learned from that last job. Part of the onboarding included a short class […]

5 (1)

2021-01-16

102 reads

Blogs

Basic XML Queries–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Don’t Stop at Just Enabling Read Committed Snapshot Isolation (RCSI)

By

This past week I had a great Client ask an even greater question, and...

Query Compile Time

By

A question that came up recently was how to track the query compile time....

Read the latest Blogs

Forums

Cannot attach database after new additional instance installation on sql server

By Fifi

Locate database files did not get out any .mdf file, even though there is...

SELECT column based on parameter

By tshad

Is there a way in the same SELECT statement to show different columns without...

Restore WITH RECOVERY freezing on source DB after tail of log backup

By J-M.L

Hello everyone, I've encountered this scenario twice so far and I still don't understand...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers