search
bookabout
emailcontact
LinkedIn
school
Title

What I'm Up To

Upcoming Events
  • How DevOps Keeps DBAs Safe from Being Automated Out of a Job – Free online Webinar – March 23, 12 PM Eastern – Register
  • SQL in the City Streamed – Free Redgate training livestream – April 3, 9 AM – 2:00PM Eastern – Register
  • Designing Schema Changes with a DevOps Mindset – Free in-person talk – April 10, 6:45 PM Pacific, OregonSQL user group (Portland)
  • SQL in the City Summit: London – In-person conference – April 30, 9 AM – 5:30 PM BST – Register, use code KendraLittle for 50% off registration
  • 3 Tips for Getting Executive Buy-In for DevOps – Data Grillen in-person conference in Lingen, Germany – June 21st, 2019 – Schedule
  • SQL in the City Summit: Austin – In-person conference – May 22, 9 AM – 5:30 PM Central – Register, use code KendraLittle for free registration
New Recordings
  • Redgate Evangelist YouTube Channel: Tutorials on Database DevOps –New videos each week – Watch
  • DevOps: What, who, why and how? – 1 hour – Watch
  • Get Inspired: Celebrate the Careers of Three DevOps Heroes – 1 hour – Watch
  • What ‘Digital Transformation’ means, and how you can use it to advance your career– 1 hour – Watch
  • Can This Team Succeed at DevOps? Panel discussion – 1 hour – Watch
  • SQL In the City Streamed – Watch the whole stream
    • Crucial data privacy and protection insights for 2010 – with Richard Macaskill – 45 minutes – Watch
    • The four keys to unlocking DevOps – 30 minutes – Watch
  • The Best of 2018 and Predictions for 2019 (Panel with Steve, Grant, and Kathi) – 1 hour – Watch
  • What We’ve Learned about Adopting Database DevOps, and What to Avoid (MVP Panel with Guest Panelist Tony Maddonna) – 1 hour – Watch

Take the 2019 State of SQL Server Monitoring Survey: Here’s What’s in It For You

Kendra Little
1 Comment
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. Your time is valuable. The survey will take 5 – 10 minutes to complete. That’s not a ton of time, but it’s a noticeable part of your day, and there should be something in it for you. Here’s why it’s worthwhile to take the survey. Database use patterns and monitoring trends are valuable to everyone in the community — and we’ve been missing out on this trend information! This isn’t the only survey from Redgate — you may also have heard of the annual State of Database DevOps Report. But this survey is different in important ways: it asks how you manage and monitor your SQL Server database environment, regardless of whether you think about DevOps at all. Redgate shared the results…
Read More

Why to Avoid Using the Current Database Name in Object Definitions in SQL Server

Kendra Little
No Comments
I’ve recently published an article, “Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures,” over on Simple Talk. Hello, my name is FINE In the article, I discuss: Why referencing the current database name creates a dependencyWhat ‘deferred name resolution’ is, and why the dependency may be more noticeable in views and some functions (rather than stored procedures)Which activities are most likely to break if you place dependencies on the current database name Read the full article here.
Read More

PASS Summit 2019 Call for Speakers is Open – How I Sketch Out My Submission Ideas

Kendra Little
No Comments
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 currently in the process of sketching out my ideas for what sessions that I’d like to submit, and I thought I’d share my process here. Generating ideas: what am I interested in spending six months thinking about? I’m a bit selfish when it comes to topic selection, and I think that’s fine: it needs to be something that I’m interested in thinking about for more than half a year. That does NOT mean that it needs to be super-advanced rocket science content. Figuring out how to present introductory level content clearly, in an easy-to-understand way takes a lot of time. The topic simply needs to compelling enough for me to stay interested. A…
Read More

Contest: Tell Your Database Development Disaster Story (5 winners get $150 USD or more each)

Kendra Little
1 Comment
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. Enter today, time’s almost up! Share your story using the form hereThe story must be true – but never fear, we will anonymize all stories and the names of the winnersEnter as often as you’d like (but each person may only win once) Need inspiration? Grant’s sample entry (the short version) “Our organization built a new application using an Object Relational Mapping (ORM) tool. The team worked without any DBAs or database developers for speed. We ended up…
Read More

Watch: Kendra Breaks and Fixes SQL Source Control (9 minutes)

Kendra Little
No Comments
I love breaking technology. Well, 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. In this 9 minute video, I ignore SQL Source Control’s valiant attempts to keep me out of trouble, and put the database code in my local git repository into an inconsistent state. Can I fix it? (Spoiler: yes I can.)
Read More

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

Kendra Little
No Comments
I’m excited to have just clicked ‘publish’ on four new videos in the brand new Evangelist Tutorials 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. The awesome thing about SQL Change Automation is that it gives you two things: Fine-grained control to tune and order the execution of changes to your database with a migrations-first approach to source controlling your codeA view of the state of your database, which is crucial for code reviews, controlling environment drift, and communicating about changes between developers and database administrators The tricky thing is that there’s a lot to learn when starting out with SQL Change Automation if you haven’t used a migrations-first approach in the past, or aren’t used to working in Visual Studio. That’s where these videos come in: you can follow along with…
Read More
Menu