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: )

339 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: )

209 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

43 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: )

615 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: )

233 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

50 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

53 reads

Blogs

Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together

By

Most enterprise questions do not live neatly in one place. The numbers may be...

Keeping Redshift System Table History Past 7 Days with S3 Tables

By

Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...

Updating the Data API Builder

By

I was updating my session for the Data API Builder (DAB) recently, mostly to...

Read the latest Blogs

Forums

Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't

By vgupta

Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....

Hyperscale Replicas I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas I

The End of Summer

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The End of Summer

Visit the forum

Question of the Day

Hyperscale Replicas I

What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?

See possible answers