Database-Administration

Category: database-administration

New Courses: Extended Events, Parallelism, Indexes, and More

New Courses: Extended Events, Parallelism, Indexes, and More

It’s been a fun, busy spring and early summer. I have loads of new courses to share, and great stuff is coming up soon!

A big thank you to all the SQLWorkbooks members who attended live events, or posted your comments and questions! Your questions are terrific, and you’ve made these events so much fun.

Continue reading

Free Webcast: DBA vs Memory Settings

Free Webcast: DBA vs Memory Settings

Join me in two weeks for a really fun free webcast.

Continue reading

Remembering Robert Davis, aka @SQLSoldier

Remembering Robert Davis, aka @SQLSoldier

I woke up early on Tuesday with a hundred things to do and plenty of energy to match my task list. By noon, I’d made a loaf of bread, helped a friend solve a tech mystery, and had various professional adventures.

Then I opened Twitter and saw the news that Robert Davis passed away.

I haven’t really gotten much done in the hours since, except think about Robert. And cry a bit. And laugh. It feels weird laughing, but I think Robert would understand.

Continue reading

Partitioned Tables: Rolling/Rotating/Round-Robining Partitions

Partitioned Tables: Rolling/Rotating/Round-Robining Partitions

I recently received a terrific question about options for “rotating” table partitions.

Continue reading

Adding a Downloadable Calendar Event File to Wordpress without a Plugin

Adding a Downloadable Calendar Event File to Wordpress without a Plugin

By Kendra Little on March 19, 2018

Let’s say you’ll be doing an event soon – say a Facebook Live event– and you want to create a calendar reminder for folks to download. Lots of us live and die by calendar invites, so this can be helpful to get people to attend.

Continue reading

Overheard: “I just think there’s not that many women who enjoy coding. And I say that based on my daughter, too.”

Overheard: “I just think there’s not that many women who enjoy coding. And I say that based on my daughter, too.”

on March 7, 2018

I’m at the Microsoft MVP Summit in Redmond, Washington this week. This is a great event for learning from the folks building amazing new technology at Microsoft, giving feedback and representing the community, and meeting and learning from other MVPs from around the world.

Continue reading

Things I Learned from Speaker Idol 2017 at the SQL PASS Summit

Things I Learned from Speaker Idol 2017 at the SQL PASS Summit

on November 9, 2017

I was lucky enough to serve as a judge for the Speaker Idol competition at the SQL PASS Summit conference this year. One of the great thing about watching presentations and giving feedback on them is that you learn a lot about speaking by watching sessions and crafting your feedback.

Continue reading