Blogs

What Is Automation in the Software Development Life Cycle?

What Is Automation in the Software Development Life Cycle?

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.

Continue reading

Upcoming Full Day Training: How to Architect Successful Database Changes

Upcoming Full Day Training: How to Architect Successful Database Changes

By Kendra Little on April 19, 2019 • 2 min read

Category: tech-community

I’m excited to be teaching a full day session with Steve Jones at the SQL PASS Summit on Tuesday, November 5, in Seattle.

Steve and I will be discussing proven patterns to version and deploy changes successfully.

Read more about this precon session, or check out the video below where I give a brief overview of what Steve and I will cover.

Continue reading

The 2019 State of SQL Server Monitoring Survey Is Open: Here's What's in It for You

The 2019 State of SQL Server Monitoring Survey Is Open: Here's What's in It for You

By Kendra Little on March 19, 2019 • 4 min read

Calling all Database Administrators, Developers, Analysts, Consultants, and Managers: Redgate has a survey open asking how you monitor your SQL Servers.

Take the survey before April 5, 2019.

Continue reading

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:

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.

They then provided a script which creates and inserts a few rows into a sample table, runs the DBCC IND command to find a list of pages for the sample table, then uses the DBCC PAGE command to examine the page.

Continue reading

PASS Summit 2019 Call for Speakers Is Open: How I Sketch Out My Submission Ideas

PASS Summit 2019 Call for Speakers Is Open: How I Sketch Out My Submission Ideas

By Kendra Little on March 13, 2019 • 7 min read

Category: tech-community

Are you interested in speaking at the Professional Association for SQL Server’s annual Summit conference?

The call for speakers is now open, and you may submit up to three sessions between now and March 31, 2019.

I’m sketching out my ideas for what sessions that I’d like to submit, and I thought I’d share my process here.

Continue reading