---

Filter by type:

• All
• Articles
• Blog Posts

Degrees and Trade Schools

• by Kevin3NF

• Dallas DBAs

Can we normalize a couple of things? 1 – Trade Schools. Back in the 80’s trade classes in high school and post high school were frowned upon, or looked...

2024-05-08

3rd Party Applications Have Issues

• by Kevin3NF

• Dallas DBAs

As a SQL DBA, what do you do when a vendor application has performance problems that are code related? Server settings don’t generally seem to be an issue. Queries...

2024-05-02

Set-Based vs Row-Based Database Code

• by Kevin3NF

• Dallas DBAs

In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles of writing SQL code to manipulate data. These styles have implications for performance, readability, and...

2023-12-01

Database Concerns – A Poll!

• by Kevin3NF

• Dallas DBAs

What are you most concerned about in your database platforms? Please pick from the list below, and expand on your choice in the comments if you like:   Thanks...

2023-10-25

SQL Server Backups are Not a High-Availability Solution

• by Kevin3NF

• Dallas DBAs

Please continue doing your backups! Backups are Disaster Recovery, yes…but not HA. Some will argue with this (in the comments most likely), but I broadly define “High Availability” as...

2023-10-17

IRL #8: SQL Server Down

• by Kevin3NF

• Dallas DBAs

Problem: My PocketDBA® client called in with a non-responsive SQL Server. Application errors, timeout, alerts firing. SQL Server box is up, and the services are running. Background: This is...

2023-09-06

SQL Server is not a Car

• by Kevin3NF

• Dallas DBAs

Lets compare them anyway, just for fun. Both have an engine Both have a monitoring device (Dashboard/Activity Monitor) Both need power (Gas/Electricity) Both need to be told what do...

2023-09-05

Reflections on the Software Industry

• by Kevin3NF

• Dallas DBAs

Every now and then we like to have someone do a guest post, with a topic of their own choosing. This time, we picked Kevin Miller (LI). Kevin is...

2023-08-01

Test Restore Your SQL Server Databases

• by Kevin3NF

• Dallas DBAs

Pain Point: Something bad happened and you need to restore a SQL Server database. Pain Point you didn’t know you had: The backup files are all corrupt due a...

2023-07-25

Storytelling for DBAs and Other Technical Folk 

• by Kevin3NF

• Dallas DBAs

(for your reading pleasure, written by Jules. –ed) We have all had that sinking feeling of defeat: you’ve just finished explaining a very important and highly technical thing to...

2023-06-20

1 reads

Filter by type:

• All
• Articles
• Blog Posts