Kevin3NF

Kevin Hill is a career SQL Server DBA living in Dallas, TX. His specialities include HA/DR, Best Practice configuration, Performance tuning and teaching new and accidental DBAs
  • Interests: Cycling, family, sci-fi, DBA stuff

Blog Post

Top 10 Careers in Data

Would you re-order these? Machine Learning Engineer $$$$$ Develop and deploy AI models Optimize machine learning algorithms for efficiency Work with big data frameworks to process large datasets Data...

2025-02-28 (first published: )

334 reads

Blog Post

3rd Party Applications Have Issues

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-20 (first published: )

199 reads

Blog Post

Degrees and Trade Schools

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

37 reads

Blog Post

Set-Based vs Row-Based Database Code

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-18 (first published: )

608 reads

Blog Post

Database Concerns – A Poll!

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-11-08 (first published: )

228 reads

Blog Post

IRL #8: SQL Server Down

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

43 reads

Blog Post

SQL Server is not a Car

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

44 reads

Blogs

PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate

By

A sequential scan is not always a problem — PostgreSQL's planner often chooses one...

Giving AI Agents Visibility Into SQL Server with MCP

By

I’ve been thinking a lot lately about what it actually takes to make an...

The Book of Redgate: Profits

By

Redgate is a for-profit company. We look to make money by building and selling...

Read the latest Blogs

Forums

Stop Prompting Your AI Agent. Give It a Playbook.

By Kumar Abhishek

Comments posted to this topic are about the item Stop Prompting Your AI Agent....

Finish the quote

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finish the quote

Everything I Needed to Know Used to be Found in One Book

By Kathi Kellenberger

Comments posted to this topic are about the item Everything I Needed to Know...

Visit the forum

Question of the Day

Finish the quote

Finish this quote (for a fun Memorial Day question):

Do not try and bend the spoon. That's impossible. ...

See possible answers