Blogs

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

Why You Shouldn't Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures

I recently published Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures over on Simple Talk.

Continue reading

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

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

Contest: Tell Your Database Development Disaster Story (5 Winners Get $150 USD or More Each)

Redgate is building a library of real-world stories about database development disasters.

Your mission: Tell us a true story in 500 words or less about a time when you were involved in an Agile or DevOps project that went full steam ahead in speeding up delivery of application code, but didn’t modernize database development practices. Did trouble follow? Check out the prizes and give us the scoop here before March 20, 2019.

Continue reading

Kendra Breaks and Fixes SQL Source Control in 9 Minutes

I love breaking technology.

I love breaking technology on purpose, in a place where it’s not going to slow anyone else down. It’s a great way to learn more about how everything works and what your options are to fix the situation when things go sideways.

Continue reading

New Free Videos on SQL Prompt, SQL Compare, and SQL Doc with Redgate SQL Change Automation

I’m excited to have just clicked ‘publish’ on four new videos in the brand new Advocate playlist on Redgate’s YouTube channel.

These videos step through setting up and working with a project in one of my favorite Redgate tools: SQL Change Automation.

Continue reading

What a Software Evangelist Does and Where the Job Is Going (Dear SQL DBA Episode 67)

I’ve been working as an Evangelist at Redgate for close to six months now, and one question keeps coming up: what exactly does an Evangelist do at a software company? In 21 minutes, I explain the core mission of Evangelists, and why I think being part of the sales process is an important part of the future of software evangelism.

Continue reading