The Voice of the DBA

Monday Monitor Tips: Changing the Fragmentation Alert

• by Steve Jones

• The Voice of the DBA

I had a customer that was concerned about the fragmentation alert for indexes and wanted to know how to change it. This post discusses the change. This is part...

2024-08-19

1 reads

SQL Saturday Denver 2024 Resources

• by Steve Jones

• The Voice of the DBA

Here are the resources from my talks today. Best Practices for Seamless Database Deployments PPTX slides Architecting Zero Downtime Deployments git repo:  https://github.com/way0utwest/ZeroDowntime  PPTX slides Some good questions today,...

2024-08-18 (first published: 2024-08-17)

A New Word: Povism

• by Steve Jones

• The Voice of the DBA

povism – n. the frustration of being stuck inside your own head, unable to see your face or read your body language in context, only ever guessing how you...

2024-08-16

Speaking at SQL Saturday Denver 2024

• by Steve Jones

• The Voice of the DBA

It’s just a couple of days away from SQL Saturday Denver 2024. This Saturday, come join me at the Lowry Convention Center in Aurora for some great talks. We...

2024-08-14

Expanding Northwind with Prompt+

• by Steve Jones

• The Voice of the DBA

I was trying to do a little testing of our subsetter and needed a larger database. So I decided to ask Prompt + to help me with a little...

2024-08-14

T-SQL Tuesday #177–Keeping track of database code

• by Steve Jones

• The Voice of the DBA

This month’s invitation is from Mala Mahadevan, who has hosted 5 times. This latest one is one that is near and dear to my heart as I use source...

2024-08-13

Grouping by Object Type in SQL Compare

• by Steve Jones

• The Voice of the DBA

A customer recently was asking about grouping objects by type to see all the differences in two databases for one set of objects, like all stored procedures. This post...

2024-08-12

A New Word: Hiddled

• by Steve Jones

• The Voice of the DBA

hiddled – adj.  feeling of loneliness of having to keep a secret to yourself. I don’t know I am often hiddled. I don’t tend to keep secrets by myself....

2024-08-09

DevOps Days Minneapolis–Best Practices for Database Deployments

• by Steve Jones

• The Voice of the DBA

Thanks to everyone who attended, though with one stage I had a fairly captive audience. I enjoyed the event and look forward to coming back to the Twin Cities...

2024-08-08

1 reads

Simple Talks–Episode 3

• by Steve Jones

• The Voice of the DBA

The third episode of Simple Talks is out. This is the new Redgate podcast from myself, Grant, Ryan, and Louis. The main page is here, and it has links...

2024-08-07

1 reads