search
LinkedIn
school
Custom Icon

What I'm Up To

Online Sessions
Community Events
Recent Recordings
Online Sessions

Redgate Free Webcasts

  • The single question to predict success for DevOps, and what it means for change control – Tue, Oct 30, 9AM PT – 30 minutes –  Register
  • 3 tips for getting executive buy-in for DevOps – Wed, Nov 14, 8AM PT – 1 hour – Register

Dear SQL DBA Free Webcasts

  • Book Review, “Accelerate: The Science of Lean Software and DevOps” – Tue Oct 23, 9AM PT – 30 minutes – Register
Community Events
  • SQLSaturday Orlando – Oct 6 – “The Changing role of the CIO and the value of DevOps” – Register
  • SQL in the City – New York – Oct 12 – use code KendraLittle to register for free – Register
  • SQL in the City – London – Oct 18 – 50% off registration with code KendraL – Register
  • SQL in the City – Chicago – Oct 26 – use code KendraLittle to register for free – Register
  • SQLSaturday Oregon – Portland – Nov 3 – “3 tips for getting executive buy-in for DevOps” – Register
  • Ride the SQLTrain – Portland to Seattle  – Nov 4 – Travel to the PASS Summit with Data Platform community members – Register
  • PASS Summit Pre-conference Training Day – Prevent Fake News in Your Data – Seattle – Nov 5 – $499 or bundled with conference – Register – Perks
Recent Recordings
  • How to lead DBAs to embrace DevOps, rather than fear change – Watch
  • DevOps terms and why they matter for database specialists – 20 minutes – Watch the video or listen to the podcast episode
  • Adapt & Thrive – Keynote, SQL in the City (online edition) – 25 minutes – Watch
  • Employee Agreements & Contracts: Best Practices – Dear SQL DBA Podcast – 23 minutes – Watch / Review on iTunes
  • Employee Agreements & Contracts: Anti-Patterns – Dear SQL DBA Podcast – 31 minutes – Watch / Review on iTunes

Interviewing for your first tech job – slides

Kendra Little
No Comments
I was lucky to get an opportunity to present a session to some college students at Seminole State College in Florida last week. I was in town for SQL Saturday Orlando– a fantastic event on its own. The organizers run a simultaneous seminar for students at the college studying software development and IT topics, and it’s an opportunity where they can hear from professionals in IT professions. I gave a session on interviewing best practices. The students were a terrific audience, and I really enjoyed speaking. The slides I shared that day are here: Interviewing for your first tech jobDownload
Read More

SQL Change Automation, Visual Studio, and the “Unknown SQL Server Platform” error

Kendra Little
1 Comment
I recently set up Redgate’s SQL Change Automation in Visual Studio 2017, and I ran into a confusing error when I started trying to use it. For any other folks out there searching on “Unknown SQL Server Platform,” here’s how I got past it. Spoiler: Visual Studio suggested updating Microsoft’s SQL Server Data Tools, which failed for me and wasted a lot of time. Updating Visual Studio did fix my issue. The basics on my setup When I installed Visual Studio 2017, I selected the ‘Data storage and processing’ workload, which contains SQL Server Data tools as well as some of the Redgate tools: Visual Studio 2017 workloads I used the default checkboxes on the right there, installing everything except F# desktop language support. First, I created a new project In the ‘SQL Change Automation’ window, I clicked ‘Create Project’, selected ‘SQL Change Automation Project’ and gave it a name, and click…
Read More

I helped write a book! No, not THOSE books…

Kendra Little
No Comments
Every now and again, someone asks if I write romance novels. Why? Well, let’s ask Bing who Kendra Little is…. To clarify,  I am not married, I have dogs instead of children, and I prefer romances about strong women who bring SQL Servers to their knees. I also don’t think it’s possible to drink too much coffee. Most of those pictures are of me, but a careful reader will note that the biography at the top references a domain name that, sadly, dear reader, I do not own. Someone out there named Kendra Little gets sweet royalties from her contemporary romance novels, but they don’t come to this address. I helped Malathi Mahadevan write a different kind of book ‘Data Professionals at Work’ is a new book by Malathi Mahadevan. Mala went out and interviewed loads of data professionals, and talked with us about topics like: How to stand out…
Read More

Help me present at GroupBy: review my abstract

Kendra Little
No Comments
I’ve submitted a session proposal to the free, online GroupBy conference. Voting will open for sessions soon, but before then, you can help me out by reading my abstract. Is it a session you’d like to see? Got any constructive criticism that you think would make the session or abstract better? Let me know in the comments over on the abstract for “What ‘Digital Transformation’ Means, and How You Can Use It to Advance Your Career (Without Being a Robot)“ Review me!
Read More

I’m Giving Four Free Sessions in October!

Kendra Little
No Comments
I’ve got FOUR sessions coming up in October.  These sessions will each be 30 minutes. Redgate Sessions Wed, Oct 3, 9AM PT / 12PM ET:  How to Lead DBAs to Embrace DevOps, Rather than Fear Change Register at GoToWebinar here Tues Oct 30, 9AM PT / 12PM ET: The Single Question to Predict Success for DevOps, and What It Means for Change Control Register at GoToWebinar here Dear SQL DBA Sessions Tues Oct 2, 9AM PT / 12PM ET: DevOps Terms and Why they Matter for Database Specialists Tues Oct 23, 9AM PT/ 12PM ET:Book Review, “Accelerate: The Science of Lean Software and DevOps” Register at SQLWorkbooks here
Read More

Why I Love DML Triggers in SQL Server

Kendra Little
1 Comment
It’s TSQL Tuesday today! If you’re not familiar, TSQL Tuesday is a monthly blogging event where a Microsoft Data Platform community member chooses a writing prompt. This is a great thing if you’re interested in starting a technical blog and wonder, “What would I write about?” It’s also great if, like me, you occasionally want a little outside inspiration to shake things up. This month’s topic is from Steve Jones: we’re invited to write about an experience that we’ve had with triggers. My first encounter with triggers was overwhelmingly positive When I first edged my way into a Junior DBA-ish role, I worked with a complex application with many large databases. Customers loaded and configured data into a (mostly) OLTP database, and then data was replicated to multiple other systems — in part to publish data to an adserving platform, in part to transform the data for reporting. Triggers were used…
Read More
Menu