Database-Administration

Category: database-administration

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

The Death of SQL Server Service Packs

The Death of SQL Server Service Packs

on October 6, 2017

SQL Server Service Packs are going away, starting with SQL Server 2017. I talk about why I think this is a good thing, and discuss Cumulative Updates, Service Packs, and the process of updating SQL Server.

Continue reading