Kathi Kellenberger


SQLServerCentral Editorial

Do presenting and writing really matter?

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)

You rated this post out of 5. Change rating

2021-10-30

174 reads

SQLServerCentral Editorial

PASS Data Community Summit Pre-cons

This year PASS Data Community Summit is a free virtual event, and I encourage you to register even if you are interested in just a handful of sessions. One of the Learning Pathways might be just what you are looking for, from Query Basics to Power BI to DevOps. What I’m most excited about this […]

You rated this post out of 5. Change rating

2021-10-09

103 reads

SQLServerCentral Editorial

All the Tools in Your Toolbox

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

You rated this post out of 5. Change rating

2021-09-18

196 reads

SQLServerCentral Editorial

What to do with more free time

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)

You rated this post out of 5. Change rating

2021-08-28

254 reads

SQLServerCentral Editorial

Taking time off

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

You rated this post out of 5. Change rating

2021-07-17

96 reads

SQLServerCentral Editorial

Looking Forward to SQL Server vNext

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

You rated this post out of 5. Change rating

2021-04-24

1,750 reads

SQLServerCentral Editorial

New Options for Training and Learning

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)

You rated this post out of 5. Change rating

2021-03-13

158 reads

SQLServerCentral Editorial

Common Table Expression Misunderstandings

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)

You rated this post out of 5. Change rating

2021-02-27

2,090 reads

SQLServerCentral Editorial

Let it go

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

You rated this post out of 5. Change rating

2021-02-06

110 reads

SQLServerCentral Editorial

Who is my customer?

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)

You rated this post out of 5. Change rating

2021-01-16

119 reads

Blogs

What happens when we drop a column on a SQL Server table? Where's my space?

By

This article was initially posted on SQLServerCentral @ 2024-04-26. Short answer: The column is marked...

Why the masters and what lies ahead

By

I recently graduated with a Master’s in Strategic Communication from the University of Delaware....

Copilot Reminded Me How To Find a File Handle

By

Recently I was trying to delete a folder and kept getting the “something is...

Read the latest Blogs

Forums

LinkedServer error

By Yousaf Khan

I getting the bellow error when runing query on linkedserver from another server after...

Filtered index prerequisites to be used

By Martass

Hello, After few videos and  showing how filtered indexes works, what are the prerequisites...

Enhancing Web Application Performance through Database Optimization: A Comprehensive Study

By nai3

Comments posted to this topic are about the item Enhancing Web Application Performance through...

Visit the forum

Question of the Day

Automated Azure SQL VM Patching

There is an Automated Patching service for VMs running SQL Server in the Azure Cloud. This uses the SQL Server IaaS Agent Extension to work with PowerShell. What types of patches are installed with this service? Note: All updates are marked with tags, such as Important, Critical, or something else

See possible answers