Kathi Kellenberger


Azure Resource Mover

Microsoft recently held the 2020 Ignite conference. Just like in previous years, there were many announcements introducing new services and expanded capabilities of existing ones, especially in Azure. Ahead of Ignite, I was asked to take a test drive of one of the new features, Azure Resource Mover (in preview). It’s easy to move a […]

2020-10-03

71 reads

Mentoring

Over the years when I changed careers and then advanced in IT, many people helped me learn or provided opportunities. Some of these people gave specific in-person help, like my brothers who taught me programming logic and database normalization before I ever thought about working in technology. Others assisted from a distance when I read […]

2020-09-05

93 reads

How to be an MVP

For those of you who haven’t heard of it, MVP stands for Most Valuable Professional. Microsoft gives this award to people in the community – not employees – who help teach the community at large about their products. The award can be given in one or more of the categories such as Data Platform, AI, […]

5 (1)

2020-08-08

125 reads

Controlling Intelligent Query Processing Features

I always look forward to new T-SQL features and optimizer enhancements with every new version of SQL Server. Starting in 2017, Microsoft came up with a set of features called Intelligent Query Processing (IQP). These features work to improve performance without changing any code. If you’d like to learn more about these features, take a […]

5 (2)

2020-07-11

258 reads

What is Azure SQL Database Serverless?

I remember when the first SQL databases were available on Azure. The size limits and missing features made them impractical for most uses at the time. Fast forward 10 years and you can you create a terabyte database and take advantage of configurations like Hyperscale, Elastic Pool, and Managed Instances. You get automatic high-availability and […]

2020-06-13

235 reads

Bad Managers

I’m constantly hearing stories about terrible managers, and, of course, I’ve experienced quite a few myself. In fact, I can’t come up with many nice things to say about most managers when I look back over my career. (Luckily, my manager at Redgate is wonderful!) Early in my tech career, I was working at a […]

5 (1)

2020-05-16

176 reads

The SQL Community Steps up in Time of Need

Healthcare workers are some of the many heroes working bravely in the face of the Covid-19 pandemic. To protect themselves and their patients, they must wear face masks during their entire shifts. This causes a great deal of ear irritation, so a strap was designed to make wearing the masks easier and alleviate pressure on […]

2020-04-18

120 reads

Azure Data Studio and Deployment Notebooks

Azure Data Studio (ADS) is a cross-platform tool that you can use to run T-SQL queries much as you have done using SQL Server Management Studio. No, the databases do not need to be hosted in Azure; the tool works fine for on-premises SQL Servers as well. I’ve started using ADS more as I teach […]

2020-03-21

136 reads

Moving on from Volunteer Projects

I can’t remember a time when I was not involved in side-projects, usually as a volunteer but also writing books or creating courses. New projects are like bright, shiny objects, and it’s easy to get involved in too many of them.

2020-03-16

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