Kathi Kellenberger 20 October 2021

Back in the office

0

Editorials

Last week, Steve Jones (@way0utwest), Grant Fritchey (@GFritchey), and I spent a few days at the Redgate Headquarters in Cambridge. Meeting at the office would not be unusual except for the times that we live in right now, as we typically get there about once a quarter. This is the first time that we’ve all … Read more

0

Editorials

Kathi Kellenberger 21 September 2021

The challenges of ever-growing estates

0

2

Editorials

Each year Redgate runs a survey to determine the state of database monitoring. This year, instead of one large report, we are publishing four insight reports, each on a different topic. The first came out this month: The real-world challenges of growing server estates. The respondents reported several trends: DBAs are managing more instances than … Read more

0

2

Editorials

Kathi Kellenberger 07 September 2021

How LAG compares to other techniques

0

11

T-SQL Programming

LAG pulls a column from another row without a self-join. In this article, Kathi Kellenberger shows how LAG compares to other techniques… Read more

0

11

T-SQL Programming

Kathi Kellenberger 25 August 2021

Machine learning, both exciting and scary

0

2

Editorials

The 2002 movie Minority Report is about a police unit called PreCrime, which can predict when people will commit a crime so they can be arrested before it happens. Things go awry when a team member played by Tom Cruise is himself “pre-accused.” To make predictions, they use technology and the special abilities of the … Read more

0

2

Editorials

Kathi Kellenberger 09 July 2021

How to learn about Azure SQL

0

6

It was always important to me to keep up with the latest versions of SQL Server, but especially so when I was a database administrator or consultant. I wasn’t always able to work with the new versions right away in production, but at least I had an idea about features, capabilities, and benefits. Fifteen years … Read more

0

6

Kathi Kellenberger 29 June 2021

DevOps is more than continuous integration and delivery

0

1

Editorials

I recently presented a session about DevOps for DBAs, explaining what it is and why DBAs should care. One of the comments I received was “I thought I knew what DevOps was. Thanks to your session, now I know better.” Here’s one definition of DevOps: The union of people, process, and products to enable continuous … Read more

0

1

Editorials

Kathi Kellenberger 15 June 2021

Introducing the PASS Data Community Summit Program

0

Editorials

Many of you know that Redgate purchased some of the assets of PASS, namely session recordings, domain names, and trademarks. Shortly after that purchase, we began talking about what it would take to put on an event to revive PASS Summit. The first step was to survey to find out what people liked and wanted … Read more

0

Editorials

Kathi Kellenberger 13 May 2021

PASS Data Community Summit 2021

0

7

Editorials

I began attending PASS Summit in 2003. I had no idea that it would change the course of my career and, well, life. Becoming part of the community I found through PASS inspired me to take my career to the next level by presenting and writing. It also led to some wonderful friendships and lots … Read more

0

7

Editorials

Kathi Kellenberger 04 May 2021

What is an ad hoc query?

0

4

Someone recently asked me which queries are ad hoc in SQL Server. An ad hoc query is a single query not included in a stored procedure and not parameterized or prepared. Depending on the server settings, SQL Server can parameterize some statements initially written as ad hoc queries. Ad hoc doesn’t mean dynamic. Here’s a … Read more

0

4

Kathi Kellenberger 20 April 2021

How different roles view database DevOps

0

1

Redgate released the 2021 State of Database DevOps Report in February, and I wrote a short article talking about the key insights from the report. More recently, I decided to take a deeper look at the data, especially how folks from different roles answered the survey questions. To simplify my analysis, I grouped respondents into … Read more

0

1

Kathi Kellenberger 07 April 2021

Can a monitoring tool save money?

0

1

Editorials

When I was a DBA responsible for 40 to 50 SQL Server instances, I didn’t have many third-party tools to help me do my job. I remember that I was able to buy a tool to compress database backups before that functionality was built into SQL Server. I also had a handful of licenses for … Read more

0

1

Editorials

Kathi Kellenberger 24 March 2021

To soon?

0

48

Editorials

I’ve noticed that some television shows have been incorporating the Covid-19 pandemic into their recent episodes. (There are some spoilers here, so read with caution!) A medical series, “The Good Doctor,” featured it in two episodes and then, magically, the pandemic was over. The popular series “This is Us” is trying to set a good … Read more

0

48

Editorials

Kathi Kellenberger 23 February 2021

Do something that scares you

0

4

Editorials

Recently, the editor of SQLServerCentral.com, Steve Jones, shared a video in our team Slack channel that talked about how you shouldn’t feel like an imposter when you get out of your comfort zone. It talked about how incredibly successful people didn’t know how to do what they eventually accomplished back when they started. For example, … Read more

0

4

Editorials

Kathi Kellenberger 15 February 2021

Key insights from the 2021 State of Database DevOps survey

0

1

This is the fifth year that Redgate has surveyed IT professionals about their organization’s DevOps practices. Each year, the number of respondents increases, reaching 3,200 submissions this year. An interesting new topic to consider this year is how the Covid-19 pandemic affected DevOps practices. Here are the some of the key insights found in the … Read more

0

1

Kathi Kellenberger 27 January 2021

Falling out of the zone

0

3

Editorials

If you are lucky enough to enjoy the work you do, it could be because you are frequently “in the zone.” The zone is a state of complete concentration, also called “flow,” where time seems to stand still, and performance is at its peak. Before I heard these terms, I often experienced deep concentration while … Read more

0

3

Editorials

Kathi Kellenberger 22 December 2020

Security is hard work

0

1

Blogs

I was once a database administrator in charge of several SQL Servers hosting the databases of vendor apps. Right after taking the job, I began looking at things like backups and security. I was quite shocked to find that one of the most important SQL Servers in the firm had a blank sa password. I … Read more

0

1

Blogs

Kathi Kellenberger 22 December 2020

Postponed goals, plans, and resolutions

0

4

Editorials

Every year, folks make resolutions and set goals for the new year. It would be interesting to have some real numbers comparing success in 2020 to a typical year, but I bet that many of us have failed or at least had to postpone plans and goals. I had no idea that my trip to … Read more

0

4

Editorials

Kathi Kellenberger 14 December 2020

A year of giving back at Redgate

0

3

Editorials

This year has been difficult for most of us, and it’s almost over. The lives of people throughout the world have been turned upside down. Many of us, myself included, already worked remotely, but now face a multitude of new challenges. When confronted with the looming crisis in March, Redgate thought first about the safety … Read more

0

3

Editorials

Kathi Kellenberger 22 October 2020

What you’ll learn at my 2020 PASS Summit presentation

0

Blogs

T-SQL is my favorite aspect of working with SQL Server. The release of SQL Server 2005 coincided with the beginning of my involvement with the community as a presenter and author. For a while, I would put together a “What’s new with T-SQL” session for each release. Eventually, the windowing functions were such a big … Read more

0

Blogs

Kathi Kellenberger 20 October 2020

Is communication always important?

0

5

Editorials

Conventional wisdom says that communication is the critical for success in just about any aspect of life, be that personal relationships or within teams or corporations. Of course, miscommunication can cause all sorts of problems. Communication has changed drastically over the past few centuries due to technology. We’ve gone from the ability to speak mostly … Read more

0

5

Editorials

OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Kathi Kellenberger