Take the 2019 State of SQL Server Monitoring Survey
Calling all Database Administrators, Developers, Analysts, Consultants, and Managers: Redgate has a survey open asking how you monitor your SQL Servers.
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.
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.
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.
Watch: Kendra Breaks and Fixes SQL Source Control (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.
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.
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.
State vs Migration for Database Source Control - decide based on one question
One controversial topic in database development is how to properly store and deploy database changes.
This is generally described as choosing between two options, which are approximately as easy to understand as Greek philosophy:
- State based - A Platonic view of the database as a snapshot of a set of forms in a given state at a point in time
- Migrations - An Aristotelian view of the database defined as a series of scripts which generate change over time
DBA Jobs: Threats and Opportunities (Dear SQL DBA Episode 66)
Jobs change over time, and database administrator jobs are no different. In this 35 minute recorded Twitch livestream (my first ever!) I talk about threats to DBA jobs and the related opportunities.