Key Findings for Database Professionals from the Accelerate State of DevOps Report 2019

Key Findings for Database Professionals from the Accelerate State of DevOps Report 2019

The Accelerate: State of DevOps Report 2019 has just been published. This report is the latest in six years of research. With more than 31,000 survey responses, Accelerate is the longest running study of DevOps in academia or industry. In the 2019 edition, research continues to show that DevOps drives business value: high performers at DevOps are “twice as likely to meet or exceed their organizational goals.” While this isn’t a new finding, it’s very important that this continues to be true: why invest in improving at DevOps if it doesn’t drive business value?
Managing Cross-Database Dependencies in Builds (Redgate video)

Managing Cross-Database Dependencies in Builds (Redgate video)

Building your database code is an essential practice to ensure that it compiles from source and that dependencies are met. But things can get tricky when you have objects in some databases which is dependent upon objects in other databases – or even circular dependencies.

A letter to my 20 year-old self

A letter to my 20 year-old self

This post is a part of #tsql2sday, a monthly community ritual where a topic is proposed by a community member and everyone is invited to join in. This month’s topic is from Mohammad Darab, who encouraged us to: “Write your 20 year old self a letter. If you could go back in time and give yourself advice, what would it be?” The advice I would give to my 20 year old self is the same advice I give to myself today, more than 20 years later:
What's Unique About SQL Saturdays: Nearly Everyone Interacts with Other People

What's Unique About SQL Saturdays: Nearly Everyone Interacts with Other People

Today I was looped in on an email thread about the pros and cons of attending a specific event. One person on the thread asked if any of us had attended the event in the past, and whether or not event attendees were engaged with presenters and vendor representatives.

My immediate thought was: of course the attendees were engaged, because the event is a SQL Saturday.  I’ve never been to a SQL Saturday where the attendees weren’t engaged.

But, I realized that it’s a fair question.

Paying down technical debt

Paying down technical debt

One of the cool things that I do as an Evangelist at Redgate is to periodically visit company headquarters in Cambridge. The other Evangelists and I get to meet with every software developer, product manager, and UX designer at Redgate over a series of meetings. That’s really cool. We talk about things that they’ve released lately, what they’re looking at doing in the near future, and we get to give feedback based on what we hear from the community and from folks in the sales process. We also get to share what we personally think should happen in these products now.

What is Automation?

What is Automation?

Today I got a bit closer to a meaningful definition of automation, as it applies to the software development process. I’ve been turning this concept over in my head for a while, which is partly related to the dreaded question of licensing.

The SQL Server Data Row Size Question: Why is It Bigger?

The SQL Server Data Row Size Question: Why is It Bigger?

This morning, I received the following question from a user:

Hello Madam,

Could you please clarify SQLServer “Data Row” size:

If I run the script below on SQL Server 2012, then Slot(row) Size is 710 bytes

if I run the same script against SQL Server 2016 and above, then Slot(row) Size is 724 bytes.