Sqlcomics
Kendra Little's Blog on SQL Server
by
1M ago
..read more
Visit website
Blogs
Kendra Little's Blog on SQL Server
by
7M ago
..read more
Visit website
Free Courses
Kendra Little's Blog on SQL Server
by
7M ago
These online courses are totally free, with sample scripts in GitHub and videos hosted on YouTube. The information in the courses is current through the year 2020 – I have not updated them since then. Most of what these courses cover is fairly “evergreen” information and still remains useful ..read more
Visit website
Submit a "Dear SQL DBA" Question
Kendra Little's Blog on SQL Server
by
7M ago
Contact me if you have a question for Dear SQL DBA ..read more
Visit website
SQL Server Isolation Levels Poster Archive
Kendra Little's Blog on SQL Server
by
7M ago
One of my first presentations was on isolation levels in SQL Server Back in 2010, after an interview flop, I set myself on a mission to learn isolation levels backwards and forwards in SQL Server. I was surprised to find that I loved the topic, and I decided to start presenting about it. I thought that the biggest problem with isolation levels was memorization: the names of the isolation levels are a little opaque, and it’s hard to build up a “picture” of the concepts and how they relate in your mind. So I drew a picture! A poster, in fact. I didn’t have experience making digital art. I used a ..read more
Visit website
What's the difference between DBAs, DBREs, and Data Engineers?
Kendra Little's Blog on SQL Server
by
8M ago
Twenty years ago, database administrators (DBAs) were the primary career path when it came to specializing in data management. Much has changed: development patterns transformed from Waterfall to Agile, DevOps drives automation and shared ownership of code, and cloud services have made many more kinds of PAAS databases, data lakes, and data lakehouses available to organizations of all sizes. These changes have introduced new and varied career paths for data folks which have different emphases on skill sets. In this post, I talk through the commonalities and differences between DBAs, Database R ..read more
Visit website
Should we do index maintenance on an Azure SQL Managed Instance or Azure SQL Database?
Kendra Little's Blog on SQL Server
by
9M ago
Have you ever received advice that was technically correct, but it was too hard to understand? I think of this as “accidental bad advice,” because it can lead to confusion and bad outcomes. There’s a LOT of accidental bad advice out there on index maintenance for SQL Server and cloud versions like Azure SQL, even in the official documentation. In this post I’m answering a common index maintenance question, and we’re going to keep it simple. Do we need index maintenance if we have fast storage? Last week I received a question about whether index maintenance was needed for an Azure SQL Managed i ..read more
Visit website
Even smart people make terrible data modeling decisions
Kendra Little's Blog on SQL Server
by
9M ago
I was doing a bit of data analysis, and the resulting numbers didn’t quite add up. I double-checked my queries. Had I goofed in my sql? Nope. Next, I looked into if some of the data was in an inconsistent state. What I found was worse than what I’d imagined. As a data person, it made me feel sad and icky. That’s because it’s usually not too hard to clean up bad data. It’s almost always much harder to fix a badly designed data model which is already established in production. The schema I’m anonymizing the schema here, because it doesn’t matter who did this. Badly designed relational databases ..read more
Visit website
I'm giving a performance tuning Precon and a Git session at PASS Data Community Summit 2023
Kendra Little's Blog on SQL Server
by
9M ago
I’m thrilled to be heading to Seattle in November for the PASS Data Community Summit. My favorite things about the PASS Summit are making connections, learning from folks, broading my horizons, helping build a vibrant community, and teaching. Teaching is a great privilege, and I’m excited to be giving both a pre-conference session and a regular session. I chat about the sessions in this ~4 minute video: Not in the mood for a video? Read on for the written version and a comic. My precon - Performance Tuning Secrets: Learn from My Mistakes I wanted to do something different for this day-long se ..read more
Visit website
Adding a Netlify contact form to a Hugo static site
Kendra Little's Blog on SQL Server
by
9M ago
I redid my static site’s contact form with a free option from my host, Netlify. Here’s why I changed my static site host and how I got a Netlify contact form to work with a blog built on Hugo and the Mainroad theme. Why I moved to Netlify I wrote back in 2021 about Moving From WordPress to an Azure static site with Hugo. Since then, I migrated away from Azure Static Sites to Netlify’s free plan. I moved to Netlify for a couple of reasons: 1. I was hitting storage quotas with the Azure static site that caused deployments to fail. I’d already reduced image file sizes where it made sense and mov ..read more
Visit website

Follow Kendra Little's Blog on SQL Server on FeedSpot

Continue with Google
Continue with Apple
OR