Kathi Kellenberger


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

2021-07-17

84 reads

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

2021-04-24

578 reads

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)

2021-03-13

136 reads

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 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

324 reads

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

2021-02-06

110 reads

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)

2021-01-16

108 reads

Goodbye to PASS

On December 17, the PASS organization announced the news that it would cease operations on January 15, 2021. Since the announcement, folks have been scrambling to figure out how to keep their user groups and events going or downloading recordings. By the way, if you need assistance with your user group, please reach out to […]

2020-12-26

180 reads

Automatic Install of Azure Data Studio

Microsoft recently announced that you’ll get Azure Data Studio (ADS) when you install SQL Server Management Studio (SSMS) starting with version 18.7.1. Azure Data Studio has been around for a couple of years, and it has some great features that most of us never imagined for SSMS, like the ability to connect to PostgreSQL databases […]

2020-11-07

503 reads

What is Possible?

There’s the old saying “Whether you think you can or you think you can’t -- you’re right” from Henry Ford. I’ve thought about this more recently while reading the book The Rise of Superman Decoding the Science of Ultimate Human Performance which talks about how athletes have performed so called impossible feats over the past few […]

2020-10-31

80 reads

Blogs

Using Framing for a Running Total–#SQLNewBlogger

By

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

Accessibility in your PowerPoint slide deck

By

This post is part of the series I kicked off here. You can read...

Daily Coping 28 Jul 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Error shrinking database

By Ram

While trying to shrink a database using the command "dbcc shrinkdatabase ([db_name])", I get...

Are Powerplans still relevant for VM servers?

By WebTechie

Hello, I am rolling out a new monitoring environment.  While in testing, it is...

SELECT records from table 1 that does not exist in table 2 via UNION

By technoob

Sorry if this seems too beginner; I have been stuck at this for days...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers