Kathi Kellenberger


SQLServerCentral Editorial

Moving on but not far

During my technical career, I’ve changed companies several times. I even worked as an independent contractor for three years. One thing I have never done before was switch departments and roles within one company. That’s about to change in a couple of weeks as I move from Simple Talk Editor and DevOps Advocate in Marketing […]

5 (2)

You rated this post out of 5. Change rating

2022-05-21

93 reads

SQLServerCentral Editorial

What will convince you to upgrade?

You’ve probably heard that SQL Server 2022 is on the way, and, assuming the name doesn’t change, it will be later this year. That is great news for folks in the data platform community as features and improvements they’ve been hoping for are added. I’m not currently supporting any production SQL Servers, but I’m still […]

You rated this post out of 5. Change rating

2022-04-30

106 reads

SQLServerCentral Editorial

Document yourself out of a job

Some organizations have policies in place to make sure that everything in their IT infrastructure is documented. There are runbooks, procedures, wikis, diagrams, charts, code comments, and more to make sure that knowledge is available if an employee leaves or when disaster strikes. Not only does the documentation exist, but it’s also organized and easy […]

You rated this post out of 5. Change rating

2022-04-09

190 reads

SQLServerCentral Editorial

SQLBits Report

Last week I attended my first in-person event in over two years. SQLBits, the largest data platform conference in Europe, was a hybrid event and marked the first time many of us met in person in ages. It was a huge success as folks from around the world gathered to learn...and celebrate! I heard several […]

You rated this post out of 5. Change rating

2022-03-19

90 reads

SQLServerCentral Editorial

Another look at table variables

Becoming overly enthusiastic about a new SQL Server feature can backfire if you don’t do some testing. One example is the table variable introduced with SQL Server 2000. At the time, there was a myth that table variables would always perform better than temp tables with the reasoning that, by definition, variables are stored in […]

You rated this post out of 5. Change rating

2022-02-26

214 reads

SQLServerCentral Editorial

Please include your DDL

I haven’t done it much the past few years, but I would answer some programming questions posted in forums back in the day. In the late 90s, I answered Visual Basic questions and eventually switched to SQL Server questions here on SQL Server Central as my career progressed. Answering questions not only assisted someone else, […]

You rated this post out of 5. Change rating

2022-02-05

103 reads

SQLServerCentral Editorial

T-SQL Requires the Right Approach

Some of the most problematic T-SQL code I’ve seen over the years originated because the developer approached T-SQL with techniques more suitable for developing applications. I often saw these issues in my consulting days and always took the opportunity to teach the customer instead of only fixing the problems. One reason is that SQL is […]

5 (2)

You rated this post out of 5. Change rating

2022-01-15

204 reads

SQLServerCentral Editorial

Education to solve the tech skills shortage

I’ve been teaching T-SQL to groups of students since 2014 at the non-profit LaunchCode in St. Louis. LaunchCode provides free tech training, paid apprenticeships, and career support to hundreds of people who have the ability and interest but not always the opportunity to land tech careers. For example, not having a college degree can eliminate […]

5 (1)

You rated this post out of 5. Change rating

2021-12-31

362 reads

SQLServerCentral Editorial

One to many SQL Server books

Back in the late 90s, I had one large book on my desk with everything I needed – or thought I needed -- to know about SQL Server. It covered T-SQL, installation, backups, security, and more. Over the years, Microsoft has added components like SQL Server Integration Services and features like windowing functions and improved […]

5 (3)

You rated this post out of 5. Change rating

2021-12-11

333 reads

SQLServerCentral Editorial

PASS Data Community Summit 2021 Report

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

You rated this post out of 5. Change rating

2021-11-20

318 reads

Blogs

MSSQL Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database

By

Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database As one...

Dynamic Warehouse & Lakehouse Connections in Microsoft Fabric Data Pipelines

By

When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in...

New Pluralsight Course - Certified Kubernetes Administrator - Performing Cluster Version Upgrades

By

We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight! The...

Read the latest Blogs

Forums

Strange behavior passing a variable in XML.value

By PatLap

Hi,  anyone would know why as soon as I add a WHERE statement (even...

What happened to my SSMS shortcuts in 20.1?

By Eric Mamet

I installed SSMS 20.1 and all my trusted keyboard shortcuts don't work anymore... <Ctrl>E...

logshipping is out of synch need to debug

By anoop.mig29

Hi We have logshipping which get out of synch in night due to purging...

Visit the forum

Question of the Day

Operator Precedence Order

What is the correct order of operator precedence from highest (evaluated first) to lowest?

See possible answers